kristuff / patabase

lib/Query/QueryBuilder.php

Spacing +14 added lines, -14 removed lines

@@ -138,7 +138,7 @@ 
      *
      * @return string
      */
-    public function __construct( $driver)
+    public function __construct($driver)
     {
         $this->driver = $driver;
     }
@@ -202,7 +202,7 @@ 
             }
 
             // register error 
-            $this->error['code'] = (int)$e->getCode();
+            $this->error['code'] = (int) $e->getCode();
             $this->error['message'] = $e->getMessage();
             return false;
         }
@@ -226,13 +226,13 @@ 
                 $paramType = \PDO::PARAM_STR; // default
 
                 if (!isset($val)) {
-                    $paramType =  \PDO::PARAM_NULL;
+                    $paramType = \PDO::PARAM_NULL;
                 
                 } elseif (is_int($val)) {
-                    $paramType =  \PDO::PARAM_INT;
+                    $paramType = \PDO::PARAM_INT;
                 
                 } elseif (is_bool($val)) {
-                    $paramType =  \PDO::PARAM_BOOL;
+                    $paramType = \PDO::PARAM_BOOL;
                 } 
                 
                 // bind value
@@ -251,8 +251,8 @@ 
     {
         try {
             // prepare bind execute
-            if (!isset($this->pdoStatement)){
-               if (!$this->prepare()){
+            if (!isset($this->pdoStatement)) {
+               if (!$this->prepare()) {
                    return false;
                }
             }
@@ -267,7 +267,7 @@ 
             }
 
             // register error 
-            $this->error['code'] = (int)$e->getCode();
+            $this->error['code'] = (int) $e->getCode();
             $this->error['message'] = $e->getMessage();
             return false;
         }
@@ -297,23 +297,23 @@ 
      */
     protected static function fetchOutput(QueryBuilder $query, $executed, $outputFormat)
     {
-        switch (strtoupper($outputFormat)){
+        switch (strtoupper($outputFormat)) {
 
             case Outpout::ASSOC:    
-                return $executed ? $query->pdoStatement->fetchAll(\PDO::FETCH_ASSOC) :  array();
+                return $executed ? $query->pdoStatement->fetchAll(\PDO::FETCH_ASSOC) : array();
 
             case Outpout::OBJ:    
-                return $executed ? $query->pdoStatement->fetchAll(\PDO::FETCH_OBJ) :    array();
+                return $executed ? $query->pdoStatement->fetchAll(\PDO::FETCH_OBJ) : array();
 
             case Outpout::COLUMN:    
-                return $executed ? $query->pdoStatement->fetchAll(\PDO::FETCH_COLUMN) :  array();
+                return $executed ? $query->pdoStatement->fetchAll(\PDO::FETCH_COLUMN) : array();
 
             case Outpout::JSON:
-                $results = $executed ? $query->pdoStatement->fetchAll(\PDO::FETCH_ASSOC) :  array();
+                $results = $executed ? $query->pdoStatement->fetchAll(\PDO::FETCH_ASSOC) : array();
                 return json_encode($results, JSON_NUMERIC_CHECK);   
 
             case Outpout::JSON_PRETTY_PRINT:    
-                $results = $executed ? $query->pdoStatement->fetchAll(\PDO::FETCH_ASSOC) :  array();
+                $results = $executed ? $query->pdoStatement->fetchAll(\PDO::FETCH_ASSOC) : array();
                 return json_encode($results, JSON_PRETTY_PRINT | JSON_NUMERIC_CHECK);   
                 
             default:

lib/Query/Select.php

Indentation +13 added lines, -13 removed lines

@@ -105,7 +105,7 @@ 
                 case 'sub_query':
                     $colsList[] = '('. $val['query']->sql() .') AS '. $this->escape($val['alias']);
                     break;
-           }
+            }
         }
         return $sqlDistinct . implode(', ', $colsList);
     }
@@ -153,15 +153,15 @@ 
         }
 
         return trim(implode(' ', ['SELECT', 
-           $this->sqlColumns(), 
-           $sqlFromTable,
-           $sqlJoins,
-           $sqlWhere,
-           $sqlGroupBy,
-           $sqlHaving,
-           $sqlOrderBy,
-           $sqlLimit,
-           $sqlOffset]));
+            $this->sqlColumns(), 
+            $sqlFromTable,
+            $sqlJoins,
+            $sqlWhere,
+            $sqlGroupBy,
+            $sqlHaving,
+            $sqlOrderBy,
+            $sqlLimit,
+            $sqlOffset]));
     }
      
     /**
@@ -175,10 +175,10 @@ 
     public function getAll(string $outputFormat = 'default')
     {
         // execute query
-       $exec = $this->execute();
+        $exec = $this->execute();
 
-       // format
-       $format = ($outputFormat === 'default') ? $this->driver->defaultOutputFormat() : $outputFormat; 
+        // format
+        $format = ($outputFormat === 'default') ? $this->driver->defaultOutputFormat() : $outputFormat; 
 
         // return output
         return QueryBuilder::fetchOutput($this, $exec, $format);

lib/Driver/DatabaseDriver.php

Indentation +5 added lines, -5 removed lines

@@ -33,7 +33,7 @@ 
  */
 abstract class DatabaseDriver
 {
-   /**
+    /**
      * PDO connection
      *
      * @access protected
@@ -74,9 +74,9 @@ 
      * @var string
      */
     public function sqlCreateTableOptions()
-     {
+        {
         return '';    
-     } 
+        } 
 
     /**
      * Gets/returns the default output format 
@@ -135,8 +135,8 @@ 
      */
     public function escape($str)
     {
-       $list = explode('.', $str);
-       return implode('.', $this->escapeList($list));
+        $list = explode('.', $str);
+        return implode('.', $this->escapeList($list));
     }
 
     /**