<?php namespace PHPerf; use Yaoi\Database; use Yaoi\Http\Auth; use Yaoi\Http\Auth\Settings; use Yaoi\Log; use Yaoi\Storage; date_default_timezone_set('Europe/Moscow'); header("Content-Type: text/html; charset=utf8"); error_reporting(E_ALL); ini_set('display_errors', 'on'); umask('0002'); Auth::register(function () { $dsn = new Settings(); $dsn->title = 'Developers Only Area'; $dsn->salt = '<random-string>'; $dsn->users = array('<login>' => '<password-hash>'); return $dsn; }, 'dev'); Storage::register(new Storage\PhpVar(), 'debug_log'); Log::register('storage:///?storage=debug_log', 'debug_log'); Database::register(function () { $database = new Database('mysqli://root@localhost/phperf_result'); $database->log(Log::getInstance('debug_log')); return $database; });
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(); } }