Changeset 861 for trunk/Packages/Common/Database.php

Timestamp:

Oct 2, 2019, 12:15:16 AM (5 years ago)

Author:

chronos

Message:

• Modified: Optimized netwatch inport for inserting data ti database.
• Fixed: RouterOS API to work with RouterOS newer than 6.43.

File:

• trunk/Packages/Common/Database.php (modified) (2 diffs)

trunk/Packages/Common/Database.php

@@ -96 +96 @@
     //echo('a'.$this->ShowSQLQuery.'<'.$QueryStartTime.', '.microtime_float());
     if(($this->ShowSQLQuery == true) or ($this->LogSQLQuery == true))
-      $Duration = ' ; '.round(microtime_float() - $QueryStartTime, 4). ' s';
-    if($this->LogSQLQuery == true)
+    {
+      $Time = round(microtime_float() - $QueryStartTime, 4);
+      $Duration = ' ; '.$Time. ' s';
+    } 
+    if(($this->LogSQLQuery == true) and ($Time != 0))
       file_put_contents($this->LogFile, $Query.$Duration."\n", FILE_APPEND);
     if($this->ShowSQLQuery == true)
@@ -222 +225 @@
   public function Transaction($Queries)
   {
-      $this->PDO->beginTransaction();
-      foreach ($Queries as $Query)
-      {
-        $Statement = $this->PDO->prepare($Query);
-        $Statement->execute();
-      }          
-      $this->PDO->commit();
+    //echo('|'."\n");
+    $this->PDO->beginTransaction();
+    foreach ($Queries as $Query)
+    {
+      //echo('|'.$Query."\n");
+      $Statement = $this->PDO->prepare($Query);
+      $Statement->execute();
+    }
+    $this->PDO->commit();
   }
 }