/**
* @param array $data
* @return int
*/
protected function insert(array $data)
{
$Inserter = new Inserter($this->PDO, new Object($data));
$Inserter->setAccountID(0);
$Inserter->insert();
return $Inserter->insertedID();
}
/**
* @param array $data
* @param array $route
* @param array $trackdata
* @return int
*/
protected function insertActivity(array $data, array $route, array $trackdata)
{
$Inserter = new Inserter($this->PDO, new Object($data));
$Inserter->setRoute(new Route\Object($route));
$Inserter->setTrackdata(new Trackdata\Object($trackdata));
return $this->runInserter($Inserter);
}
public function testPowerCalculation()
{
// TODO: Needs configuration setting
if (Configuration::ActivityForm()->computePower()) {
$ActivityIndoor = new Object(array(Object::DISTANCE => 10, Object::TIME_IN_SECONDS => 3000, Object::SPORTID => $this->IndoorID));
$Trackdata = new Model\Trackdata\Object(array(Model\Trackdata\Object::TIME => array(1500, 3000), Model\Trackdata\Object::DISTANCE => array(5, 10)));
$Inserter = new Inserter($this->PDO);
$Inserter->setAccountID(0);
$Inserter->setTrackdata($Trackdata);
$Inserter->insert($ActivityIndoor);
$this->assertEquals(0, $this->fetch($Inserter->insertedID())->power());
$ActivityOutdoor = clone $ActivityIndoor;
$ActivityOutdoor->set(Object::SPORTID, $this->OutdoorID);
$Inserter->insert($ActivityOutdoor);
$this->assertNotEquals(0, $this->fetch($Inserter->insertedID())->power());
$this->assertNotEmpty($Trackdata->power());
}
}
public function testEquipment()
{
$this->PDO->exec('UPDATE `runalyze_equipment` SET `distance`=0, `time`=0 WHERE `id`=' . $this->EquipmentA);
$this->PDO->exec('UPDATE `runalyze_equipment` SET `distance`=0, `time`=0 WHERE `id`=' . $this->EquipmentB);
$Object = new Object(array(Object::DISTANCE => 10, Object::TIME_IN_SECONDS => 3600, Object::SPORTID => 1));
$Inserter = new Inserter($this->PDO);
$Inserter->setAccountID(0);
$Inserter->setEquipmentIDs(array($this->EquipmentA));
$Inserter->insert($Object);
$this->assertEquals(array(10, 3600), $this->PDO->query('SELECT `distance`, `time` FROM `runalyze_equipment` WHERE `id`=' . $this->EquipmentA)->fetch(PDO::FETCH_NUM));
$this->assertEquals(array(0, 0), $this->PDO->query('SELECT `distance`, `time` FROM `runalyze_equipment` WHERE `id`=' . $this->EquipmentB)->fetch(PDO::FETCH_NUM));
$Deleter = new Deleter($this->PDO, $Object);
$Deleter->setAccountID(0);
$Deleter->setEquipmentIDs(array($this->EquipmentA));
$Deleter->delete();
$this->assertEquals(array(0, 0), $this->PDO->query('SELECT `distance`, `time` FROM `runalyze_equipment` WHERE `id`=' . $this->EquipmentA)->fetch(PDO::FETCH_NUM));
$this->assertEquals(array(0, 0), $this->PDO->query('SELECT `distance`, `time` FROM `runalyze_equipment` WHERE `id`=' . $this->EquipmentB)->fetch(PDO::FETCH_NUM));
}
public function testEquipment()
{
$this->PDO->exec('UPDATE `runalyze_equipment` SET `distance`=0, `time`=0 WHERE `id`=' . $this->EquipmentA);
$this->PDO->exec('UPDATE `runalyze_equipment` SET `distance`=0, `time`=0 WHERE `id`=' . $this->EquipmentB);
$OldObject = new Object(array(Object::DISTANCE => 12.34, Object::TIME_IN_SECONDS => 3600, Object::SPORTID => $this->OutdoorID));
$Inserter = new Inserter($this->PDO);
$Inserter->setAccountID(0);
$Inserter->setEquipmentIDs(array($this->EquipmentA));
$Inserter->insert($OldObject);
$this->assertEquals(array(12.34, 3600), $this->PDO->query('SELECT `distance`, `time` FROM `runalyze_equipment` WHERE `id`=' . $this->EquipmentA)->fetch(PDO::FETCH_NUM));
$this->assertEquals(array(0.0, 0), $this->PDO->query('SELECT `distance`, `time` FROM `runalyze_equipment` WHERE `id`=' . $this->EquipmentB)->fetch(PDO::FETCH_NUM));
$NewObject = clone $OldObject;
$Updater = new Updater($this->PDO, $NewObject, $OldObject);
$Updater->setAccountID(0);
$Updater->setEquipmentIDs(array($this->EquipmentB), array($this->EquipmentA));
$Updater->update();
$this->assertEquals(array(0.0, 0), $this->PDO->query('SELECT `distance`, `time` FROM `runalyze_equipment` WHERE `id`=' . $this->EquipmentA)->fetch(PDO::FETCH_NUM));
$this->assertEquals(array(12.34, 3600), $this->PDO->query('SELECT `distance`, `time` FROM `runalyze_equipment` WHERE `id`=' . $this->EquipmentB)->fetch(PDO::FETCH_NUM));
}
