kristuff / patabase

lib/Database.php

Indentation +1 added lines, -1 removed lines

@@ -97,7 +97,7 @@
      * @param string    $tableName      The name of the table
      * 
      * @return bool     True if the table has been dropped, otherwise false
-      */
+     */
     public function dropTable(string $tableName): bool
     {
         $sql = trim(sprintf('DROP TABLE %s', $tableName));

lib/Driver/DatabaseDriver.php

Indentation +2 added lines, -2 removed lines

@@ -131,8 +131,8 @@
      */
     public function escape(string $str): string
     {
-       $list = explode('.', $str);
-       return implode('.', $this->escapeList($list));
+        $list = explode('.', $str);
+        return implode('.', $this->escapeList($list));
     }
 
     /**

lib/Driver/Postgres/PostgresDriver.php

Indentation +11 added lines, -12 removed lines

@@ -122,9 +122,9 @@ 
      */
     public function lastInsertedId(): string
     {
-       // 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 string 
@@ -158,7 +158,6 @@ 
     /**
      * Get whether foreign keys are enabled or not
      * For compatibility with Sqlite, not implemented in that driver, return false 
-
      * @access public
      * @return bool     true if foreign keys are enabled, otherwise false
      */
@@ -182,11 +181,11 @@ 
     public function addForeignKey(string $fkName, string $srcTable, string $srcColumn, string $refTable, string $refColumn): bool
     {
         $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);
     }
@@ -203,9 +202,9 @@ 
     public function dropForeignKey(string $fkName, string $tableName, bool $ifExists = false): bool
     {
         $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 +10 added lines, -11 removed lines

@@ -86,7 +86,7 @@ 
         $port    = !empty($settings['port'])     ?  ';port='.$settings['port']        : '';
         $dbname  = !empty($settings['database']) ?  ';dbname='.$settings['database']  : '';
         $options = [
-          //  \PDO::ATTR_EMULATE_PREPARES => false,
+            //  \PDO::ATTR_EMULATE_PREPARES => false,
         ];
 
         $this->pdo = new \PDO(
@@ -138,7 +138,6 @@ 
     /**
      * Get whether foreign keys are enabled or not
      * For compatibility with Sqlite, not implemented in that driver, return false 
-
      * @access public
      * @return bool     true if foreign keys are enabled, otherwise false
      */
@@ -162,11 +161,11 @@ 
     public function addForeignKey(string $fkName, string $srcTable, string $srcColumn, string $refTable, string $refColumn): bool
     {
         $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);
     }
@@ -183,8 +182,8 @@ 
     public function dropForeignKey(string $fkName, string $tableName): bool
     {
         $sql = sprintf('ALTER TABLE %s DROP FOREIGN KEY %s',
-                       $this->escape($tableName),
-                       $fkName
+                        $this->escape($tableName),
+                        $fkName
         );
         return $this->prepareAndExecuteSql($sql);
     }
@@ -239,7 +238,7 @@ 
                     "'" . $userPassword ."'"
         ));
         return $this->prepareAndExecuteSql($sql);
-   }
+    }
 
     /**
      * Drop a user
@@ -269,7 +268,7 @@ 
      *
      * @return bool     True if the user has been granted, otherwise false. 
      */
-     public function grantUser(string $databaseName, string $userName): bool
+        public function grantUser(string $databaseName, string $userName): bool
     {
         $sql = trim(sprintf('GRANT ALL ON %s.* TO %s@%s; FLUSH PRIVILEGES;', 
             $this->escape($databaseName),

lib/Query/InsertBase.php

Indentation +1 added lines, -1 removed lines

@@ -61,7 +61,7 @@
      */
     protected function getArgName(string $column): string
     {
-         return '_' . str_replace('.', '_', $column);
+            return '_' . str_replace('.', '_', $column);
     }
 
     /**

lib/Query/Delete.php

Indentation +5 added lines, -5 removed lines

@@ -90,12 +90,12 @@
      */
     public function sql(): string
     {
-       // Build sql where and escape table name
-       $sqlWhere = (isset($this->where)) ? $this->where->sql() : '';
-       $sqlTableName = $this->escape($this->tableName);
+        // Build sql where and escape table name
+        $sqlWhere = (isset($this->where)) ? $this->where->sql() : '';
+        $sqlTableName = $this->escape($this->tableName);
        
-       // DELETE query
-       return trim(sprintf('DELETE FROM %s %s', 
+        // DELETE query
+        return trim(sprintf('DELETE FROM %s %s', 
                             $sqlTableName, 
                             $sqlWhere));
     }

lib/Query/SelectBase.php

Indentation +6 added lines, -6 removed lines

@@ -100,7 +100,7 @@ 
      * @access protected
      * @var QueryBuilder
      */
-     protected $topQuery = null;
+        protected $topQuery = null;
 
     /**
      * Constructor
@@ -121,7 +121,7 @@ 
         }
     }
 
-   /**
+    /**
      * Parse the columns arguments for the select query
      *
      * @access protected
@@ -199,7 +199,7 @@ 
      */
     public function count(string $alias)
     {
-         $this->columns[] = array(
+            $this->columns[] = array(
             'type'  => 'count',
             'alias' => $alias
         );
@@ -216,7 +216,7 @@ 
      */
     public function sum(string $column, string $alias)
     {
-         $this->columns[] = array(
+            $this->columns[] = array(
             'type'  => 'sum',
             'name'  => $column,
             'alias' => $alias
@@ -234,7 +234,7 @@ 
      */
     public function min(string $column, string $alias)
     {
-         $this->columns[] = array(
+            $this->columns[] = array(
             'type'  => 'min',
             'name'  => $column,
             'alias' => $alias
@@ -252,7 +252,7 @@ 
      */
     public function max(string $column, string $alias)
     {
-         $this->columns[] = array(
+            $this->columns[] = array(
             'type'  => 'max',
             'name'  => $column,
             'alias' => $alias

lib/Query/Select.php

Indentation +13 added lines, -13 removed lines

@@ -110,7 +110,7 @@ 
                 case 'sub_query':
                     $colsList[] = '('. $val['query']->sql() .') AS '. $this->escape($val['alias']);
                     break;
-           }
+            }
         }
         return $sqlDistinct . implode(', ', $colsList);
     }
@@ -158,15 +158,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]));
     }
      
     /**
@@ -180,10 +180,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 $this->fetchOutput($exec, $format);

lib/Query/QueryBuilder.php

Indentation +5 added lines, -5 removed lines

@@ -111,7 +111,7 @@ 
      */
     public function escape(string $str): string
     {
-       return $this->driver->escape($str);
+        return $this->driver->escape($str);
     }
 
     /**
@@ -188,7 +188,7 @@ 
      */
     public function prepare()
     {
-         try {
+            try {
             // prepare is in a try catch block because sqlite for example could raise 
             // an exception when prepareing the statement (with invalid table name for example)
             // when mysql and postres wont. 
@@ -253,9 +253,9 @@ 
         try {
             // prepare bind execute
             if (!isset($this->pdoStatement)){
-               if (!$this->prepare()){
-                   return false;
-               }
+                if (!$this->prepare()){
+                    return false;
+                }
             }
             $this->bindValues();
             return $this->pdoStatement ? $this->pdoStatement->execute() : false;