gin0115 / pixie-wpdb

src/AliasFacade.php

Spacing +1 added lines, -1 removed lines

@@ -25,7 +25,7 @@
      */
     public static function __callStatic($method, $args)
     {
-        if (!static::$queryBuilderInstance) {
+        if ( ! static::$queryBuilderInstance) {
             static::$queryBuilderInstance = new QueryBuilderHandler();
         }
 

src/Binding.php

Spacing +2 added lines, -2 removed lines

@@ -125,7 +125,7 @@ 
     protected function verifyType(?string $type): void
     {
         $validTypes = [self::STRING, self::BOOL, self::FLOAT, self::INT, self::JSON, self::RAW];
-        if (null !== $type && !in_array($type, $validTypes, true)) {
+        if (null !== $type && ! in_array($type, $validTypes, true)) {
             throw new Exception("{$type} is not a valid type to use for Bindings.", 1);
         }
     }
@@ -137,7 +137,7 @@ 
      */
     public function hasTypeDefined(): bool
     {
-        return !\in_array($this->type, [null, self::RAW], true);
+        return ! \in_array($this->type, [null, self::RAW], true);
     }
 
     /**

src/Connection.php

Spacing +1 added lines, -1 removed lines

@@ -64,7 +64,7 @@
         }
 
         // Preserve the first database connection with a static property
-        if (!static::$storedConnection) {
+        if ( ! static::$storedConnection) {
             static::$storedConnection = $this;
         }
     }

src/QueryBuilder/QueryObject.php

Spacing +1 added lines, -1 removed lines

@@ -28,7 +28,7 @@
      */
     public function __construct(string $sql, array $bindings, wpdb $dbInstance)
     {
-        $this->sql        = (string)$sql;
+        $this->sql        = (string) $sql;
         $this->bindings   = $bindings;
         $this->dbInstance = $dbInstance;
     }

src/QueryBuilder/Raw.php

Spacing +3 added lines, -3 removed lines

@@ -20,8 +20,8 @@ 
      */
     public function __construct($value, $bindings = [])
     {
-        $this->value    = (string)$value;
-        $this->bindings = (array)$bindings;
+        $this->value    = (string) $value;
+        $this->bindings = (array) $bindings;
     }
 
     /**
@@ -49,6 +49,6 @@ 
      */
     public function __toString()
     {
-        return (string)$this->value;
+        return (string) $this->value;
     }
 }

src/EventHandler.php

Spacing +2 added lines, -2 removed lines

@@ -86,7 +86,7 @@ 
             // Fire before events for :any table
             if ($action = $this->getEvent($event, $table)) {
                 // Make an event id, with event type and table
-                $eventId = $event . $table;
+                $eventId = $event.$table;
 
                 // Fire event
                 $handlerParams = func_get_args();
@@ -94,7 +94,7 @@ 
                 // Add to fired list
                 $this->firedEvents[] = $eventId;
                 $result              = call_user_func_array($action, $handlerParams);
-                if (!is_null($result)) {
+                if ( ! is_null($result)) {
                     return $result;
                 }
             }

src/Hydration/Hydrator.php

Spacing +1 added lines, -1 removed lines

@@ -195,6 +195,6 @@
     {
         return $underscore
             ? "set_{$property}"
-            : 'set' . ucfirst($property);
+            : 'set'.ucfirst($property);
     }
 }

src/QueryBuilder/WPDBAdapter.php

Spacing +43 added lines, -43 removed lines

@@ -49,9 +49,9 @@ 
      */
     public function select(array $statements): array
     {
-        if (!array_key_exists('tables', $statements)) {
+        if ( ! array_key_exists('tables', $statements)) {
             throw new Exception('No table specified.', 3);
-        } elseif (!array_key_exists('selects', $statements)) {
+        } elseif ( ! array_key_exists('selects', $statements)) {
             $statements['selects'][] = '*';
         }
 
@@ -66,7 +66,7 @@ 
         // Group bys
         $groupBys = '';
         if (isset($statements['groupBys']) && $groupBys = $this->arrayStr($statements['groupBys'], ', ')) {
-            $groupBys = 'GROUP BY ' . $groupBys;
+            $groupBys = 'GROUP BY '.$groupBys;
         }
 
         // Order bys
@@ -77,17 +77,17 @@ 
                 if ($field instanceof Closure) {
                     continue;
                 }
-                $orderBys .= $field . ' ' . $orderBy['type'] . ', ';
+                $orderBys .= $field.' '.$orderBy['type'].', ';
             }
 
             if ($orderBys = trim($orderBys, ', ')) {
-                $orderBys = 'ORDER BY ' . $orderBys;
+                $orderBys = 'ORDER BY '.$orderBys;
             }
         }
 
         // Limit and offset
-        $limit  = isset($statements['limit']) ? 'LIMIT ' . (int) $statements['limit'] : '';
-        $offset = isset($statements['offset']) ? 'OFFSET ' . (int) $statements['offset'] : '';
+        $limit  = isset($statements['limit']) ? 'LIMIT '.(int) $statements['limit'] : '';
+        $offset = isset($statements['offset']) ? 'OFFSET '.(int) $statements['offset'] : '';
 
         // Having
         list($havingCriteria, $havingBindings) = $this->buildCriteriaWithType($statements, 'havings', 'HAVING');
@@ -97,7 +97,7 @@ 
 
         /** @var string[] */
         $sqlArray = [
-            'SELECT' . (isset($statements['distinct']) ? ' DISTINCT' : ''),
+            'SELECT'.(isset($statements['distinct']) ? ' DISTINCT' : ''),
             $selects,
             'FROM',
             $tables,
@@ -131,7 +131,7 @@ 
     public function criteriaOnly(array $statements, bool $bindValues = true): array
     {
         $sql = $bindings = [];
-        if (!isset($statements['criteria'])) {
+        if ( ! isset($statements['criteria'])) {
             return compact('sql', 'bindings');
         }
 
@@ -153,7 +153,7 @@ 
      */
     private function doInsert(array $statements, array $data, string $type): array
     {
-        if (!isset($statements['tables'])) {
+        if ( ! isset($statements['tables'])) {
             throw new Exception('No table specified', 3);
         }
 
@@ -174,20 +174,20 @@ 
             if ($value instanceof Raw) {
                 $values[] = $this->parseRaw($value);
             } elseif ($isBindings) {
-                $values[]   =  $value->getType();
+                $values[]   = $value->getType();
                 $bindings[] = $value->getValue();
             } else {
-                $values[]   =  $this->inferType($value);
+                $values[]   = $this->inferType($value);
                 $bindings[] = $value;
             }
         }
 
         $sqlArray = [
-        $type . ' INTO',
+        $type.' INTO',
         $this->wrapSanitizer($table),
-        '(' . $this->arrayStr($keys, ',') . ')',
+        '('.$this->arrayStr($keys, ',').')',
         'VALUES',
-        '(' . $this->arrayStr($values, ',') . ')',
+        '('.$this->arrayStr($values, ',').')',
         ];
 
         if (isset($statements['onduplicate'])) {
@@ -195,7 +195,7 @@ 
                 throw new Exception('No data given.', 4);
             }
             list($updateStatement, $updateBindings) = $this->getUpdateStatement($statements['onduplicate']);
-            $sqlArray[]                             = 'ON DUPLICATE KEY UPDATE ' . $updateStatement;
+            $sqlArray[]                             = 'ON DUPLICATE KEY UPDATE '.$updateStatement;
             $bindings                               = array_merge($bindings, $updateBindings);
         }
 
@@ -303,12 +303,12 @@ 
             }
 
             if ($value instanceof Raw) {
-                $statement .= $this->stringifyValue($this->wrapSanitizer($key)) . '=' . $value . ',';
+                $statement .= $this->stringifyValue($this->wrapSanitizer($key)).'='.$value.',';
             } elseif ($isBindings) {
-                $statement .= $this->stringifyValue($this->wrapSanitizer($key)) . sprintf('=%s,', $value->getType());
+                $statement .= $this->stringifyValue($this->wrapSanitizer($key)).sprintf('=%s,', $value->getType());
                 $bindings[] = $value->getValue();
             } else {
-                $statement .= $this->stringifyValue($this->wrapSanitizer($key)) . sprintf('=%s,', $this->inferType($value));
+                $statement .= $this->stringifyValue($this->wrapSanitizer($key)).sprintf('=%s,', $this->inferType($value));
                 $bindings[] = $value;
             }
         }
@@ -330,7 +330,7 @@ 
      */
     public function update($statements, array $data)
     {
-        if (!isset($statements['tables'])) {
+        if ( ! isset($statements['tables'])) {
             throw new Exception('No table specified', 3);
         } elseif (count($data) < 1) {
             throw new Exception('No data given.', 4);
@@ -345,12 +345,12 @@ 
         list($whereCriteria, $whereBindings) = $this->buildCriteriaWithType($statements, 'wheres', 'WHERE');
 
         // Limit
-        $limit = isset($statements['limit']) ? 'LIMIT ' . $statements['limit'] : '';
+        $limit = isset($statements['limit']) ? 'LIMIT '.$statements['limit'] : '';
 
         $sqlArray = [
             'UPDATE',
             $this->wrapSanitizer($table),
-            'SET ' . $updateStatement,
+            'SET '.$updateStatement,
             $whereCriteria,
             $limit,
         ];
@@ -373,7 +373,7 @@ 
      */
     public function delete($statements)
     {
-        if (!isset($statements['tables'])) {
+        if ( ! isset($statements['tables'])) {
             throw new Exception('No table specified', 3);
         }
 
@@ -388,7 +388,7 @@ 
         list($whereCriteria, $whereBindings) = $this->buildCriteriaWithType($statements, 'wheres', 'WHERE');
 
         // Limit
-        $limit = isset($statements['limit']) ? 'LIMIT ' . $statements['limit'] : '';
+        $limit = isset($statements['limit']) ? 'LIMIT '.$statements['limit'] : '';
 
         $sqlArray = ['DELETE FROM', $table, $whereCriteria];
         $sql      = $this->concatenateQuery($sqlArray);
@@ -410,11 +410,11 @@ 
     {
         $str = '';
         foreach ($pieces as $key => $piece) {
-            if (!is_int($key)) {
-                $piece = $key . ' AS ' . $piece;
+            if ( ! is_int($key)) {
+                $piece = $key.' AS '.$piece;
             }
 
-            $str .= $piece . $glue;
+            $str .= $piece.$glue;
         }
 
         return trim($str, $glue);
@@ -431,7 +431,7 @@ 
     {
         $str = '';
         foreach ($pieces as $piece) {
-            $str = trim($str) . ' ' . trim($piece);
+            $str = trim($str).' '.trim($piece);
         }
 
         return trim($str);
@@ -446,7 +446,7 @@ 
     public function getType($value): string
     {
         return $value instanceof Binding && $value->getType() !== null
-            ? $value->getType() : $this->inferType($value) ;
+            ? $value->getType() : $this->inferType($value);
     }
 
     /**
@@ -489,7 +489,7 @@ 
 
 
         $bindings = array_map([$this, 'getValue'], $bindings);
-        $query = $this->connection->getDbInstance()->prepare($query, $bindings) ;
+        $query = $this->connection->getDbInstance()->prepare($query, $bindings);
         return is_string($query) ? $query : '';
     }
 
@@ -530,10 +530,10 @@ 
                 // Merge the bindings we get from nestedCriteria object
                 $bindings = array_merge($bindings, $queryObject->getBindings());
                 // Append the sql we get from the nestedCriteria object
-                $criteria .= $statement['joiner'] . ' (' . $queryObject->getSql() . ') ';
+                $criteria .= $statement['joiner'].' ('.$queryObject->getSql().') ';
             } elseif (is_array($value)) {
                 // where_in or between like query
-                $criteria .= $statement['joiner'] . ' ' . $key . ' ' . $statement['operator'];
+                $criteria .= $statement['joiner'].' '.$key.' '.$statement['operator'];
 
                 switch ($statement['operator']) {
                     case 'BETWEEN':
@@ -549,7 +549,7 @@ 
                         $value[1] = $this->getValue($value[1]);
 
                         // Parse any raws.
-                        $value = array_map(function ($value) {
+                        $value = array_map(function($value) {
                             return $value instanceof Raw
                                 ? $this->parseRaw($value)
                                 : $value;
@@ -573,7 +573,7 @@ 
                         }
 
                         $valuePlaceholder = trim($valuePlaceholder, ', ');
-                        $criteria .= ' (' . $valuePlaceholder . ') ';
+                        $criteria .= ' ('.$valuePlaceholder.') ';
                         break;
                 }
             } elseif ($value instanceof Raw) {
@@ -581,20 +581,20 @@ 
                 $criteria .= "{$statement['joiner']} {$key} {$statement['operator']} $value ";
             } else {
                 // Usual where like criteria
-                if (!$bindValues) {
+                if ( ! $bindValues) {
                     // Specially for joins
                     // We are not binding values, lets sanitize then
                     $value = $this->stringifyValue($this->wrapSanitizer($value)) ?? '';
-                    $criteria .= $statement['joiner'] . ' ' . $key . ' ' . $statement['operator'] . ' ' . $value . ' ';
+                    $criteria .= $statement['joiner'].' '.$key.' '.$statement['operator'].' '.$value.' ';
                 } elseif ($statement['key'] instanceof Raw) {
-                    $criteria .= $statement['joiner'] . ' ' . $key . ' ';
+                    $criteria .= $statement['joiner'].' '.$key.' ';
                     $bindings = array_merge($bindings, $statement['key']->getBindings());
                 } else {
                     // For wheres
                     $bindings[] = $this->getValue($value);
 
-                    $criteria .= $statement['joiner'] . ' ' . $key . ' ' . $statement['operator'] . ' '
-                    . $this->getType($value) . ' ';
+                    $criteria .= $statement['joiner'].' '.$key.' '.$statement['operator'].' '
+                    . $this->getType($value).' ';
                 }
             }
         }
@@ -649,7 +649,7 @@ 
 
         foreach ($valueArr as $key => $subValue) {
             // Don't wrap if we have *, which is not a usual field
-            $valueArr[$key] = '*' == trim($subValue) ? $subValue : $this->sanitizer . $subValue . $this->sanitizer;
+            $valueArr[$key] = '*' == trim($subValue) ? $subValue : $this->sanitizer.$subValue.$this->sanitizer;
         }
 
         // Join these back with "." and return
@@ -676,7 +676,7 @@ 
             list($criteria, $bindings) = $this->buildCriteria($statements[$key], $bindValues);
 
             if ($criteria) {
-                $criteria = $type . ' ' . $criteria;
+                $criteria = $type.' '.$criteria;
             }
         }
 
@@ -697,7 +697,7 @@ 
     {
         $sql = '';
 
-        if (!array_key_exists('joins', $statements) || !is_array($statements['joins'])) {
+        if ( ! array_key_exists('joins', $statements) || ! is_array($statements['joins'])) {
             return $sql;
         }
 
@@ -705,7 +705,7 @@ 
             if (is_array($joinArr['table'])) {
                 $mainTable  = $this->stringifyValue($this->wrapSanitizer($joinArr['table'][0]));
                 $aliasTable = $this->stringifyValue($this->wrapSanitizer($joinArr['table'][1]));
-                $table      = $mainTable . ' AS ' . $aliasTable;
+                $table      = $mainTable.' AS '.$aliasTable;
             } else {
                 $table = $joinArr['table'] instanceof Raw
                     ? $this->parseRaw($joinArr['table'])

src/QueryBuilder/TablePrefixer.php

Spacing +4 added lines, -4 removed lines

@@ -27,7 +27,7 @@ 
 
         // If supplied value is not an array then make it one
         $single = false;
-        if (!is_array($values)) {
+        if ( ! is_array($values)) {
             $values = [$values];
             // We had single value, so should return a single value
             $single = true;
@@ -45,20 +45,20 @@ 
             // If key is not integer, it is likely a alias mapping,
             // so we need to change prefix target
             $target = &$value;
-            if (!is_int($key)) {
+            if ( ! is_int($key)) {
                 $target = &$key;
             }
 
             // Do prefix if the target is an expression or function.
             if (
-                !$tableFieldMix
+                ! $tableFieldMix
                 || (
                     is_string($target) // Must be a string
                     && (bool) preg_match('/^[A-Za-z0-9_.]+$/', $target) // Can only contain letters, numbers, underscore and full stops
                     && 1 === \substr_count($target, '.') // Contains a single full stop ONLY.
                 )
             ) {
-                $target = $this->getTablePrefix() . $target;
+                $target = $this->getTablePrefix().$target;
             }
 
             $return[$key] = $value;