Revize 7cee2250

refs #6919: Logy

Oprava logovani v cronu. Do logu odchytavany i vyvolavane vyjimky. Pridan ukazkovy soubor (nejdrive beh OK, pote beh, kdy data uz byla v DB, pak beh, kdy data jeste nebyla ke stazeni, a na zaver beh, kdy byla spatna struktura DB).

cron/cron.php

@@ -26 +26 @@
     // Kvuli timeoutu.
     set_time_limit(0);
     
+    // Objekt pro logovani.
+    $logs = new Logging();
+    
     // Vytvoreni objektu pro komunikaci s DB.
-    $dbh = new DB_WEB();
+    $dbh = new DB_WEB($logs);
     $DAO = new DAO();
     $DAO->setDB($dbh);
     
-    // Objekt pro logovani.
-    $logs = new Logging();
-    
     if ($date != NULL && $DAO->controlTrafficData($date->format("Y-m-d"))) {
         $logs->log(Logging::INFO, "Data k vybranemu dni (".$date->format("d.m.Y").") jeste v databazi nejsou.");
         $parser = new Parser($logs);

cron/db/db-exception.php

@@ -1 +1 @@
 <?php
 
+require_once "/../logging.php";
+
 class DB_Exception extends Exception {
     
-    public function __construct($message = false, $code = false) {
+    public function __construct($logs = NULL, $message = false, $code = false) {
         if (!$message) {
             $this->message = mysql_error();
         } 
         if (!$code) {
             $this->code = mysql_errno();
         }
+        if ($logs != NULL) {
+            $logs->log(Logging::ERROR, $this->__toString());
+        }
     }
     
 }

cron/db/db-pdo.php

@@ -9 +9 @@
     protected $dbhost;
     protected $dbname;
     protected $dbh;
+    
+    protected $logs;
   
     public function __construct($user, $pass, $dbhost, $dbname) {
         $this->user = $user;
@@ -20 +22 @@
     protected function connect() {
         $this->dbh = new PDO("mysql:host=".$this->dbhost.";dbname=".$this->dbname.";charset=utf8", $this->user, $this->pass);
         if (!$this->dbh) {
-            throw new DB_Exception;
+            throw new DB_Exception($this->logs);
         }
     }
   
@@ -30 +32 @@
         }
         $ret = $this->dbh->query($query);
         if (!$ret) {
-            throw new DB_Exception;
+            throw new DB_Exception($this->logs);
         } else {
-            $stmt = new DB_PDOStatement($this->dbh, $query);
+            $stmt = new DB_PDOStatement($this->dbh, $query, $this->logs);
             $stmt->result = $ret;
             $stmt->number = $ret->rowCount();
             return $stmt;
@@ -47 +49 @@
     public $query;
     public $number;
     protected $dbh;
+    
+    private $logs;
   
-    public function __construct($dbh, $query) {
+    public function __construct($dbh, $query, $logs) {
         $this->query = $query;
         $this->dbh = $dbh;
+        $this->logs = $logs;
         if (!$dbh) {
-            throw new DB_Exception("Spojení s databází se nezdařilo!");
+            throw new DB_Exception($this->logs, "Spojení s databází se nezdařilo!");
         }
     }
   
     public function fetchAssoc() {
         if (!$this->result) {
-            throw new DB_Exception("Dotaz nebyl vykonán!");
+            throw new DB_Exception($this->logs, "Dotaz nebyl vykonán!");
         }
         return $this->result->fetch(PDO::FETCH_ASSOC);
     }

cron/db/db-web.php

@@ -8 +8 @@
     protected $pass = "";
     protected $dbhost = "localhost";
     protected $dbname = "prujezd_vozidel";
+    
+    protected $logs = NULL;
   
-    public function __construct() {
+    public function __construct($logs) {
+        $this->logs = $logs;
     }
      
 }

cron/log/cron.txt

@@ -1 @@
-21.05.2018 21:08:55.799
+22.05.2018 23:30:19.506
 --- INFO ---
-Data k vybranemu dni jeste v databazi nejsou.
+Data k vybranemu dni (21.05.2018) jeste v databazi nejsou.
 
-21.05.2018 21:08:55.811
+22.05.2018 23:30:19.518
 --- INFO ---
-ZACATEK PROCEDURY pro den 20.05.2018.
+ZACATEK PROCEDURY pro den 21.05.2018.
 
-21.05.2018 21:09:01.904
+22.05.2018 23:30:25.832
 --- INFO ---
 Stazeni archivu probehlo v poradku.
 
-21.05.2018 21:09:02.588
+22.05.2018 23:30:26.887
 --- INFO ---
 Extrahovani archivu v poradku dokonceno.
 
-21.05.2018 21:09:02.598
+22.05.2018 23:30:26.897
 --- INFO ---
 Zpracovavani zaznamu o doprave.
 
-21.05.2018 21:11:08.933
+22.05.2018 23:33:56.540
 --- INFO ---
 Zpracovavani zaznamu o lokacich.
 
-21.05.2018 21:11:08.945
+22.05.2018 23:33:56.552
 --- INFO ---
 Odstranovani slozky s extrahovanymi daty.
 
-21.05.2018 21:11:08.969
+22.05.2018 23:33:56.584
 --- INFO ---
 KONEC PROCEDURY.
 
-21.05.2018 21:22:56.954
+22.05.2018 23:51:45.080
 --- WARNING ---
-Pro vybrany den (20.05.2018) jiz data v databazi jsou.
+Pro vybrany den (21.05.2018) jiz data v databazi jsou.
+
+23.05.2018 00:02:20.633
+--- INFO ---
+Data k vybranemu dni (22.05.2018) jeste v databazi nejsou.
+
+23.05.2018 00:02:20.644
+--- INFO ---
+ZACATEK PROCEDURY pro den 22.05.2018.
+
+23.05.2018 00:02:21.236
+--- WARNING ---
+Pro dany datum neexistuji data.
+
+23.05.2018 00:02:21.248
+--- INFO ---
+KONEC PROCEDURY.
+
+23.05.2018 00:10:05.350
+--- ERROR ---
+exception 'DB_Exception' in C:\Program Files (x86)\EasyPHP-12.1\www\cron\db\db-pdo.php:35
+Stack trace:
+#0 C:\Program Files (x86)\EasyPHP-12.1\www\cron\dao\dao.php(40): DB_PDO->executeQuery('SELECT COUNT(*)...')
+#1 C:\Program Files (x86)\EasyPHP-12.1\www\cron\cron.php(37): DAO->controlTrafficData('2018-05-21')
+#2 C:\Program Files (x86)\EasyPHP-12.1\www\cron\cron.php(21): cron_procedure(Object(DateTime))
+#3 C:\Program Files (x86)\EasyPHP-12.1\www\cron\index.php(9): cron()
+#4 {main}