kristuff / patabase

lib/Server.php

Indentation +1 added lines, -1 removed lines

@@ -30,7 +30,7 @@
  *
  * Represents a connection to SQL database server
  */
- class Server extends Datasource
+    class Server extends Datasource
 {
 
     /**

lib/Table.php

Indentation +2 added lines, -2 removed lines

@@ -168,8 +168,8 @@
      */
     public function rename($newName)
     {
-       $result = $this->database->renameTable($this->name, $newName);
-       if ($result){
+        $result = $this->database->renameTable($this->name, $newName);
+        if ($result){
             $this->name = $newName;
         }
         return $result;

lib/Query/InsertBase.php

Indentation +1 added lines, -1 removed lines

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

lib/Query/CreateTable.php

Indentation +10 added lines, -10 removed lines

@@ -109,8 +109,8 @@ 
      */
     public function column()
     {
-       $this->columns[] = func_get_args();
-       return $this;
+        $this->columns[] = func_get_args();
+        return $this;
     }
      
     /**
@@ -128,15 +128,15 @@ 
      */
     public function fk($fkName, $srcColumn, $refTable, $refColumn, $onUpdate = 'CASCADE', $onDelete = 'RESTRICT')
     {
-       $this->foreignKeys[] = array(
+        $this->foreignKeys[] = array(
             'name'          => $fkName,
             'src_column'    => $srcColumn,
             'ref_table'     => $refTable,
             'ref_column'    => $refColumn,
             'on_update'     => $onUpdate,
             'on_delete'     => $onDelete
-       );
-       return $this;
+        );
+        return $this;
     }
 
     /**
@@ -239,11 +239,11 @@ 
             // PK ?, UNIQUE ?, NULL? (PK cannot be null), DEFAULT?
             // AI is handle with sqltype
             $result[] = trim(implode(' ', [$sqlName, 
-                                           $sqlType, 
-                                           $isPk ? 'NOT NULL' : $sqlConstraintNullable,
-                                           $isPk ? 'PRIMARY KEY' : '',
-                                           $sqlConstraintUnique,
-                                           $sqlDefault]));
+                                            $sqlType, 
+                                            $isPk ? 'NOT NULL' : $sqlConstraintNullable,
+                                            $isPk ? 'PRIMARY KEY' : '',
+                                            $sqlConstraintUnique,
+                                            $sqlDefault]));
         }
 
         // FK CONSTRANT

lib/Query/QueryBuilder.php

Indentation +5 added lines, -5 removed lines

@@ -109,7 +109,7 @@ 
      */
     public function escape($str)
     {
-       return $this->driver->escape($str);
+        return $this->driver->escape($str);
     }
 
     /**
@@ -186,7 +186,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. 
@@ -251,9 +251,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;

lib/Query/Delete.php

Indentation +5 added lines, -5 removed lines

@@ -90,12 +90,12 @@
      */
     public function sql()
     {
-       // 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/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($ouputFormat = 'default')
     {
         // execute query
-       $exec = $this->execute();
+        $exec = $this->execute();
 
-       // format
-       $format = ($ouputFormat === 'default') ? $this->driver->defaultOutputFormat() : $ouputFormat; 
+        // format
+        $format = ($ouputFormat === 'default') ? $this->driver->defaultOutputFormat() : $ouputFormat; 
 
         // return output
         return QueryBuilder::fetchOutput($this, $exec, $format);

lib/Query/SelectBase.php

Indentation +4 added lines, -4 removed lines

@@ -104,7 +104,7 @@ 
      * @access protected
      * @var    QueryBuilder
      */
-     protected $topQuery = null;
+        protected $topQuery = null;
 
     /**
      * Constructor
@@ -125,7 +125,7 @@ 
         }
     }
 
-   /**
+    /**
      * Parse the columns arguments for the select query
      *
      * @access protected
@@ -203,7 +203,7 @@ 
      */
     public function count($alias)
     {
-         $this->columns[] = array(
+            $this->columns[] = array(
             'type'  => 'count',
             'alias' => $alias
         );
@@ -220,7 +220,7 @@ 
      */
     public function sum($column, $alias)
     {
-         $this->columns[] = array(
+            $this->columns[] = array(
             'type'  => 'sum',
             'name'  => $column,
             'alias' => $alias

lib/Query/QueryFilter.php

Indentation +3 added lines, -3 removed lines

@@ -204,7 +204,7 @@ 
      */
     protected function returnFunction()
     {
-         return $this->isGroupOpen === true ? $this : $this->query;
+            return $this->isGroupOpen === true ? $this : $this->query;
     }
 
     /**
@@ -262,7 +262,7 @@ 
                         $sql .= ')';
                         break;
 
-                   case 'NULL':
+                    case 'NULL':
                    case 'NOT_NULL':
                         $sql .=  $isSqlNeedOperator ? ' '.$currentOperator.' ' : '';
                         $sql .=  $item['sql'];
@@ -279,7 +279,7 @@ 
                         if (is_string($item['value']) && 
                             strlen($item['value']) >  strlen(Patabase\Constants::COLUMN_LITERALL) &&
                             substr($item['value'], 0, strlen(Patabase\Constants::COLUMN_LITERALL)) === 
-                                                             Patabase\Constants::COLUMN_LITERALL) {
+                                                                Patabase\Constants::COLUMN_LITERALL) {
 
                             $arg = substr($item['value'], strlen(Patabase\Constants::COLUMN_LITERALL));
                             $sql .=  $isSqlNeedOperator ? ' '.$currentOperator.' ' : '';

Braces +1 added lines, -1 removed lines

@@ -285,7 +285,7 @@
                             $sql .=  $isSqlNeedOperator ? ' '.$currentOperator.' ' : '';
                             $sql .=  $item['sql'] . $this->query->escape($arg);
 
-                        }   else {
+                        } else {
                                 // *normal* value 
                                 $arg = $this->getArgumentName($item['column']);
                                 $sql .=  $isSqlNeedOperator ? ' '.$currentOperator.' ' : '';