public function testSimpleUpdate()
{
$Inserter = new Inserter($this->PDO);
$Inserter->setAccountID(1);
$Inserter->insert(new Object(array(Object::NAME => 'Type name', Object::ABBREVIATION => 'Tn', Object::HR_AVG => 120, Object::QUALITY_SESSION => 1)));
$Type = new Object($this->PDO->query('SELECT * FROM `' . PREFIX . 'type` WHERE `id`=' . $Inserter->insertedID())->fetch(PDO::FETCH_ASSOC));
$Type->set(Object::ABBREVIATION, '');
$Changed = clone $Type;
$Changed->set(Object::NAME, 'New type name');
$Updater = new Updater($this->PDO, $Changed, $Type);
$Updater->setAccountID(1);
$Updater->update();
$Result = new Object($this->PDO->query('SELECT * FROM `' . PREFIX . 'type` WHERE `id`=' . $Inserter->insertedID())->fetch(PDO::FETCH_ASSOC));
$this->assertEquals('New type name', $Result->name());
$this->assertEquals('Tn', $Result->abbreviation());
$this->assertEquals(120, $Result->hrAvg());
$this->assertEquals(true, $Result->isQualitySession());
}
public function testSimpleInsert()
{
$Type = new Object(array(Object::NAME => 'Type name', Object::ABBREVIATION => 'Tn', Object::SPORTID => 1, Object::SHORT => 0, Object::HR_AVG => 120, Object::QUALITY_SESSION => 1));
$Inserter = new Inserter($this->PDO, $Type);
$Inserter->setAccountID(1);
$Inserter->insert();
$data = $this->PDO->query('SELECT * FROM `' . PREFIX . 'type` WHERE `accountid`=1')->fetch(PDO::FETCH_ASSOC);
$New = new Object($data);
$this->assertEquals('Type name', $New->name());
$this->assertEquals('Tn', $New->abbreviation());
$this->assertEquals(1, $New->sportid());
$this->assertEquals(120, $New->hrAvg());
$this->assertEquals(true, $New->isQualitySession());
$this->assertFalse($New->usesShortMode());
}
/**
* Keys to insert
* @return array
*/
protected function keys()
{
return array_merge(array(self::ACCOUNTID), Object::allDatabaseProperties());
}
/**
* Get content for a given dataset
* @param string $name
* @return string
*/
public function getDataset($name)
{
switch ($name) {
case 'sportid':
if (!is_null($this->Sport)) {
return $this->Sport->icon()->code();
}
return '';
case 'typeid':
if (!is_null($this->Type)) {
if ($this->Type->isQualitySession()) {
return '<strong>' . $this->Type->abbreviation() . '</strong>';
}
return $this->Type->abbreviation();
}
return '';
case 'time':
return $this->Dataview->daytime();
case 'distance':
return $this->Dataview->distance() . $this->distanceComparison();
case 's':
return $this->Dataview->duration()->string();
case 'pace':
if ($this->Activity->distance() > 0) {
if (isset($this->ActivityData['s_sum_with_distance'])) {
if ($this->ActivityData['s_sum_with_distance'] > 0) {
$Pace = new Pace($this->ActivityData['s_sum_with_distance'], $this->Activity->distance(), SportFactory::getSpeedUnitFor($this->Activity->sportid()));
return $Pace->valueWithAppendix();
}
return '';
}
return $this->Dataview->pace()->valueWithAppendix();
}
return '';
case 'elevation':
if ($this->Activity->elevation() > 0) {
return $this->Dataview->elevation()->string();
}
return '';
case 'kcal':
return $this->Dataview->calories();
case 'pulse_avg':
if ($this->Activity->hrAvg() > 0) {
return $this->Dataview->hrAvg()->string();
}
return '';
case 'pulse_max':
if ($this->Activity->hrMax() > 0) {
return $this->Dataview->hrMax()->string();
}
return '';
case 'trimp':
return $this->Dataview->trimp();
case 'cadence':
if ($this->Dataview->cadence()->value() > 0) {
return $this->Dataview->cadence()->asString();
}
return '';
case 'stride_length':
if ($this->Dataview->strideLength()->value() > 0) {
return $this->Dataview->strideLength()->string();
}
return '';
case 'groundcontact':
return $this->Dataview->groundcontact();
case 'vertical_oscillation':
return $this->Dataview->verticalOscillation();
case 'power':
return $this->Dataview->power();
case 'temperature':
if (!$this->Activity->weather()->temperature()->isUnknown() && (is_null($this->Sport) || $this->Sport->isOutside())) {
return Temperature::format($this->Activity->weather()->temperature()->value(), true, false);
}
return '';
case 'weatherid':
if (!$this->Activity->weather()->isEmpty() && (is_null($this->Sport) || $this->Sport->isOutside())) {
return $this->Activity->weather()->condition()->icon()->code();
}
return '';
case 'routeid':
if ($this->Activity->get(Activity\Object::ROUTEID) > 0) {
return $this->cut($this->Factory->route($this->Activity->get(Activity\Object::ROUTEID))->name());
}
return '';
case 'splits':
if (!$this->Activity->splits()->isEmpty()) {
if ($this->Activity->splits()->hasActiveAndInactiveLaps() || round($this->Activity->splits()->totalDistance()) != round($this->Activity->distance()) || !is_null($this->Type) && $this->Type->id() == Configuration::General()->competitionType()) {
// TODO: Icon with tooltip?
$Icon = new Icon(Icon::CLOCK);
return $Icon->code();
}
}
return '';
case 'comment':
return $this->cut($this->Activity->comment());
case 'partner':
return $this->cut($this->Activity->partner()->asString());
case 'abc':
return $this->Dataview->abcIcon();
case 'vdoticon':
if (!is_null($this->Sport) && $this->Sport->id() == Configuration::General()->runningSport()) {
return $this->Dataview->vdotIcon();
}
return '';
case 'vdot':
if (!is_null($this->Sport) && $this->Sport->id() == Configuration::General()->runningSport() && $this->Activity->vdotByHeartRate() > 0) {
if (!$this->Activity->usesVDOT()) {
return '<span class="unimportant">' . $this->Dataview->vdot()->value() . '</span>';
}
return $this->Dataview->vdot()->value();
}
return '';
case 'jd_intensity':
if (!is_null($this->Sport) && $this->Sport->id() == Configuration::General()->runningSport()) {
return $this->Dataview->jdIntensityWithStresscolor();
}
return '';
case 'fit_vdot_estimate':
if (!is_null($this->Sport) && $this->Sport->id() == Configuration::General()->runningSport()) {
return $this->Dataview->fitVdotEstimate();
}
return '';
case 'fit_recovery_time':
return $this->Dataview->fitRecoveryTime();
case 'fit_hrv_analysis':
return $this->Dataview->fitHRVscore();
}
return '';
}
/**
* Get content for a given dataset
* @param string $name
* @return string
*/
public function getDataset($name)
{
switch ($name) {
case 'sportid':
if (!is_null($this->Sport)) {
return $this->Sport->icon()->code();
}
return '';
case 'typeid':
if (!is_null($this->Type)) {
if ($this->Type->isQualitySession()) {
return '<strong>' . $this->Type->abbreviation() . '</strong>';
}
return $this->Type->abbreviation();
}
return '';
case 'time':
return $this->Dataview->daytime();
case 'distance':
return $this->Dataview->distance() . $this->distanceComparison();
case 's':
return $this->Dataview->duration()->string();
case 'pace':
if ($this->Activity->distance() > 0) {
// TODO: 's_sum_with_distance'
//return $this->TrainingObject->DataView()->getSpeedStringForTime( $this->TrainingObject->getTimeInSecondsSumWithDistance() );
return $this->Dataview->pace()->valueWithAppendix();
}
return '';
case 'elevation':
return $this->Dataview->elevation();
case 'kcal':
return $this->Dataview->calories();
case 'pulse_avg':
if ($this->Activity->hrAvg() > 0) {
return $this->Dataview->hrAvg()->string();
}
return '';
case 'pulse_max':
if ($this->Activity->hrMax() > 0) {
return $this->Dataview->hrMax()->string();
}
return '';
case 'trimp':
return $this->Dataview->trimp();
case 'cadence':
if ($this->Dataview->cadence()->value() > 0) {
return $this->Dataview->cadence()->asString();
}
return '';
case 'stride_length':
if ($this->Dataview->strideLength()->inCM() > 0) {
return $this->Dataview->strideLength()->string();
}
return '';
case 'groundcontact':
return $this->Dataview->groundcontact();
case 'vertical_oscillation':
return $this->Dataview->verticalOscillation();
case 'power':
return $this->Dataview->power();
case 'temperature':
if (!$this->Activity->weather()->temperature()->isUnknown() && (is_null($this->Sport) || $this->Sport->isOutside())) {
return $this->Activity->weather()->temperature()->asString();
}
return '';
case 'weatherid':
if (!$this->Activity->weather()->isEmpty() && (is_null($this->Sport) || $this->Sport->isOutside())) {
return $this->Activity->weather()->condition()->icon()->code();
}
return '';
case 'routeid':
if ($this->Activity->get(Activity\Object::ROUTEID) > 0) {
return $this->cut($this->Factory->route($this->Activity->get(Activity\Object::ROUTEID))->name());
}
return '';
case 'clothes':
return $this->cut($this->Dataview->clothes());
case 'splits':
if (!$this->Activity->splits()->isEmpty()) {
if ($this->Activity->splits()->hasActiveAndInactiveLaps() || round($this->Activity->splits()->totalDistance()) != round($this->Activity->distance()) || !is_null($this->Type) && $this->Type->id() == Configuration::General()->competitionType()) {
// TODO: Icon with tooltip?
$Icon = new Icon(Icon::CLOCK);
return $Icon->code();
}
}
return '';
case 'comment':
return $this->cut($this->Activity->comment());
case 'partner':
return $this->cut($this->Activity->partner()->asString());
case 'abc':
return $this->Dataview->abcIcon();
case 'shoeid':
if ($this->Activity->shoeID() > 0) {
return ShoeFactory::NameOf($this->Activity->shoeID());
}
return '';
case 'vdoticon':
if (!is_null($this->Sport) && $this->Sport->id() == Configuration::General()->runningSport()) {
return $this->Dataview->vdotIcon();
}
return '';
case 'vdot':
if (!is_null($this->Sport) && $this->Sport->id() == Configuration::General()->runningSport() && $this->Activity->vdotByHeartRate() > 0) {
if (!$this->Activity->usesVDOT()) {
return '<span class="unimportant">' . $this->Dataview->vdot()->value() . '</span>';
}
return $this->Dataview->vdot()->value();
}
return '';
case 'jd_intensity':
if (!is_null($this->Sport) && $this->Sport->id() == Configuration::General()->runningSport()) {
return $this->Dataview->jdIntensityWithStresscolor();
}
return '';
}
return '';
}