kristuff / patabase

lib/Driver/Postgres/PostgresDriver.php

Indentation +11 added lines, -11 removed lines

@@ -121,9 +121,9 @@ 
      */
     public function lastInsertedId()
     {
-       // Postgres does not set pdo->lastInsertedId
-       // use sequence
-       try {
+        // Postgres does not set pdo->lastInsertedId
+        // use sequence
+        try {
             $rq = $this->pdo->prepare('SELECT LASTVAL()');
             $rq->execute();
             return $rq->fetchColumn();
@@ -168,11 +168,11 @@ 
     public function addForeignKey($fkName, $srcTable, $srcColumn, $refTable, $refColumn)
     {
         $sql = sprintf('ALTER TABLE %s ADD CONSTRAINT %s FOREIGN KEY (%s) REFERENCES %s(%s)',
-                       $this->escape($srcTable),
-                       $fkName,
-                       $this->escape($srcColumn),
-                       $this->escape($refTable),
-                       $this->escape($refColumn)
+                        $this->escape($srcTable),
+                        $fkName,
+                        $this->escape($srcColumn),
+                        $this->escape($refTable),
+                        $this->escape($refColumn)
         );
         return $this->prepareAndExecuteSql($sql);
     }
@@ -189,9 +189,9 @@ 
     public function dropForeignKey($fkName, $tableName, $ifExists = false)
     {
         $sql = sprintf('ALTER TABLE %s DROP CONSTRAINT %s %s',
-                       $this->escape($tableName),
-                       $ifExists ? 'IF EXISTS' : '',
-                       $fkName
+                        $this->escape($tableName),
+                        $ifExists ? 'IF EXISTS' : '',
+                        $fkName
         );
         return $this->prepareAndExecuteSql($sql);
     }

lib/Driver/Mysql/MysqlDriver.php

Indentation +9 added lines, -9 removed lines

@@ -147,11 +147,11 @@ 
     public function addForeignKey($fkName, $srcTable, $srcColumn, $refTable, $refColumn)
     {
         $sql = sprintf('ALTER TABLE %s ADD CONSTRAINT %s FOREIGN KEY (%s) REFERENCES %s(%s)',
-                       $this->escape($srcTable),
-                       $fkName,
-                       $this->escape($srcColumn),
-                       $this->escape($refTable),
-                       $this->escape($refColumn)
+                        $this->escape($srcTable),
+                        $fkName,
+                        $this->escape($srcColumn),
+                        $this->escape($refTable),
+                        $this->escape($refColumn)
         );
         return $this->prepareAndExecuteSql($sql);
     }
@@ -168,8 +168,8 @@ 
     public function dropForeignKey($fkName, $tableName)
     {
         $sql = sprintf('ALTER TABLE %s DROP FOREIGN KEY %s',
-                       $this->escape($tableName),
-                       $fkName
+                        $this->escape($tableName),
+                        $fkName
         );
         return $this->prepareAndExecuteSql($sql);
     }
@@ -223,7 +223,7 @@ 
                     "'" . $userPassword ."'"
         ));
         return $this->prepareAndExecuteSql($sql);
-   }
+    }
 
     /**
      * Drop a user
@@ -253,7 +253,7 @@ 
      *
      * @return bool     True if the user has been granted, otherwise false. 
      */
-     public function grantUser($databaseName, $userName)
+        public function grantUser($databaseName, $userName)
     {
         $sql = trim(sprintf('GRANT ALL ON %s.* TO %s@%s; FLUSH PRIVILEGES;', 
             $this->escape($databaseName),

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));
     }
 
     /**