Jacek Kowalski
2019-06-10 9afb6bced6e66683efe2ba570fccecbe754bfde7
Check if data timestamps are recent before doing any DB changes
2 files modified
22 ■■■■■ changed files
lib/mapper.php 12 ●●●●● patch | view | raw | blame | history
parse.php 10 ●●●●● patch | view | raw | blame | history
lib/mapper.php
@@ -5,7 +5,9 @@
use transit_realtime\FeedMessage;
class Mapper {
    private $ttssDate = NULL;
    private $ttssTrips = [];
    private $gtfsrtDate = NULL;
    private $gtfsrtTrips = [];
    private $logger = NULL;
    
@@ -28,6 +30,7 @@
    
    public function loadTTSS($file) {
        $ttss = json_decode(file_get_contents($file));
        $this->ttssDate = $ttss->lastUpdate;
        foreach($ttss->vehicles as $vehicle) {
            if(isset($vehicle->isDeleted) && $vehicle->isDeleted) continue;
            if(!isset($vehicle->tripId) || !$vehicle->tripId) continue;
@@ -48,10 +51,15 @@
        ksort($this->ttssTrips);
    }
    
    public function getTTSSDate() {
        return $this->ttssDate / 1000.0;
    }
    public function loadGTFSRT($file) {
        $data = file_get_contents($file);
        $feed = new FeedMessage();
        $feed->parse($data);
        $this->gtfsrtDate = $feed->header->timestamp;
        foreach ($feed->getEntityList() as $entity) {
            $vehiclePosition = $entity->getVehicle();
            $position = $vehiclePosition->getPosition();
@@ -69,6 +77,10 @@
        ksort($this->gtfsrtTrips);
    }
    
    public function getGTFSRTDate() {
        return $this->gtfsrtDate;
    }
    public function findOffset() {
        if(count($this->ttssTrips) == 0 || count($this->gtfsrtTrips) == 0) {
            return NULL;
parse.php
@@ -36,8 +36,18 @@
        
        $logger->info('Loading data...');
        $mapper = new Mapper();
        $mapper->loadTTSS($source['ttss_file']);
        $timeDifference = time() - $mapper->getTTSSDate();
        if(abs($timeDifference) > 60) {
            throw new Exception('TTSS timestamp difference ('.$timeDifference.'s) is too high, aborting!');
        }
        $mapper->loadGTFSRT($source['gtfsrt_file']);
        $timeDifference = time() - $mapper->getGTFSRTDate();
        if(abs($timeDifference) > 60) {
            throw new Exception('GTFSRT timestamp difference ('.$timeDifference.'s) is too high, aborting!');
        }
        
        $db = new Database($source['database']);