public function testSimpleInsert() { $R = new Object(array(Object::NAME => 'Test route', Object::DISTANCE => 3.14, Object::LATITUDES => array(47.7, 47.8), Object::LONGITUDES => array(7.8, 7.7))); $I = new Inserter($this->PDO, $R); $I->setAccountID(0); $I->insert(); $data = $this->PDO->query('SELECT * FROM `' . PREFIX . 'route` WHERE `accountid`=0')->fetch(PDO::FETCH_ASSOC); $N = new Object($data); $this->assertEquals(0, $data[Inserter::ACCOUNTID]); $this->assertEquals('Test route', $N->name()); $this->assertTrue($N->hasID()); $this->assertTrue($N->hasPositionData()); $this->assertEquals(47.7, $N->get(Object::MIN_LATITUDE)); }
public function testSimpleUpdate() { $Inserter = new Inserter($this->PDO); $Inserter->setAccountID(0); $Inserter->insert(new Object(array(Object::NAME => 'Route name', Object::DISTANCE => 3.14))); $Route = new Object($this->PDO->query('SELECT * FROM `' . PREFIX . 'route` WHERE `id`=' . $Inserter->insertedID())->fetch(PDO::FETCH_ASSOC)); $Route->set(Object::DISTANCE, 0); $Changed = clone $Route; $Changed->set(Object::NAME, 'New route name'); $Updater = new Updater($this->PDO, $Changed, $Route); $Updater->setAccountID(0); $Updater->update(); $Result = new Object($this->PDO->query('SELECT * FROM `' . PREFIX . 'route` WHERE `id`=' . $Inserter->insertedID())->fetch(PDO::FETCH_ASSOC)); $this->assertEquals('New route name', $Result->name()); $this->assertEquals(3.14, $Result->distance()); }