PHPSocialNetwork / phpfastcache

src/phpFastCache/Drivers/Sqlite/Driver.php

Indentation +29 added lines, -29 removed lines

@@ -150,7 +150,7 @@ 
 
             $PDO = new PDO("sqlite:" . $this->SqliteDir . '/' . self::INDEXING_FILE);
             $PDO->setAttribute(PDO::ATTR_ERRMODE,
-              PDO::ERRMODE_EXCEPTION);
+                PDO::ERRMODE_EXCEPTION);
 
             if ($createTable == true) {
                 $this->initIndexing($PDO);
@@ -185,7 +185,7 @@ 
         // look for keyword
         $stm = $this->indexing->prepare("SELECT * FROM `balancing` WHERE `keyword`=:keyword LIMIT 1");
         $stm->execute([
-          ':keyword' => $keyword,
+            ':keyword' => $keyword,
         ]);
         $row = $stm->fetch(PDO::FETCH_ASSOC);
         if (isset($row[ 'db' ]) && $row[ 'db' ] != '') {
@@ -197,8 +197,8 @@ 
             $db = $this->currentDB;
             $stm = $this->indexing->prepare("INSERT INTO `balancing` (`keyword`,`db`) VALUES(:keyword, :db)");
             $stm->execute([
-              ':keyword' => $keyword,
-              ':db' => $db,
+                ':keyword' => $keyword,
+                ':db' => $db,
             ]);
         }
 
@@ -269,11 +269,11 @@ 
             if ($toWrite == true) {
                 try {
                     $stm = $this->getDb($item->getKey())
-                      ->prepare("INSERT OR REPLACE INTO `caching` (`keyword`,`object`,`exp`) values(:keyword,:object,:exp)");
+                        ->prepare("INSERT OR REPLACE INTO `caching` (`keyword`,`object`,`exp`) values(:keyword,:object,:exp)");
                     $stm->execute([
-                      ':keyword' => $item->getKey(),
-                      ':object' => $this->encode($this->driverPreWrap($item)),
-                      ':exp' => time() + $item->getTtl(),
+                        ':keyword' => $item->getKey(),
+                        ':object' => $this->encode($this->driverPreWrap($item)),
+                        ':exp' => time() + $item->getTtl(),
                     ]);
 
                     return true;
@@ -281,11 +281,11 @@ 
 
                     try {
                         $stm = $this->getDb($item->getKey(), true)
-                          ->prepare("INSERT OR REPLACE INTO `caching` (`keyword`,`object`,`exp`) values(:keyword,:object,:exp)");
+                            ->prepare("INSERT OR REPLACE INTO `caching` (`keyword`,`object`,`exp`) values(:keyword,:object,:exp)");
                         $stm->execute([
-                          ':keyword' => $item->getKey(),
-                          ':object' => $this->encode($this->driverPreWrap($item)),
-                          ':exp' => time() + $item->getTtl(),
+                            ':keyword' => $item->getKey(),
+                            ':object' => $this->encode($this->driverPreWrap($item)),
+                            ':exp' => time() + $item->getTtl(),
                         ]);
                     } catch (PDOException $e) {
                         return false;
@@ -307,20 +307,20 @@ 
     {
         try {
             $stm = $this->getDb($key)
-              ->prepare("SELECT * FROM `caching` WHERE `keyword`=:keyword AND (`exp` >= :U)  LIMIT 1");
+                ->prepare("SELECT * FROM `caching` WHERE `keyword`=:keyword AND (`exp` >= :U)  LIMIT 1");
             $stm->execute([
-              ':keyword' => $key,
-              ':U' => time(),
+                ':keyword' => $key,
+                ':U' => time(),
             ]);
             $row = $stm->fetch(PDO::FETCH_ASSOC);
 
         } catch (PDOException $e) {
             try {
                 $stm = $this->getDb($key, true)
-                  ->prepare("SELECT * FROM `caching` WHERE `keyword`=:keyword AND (`exp` >= :U)  LIMIT 1");
+                    ->prepare("SELECT * FROM `caching` WHERE `keyword`=:keyword AND (`exp` >= :U)  LIMIT 1");
                 $stm->execute([
-                  ':keyword' => $key,
-                  ':U' => time(),
+                    ':keyword' => $key,
+                    ':U' => time(),
                 ]);
                 $row = $stm->fetch(PDO::FETCH_ASSOC);
             } catch (PDOException $e) {
@@ -358,13 +358,13 @@ 
         if ($item instanceof Item) {
             try {
                 $stm = $this->getDb($item->getKey())
-                  //->prepare("DELETE FROM `caching` WHERE (`id`=:id) OR (`exp` <= :U) ");
-                  ->prepare("DELETE FROM `caching` WHERE (`exp` <= :U) OR (`keyword`=:keyword) ");
+                    //->prepare("DELETE FROM `caching` WHERE (`id`=:id) OR (`exp` <= :U) ");
+                    ->prepare("DELETE FROM `caching` WHERE (`exp` <= :U) OR (`keyword`=:keyword) ");
 
                 return $stm->execute([
                     // ':id' => $row[ 'id' ],
-                  ':keyword' => $item->getKey(),
-                  ':U' => time(),
+                    ':keyword' => $item->getKey(),
+                    ':U' => time(),
                 ]);
             } catch (PDOException $e) {
                 return false;
@@ -422,10 +422,10 @@ 
              * @todo: Check expiration time here
              */
             $stm = $this->getDb($item->getKey())
-              ->prepare("SELECT COUNT(`id`) as `total` FROM `caching` WHERE (`keyword`=:keyword) AND (`exp` <= :U) ");
+                ->prepare("SELECT COUNT(`id`) as `total` FROM `caching` WHERE (`keyword`=:keyword) AND (`exp` <= :U) ");
             $stm->execute([
-              ':keyword' => $item->getKey(),
-              ':U' => time(),
+                ':keyword' => $item->getKey(),
+                ':U' => time(),
             ]);
             $data = $stm->fetch(PDO::FETCH_ASSOC);
             if ($data[ 'total' ] >= 1) {
@@ -464,11 +464,11 @@ 
                 try {
                     $PDO = new PDO("sqlite:" . $file_path);
                     $PDO->setAttribute(PDO::ATTR_ERRMODE,
-                      PDO::ERRMODE_EXCEPTION);
+                        PDO::ERRMODE_EXCEPTION);
 
                     $stm = $PDO->prepare("DELETE FROM `caching` WHERE `exp` <= :U");
                     $stm->execute([
-                      ':U' => date('U'),
+                        ':U' => date('U'),
                     ]);
 
                     $PDO->exec('VACUUM;');
@@ -482,9 +482,9 @@ 
         }
 
         $stat->setSize($optimized)
-          ->setInfo('Total before removing expired entries [bytes]: ' . $total . ', '
+            ->setInfo('Total before removing expired entries [bytes]: ' . $total . ', '
             . 'Optimized after removing expired entries [bytes]: ' . $optimized
-          );
+            );
 
         return $stat;
     }