kristuff / patabase

lib/Server.php

Spacing +1 added lines, -1 removed lines

@@ -143,7 +143,7 @@
     public function dropDatabase($databaseName, $ifExists = false)
     {
         $sql = trim(sprintf('DROP DATABASE %s %s', 
-            $ifExists === true ? 'IF EXISTS': '',
+            $ifExists === true ? 'IF EXISTS' : '',
             $this->driver->escape($databaseName)));
         return $this->driver->prepareAndExecuteSql($sql);
     }

lib/Table.php

Spacing +3 added lines, -3 removed lines

@@ -92,7 +92,7 @@ 
     {
         $query = new Query\Update($this->database->getDriver(), $this->name);
         foreach ($parameters as $key => $val) {
-            $query->setValue($key,  $val);
+            $query->setValue($key, $val);
         }
         return $query;
     }
@@ -120,7 +120,7 @@ 
     {
         $query = new Query\Insert($this->database->getDriver(), $this->name);
         foreach ($parameters as $key => $val) {
-            $query->setValue($key,  $val);
+            $query->setValue($key, $val);
         }
         return $query;
     }
@@ -169,7 +169,7 @@ 
     public function rename($newName)
     {
        $result = $this->database->renameTable($this->name, $newName);
-       if ($result){
+       if ($result) {
             $this->name = $newName;
         }
         return $result;

lib/Query/InsertBase.php

Spacing +2 added lines, -2 removed lines

@@ -63,7 +63,7 @@ 
      */
     protected function getArgName($column)
     {
-         return '_' . str_replace('.', '_', $column);
+         return '_'.str_replace('.', '_', $column);
     }
 
     /**
@@ -78,7 +78,7 @@ 
     {
         // Define column parameters
         $columns = func_get_args();
-        if (!empty($columns)){
+        if (!empty($columns)) {
 
             // clear current parameters
             unset($this->parameters);

lib/Query/CreateTable.php

Spacing +23 added lines, -23 removed lines

@@ -148,50 +148,50 @@ 
     private function sqlColumns()
     {
         $result = array();
-        foreach ($this->columns as $col){
+        foreach ($this->columns as $col) {
 
             // Parse arguments. First item is NAME and second is TYPE
             $sqlName   = $this->escape($col[0]);
-            $sqlType   = $col[1];  //TODO check type
+            $sqlType   = $col[1]; //TODO check type
             
             // following arguments
-            $args       = array_slice($col, 2);
+            $args = array_slice($col, 2);
             $currentIndex       = 0;
             $defaultValueIndex  = -1;
 
-            $sqlConstraintUnique    = '';       // UNIQUE ?, not by default
-            $sqlConstraintNullable  = 'NULL';   // allow null value by default
-            $isPk                   = false;    // PRIMARY KEY?
-            $sqlDefault             = '';       // DEFAULT VALUE?
+            $sqlConstraintUnique    = ''; // UNIQUE ?, not by default
+            $sqlConstraintNullable  = 'NULL'; // allow null value by default
+            $isPk                   = false; // PRIMARY KEY?
+            $sqlDefault             = ''; // DEFAULT VALUE?
 
-            foreach ($args as $arg){
+            foreach ($args as $arg) {
 
                 // last index was DEFAULT, so the current argument 
                 // is the value for default contsaint
-                if ($currentIndex === $defaultValueIndex){
+                if ($currentIndex === $defaultValueIndex) {
                     
                     // string
-                    if (is_string($arg)){
+                    if (is_string($arg)) {
                             
                         // escape everything except constants
-                        if (in_array(strtoupper($arg), $this->supportedDefaults)){
-                            $sqlDefault = 'DEFAULT ' . $arg;
+                        if (in_array(strtoupper($arg), $this->supportedDefaults)) {
+                            $sqlDefault = 'DEFAULT '.$arg;
                         } else {
-                            $sqlDefault = 'DEFAULT ' . $this->driver->escapeValue($arg);
+                            $sqlDefault = 'DEFAULT '.$this->driver->escapeValue($arg);
                         }
                         
                     // int/float are not escaped
-                    } elseif (is_int($arg) || is_float($arg)){
-                        $sqlDefault = 'DEFAULT ' . $arg;
+                    } elseif (is_int($arg) || is_float($arg)) {
+                        $sqlDefault = 'DEFAULT '.$arg;
 
                     // bool Type
-                    } elseif (is_bool($arg)){
-                        $sqlDefault = 'DEFAULT ' . ($arg ? 'TRUE' : 'FALSE');                            
+                    } elseif (is_bool($arg)) {
+                        $sqlDefault = 'DEFAULT '.($arg ? 'TRUE' : 'FALSE');                            
                     }
 
 
                 } else {
-                    switch (strtoupper($arg)){
+                    switch (strtoupper($arg)) {
                         
                         // NULL  /NOT NULL 
                         case 'NULL':
@@ -225,14 +225,14 @@ 
                         // DEFAULT
                         case 'DEFAULT':
                             // define next index as the DefaultValue index
-                            $defaultValueIndex = $currentIndex +1;
+                            $defaultValueIndex = $currentIndex+1;
                             break;
                     
                     }
                 }
 
                 // update  current index
-                $currentIndex ++;
+                $currentIndex++;
             }
 
             // set optional params
@@ -247,8 +247,8 @@ 
         }
 
         // FK CONSTRANT
-        foreach ($this->foreignKeys as $foreignKey){
-            $result[] =  trim(sprintf('CONSTRAINT %s FOREIGN KEY (%s) REFERENCES %s(%s)', 
+        foreach ($this->foreignKeys as $foreignKey) {
+            $result[] = trim(sprintf('CONSTRAINT %s FOREIGN KEY (%s) REFERENCES %s(%s)', 
                             $foreignKey['name'], 
                             $this->driver->escapeIdentifier($foreignKey['src_column']), 
                             $this->driver->escapeIdentifier($foreignKey['ref_table']),
@@ -268,7 +268,7 @@ 
     public function sql()
     {
         $sqlTableName = $this->driver->escape($this->tableName);
-        $sqlIfNotExists =  $this->isNotExists === true ? 'IF NOT EXISTS' : '';
+        $sqlIfNotExists = $this->isNotExists === true ? 'IF NOT EXISTS' : '';
 
         return trim(sprintf(
             'CREATE TABLE %s %s (%s) %s',

lib/Query/Insert.php

Spacing +1 added lines, -1 removed lines

@@ -46,7 +46,7 @@
         foreach ($this->parameters as $key => $val) {
             $arg = $this->getArgName($key);
             $columnsNames[]    = $this->escape($key); 
-            $columnsValues[]   = ':' . $arg;
+            $columnsValues[]   = ':'.$arg;
         }        
         return trim(sprintf(
             'INSERT INTO %s (%s) VALUES (%s)',

lib/Query/Delete.php

Spacing +1 added lines, -1 removed lines

@@ -64,7 +64,7 @@
      */
     public function where()
     {
-        if (!isset($this->where)){
+        if (!isset($this->where)) {
             $this->where = new Query\Where($this, $this->driver);
         }
         return $this->where; 

lib/Query/QueryBase.php

Spacing +1 added lines, -1 removed lines

@@ -58,7 +58,7 @@
      */
     public function errorCode()
     {
-        return !empty($this->error) ? $this->error['code']: null;
+        return !empty($this->error) ? $this->error['code'] : null;
     }
 
     /**

lib/Query/Having.php

Spacing +2 added lines, -2 removed lines

@@ -53,7 +53,7 @@ 
      */
     public function fn($function, $column, $operator, $value)
     {
-        $sql = $function .'('. ($column ? $this->query->escape($column): '') . ') ' . $operator . ' ';
+        $sql = $function.'('.($column ? $this->query->escape($column) : '').') '.$operator.' ';
         $this->addCondition($function, $sql, $column, $value);
         return $this->returnFunction();
     }
@@ -69,7 +69,7 @@ 
      */
     public function count($operator, $value)
     {
-        $sql = 'COUNT(*) '. $operator. ' ';
+        $sql = 'COUNT(*) '.$operator.' ';
         $this->addCondition('COUNT', $sql, 'COUNT', $value);
         return $this->returnFunction();
     }

lib/Query/SelectBase.php

Spacing +6 added lines, -6 removed lines

@@ -120,7 +120,7 @@ 
         $this->topQuery = $query;
 
         // columns arguments
-        if (! empty($args)) {
+        if (!empty($args)) {
             $this->parseColumnsArguments($args);
         }
     }
@@ -139,7 +139,7 @@ 
         $cols = (count($args) === 1 && is_array($args[0])) ? $args[0] : $args;
 
         // parse column
-        foreach ($cols as $key => $value){
+        foreach ($cols as $key => $value) {
             
             // Each arg could be a non indexed array of name, or 
             // an indexed array name => alias
@@ -373,7 +373,7 @@ 
      */
     public function where()
     {
-        if (!isset($this->where)){
+        if (!isset($this->where)) {
             $this->where = new Query\Where($this, $this->driver, $this->topQuery);
         }
         return $this->where; 
@@ -400,7 +400,7 @@ 
      */
     public function having()
     {
-        if (!isset($this->having)){
+        if (!isset($this->having)) {
             $this->having = new Query\Having($this, $this->driver, $this->topQuery);
         }
         return $this->having; 
@@ -487,7 +487,7 @@ 
      */
     public function limit($value)
     {
-        if (! is_null($value)) {
+        if (!is_null($value)) {
             $this->limit = (int) $value;
         }
         return $this;
@@ -503,7 +503,7 @@ 
      */
     public function offset($value)
     {
-        if (! is_null($value)) {
+        if (!is_null($value)) {
             $this->offset = (int) $value;
         }
         return $this;