gin0115 / pixie-wpdb

src/QueryBuilder/Raw.php

Spacing +3 added lines, -3 removed lines

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

src/QueryBuilder/WPDBAdapter.php

Spacing +40 added lines, -41 removed lines

@@ -40,9 +40,9 @@ 
      */
     public function select($statements)
     {
-        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'][] = '*';
         }
 
@@ -57,24 +57,24 @@ 
         // Group bys
         $groupBys = '';
         if (isset($statements['groupBys']) && $groupBys = $this->arrayStr($statements['groupBys'], ', ')) {
-            $groupBys = 'GROUP BY ' . $groupBys;
+            $groupBys = 'GROUP BY '.$groupBys;
         }
 
         // Order bys
         $orderBys = '';
         if (isset($statements['orderBys']) && is_array($statements['orderBys'])) {
             foreach ($statements['orderBys'] as $orderBy) {
-                $orderBys .= $this->wrapSanitizer($orderBy['field']) . ' ' . $orderBy['type'] . ', ';
+                $orderBys .= $this->wrapSanitizer($orderBy['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');
@@ -83,7 +83,7 @@ 
         $joinString = $this->buildJoin($statements);
 
         $sqlArray = array(
-            'SELECT' . (isset($statements['distinct']) ? ' DISTINCT' : ''),
+            'SELECT'.(isset($statements['distinct']) ? ' DISTINCT' : ''),
             $selects,
             'FROM',
             $tables,
@@ -117,7 +117,7 @@ 
     public function criteriaOnly($statements, $bindValues = true)
     {
         $sql = $bindings = array();
-        if (!isset($statements['criteria'])) {
+        if ( ! isset($statements['criteria'])) {
             return compact('sql', 'bindings');
         }
 
@@ -137,7 +137,7 @@ 
      */
     private function doInsert($statements, array $data, $type)
     {
-        if (!isset($statements['tables'])) {
+        if ( ! isset($statements['tables'])) {
             throw new Exception('No table specified', 3);
         }
 
@@ -150,17 +150,17 @@ 
             if ($value instanceof Raw) {
                 $values[] = (string) $value;
             } else {
-                $values[] =  $this->inferType($value);
+                $values[] = $this->inferType($value);
                 $bindings[] = $value;
             }
         }
 
         $sqlArray = array(
-            $type . ' INTO',
+            $type.' INTO',
             $this->wrapSanitizer($table),
-            '(' . $this->arrayStr($keys, ',') . ')',
+            '('.$this->arrayStr($keys, ',').')',
             'VALUES',
-            '(' . $this->arrayStr($values, ',', false) . ')',
+            '('.$this->arrayStr($values, ',', false).')',
         );
 
         if (isset($statements['onduplicate'])) {
@@ -168,7 +168,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);
         }
 
@@ -233,9 +233,9 @@ 
 
         foreach ($data as $key => $value) {
             if ($value instanceof Raw) {
-                $statement .= $this->wrapSanitizer($key) . '=' . $value . ',';
+                $statement .= $this->wrapSanitizer($key).'='.$value.',';
             } else {
-                $statement .= $this->wrapSanitizer($key) . sprintf('=%s,', $this->inferType($value));
+                $statement .= $this->wrapSanitizer($key).sprintf('=%s,', $this->inferType($value));
                 $bindings[] = $value;
             }
         }
@@ -255,7 +255,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);
@@ -270,12 +270,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 = array(
             'UPDATE',
             $this->wrapSanitizer($table),
-            'SET ' . $updateStatement,
+            'SET '.$updateStatement,
             $whereCriteria,
             $limit
         );
@@ -296,7 +296,7 @@ 
      */
     public function delete($statements)
     {
-        if (!isset($statements['tables'])) {
+        if ( ! isset($statements['tables'])) {
             throw new Exception('No table specified', 3);
         }
 
@@ -306,7 +306,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 = array('DELETE FROM', $this->wrapSanitizer($table), $whereCriteria);
         $sql = $this->concatenateQuery($sqlArray);
@@ -333,11 +333,11 @@ 
                 $piece = $this->wrapSanitizer($piece);
             }
 
-            if (!is_int($key)) {
-                $piece = ($wrapSanitizer ? $this->wrapSanitizer($key) : $key) . ' AS ' . $piece;
+            if ( ! is_int($key)) {
+                $piece = ($wrapSanitizer ? $this->wrapSanitizer($key) : $key).' AS '.$piece;
             }
 
-            $str .= $piece . $glue;
+            $str .= $piece.$glue;
         }
 
         return trim($str, $glue);
@@ -354,7 +354,7 @@ 
     {
         $str = '';
         foreach ($pieces as $piece) {
-            $str = trim($str) . ' ' . trim($piece);
+            $str = trim($str).' '.trim($piece);
         }
         return trim($str);
     }
@@ -390,10 +390,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':
@@ -413,7 +413,7 @@ 
                         }
 
                         $valuePlaceholder = trim($valuePlaceholder, ', ');
-                        $criteria .= ' (' . $valuePlaceholder . ') ';
+                        $criteria .= ' ('.$valuePlaceholder.') ';
                         break;
                 }
             } elseif ($value instanceof Raw) {
@@ -421,21 +421,21 @@ 
             } else {
                 // Usual where like criteria
 
-                if (!$bindValues) {
+                if ( ! $bindValues) {
                     // Specially for joins
 
                     // We are not binding values, lets sanitize then
                     $value = $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
                     $valuePlaceholder = $this->inferType($value);
                     $bindings[] = $value;
-                    $criteria .= $statement['joiner'] . ' ' . $key . ' ' . $statement['operator'] . ' '
-                        . $valuePlaceholder . ' ';
+                    $criteria .= $statement['joiner'].' '.$key.' '.$statement['operator'].' '
+                        . $valuePlaceholder.' ';
                 }
             }
         }
@@ -478,7 +478,7 @@ 
     {
         // Its a raw query, just cast as string, object has __toString()
         if ($value instanceof Raw) {
-            return (string)$value;
+            return (string) $value;
         } elseif ($value instanceof \Closure) {
             return $value;
         }
@@ -489,7 +489,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
@@ -516,7 +516,7 @@ 
             list($criteria, $bindings) = $this->buildCriteria($statements[$key], $bindValues);
 
             if ($criteria) {
-                $criteria = $type . ' ' . $criteria;
+                $criteria = $type.' '.$criteria;
             }
         }
 
@@ -534,7 +534,7 @@ 
     {
         $sql = '';
 
-        if (!array_key_exists('joins', $statements) || !is_array($statements['joins'])) {
+        if ( ! array_key_exists('joins', $statements) || ! is_array($statements['joins'])) {
             return $sql;
         }
 
@@ -542,11 +542,10 @@ 
             if (is_array($joinArr['table'])) {
                 $mainTable = $joinArr['table'][0];
                 $aliasTable = $joinArr['table'][1];
-                $table = $this->wrapSanitizer($mainTable) . ' AS ' . $this->wrapSanitizer($aliasTable);
+                $table = $this->wrapSanitizer($mainTable).' AS '.$this->wrapSanitizer($aliasTable);
             } else {
                 $table = $joinArr['table'] instanceof Raw ?
-                    (string) $joinArr['table'] :
-                    $this->wrapSanitizer($joinArr['table']);
+                    (string) $joinArr['table'] : $this->wrapSanitizer($joinArr['table']);
             }
             $joinBuilder = $joinArr['joinBuilder'];
 

src/QueryBuilder/QueryObject.php

Spacing +1 added lines, -1 removed lines

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

src/QueryBuilder/QueryBuilderHandler.php

Spacing +25 added lines, -25 removed lines

@@ -169,7 +169,7 @@ 
     public function get()
     {
         $eventResult = $this->fireEvents('before-select');
-        if (!is_null($eventResult)) {
+        if ( ! is_null($eventResult)) {
             return $eventResult;
         };
         $executionTime = 0;
@@ -280,7 +280,7 @@ 
             ->select([$this->raw(sprintf('%s(%s) AS field', strtoupper($type), $field))])
             ->first();
 
-        return isset($count->field) === true ? (float)$count->field : 0;
+        return isset($count->field) === true ? (float) $count->field : 0;
     }
 
     /**
@@ -294,7 +294,7 @@ 
      */
     public function count(string $field = '*'): int
     {
-        return (int)$this->aggregate('count', $field);
+        return (int) $this->aggregate('count', $field);
     }
 
     /**
@@ -359,8 +359,8 @@ 
     public function getQuery($type = 'select', $dataToBePassed = array())
     {
         $allowedTypes = array('select', 'insert', 'insertignore', 'replace', 'delete', 'update', 'criteriaonly');
-        if (!in_array(strtolower($type), $allowedTypes)) {
-            throw new Exception($type . ' is not a known type.', 2);
+        if ( ! in_array(strtolower($type), $allowedTypes)) {
+            throw new Exception($type.' is not a known type.', 2);
         }
 
         $queryArr = $this->adapterInstance->$type($this->statements, $dataToBePassed);
@@ -379,9 +379,9 @@ 
      */
     public function subQuery(QueryBuilderHandler $queryBuilder, $alias = null)
     {
-        $sql = '(' . $queryBuilder->getQuery()->getRawSql() . ')';
+        $sql = '('.$queryBuilder->getQuery()->getRawSql().')';
         if ($alias) {
-            $sql = $sql . ' as ' . $alias;
+            $sql = $sql.' as '.$alias;
         }
 
         return $queryBuilder->raw($sql);
@@ -395,12 +395,12 @@ 
     private function doInsert($data, $type)
     {
         $eventResult = $this->fireEvents('before-insert');
-        if (!is_null($eventResult)) {
+        if ( ! is_null($eventResult)) {
             return $eventResult;
         }
 
         // If first value is not an array () not a batch insert)
-        if (!is_array(current($data))) {
+        if ( ! is_array(current($data))) {
             $queryObject = $this->getQuery($type, $data);
 
             list($preparedQuery, $executionTime) = $this->statement($queryObject->getSql(), $queryObject->getBindings());
@@ -468,7 +468,7 @@ 
     public function update($data)
     {
         $eventResult = $this->fireEvents('before-update');
-        if (!is_null($eventResult)) {
+        if ( ! is_null($eventResult)) {
             return $eventResult;
         }
 
@@ -514,7 +514,7 @@ 
     public function delete()
     {
         $eventResult = $this->fireEvents('before-delete');
-        if (!is_null($eventResult)) {
+        if ( ! is_null($eventResult)) {
             return $eventResult;
         }
 
@@ -535,7 +535,7 @@ 
      */
     public function table($tables)
     {
-        if (!is_array($tables)) {
+        if ( ! is_array($tables)) {
             // because a single table is converted to an array anyways,
             // this makes sense.
             $tables = func_get_args();
@@ -555,7 +555,7 @@ 
      */
     public function from($tables)
     {
-        if (!is_array($tables)) {
+        if ( ! is_array($tables)) {
             $tables = func_get_args();
         }
 
@@ -571,7 +571,7 @@ 
      */
     public function select($fields)
     {
-        if (!is_array($fields)) {
+        if ( ! is_array($fields)) {
             $fields = func_get_args();
         }
 
@@ -612,7 +612,7 @@ 
      */
     public function orderBy($fields, $defaultDirection = 'ASC')
     {
-        if (!is_array($fields)) {
+        if ( ! is_array($fields)) {
             $fields = array($fields);
         }
 
@@ -623,7 +623,7 @@ 
                 $field = $value;
                 $type = $defaultDirection;
             }
-            if (!$field instanceof Raw) {
+            if ( ! $field instanceof Raw) {
                 $field = $this->addTablePrefix($field);
             }
             $this->statements['orderBys'][] = compact('field', 'type');
@@ -859,7 +859,7 @@ 
         $prefix = \strlen($prefix) === 0 ? '' : " {$prefix}";
 
         $key = $this->adapterInstance->wrapSanitizer($this->addTablePrefix($key));
-        return $this->{$operator . 'Where'}($this->raw("{$key} IS{$prefix} NULL"));
+        return $this->{$operator.'Where'}($this->raw("{$key} IS{$prefix} NULL"));
     }
 
     /**
@@ -873,8 +873,8 @@ 
      */
     public function join($table, $key, $operator = null, $value = null, $type = 'inner')
     {
-        if (!$key instanceof \Closure) {
-            $key = function ($joinBuilder) use ($key, $operator, $value) {
+        if ( ! $key instanceof \Closure) {
+            $key = function($joinBuilder) use ($key, $operator, $value) {
                 $joinBuilder->on($key, $operator, $value);
             };
         }
@@ -1088,7 +1088,7 @@ 
 
         // If supplied value is not an array then make it one
         $single = false;
-        if (!is_array($values)) {
+        if ( ! is_array($values)) {
             $values = array($values);
             // We had single value, so should return a single value
             $single = true;
@@ -1106,12 +1106,12 @@ 
             // 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;
             }
 
-            if (!$tableFieldMix || ($tableFieldMix && strpos($target, '.') !== false)) {
-                $target = $this->tablePrefix . $target;
+            if ( ! $tableFieldMix || ($tableFieldMix && strpos($target, '.') !== false)) {
+                $target = $this->tablePrefix.$target;
             }
 
             $return[$key] = $value;
@@ -1127,11 +1127,11 @@ 
      */
     protected function addStatement($key, $value)
     {
-        if (!is_array($value)) {
+        if ( ! is_array($value)) {
             $value = array($value);
         }
 
-        if (!array_key_exists($key, $this->statements)) {
+        if ( ! array_key_exists($key, $this->statements)) {
             $this->statements[$key] = $value;
         } else {
             $this->statements[$key] = array_merge($this->statements[$key], $value);

src/EventHandler.php

Spacing +2 added lines, -2 removed lines

@@ -81,7 +81,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();
@@ -89,7 +89,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/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/Connection.php

Spacing +3 added lines, -3 removed lines

@@ -64,7 +64,7 @@ 
         }
 
         // Preserve the first database connection with a static property
-        if (! static::$storedConnection) {
+        if ( ! static::$storedConnection) {
             static::$storedConnection = $this;
         }
     }
@@ -77,7 +77,7 @@ 
     public function createAlias(string $alias): void
     {
         class_alias(AliasFacade::class, $alias);
-        $builder = $this->container->build(QueryBuilderHandler::class, array( $this ));
+        $builder = $this->container->build(QueryBuilderHandler::class, array($this));
         AliasFacade::setQueryBuilderInstance($builder);
     }
 
@@ -86,7 +86,7 @@ 
      */
     public function getQueryBuilder(): QueryBuilderHandler
     {
-        return $this->container->build(QueryBuilderHandler::class, array( $this ));
+        return $this->container->build(QueryBuilderHandler::class, array($this));
     }
 
     /**

src/Hydration/Hydrator.php

Spacing +1 added lines, -1 removed lines

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