PHPSocialNetwork / phpfastcache

src/phpFastCache/Drivers/sqlite.php

Indentation +35 added lines, -35 removed lines

@@ -132,7 +132,7 @@ 
 
             $PDO = new PDO("sqlite:" . $this->path . '/' . self::INDEXING_FILE);
             $PDO->setAttribute(PDO::ATTR_ERRMODE,
-              PDO::ERRMODE_EXCEPTION);
+                PDO::ERRMODE_EXCEPTION);
 
             if ($createTable == true) {
                 $this->initIndexing($PDO);
@@ -167,7 +167,7 @@ 
         // look for keyword
         $stm = $this->indexing->prepare("SELECT * FROM `balancing` WHERE `keyword`=:keyword LIMIT 1");
         $stm->execute(array(
-          ':keyword' => $keyword,
+            ':keyword' => $keyword,
         ));
         $row = $stm->fetch(PDO::FETCH_ASSOC);
         if (isset($row[ 'db' ]) && $row[ 'db' ] != '') {
@@ -179,8 +179,8 @@ 
             $db = $this->currentDB;
             $stm = $this->indexing->prepare("INSERT INTO `balancing` (`keyword`,`db`) VALUES(:keyword, :db)");
             $stm->execute(array(
-              ':keyword' => $keyword,
-              ':db' => $db,
+                ':keyword' => $keyword,
+                ':db' => $db,
             ));
         }
 
@@ -244,10 +244,10 @@ 
      * @return bool
      */
     public function driver_set(
-      $keyword,
-      $value = '',
-      $time = 300,
-      $option = array()
+        $keyword,
+        $value = '',
+        $time = 300,
+        $option = array()
     ) {
         $skipExisting = isset($option[ 'skipExisting' ]) ? $option[ 'skipExisting' ] : false;
         $toWrite = true;
@@ -266,11 +266,11 @@ 
         if ($toWrite == true) {
             try {
                 $stm = $this->db($keyword)
-                  ->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(array(
-                  ':keyword' => $keyword,
-                  ':object' => $this->encode($value),
-                  ':exp' => time() + (int)$time,
+                    ':keyword' => $keyword,
+                    ':object' => $this->encode($value),
+                    ':exp' => time() + (int)$time,
                 ));
 
                 return true;
@@ -278,11 +278,11 @@ 
 
                 try {
                     $stm = $this->db($keyword, 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(array(
-                      ':keyword' => $keyword,
-                      ':object' => $this->encode($value),
-                      ':exp' => time() + (int)$time,
+                        ':keyword' => $keyword,
+                        ':object' => $this->encode($value),
+                        ':exp' => time() + (int)$time,
                     ));
                 } catch (PDOException $e) {
                     return false;
@@ -303,18 +303,18 @@ 
         // return value if in caching
         try {
             $stm = $this->db($keyword)
-              ->prepare("SELECT * FROM `caching` WHERE `keyword`=:keyword LIMIT 1");
+                ->prepare("SELECT * FROM `caching` WHERE `keyword`=:keyword LIMIT 1");
             $stm->execute(array(
-              ':keyword' => $keyword,
+                ':keyword' => $keyword,
             ));
             $row = $stm->fetch(PDO::FETCH_ASSOC);
 
         } catch (PDOException $e) {
             try {
                 $stm = $this->db($keyword, true)
-                  ->prepare("SELECT * FROM `caching` WHERE `keyword`=:keyword LIMIT 1");
+                    ->prepare("SELECT * FROM `caching` WHERE `keyword`=:keyword LIMIT 1");
                 $stm->execute(array(
-                  ':keyword' => $keyword,
+                    ':keyword' => $keyword,
                 ));
                 $row = $stm->fetch(PDO::FETCH_ASSOC);
             } catch (PDOException $e) {
@@ -357,10 +357,10 @@ 
     {
         try {
             $stm = $this->db($row[ 'keyword' ])
-              ->prepare("DELETE FROM `caching` WHERE (`id`=:id) OR (`exp` <= :U) ");
+                ->prepare("DELETE FROM `caching` WHERE (`id`=:id) OR (`exp` <= :U) ");
             $stm->execute(array(
-              ':id' => $row[ 'id' ],
-              ':U' => time(),
+                ':id' => $row[ 'id' ],
+                ':U' => time(),
             ));
         } catch (PDOException $e) {
             return false;
@@ -376,10 +376,10 @@ 
     {
         try {
             $stm = $this->db($keyword)
-              ->prepare("DELETE FROM `caching` WHERE (`keyword`=:keyword) OR (`exp` <= :U)");
+                ->prepare("DELETE FROM `caching` WHERE (`keyword`=:keyword) OR (`exp` <= :U)");
             $stm->execute(array(
-              ':keyword' => $keyword,
-              ':U' => time(),
+                ':keyword' => $keyword,
+                ':U' => time(),
             ));
         } catch (PDOException $e) {
             return false;
@@ -394,9 +394,9 @@ 
     public function driver_stats($option = array())
     {
         $res = array(
-          'info' => '',
-          'size' => '',
-          'data' => '',
+            'info' => '',
+            'size' => '',
+            'data' => '',
         );
         $total = 0;
         $optimized = 0;
@@ -411,11 +411,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(array(
-                      ':U' => date('U'),
+                        ':U' => date('U'),
                     ));
 
                     $PDO->exec('VACUUM;');
@@ -431,8 +431,8 @@ 
         }
         $res[ 'size' ] = $optimized;
         $res[ 'info' ] = array(
-          'total before removing expired entries [bytes]' => $total,
-          'optimized after removing expired entries [bytes]' => $optimized,
+            'total before removing expired entries [bytes]' => $total,
+            'optimized after removing expired entries [bytes]' => $optimized,
         );
 
         return $res;
@@ -465,9 +465,9 @@ 
     {
         try {
             $stm = $this->db($keyword)
-              ->prepare("SELECT COUNT(`id`) as `total` FROM `caching` WHERE `keyword`=:keyword");
+                ->prepare("SELECT COUNT(`id`) as `total` FROM `caching` WHERE `keyword`=:keyword");
             $stm->execute(array(
-              ':keyword' => $keyword,
+                ':keyword' => $keyword,
             ));
             $data = $stm->fetch(PDO::FETCH_ASSOC);
             if ($data[ 'total' ] >= 1) {