Exemple #1
0
 public function performAction()
 {
     /** @var Table[] $tables */
     $tables = array(Points::table(), Segment5::table(), Segment10::table(), Segment50::table(), Segment100::table(), Segment500::table(), Segment1k::table(), Segment5k::table(), Segment10k::table(), Segment10s::table(), Segment60s::table());
     $log = new Log('colored-stdout');
     if ($this->wipe) {
         foreach ($tables as $table) {
             $table->migration()->setLog($log)->setDryRun($this->dryRun)->rollback();
         }
     }
     foreach ($tables as $table) {
         $table->migration()->setLog($log)->setDryRun($this->dryRun)->apply();
     }
 }
 public function performAction()
 {
     if (!file_exists($this->path)) {
         throw new \Exception(Expression::create('File ? not found', $this->path));
     }
     $GPSEssentials = new GPSEssentials($this->path);
     $database = new Database('sqlite:///' . realpath($this->path));
     $database->log(new Log('colored-stdout'));
     TrackElement::bindDatabase($database);
     //$this->count = $database->query("SELECT COUNT(1) AS c FROM ?", TrackElement::table())->fetchRow('c');
     $pageQuery = TrackElement::statement()->order("? ASC", TrackElement::columns()->id)->limit($this->pageSize);
     if ($this->from) {
         $pageQuery->where('? >= 1000 * ?', TrackElement::columns()->time, strtotime($this->from));
     }
     if ($this->to) {
         $pageQuery->where('? <= 1000 * ?', TrackElement::columns()->time, strtotime($this->to));
     }
     $this->segments = array(Segment5::className(), Segment10::className(), Segment100::className(), Segment500::className(), Segment1k::className(), Segment5k::className(), Segment10k::className());
     $timeSegments = array(Segment10s::className(), Segment60s::className());
     /** @var BatchSaver[] $batchSavers */
     $batchSavers = array();
     foreach ($this->segments as $segment) {
         $batchSavers[$segment] = new BatchSaver();
     }
     foreach ($timeSegments as $segment) {
         $batchSavers[$segment] = new BatchSaver();
     }
     while ($res = $pageQuery->query()->fetchAll()) {
         /** @var TrackElement $row */
         foreach ($res as $row) {
             $row->time /= 1000;
             /** @var Segment5|string $segment */
             foreach ($this->segments as $segment) {
                 if (!isset($this->lastPoints[$segment])) {
                     $this->lastPoints[$segment] = $row;
                 }
                 /** @var TrackElement $lastPoint */
                 $lastPoint = $this->lastPoints[$segment];
                 if (($distance = GPSEssentials::distance($lastPoint, $row)) > $segment::MIN_DISTANCE) {
                     /** @var Segment5 $segmentItem */
                     $segmentItem = new $segment();
                     $segmentItem->distance = $distance;
                     $segmentItem->latitude = $row->latitude;
                     $segmentItem->longitude = $row->longitude;
                     $segmentItem->ut = $row->time;
                     $segmentItem->altitude = $row->altitude;
                     $segmentItem->time = $row->time - $lastPoint->time;
                     if ($segmentItem->time) {
                         $segmentItem->speed = $segmentItem->distance / $segmentItem->time;
                     }
                     $segmentItem->elevation = $row->altitude - $lastPoint->altitude;
                     $batchSavers[$segment]->add($segmentItem);
                     //$segmentItem->save();
                     $this->lastPoints[$segment] = $row;
                 }
             }
             /** @var Segment10s|string $segment */
             foreach ($timeSegments as $segment) {
                 if (!isset($this->lastPoints[$segment])) {
                     $this->lastPoints[$segment] = $row;
                 }
                 /** @var TrackElement $lastPoint */
                 $lastPoint = $this->lastPoints[$segment];
                 if ($row->time - $lastPoint->time > $segment::MIN_TIME) {
                     /** @var Segment5 $segmentItem */
                     $segmentItem = new $segment();
                     $segmentItem->distance = GPSEssentials::distance($lastPoint, $row);
                     $segmentItem->latitude = $row->latitude;
                     $segmentItem->longitude = $row->longitude;
                     $segmentItem->ut = $row->time;
                     $segmentItem->altitude = $row->altitude;
                     $segmentItem->time = $row->time - $lastPoint->time;
                     if ($segmentItem->time) {
                         $segmentItem->speed = $segmentItem->distance / $segmentItem->time;
                     }
                     $segmentItem->elevation = $row->altitude - $lastPoint->altitude;
                     $batchSavers[$segment]->add($segmentItem);
                     //$segmentItem->save();
                     $this->lastPoints[$segment] = $row;
                 }
             }
         }
         $this->offset += $this->pageSize;
         $pageQuery->offset($this->offset);
     }
     foreach ($batchSavers as $batchSaver) {
         $batchSaver->flush();
     }
 }