/**
* Run backup
*/
public final function run()
{
$this->DB->stopAddingAccountID();
$Tables = array(PREFIX . 'account', PREFIX . 'clothes', PREFIX . 'conf', PREFIX . 'dataset', PREFIX . 'hrv', PREFIX . 'plugin', PREFIX . 'plugin_conf', PREFIX . 'shoe', PREFIX . 'sport', PREFIX . 'type', PREFIX . 'user', PREFIX . 'route', PREFIX . 'training', PREFIX . 'trackdata', PREFIX . 'swimdata');
foreach ($Tables as $TableName) {
$this->saveTableStructure($TableName);
$this->saveTableRows($TableName);
}
$this->Writer->finish();
$this->DB->startAddingAccountID();
}
/**
* @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);
}
/**
* Run backup
*/
public final function run()
{
$this->DB->stopAddingAccountID();
$this->startBackup();
// REMINDER: think about required order, e.g.
// - plugin before plugin_conf
// - sport/type/route before training
// - training before trackdata/swimdata/hrv
// - equipment_Type before equipment_sport before equipment before activity_equipment
// - tag before activity_tag
$Tables = array(PREFIX . 'account', PREFIX . 'conf', PREFIX . 'dataset', PREFIX . 'plugin', PREFIX . 'plugin_conf', PREFIX . 'sport', PREFIX . 'type', PREFIX . 'user', PREFIX . 'route', PREFIX . 'training', PREFIX . 'trackdata', PREFIX . 'swimdata', PREFIX . 'hrv', PREFIX . 'equipment_type', PREFIX . 'equipment_sport', PREFIX . 'equipment', PREFIX . 'activity_equipment', PREFIX . 'tag', PREFIX . 'activity_tag');
foreach ($Tables as $TableName) {
$this->saveTableStructure($TableName);
$this->saveTableRows($TableName);
}
$this->finishBackup();
$this->Writer->finish();
$this->DB->startAddingAccountID();
}
