public function testSimpleInsert() { $R = new Object(array(Object::ACTIVITYID => 1, Object::POOL_LENGTH => 2500, Object::STROKE => array(25, 20, 15, 20), Object::STROKETYPE => array(2, 2, 2, 2))); $I = new Inserter($this->PDO, $R); $I->setAccountID(1); $I->insert(); $data = $this->PDO->query('SELECT * FROM `' . PREFIX . 'swimdata` WHERE `activityid`=1')->fetch(PDO::FETCH_ASSOC); $N = new Object($data); $this->assertEquals(1, $data[Inserter::ACCOUNTID]); $this->assertEquals(2500, $N->poollength()); $this->assertEquals(array(25, 20, 15, 20), $N->stroke()); $this->assertEquals(array(2, 2, 2, 2), $N->stroketype()); }
public function testSimpleUpdate() { $Inserter = new Inserter($this->PDO); $Inserter->setAccountID(1); $Inserter->insert(new Object(array(Object::ACTIVITYID => 1, Object::STROKE => array(25, 20, 15, 20)))); $Swimdata = new Object($this->PDO->query('SELECT * FROM `' . PREFIX . 'swimdata` WHERE `activityid`=1')->fetch(PDO::FETCH_ASSOC)); $Swimdata->set(Object::STROKE, array()); $Changed = clone $Swimdata; $Changed->set(Object::STROKETYPE, array(2, 2, 2, 2)); $Updater = new Updater($this->PDO, $Changed, $Swimdata); $Updater->setAccountID(1); $Updater->update(); $Result = new Object($this->PDO->query('SELECT * FROM `' . PREFIX . 'swimdata` WHERE `activityid`=1')->fetch(PDO::FETCH_ASSOC)); $this->assertEquals(array(25, 20, 15, 20), $Result->stroke()); $this->assertEquals(array(2, 2, 2, 2), $Result->stroketype()); }
/** * @param array $data */ protected function insert(array $data) { $Inserter = new Inserter($this->PDO, new Object($data)); $Inserter->setAccountID(0); $Inserter->insert(); }