thecodingmachine / magic-query

src/Mouf/Database/MagicQuery/Twig/SqlTwigEnvironmentFactory.php

Unused Use Statements -2 removed lines

@@ -1,8 +1,6 @@
 <?php
 namespace Mouf\Database\MagicQuery\Twig;
 
-use Doctrine\DBAL\Connection;
-
 /**
  * Class in charge of creating the Twig environment
  */

src/SQLParser/Node/SubQuery.php

Unused Use Statements -1 removed lines

@@ -39,7 +39,6 @@
 use SQLParser\Query\Select;
 use Mouf\MoufInstanceDescriptor;
 use Mouf\MoufManager;
-use SQLParser\SqlRenderInterface;
 
 /**
  * This class represents a subquery (and optionally a JOIN .. ON expression in an SQL expression.

src/SQLParser/LexerSplitter.php

Spacing +1 added lines, -1 removed lines

@@ -37,7 +37,7 @@
 class LexerSplitter
 {
     private static $splitters = array("\r\n", '!=', '>=', '<=', '<>', ':=', '\\', '&&', '>', '<', '|', '=', '^', '(',
-                                      ')', "\t", "\n", "'", '"', '`', ',', '@', ' ', '+', '-', '*', '/', ';', );
+                                      ')', "\t", "\n", "'", '"', '`', ',', '@', ' ', '+', '-', '*', '/', ';',);
     private $tokenSize;
     private $hashSet;
 

src/SQLParser/Node/NodeFactory.php

Spacing +4 added lines, -4 removed lines

@@ -335,7 +335,7 @@ 
             if (!empty($subTree) && !isset($subTree[0])) {
                 $subTree = StatementFactory::toObject($subTree);
             } else {
-                $subTree = array_map(function ($item) {
+                $subTree = array_map(function($item) {
                     if (is_array($item)) {
                         return self::toObject($item);
                     } else {
@@ -365,7 +365,7 @@ 
             array('NOT'),
             array('&&', 'AND'),
             array('XOR'),
-            array('||', 'OR'), );
+            array('||', 'OR'),);
 
     private static $OPERATOR_TO_CLASS = array(
             '=' => 'SQLParser\Node\Equal',
@@ -626,7 +626,7 @@ 
     {
         $instanceDescriptor = $moufManager->createInstance(get_called_class());
 
-        return self::array_map_deep($node, function ($item) use ($moufManager) {
+        return self::array_map_deep($node, function($item) use ($moufManager) {
             if ($item instanceof NodeInterface) {
                 return $item->toInstanceDescriptor($moufManager);
             } else {
@@ -670,7 +670,7 @@ 
     {
         if (is_array($nodes)) {
             $elems = array();
-            array_walk_recursive($nodes, function ($item) use (&$elems, $dbConnection, $indent, $delimiter, $parameters, $conditionsMode) {
+            array_walk_recursive($nodes, function($item) use (&$elems, $dbConnection, $indent, $delimiter, $parameters, $conditionsMode) {
                 if ($item instanceof SqlRenderInterface) {
                     $itemSql = $item->toSql($parameters, $dbConnection, $indent, $conditionsMode);
                     if ($itemSql !== null) {

src/SQLParser/Node/Parameter.php

Spacing +8 added lines, -8 removed lines

@@ -68,8 +68,8 @@ 
      */
     public function setName($name)
     {
-        if (strrpos($name, '!') === strlen($name)-1) {
-            $this->name = substr($name, 0, strlen($name)-1);
+        if (strrpos($name, '!') === strlen($name) - 1) {
+            $this->name = substr($name, 0, strlen($name) - 1);
             $this->discardedOnNull = false;
         } else {
             $this->name = $name;
@@ -164,22 +164,22 @@ 
     {
         if (isset($parameters[$this->name])) {
             if ($dbConnection) {
-                if(is_array($parameters[$this->name])){
-                    return '('.implode(',',array_map(function($item) use ($dbConnection) {
+                if (is_array($parameters[$this->name])) {
+                    return '('.implode(',', array_map(function($item) use ($dbConnection) {
                             return $dbConnection->quote($this->autoPrepend.$item.$this->autoAppend);
                         }, $parameters[$this->name])).')';
-                } else{
+                } else {
                     return $dbConnection->quote($this->autoPrepend.$parameters[$this->name].$this->autoAppend);
                 }
             } else {
                 if ($parameters[$this->name] === null) {
                     return "null";
                 } else {
-                    if(is_array($parameters[$this->name])){
-                        return '('.implode(',',array_map(function($item) {
+                    if (is_array($parameters[$this->name])) {
+                        return '('.implode(',', array_map(function($item) {
                             return "'".addslashes($this->autoPrepend.$item.$this->autoAppend)."'";
                         }, $parameters[$this->name])).')';
-                    } else{
+                    } else {
                        return "'".addslashes($this->autoPrepend.$parameters[$this->name].$this->autoAppend)."'"; 
                     }
                     

src/SQLParser/PHPSQLParserConstants.php

Spacing +4 added lines, -4 removed lines

@@ -98,7 +98,7 @@ 
                                        'TRAILING', 'TRUE', 'UNDO', 'UNION', 'UNIQUE', 'UNLOCK', 'UNSIGNED', 'UPDATE',
                                        'USAGE', 'USE', 'USER_RESOURCES', 'USING', 'UTC_DATE', 'UTC_TIME',
                                        'UTC_TIMESTAMP', 'VALUES', 'VARBINARY', 'VARCHAR', 'VARCHARACTER', 'VARYING',
-                                       'WHEN', 'WHERE', 'WHILE', 'WITH', 'WRITE', 'XOR', 'YEAR_MONTH', 'ZEROFILL', );
+                                       'WHEN', 'WHERE', 'WHILE', 'WITH', 'WRITE', 'XOR', 'YEAR_MONTH', 'ZEROFILL',);
 
     protected static $parameterizedFunctions = array('ABS', 'ACOS', 'ADDDATE', 'ADDTIME', 'AES_ENCRYPT', 'AES_DECRYPT',
                                                      'AGAINST', 'ASCII', 'ASIN', 'ATAN', 'AVG', 'BENCHMARK', 'BIN',
@@ -131,7 +131,7 @@ 
                                                      'TIME_TO_SEC', 'TO_DAYS', 'TRIM', 'TRUNCATE', 'UCASE',
                                                      'UNCOMPRESS', 'UNCOMPRESSED_LENGTH', 'UNHEX', 'UPPER', 'VAR_POP',
                                                      'VAR_SAMP', 'VARIANCE', 'WEEK', 'WEEKDAY', 'WEEKOFYEAR', 'YEAR',
-                                                     'YEARWEEK', );
+                                                     'YEARWEEK',);
 
     protected static $functions = array('ABS', 'ACOS', 'ADDDATE', 'ADDTIME', 'AES_ENCRYPT', 'AES_DECRYPT', 'AGAINST',
                                         'ASCII', 'ASIN', 'ATAN', 'AVG', 'BENCHMARK', 'BIN', 'BIT_AND', 'BIT_OR',
@@ -162,9 +162,9 @@ 
                                         'TIME_TO_SEC', 'TO_DAYS', 'TRIM', 'TRUNCATE', 'UCASE', 'UNCOMPRESS',
                                         'UNCOMPRESSED_LENGTH', 'UNHEX', 'UNIX_TIMESTAMP', 'UPPER', 'USER', 'UTC_DATE',
                                         'UTC_TIME', 'UTC_TIMESTAMP', 'UUID', 'VAR_POP', 'VAR_SAMP', 'VARIANCE',
-                                        'VERSION', 'WEEK', 'WEEKDAY', 'WEEKOFYEAR', 'YEAR', 'YEARWEEK', );
+                                        'VERSION', 'WEEK', 'WEEKDAY', 'WEEKOFYEAR', 'YEAR', 'YEARWEEK',);
 
     protected static $aggregateFunctions = array('AVG', 'SUM', 'COUNT', 'MIN', 'MAX', 'STDDEV', 'STDDEV_SAMP',
                                                  'STDDEV_POP', 'VARIANCE', 'VAR_SAMP', 'VAR_POP', 'GROUP_CONCAT',
-                                                 'BIT_AND', 'BIT_OR', 'BIT_XOR', );
+                                                 'BIT_AND', 'BIT_OR', 'BIT_XOR',);
 }

src/SQLParser/PositionCalculator.php

Spacing +1 added lines, -1 removed lines

@@ -44,7 +44,7 @@
 {
     private static $allowedOnOperator = array("\t", "\n", "\r", ' ', ',', '(', ')', '_', "'", '"');
     private static $allowedOnOther = array("\t", "\n", "\r", ' ', ',', '(', ')', '<', '>', '*', '+', '-', '/', '|',
-                                           '&', '=', '!', ';', );
+                                           '&', '=', '!', ';',);
 
     private function printPos($text, $sql, $charPos, $key, $parsed, $backtracking)
     {

src/SQLParser/Query/Select.php

Spacing +1 added lines, -1 removed lines

@@ -360,7 +360,7 @@
         if ($children) {
             if (is_array($children)) {
                 foreach ($children as $key => $operand) {
-                    if($operand) {
+                    if ($operand) {
                         $result2 = $operand->walk($visitor);
                         if ($result2 === NodeTraverser::REMOVE_NODE) {
                             unset($children[$key]);

src/SQLParser/Node/LimitNode.php

Spacing +2 added lines, -2 removed lines

@@ -91,11 +91,11 @@
      */
     public function toSql(array $parameters = array(), Connection $dbConnection = null, $indent = 0, $conditionsMode = self::CONDITION_APPLY)
     {
-        if($this->value === null) {
+        if ($this->value === null) {
             throw new \Exception('A limit parameter must be an integer');
         }
 
-        if(is_numeric($this->value)) {
+        if (is_numeric($this->value)) {
            return (int) $this->value;
         } else if ($dbConnection != null) {
             return $dbConnection->quote($this->value);