/** * @covers PDOforRunalyze::startAddingAccountID * @covers PDOforRunalyze::stopAddingAccountID * @covers PDOforRunalyze::setAccountID */ public function testStartAddingAccountID() { $this->object->exec('INSERT INTO `runalyze_training` (`s`, `accountid`) VALUES(100, 1)'); $this->object->exec('INSERT INTO `runalyze_training` (`s`, `accountid`) VALUES(200, 1)'); $this->object->exec('INSERT INTO `runalyze_training` (`s`, `accountid`) VALUES(66, 3)'); $this->object->setAccountID(1); $this->object->startAddingAccountID(); $this->assertEquals(300, $this->object->query('SELECT SUM(`s`) FROM `runalyze_training`')->fetchColumn()); $this->assertEquals(2, $this->object->query('SELECT COUNT(*) FROM `runalyze_training`')->fetchColumn()); $this->object->setAccountID(3); $this->assertEquals(66, $this->object->query('SELECT SUM(`s`) FROM `runalyze_training`')->fetchColumn()); $this->assertEquals(1, $this->object->query('SELECT COUNT(*) FROM `runalyze_training`')->fetchColumn()); $this->object->stopAddingAccountID(); $this->assertEquals(366, $this->object->query('SELECT SUM(`s`) FROM `runalyze_training`')->fetchColumn()); $this->assertEquals(3, $this->object->query('SELECT COUNT(*) FROM `runalyze_training`')->fetchColumn()); $this->object->exec('TRUNCATE TABLE `runalyze_training`'); $this->object->setAccountID(false); }