/**
* @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);
}
