adumitru68 / QueryBuilder

src/Dependencies/QueryStructure.php

Spacing +7 added lines, -7 removed lines

@@ -60,7 +60,7 @@ 
 	/**
 	 * @var array
 	 */
-	private static $usedInstanceIds = [];
+	private static $usedInstanceIds = [ ];
 
 	/**
 	 * @var array
@@ -132,7 +132,7 @@ 
 		while ( in_array( $instance, self::$usedInstanceIds ) ) {
 			$instance = QueryHelper::random( 7 );
 		}
-		self::$usedInstanceIds[] = $instance;
+		self::$usedInstanceIds[ ] = $instance;
 
 		return $instance;
 	}
@@ -179,7 +179,7 @@ 
 			return true;
 
 		if ( $this->typeEL[ $name ] === self::ELEMENT_TYPE_ARRAY )
-			$this->syntaxEL[ $name ][] = $value;
+			$this->syntaxEL[ $name ][ ] = $value;
 		else
 			$this->syntaxEL[ $name ] = $value;
 
@@ -241,7 +241,7 @@ 
 	 * @param string $search
 	 * @return string
 	 */
-	public function bindParamsExpression( $expression, array $params = [], $search = '?' )
+	public function bindParamsExpression( $expression, array $params = [ ], $search = '?' )
 	{
 		if ( !count( $params ) )
 			return $expression;
@@ -252,12 +252,12 @@ 
 		$params = array_slice( $params, 0, substr_count( $expression, $search ) );
 
 		$i = 0;
-		$arrayReturn = [];
+		$arrayReturn = [ ];
 		$expressionToArray = explode( $search, $expression );
 
 		foreach ( $expressionToArray as $sub ) {
-			$arrayReturn[] = $sub;
-			$arrayReturn[] = array_key_exists( $i, $params ) ? $this->bindParam( 'exp', $params[ $i ] ) : '';
+			$arrayReturn[ ] = $sub;
+			$arrayReturn[ ] = array_key_exists( $i, $params ) ? $this->bindParam( 'exp', $params[ $i ] ) : '';
 			$i++;
 		}
 

src/Traits/InsertMultiple.php

Spacing +26 added lines, -26 removed lines

@@ -25,12 +25,12 @@ 
      * @param array $rowsForInsert
      * @return $this
      */
-    public function fromArray($fieldsList, array $rowsForInsert)
+    public function fromArray( $fieldsList, array $rowsForInsert )
     {
-        $this->setFieldsList($fieldsList);
+        $this->setFieldsList( $fieldsList );
 
-        foreach ($rowsForInsert as $row)
-            $this->addSingleRow($row);
+        foreach ( $rowsForInsert as $row )
+            $this->addSingleRow( $row );
 
         return $this;
     }
@@ -41,14 +41,14 @@ 
      * @param QuerySelect $query
      * @return $this
      */
-    public function fromQuerySelect($fieldsList, QuerySelect $query)
+    public function fromQuerySelect( $fieldsList, QuerySelect $query )
     {
-        $this->setFieldsList($fieldsList);
+        $this->setFieldsList( $fieldsList );
 
-        foreach ($query->getBindParams() as $key => $value)
-            $this->queryStructure->setParams($key, $value);
+        foreach ( $query->getBindParams() as $key => $value )
+            $this->queryStructure->setParams( $key, $value );
 
-        $this->queryStructure->replaceElement(QueryStructure::SET_FIELDS, $query);
+        $this->queryStructure->replaceElement( QueryStructure::SET_FIELDS, $query );
 
         return $this;
     }
@@ -57,12 +57,12 @@ 
     /**
      * @param string|array $fieldList
      */
-    private function setFieldsList($fieldList)
+    private function setFieldsList( $fieldList )
     {
-        if (!is_array($fieldList))
-            $fieldList = QueryHelper::explode($fieldList);
+        if ( !is_array( $fieldList ) )
+            $fieldList = QueryHelper::explode( $fieldList );
 
-        $this->queryStructure->replaceElement(QueryStructure::FIELDS, $fieldList);
+        $this->queryStructure->replaceElement( QueryStructure::FIELDS, $fieldList );
 
     }
 
@@ -71,20 +71,20 @@ 
      * @return $this
      * @throws QueryException
      */
-    private function addSingleRow(array $rowValues)
+    private function addSingleRow( array $rowValues )
     {
 
-        if ($this->getNumberOfFields() !== count($rowValues))
-            throw new QueryException('Ivalid number of fields.', QueryException::QUERY_ERROR_INVALID_FIELDS_COUNT);
+        if ( $this->getNumberOfFields() !== count( $rowValues ) )
+            throw new QueryException( 'Ivalid number of fields.', QueryException::QUERY_ERROR_INVALID_FIELDS_COUNT );
 
         $pdoRowValues = array();
 
-        foreach ($rowValues as $value)
-            $pdoRowValues[] = $this->queryStructure->bindParam('value', $value);
+        foreach ( $rowValues as $value )
+            $pdoRowValues[ ] = $this->queryStructure->bindParam( 'value', $value );
 
-        $pdoRowValuesString = '( ' . QueryHelper::implode($pdoRowValues, ', ') . ' )';
+        $pdoRowValuesString = '( ' . QueryHelper::implode( $pdoRowValues, ', ' ) . ' )';
 
-        $this->queryStructure->setElement(QueryStructure::SET_FIELDS, $pdoRowValuesString);
+        $this->queryStructure->setElement( QueryStructure::SET_FIELDS, $pdoRowValuesString );
 
         return $this;
     }
@@ -94,11 +94,11 @@ 
      */
     private function getInsertMultipleRowsSyntax()
     {
-        if (is_a($this->queryStructure->getElement(QueryStructure::SET_FIELDS), QuerySelect::class))
+        if ( is_a( $this->queryStructure->getElement( QueryStructure::SET_FIELDS ), QuerySelect::class ) )
             return $this->getSyntaxWithSelect();
 
-        $fields = '( ' . QueryHelper::implode($this->queryStructure->getElement(QueryStructure::FIELDS), ', ') . ' )';
-        $values = QueryHelper::implode($this->queryStructure->getElement(QueryStructure::SET_FIELDS), ', ');
+        $fields = '( ' . QueryHelper::implode( $this->queryStructure->getElement( QueryStructure::FIELDS ), ', ' ) . ' )';
+        $values = QueryHelper::implode( $this->queryStructure->getElement( QueryStructure::SET_FIELDS ), ', ' );
 
         return $fields . ' VALUES ' . $values;
     }
@@ -109,9 +109,9 @@ 
      */
     private function getSyntaxWithSelect()
     {
-        $fields = '( ' . QueryHelper::implode($this->queryStructure->getElement(QueryStructure::FIELDS), ', ') . ' )';
+        $fields = '( ' . QueryHelper::implode( $this->queryStructure->getElement( QueryStructure::FIELDS ), ', ' ) . ' )';
 
-        return $fields . ' ' . $this->queryStructure->getElement(QueryStructure::SET_FIELDS)->getSyntax();
+        return $fields . ' ' . $this->queryStructure->getElement( QueryStructure::SET_FIELDS )->getSyntax();
     }
 
     /**
@@ -119,7 +119,7 @@ 
      */
     private function getNumberOfFields()
     {
-        return count($this->queryStructure->getElement(QueryStructure::FIELDS));
+        return count( $this->queryStructure->getElement( QueryStructure::FIELDS ) );
     }
 
 

src/Traits/SelectFields.php

Spacing +18 added lines, -18 removed lines

@@ -22,29 +22,29 @@ 
      * @return $this
      * @throws QueryException
      */
-    public function fields($fields)
+    public function fields( $fields )
     {
 
-        switch (gettype($fields)) {
+        switch ( gettype( $fields ) ) {
             case QueryStructure::ELEMENT_TYPE_ARRAY:
 
-                $fields = $this->prepareArrayFields($fields);
+                $fields = $this->prepareArrayFields( $fields );
 
-                if (count($fields))
-                    $this->queryStructure->setElement(QueryStructure::FIELDS, implode(', ', $fields)); else
-                    $this->queryStructure->setElement(QueryStructure::FIELDS, '*');
+                if ( count( $fields ) )
+                    $this->queryStructure->setElement( QueryStructure::FIELDS, implode( ', ', $fields ) ); else
+                    $this->queryStructure->setElement( QueryStructure::FIELDS, '*' );
                 break;
 
             case QueryStructure::ELEMENT_TYPE_STRING:
 
-                $fields = trim($fields);
-                if ('' !== $fields)
-                    $this->queryStructure->setElement(QueryStructure::FIELDS, $fields); else
-                    $this->queryStructure->setElement(QueryStructure::FIELDS, '*');
+                $fields = trim( $fields );
+                if ( '' !== $fields )
+                    $this->queryStructure->setElement( QueryStructure::FIELDS, $fields ); else
+                    $this->queryStructure->setElement( QueryStructure::FIELDS, '*' );
                 break;
 
             default:
-                throw new QueryException('Invalid fields parameter type', QueryException::QUERY_ERROR_WHERE_INVALID_PARAM_ARRAY);
+                throw new QueryException( 'Invalid fields parameter type', QueryException::QUERY_ERROR_WHERE_INVALID_PARAM_ARRAY );
 
         }
 
@@ -56,16 +56,16 @@ 
      * @return array
      * @throws QueryException
      */
-    private function prepareArrayFields($fieldsArray = array())
+    private function prepareArrayFields( $fieldsArray = array() )
     {
-        $prepareArray = [];
+        $prepareArray = [ ];
 
-        foreach ($fieldsArray as $field) {
-            if (gettype($field) !== QueryStructure::ELEMENT_TYPE_STRING)
-                throw new QueryException('Invalid select field type!', QueryException::QUERY_ERROR_SELECT_INVALID_FIELD);
+        foreach ( $fieldsArray as $field ) {
+            if ( gettype( $field ) !== QueryStructure::ELEMENT_TYPE_STRING )
+                throw new QueryException( 'Invalid select field type!', QueryException::QUERY_ERROR_SELECT_INVALID_FIELD );
 
-            if ('' !== trim($field))
-                $prepareArray[] = trim($field);
+            if ( '' !== trim( $field ) )
+                $prepareArray[ ] = trim( $field );
         }
 
         return $prepareArray;

src/Traits/GroupBy.php

Spacing +14 added lines, -14 removed lines

@@ -24,14 +24,14 @@ 
      * @return $this
      * @throws QueryException
      */
-    public function groupBy($column, array $allowedColumns = [])
+    public function groupBy( $column, array $allowedColumns = [ ] )
     {
-        $column = trim($column);
+        $column = trim( $column );
 
-        if (!$this->validateColumn($column, $allowedColumns))
-            throw new QueryException('Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME);
+        if ( !$this->validateColumn( $column, $allowedColumns ) )
+            throw new QueryException( 'Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME );
 
-        $this->queryStructure->setElement(QueryStructure::GROUP_BY, $column);
+        $this->queryStructure->setElement( QueryStructure::GROUP_BY, $column );
 
         return $this;
     }
@@ -43,14 +43,14 @@ 
      * @return $this
      * @throws QueryException
      */
-    public function groupByDesc($column, array $allowedColumns = [])
+    public function groupByDesc( $column, array $allowedColumns = [ ] )
     {
-        $column = trim($column);
+        $column = trim( $column );
 
-        if (!$this->validateColumn($column, $allowedColumns))
-            throw new QueryException('Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME);
+        if ( !$this->validateColumn( $column, $allowedColumns ) )
+            throw new QueryException( 'Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME );
 
-        $this->queryStructure->setElement(QueryStructure::GROUP_BY, $column . ' DESC');
+        $this->queryStructure->setElement( QueryStructure::GROUP_BY, $column . ' DESC' );
 
         return $this;
     }
@@ -60,9 +60,9 @@ 
      * @param $expression
      * @return $this
      */
-    public function groupByExpression($expression)
+    public function groupByExpression( $expression )
     {
-        $this->queryStructure->setElement(QueryStructure::GROUP_BY, $expression);
+        $this->queryStructure->setElement( QueryStructure::GROUP_BY, $expression );
 
         return $this;
     }
@@ -73,8 +73,8 @@ 
      */
     private function getGroupBySyntax()
     {
-        if (count($this->queryStructure->getElement(QueryStructure::GROUP_BY)))
-            return 'GROUP BY ' . QueryHelper::implode($this->queryStructure->getElement(QueryStructure::GROUP_BY), ', ');
+        if ( count( $this->queryStructure->getElement( QueryStructure::GROUP_BY ) ) )
+            return 'GROUP BY ' . QueryHelper::implode( $this->queryStructure->getElement( QueryStructure::GROUP_BY ), ', ' );
 
         return '';
     }

src/Traits/Replacement.php

Spacing +10 added lines, -10 removed lines

@@ -23,30 +23,30 @@
      * @param int $withReplacement
      * @return mixed|string
      */
-    private function getSyntaxReplace($syntax, $withReplacement = QueryStatementInterface::REPLACEMENT_NONE)
+    private function getSyntaxReplace( $syntax, $withReplacement = QueryStatementInterface::REPLACEMENT_NONE )
     {
-        $syntax = QueryHelper::clearMultipleSpaces($syntax);
+        $syntax = QueryHelper::clearMultipleSpaces( $syntax );
 
-        if (!$withReplacement)
+        if ( !$withReplacement )
             return $syntax;
 
-        return $this->replaceValues($syntax);
+        return $this->replaceValues( $syntax );
     }
 
     /**
      * @param $syntax
      * @return string
      */
-    private function replaceValues($syntax)
+    private function replaceValues( $syntax )
     {
-        $bindParams = $this->queryStructure->getElement(QueryStructure::BIND_PARAMS);
+        $bindParams = $this->queryStructure->getElement( QueryStructure::BIND_PARAMS );
         $search = array();
         $replace = array();
-        foreach ($bindParams as $key => $value) {
-            $search[] = ':' . $key;
-            $replace[] = DbConnect::getInstance()->quote($value);
+        foreach ( $bindParams as $key => $value ) {
+            $search[ ] = ':' . $key;
+            $replace[ ] = DbConnect::getInstance()->quote( $value );
         }
-        $syntax = str_ireplace($search, $replace, $syntax);
+        $syntax = str_ireplace( $search, $replace, $syntax );
 
         return $syntax;
 

src/Traits/Distinct.php

Spacing +6 added lines, -6 removed lines

@@ -23,7 +23,7 @@ 
      */
     public function all()
     {
-        $this->queryStructure->setElement(QueryStructure::DISTINCT, 0);
+        $this->queryStructure->setElement( QueryStructure::DISTINCT, 0 );
 
         return $this;
     }
@@ -33,7 +33,7 @@ 
      */
     public function distinct()
     {
-        $this->queryStructure->setElement(QueryStructure::DISTINCT, 1);
+        $this->queryStructure->setElement( QueryStructure::DISTINCT, 1 );
 
         return $this;
     }
@@ -43,7 +43,7 @@ 
      */
     public function distinctRow()
     {
-        $this->queryStructure->setElement(QueryStructure::DISTINCT, 2);
+        $this->queryStructure->setElement( QueryStructure::DISTINCT, 2 );
 
         return $this;
     }
@@ -55,9 +55,9 @@ 
      */
     private function getDistinctSyntax()
     {
-        $useDistinct = $this->queryStructure->getElement(QueryStructure::DISTINCT);
+        $useDistinct = $this->queryStructure->getElement( QueryStructure::DISTINCT );
 
-        switch ($useDistinct) {
+        switch ( $useDistinct ) {
             case 0:
                 return '';
             case 1:
@@ -65,7 +65,7 @@ 
             case 2:
                 return 'DISTINCTROW';
             default:
-                throw new QueryException('Invalid distinct type', QueryException::QUERY_ERROR_INVALID_DISTINCT);
+                throw new QueryException( 'Invalid distinct type', QueryException::QUERY_ERROR_INVALID_DISTINCT );
         }
 
     }

src/Traits/LowPriority.php

Spacing +1 added lines, -1 removed lines

@@ -21,7 +21,7 @@
      */
     public function lowPriority()
     {
-        $this->queryStructure->setElement(QueryStructure::PRIORITY, 'LOW_PRIORITY');
+        $this->queryStructure->setElement( QueryStructure::PRIORITY, 'LOW_PRIORITY' );
 
         return $this;
     }

src/Traits/SetFields.php

Spacing +10 added lines, -10 removed lines

@@ -22,10 +22,10 @@ 
      * @param $fieldValue
      * @return $this
      */
-    public function setField($fieldName, $fieldValue)
+    public function setField( $fieldName, $fieldValue )
     {
-        $valuePdoString = $this->queryStructure->bindParam($fieldName, $fieldValue);
-        $this->queryStructure->setElement(QueryStructure::SET_FIELDS, "$fieldName = $valuePdoString");
+        $valuePdoString = $this->queryStructure->bindParam( $fieldName, $fieldValue );
+        $this->queryStructure->setElement( QueryStructure::SET_FIELDS, "$fieldName = $valuePdoString" );
 
         return $this;
     }
@@ -34,9 +34,9 @@ 
      * @param string $expression
      * @return $this
      */
-    public function setFieldByExpression($expression)
+    public function setFieldByExpression( $expression )
     {
-        $this->queryStructure->setElement(QueryStructure::SET_FIELDS, $expression);
+        $this->queryStructure->setElement( QueryStructure::SET_FIELDS, $expression );
 
         return $this;
     }
@@ -46,10 +46,10 @@ 
      * @param array $updateFieldsArray
      * @return $this
      */
-    public function setFieldsByArray(array $updateFieldsArray)
+    public function setFieldsByArray( array $updateFieldsArray )
     {
-        foreach ($updateFieldsArray as $fieldName => $fieldValue)
-            $this->setField($fieldName, $fieldValue);
+        foreach ( $updateFieldsArray as $fieldName => $fieldValue )
+            $this->setField( $fieldName, $fieldValue );
 
         return $this;
     }
@@ -59,10 +59,10 @@ 
      */
     private function getSettingFieldsSyntax()
     {
-        if (!count($this->queryStructure->getElement(QueryStructure::SET_FIELDS)))
+        if ( !count( $this->queryStructure->getElement( QueryStructure::SET_FIELDS ) ) )
             return '';
 
-        return 'SET ' . implode(', ', $this->queryStructure->getElement(QueryStructure::SET_FIELDS));
+        return 'SET ' . implode( ', ', $this->queryStructure->getElement( QueryStructure::SET_FIELDS ) );
     }
 
 }
\ No newline at end of file

src/Traits/Join.php

Spacing +21 added lines, -21 removed lines

@@ -23,9 +23,9 @@ 
      * @param null $onRight
      * @return $this
      */
-    public function innerJoin($tableJoin, $onLeft, $onRight = null)
+    public function innerJoin( $tableJoin, $onLeft, $onRight = null )
     {
-        return $this->makeJoin('INNER JOIN', $tableJoin, $onLeft, $onRight);
+        return $this->makeJoin( 'INNER JOIN', $tableJoin, $onLeft, $onRight );
     }
 
     /**
@@ -34,9 +34,9 @@ 
      * @param null $onRight
      * @return $this
      */
-    public function leftJoin($tableJoin, $onLeft, $onRight = null)
+    public function leftJoin( $tableJoin, $onLeft, $onRight = null )
     {
-        return $this->makeJoin('LEFT JOIN', $tableJoin, $onLeft, $onRight);
+        return $this->makeJoin( 'LEFT JOIN', $tableJoin, $onLeft, $onRight );
     }
 
     /**
@@ -45,9 +45,9 @@ 
      * @param null $onRight
      * @return $this
      */
-    public function leftOuterJoin($tableJoin, $onLeft, $onRight = null)
+    public function leftOuterJoin( $tableJoin, $onLeft, $onRight = null )
     {
-        return $this->makeJoin('LEFT OUTER JOIN', $tableJoin, $onLeft, $onRight);
+        return $this->makeJoin( 'LEFT OUTER JOIN', $tableJoin, $onLeft, $onRight );
     }
 
     /**
@@ -56,9 +56,9 @@ 
      * @param null $onRight
      * @return $this
      */
-    public function rightJoin($tableJoin, $onLeft, $onRight = null)
+    public function rightJoin( $tableJoin, $onLeft, $onRight = null )
     {
-        return $this->makeJoin('RIGHT JOIN', $tableJoin, $onLeft, $onRight);
+        return $this->makeJoin( 'RIGHT JOIN', $tableJoin, $onLeft, $onRight );
     }
 
     /**
@@ -67,9 +67,9 @@ 
      * @param null $onRight
      * @return $this
      */
-    public function rightOuterJoin($tableJoin, $onLeft, $onRight = null)
+    public function rightOuterJoin( $tableJoin, $onLeft, $onRight = null )
     {
-        return $this->makeJoin('RIGHT OUTER JOIN', $tableJoin, $onLeft, $onRight);
+        return $this->makeJoin( 'RIGHT OUTER JOIN', $tableJoin, $onLeft, $onRight );
     }
 
     /**
@@ -78,9 +78,9 @@ 
      * @param null $onRight
      * @return $this
      */
-    public function fullJoin($tableJoin, $onLeft, $onRight = null)
+    public function fullJoin( $tableJoin, $onLeft, $onRight = null )
     {
-        return $this->makeJoin('FULL JOIN', $tableJoin, $onLeft, $onRight);
+        return $this->makeJoin( 'FULL JOIN', $tableJoin, $onLeft, $onRight );
     }
 
     /**
@@ -89,18 +89,18 @@ 
      * @param null $onRight
      * @return $this
      */
-    public function fullOuterJoin($tableJoin, $onLeft, $onRight = null)
+    public function fullOuterJoin( $tableJoin, $onLeft, $onRight = null )
     {
-        return $this->makeJoin('FULL OUTER JOIN', $tableJoin, $onLeft, $onRight);
+        return $this->makeJoin( 'FULL OUTER JOIN', $tableJoin, $onLeft, $onRight );
     }
 
     /**
      * @param $stringJoin
      * @return $this
      */
-    public function join($stringJoin)
+    public function join( $stringJoin )
     {
-        $this->queryStructure->setElement(QueryStructure::JOIN, $stringJoin);
+        $this->queryStructure->setElement( QueryStructure::JOIN, $stringJoin );
 
         return $this;
     }
@@ -112,15 +112,15 @@ 
      * @param null $onRight
      * @return $this
      */
-    private function makeJoin($typeJoin, $tableJoin, $onLeft, $onRight = null)
+    private function makeJoin( $typeJoin, $tableJoin, $onLeft, $onRight = null )
     {
         $join = $typeJoin . ' ' . $tableJoin;
 
-        if (is_null($onRight))
+        if ( is_null( $onRight ) )
             $join .= " USING ( $onLeft )"; else
             $join .= " ON $onLeft = $onRight";
 
-        $this->queryStructure->setElement(QueryStructure::JOIN, $join);
+        $this->queryStructure->setElement( QueryStructure::JOIN, $join );
 
         return $this;
     }
@@ -130,9 +130,9 @@ 
      */
     private function getJoinSyntax()
     {
-        $joinString = implode(' ', $this->queryStructure->getElement(QueryStructure::JOIN));
+        $joinString = implode( ' ', $this->queryStructure->getElement( QueryStructure::JOIN ) );
 
-        return QueryHelper::clearMultipleSpaces($joinString);
+        return QueryHelper::clearMultipleSpaces( $joinString );
     }
 
 }
\ No newline at end of file