tsukasa-mixer / QueryBuilder

src/BaseLookupCollection.php

Spacing +1 added lines, -1 removed lines

@@ -106,7 +106,7 @@
 
             case 'in':
                 if (is_array($value)) {
-                    $quotedValues = array_map(function ($item) use ($adapter) {
+                    $quotedValues = array_map(function($item) use ($adapter) {
                         return $adapter->quoteValue($item);
                     }, $value);
                     $sqlValue = implode(', ', $quotedValues);

src/BaseAdapter.php

Spacing +7 added lines, -7 removed lines

@@ -108,7 +108,7 @@ 
     public function setDriver($driver)
     {
         if (!($driver instanceof \PDO || $driver instanceof Connection)) {
-            throw new QBException('Drive must be instance PDO or '. Connection::class);
+            throw new QBException('Drive must be instance PDO or ' . Connection::class);
         }
 
         $this->driver = $driver;
@@ -340,7 +340,7 @@ 
                 $values[] = '(' . implode(', ', $record) . ')';
             }
 
-            $sql = 'INSERT'. $options .' INTO ' . $this->quoteTableName($tableName) . ' (' . implode(', ', $columns) . ') VALUES ' . implode(', ', $values);
+            $sql = 'INSERT' . $options . ' INTO ' . $this->quoteTableName($tableName) . ' (' . implode(', ', $columns) . ') VALUES ' . implode(', ', $values);
 
             return $this->quoteSql($sql);
         }
@@ -348,7 +348,7 @@ 
         $values = array_map([$this, 'quoteValue'], $rows);
         $columns = array_map([$this, 'quoteColumn'], array_keys($rows));
 
-        $sql = 'INSERT'. $options .' INTO ' . $this->quoteTableName($tableName) . ' (' . implode(', ', $columns) . ') VALUES (' . implode(', ', $values) . ')';
+        $sql = 'INSERT' . $options . ' INTO ' . $this->quoteTableName($tableName) . ' (' . implode(', ', $columns) . ') VALUES (' . implode(', ', $values) . ')';
 
         return $this->quoteSql($sql);
     }
@@ -364,7 +364,7 @@ 
             $options = " {$options} ";
         }
 
-        return 'UPDATE '. $options . $this->quoteTableName($tableName) . ' SET ' . implode(', ', $parts);
+        return 'UPDATE ' . $options . $this->quoteTableName($tableName) . ' SET ' . implode(', ', $parts);
     }
 
     /**
@@ -629,12 +629,12 @@ 
         $toSql = [$joinType];
         if (is_string($tableName) && $tableName = $this->getRawTableName($tableName)) {
             if (strpos($tableName, 'SELECT') !== false) {
-                $toSql[] = '(' . $this->quoteSql($tableName) . ')' ;
+                $toSql[] = '(' . $this->quoteSql($tableName) . ')';
             } else {
-                $toSql[]  = $this->quoteTableName($tableName);
+                $toSql[] = $this->quoteTableName($tableName);
             }
         } else if ($tableName instanceof QueryBuilder) {
-            $toSql[] =  '(' . $this->quoteSql($tableName->toSQL()) . ')' ;
+            $toSql[] = '(' . $this->quoteSql($tableName->toSQL()) . ')';
         } else {
             throw new QBException('Incorrect table name');
         }

Braces +5 added lines, -10 removed lines

@@ -806,8 +806,7 @@ 
                 if (!is_numeric($column)) {
                     $value .= ' AS ' . $this->quoteColumn($column);
                 }
-            }
-            else {
+            } else {
                 $subQuery = $this->quoteSql($expr);
 
                 if (is_numeric($column)) {
@@ -818,12 +817,10 @@ 
                 if (!empty($subQuery)) {
                     if (strpos($subQuery, 'SELECT') !== false) {
                         $value = '(' . $subQuery . ') AS ' . $this->quoteColumn($column);
-                    }
-                    else {
+                    } else {
                         $value = $this->quoteColumn($subQuery) . ' AS ' . $this->quoteColumn($column);
                     }
-                }
-                else if (strpos($column, ',') === false && strpos($column, 'AS') !== false) {
+                } else if (strpos($column, ',') === false && strpos($column, 'AS') !== false) {
 
                     list($rawColumn, $rawAlias) = explode('AS', $column);
                     $value = $this->quoteColumn(trim($rawColumn));
@@ -831,8 +828,7 @@ 
                     if (!empty($rawAlias)) {
                         $value .= ' AS ' . $this->quoteColumn(trim($rawAlias));
                     }
-                }
-                else if (strpos($column, ',') !== false) {
+                } else if (strpos($column, ',') !== false) {
                     $newSelect = [];
 
                     foreach (explode(',', $column) as $item) {
@@ -853,8 +849,7 @@ 
                     }
                     $value = implode(', ', $newSelect);
 
-                }
-                else {
+                } else {
                     $value = $this->quoteColumn($column);
                 }
             }

src/Expression/Expression.php

Spacing +2 added lines, -2 removed lines

@@ -50,10 +50,10 @@
         if (strpos($sql, '?'))
         {
             if (mb_substr_count($sql, '?') !== count($this->params)) {
-                throw new QBException('Incorrect parameters count in Expression: "'.addslashes($this->expression).'"');
+                throw new QBException('Incorrect parameters count in Expression: "' . addslashes($this->expression) . '"');
             }
 
-            $sql = preg_replace_callback('~\?~', function ($matches) {
+            $sql = preg_replace_callback('~\?~', function($matches) {
                 return $this->qb->getAdapter()->quoteValue(
                     $this->getNextParam()
                 );

src/QueryBuilder.php

Spacing +2 added lines, -2 removed lines

@@ -823,7 +823,7 @@ 
 
     public function generateDeleteSql()
     {
-        $options = $this->_queryOptions ;
+        $options = $this->_queryOptions;
         if ($options) {
             $options = " {$options} ";
         }
@@ -980,7 +980,7 @@ 
         $tableName = $this->getAdapter()->getRawTableName($table);
 
         if (strpos($tableName, '.') !== false) {
-            $tableName = substr($tableName, strpos($tableName, '.')+1);
+            $tableName = substr($tableName, strpos($tableName, '.') + 1);
         }
 
         return strtr('{table}_{count}', [

Braces +1 added lines, -2 removed lines

@@ -1120,8 +1120,7 @@
             foreach ($this->_order as $column) {
                 if ($column instanceof Expression) {
                     $order[$column->toSQL()] = '';
-                }
-                else if ($column === '?') {
+                } else if ($column === '?') {
                     $order[] = $this->getAdapter()->getRandomOrder();
                 } else {
                     list($newColumn, $direction) = $this->buildOrderJoin($column);