Ejemplo n.º 1
0
 public function testSimpleUpdate()
 {
     $Inserter = new Inserter($this->PDO);
     $Inserter->setAccountID(1);
     $Inserter->insert(new Object(array(Object::NAME => 'Sport name', Object::CALORIES_PER_HOUR => 700)));
     $Sport = new Object($this->PDO->query('SELECT * FROM `' . PREFIX . 'sport` WHERE `id`=' . $Inserter->insertedID())->fetch(PDO::FETCH_ASSOC));
     $Sport->set(Object::CALORIES_PER_HOUR, 0);
     $Changed = clone $Sport;
     $Changed->set(Object::NAME, 'New sport name');
     $Updater = new Updater($this->PDO, $Changed, $Sport);
     $Updater->setAccountID(1);
     $Updater->update();
     $Result = new Object($this->PDO->query('SELECT * FROM `' . PREFIX . 'sport` WHERE `id`=' . $Inserter->insertedID())->fetch(PDO::FETCH_ASSOC));
     $this->assertEquals('New sport name', $Result->name());
     $this->assertEquals(700, $Result->caloriesPerHour());
 }
Ejemplo n.º 2
0
 public function testSimpleInsert()
 {
     $Object = new Object(array(Object::NAME => 'Sport name', Object::SHORT => 0, Object::CALORIES_PER_HOUR => 700, Object::HR_AVG => 140, Object::HAS_DISTANCES => 1, Object::PACE_UNIT => 'foo', Object::HAS_POWER => 0, Object::IS_OUTSIDE => 1));
     $Inserter = new Inserter($this->PDO, $Object);
     $Inserter->setAccountID(1);
     $Inserter->insert();
     $data = $this->PDO->query('SELECT * FROM `' . PREFIX . 'sport` WHERE `accountid`=1')->fetch(PDO::FETCH_ASSOC);
     $Sport = new Object($data);
     $this->assertEquals('Sport name', $Sport->name());
     $this->assertEquals(700, $Sport->caloriesPerHour());
     $this->assertEquals(140, $Sport->avgHR());
     $this->assertEquals('foo', $Sport->paceUnitEnum());
     $this->assertTrue($Sport->hasDistances());
     $this->assertTrue($Sport->isOutside());
     $this->assertFalse($Sport->usesShortDisplay());
     $this->assertFalse($Sport->hasPower());
 }