adumitru68 / QueryBuilder

src/Traits/AsSingleton.php

Braces +3 added lines, -2 removed lines

@@ -19,8 +19,9 @@
 	 */
 	public static function getInstance()
 	{
-		if ( is_null( self::$instance ) )
-			self::$instance = new self();
+		if ( is_null( self::$instance ) ) {
+					self::$instance = new self();
+		}
 
 		return self::$instance;
 	}

src/Traits/SelectFields.php

Spacing +4 added lines, -4 removed lines

@@ -74,19 +74,19 @@
 	 */
 	private function prepareArrayFields( $fieldsArray = array() )
 	{
-		$prepareArray = [];
+		$prepareArray = [ ];
 
 		foreach ( $fieldsArray as $field ) {
 
 			switch ( gettype( $field ) ) {
 				case QueryStructure::ELEMENT_TYPE_STRING:
-					$prepareArray[] = $this->queryStructure->prepare( $field );
+					$prepareArray[ ] = $this->queryStructure->prepare( $field );
 					break;
 				case QueryStructure::ELEMENT_TYPE_ARRAY:
-					$prepareArray[] = $this->getFieldByArray( $field );
+					$prepareArray[ ] = $this->getFieldByArray( $field );
 					break;
 				default:
-					throw new QueryException('Invalid field description');
+					throw new QueryException( 'Invalid field description' );
 			}
 		}
 

Braces +8 added lines, -8 removed lines

@@ -31,10 +31,11 @@ 
 
 				$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:
@@ -44,9 +45,9 @@ 
 					$fields = explode( ',', $fields );
 					$fields = $this->prepareArrayFields( $fields );
 					$this->queryStructure->setElement( QueryStructure::FIELDS, implode( ', ', $fields ) );
+				} else {
+									$this->queryStructure->setElement( QueryStructure::FIELDS, '*' );
 				}
-				else
-					$this->queryStructure->setElement( QueryStructure::FIELDS, '*' );
 				break;
 
 			default:
@@ -108,8 +109,7 @@ 
 
 		if ( count( $fieldArray ) === 1 ) {
 			return $this->queryStructure->prepare( trim( $fieldArray[ 0 ] ) );
-		}
-		else {
+		} else {
 			return $this->queryStructure->prepare( trim( $fieldArray[ 0 ] ) ) . ' ' . $this->queryStructure->prepare( trim( $fieldArray[ 1 ] ) );
 		}
 

src/Dependencies/QueryHelper.php

Spacing +3 added lines, -3 removed lines

@@ -58,7 +58,7 @@ 
 		foreach ( $brutArray as $value ) {
 			$value = trim( $value );
 			if ( '' !== $value )
-				$newArray[] = $value;
+				$newArray[ ] = $value;
 		}
 
 		return $newArray;
@@ -120,14 +120,14 @@ 
 	public static function addBacktick( $string )
 	{
 		$string = str_replace( '`', '', $string );
-		$stringArrayBacktick = [];
+		$stringArrayBacktick = [ ];
 		$string = self::clearMultipleSpaces( $string );
 		$stringArray = explode( '.', $string );
 		foreach ( $stringArray as $part ) {
 			$part = self::clearMultipleSpaces( $part );
 			if ( empty( $part ) )
 				continue;
-			$stringArrayBacktick[] = '`' . $part . '`';
+			$stringArrayBacktick[ ] = '`' . $part . '`';
 		}
 
 		return implode( '.', $stringArrayBacktick );

Braces +9 added lines, -6 removed lines

@@ -57,8 +57,9 @@ 
 		$newArray = array();
 		foreach ( $brutArray as $value ) {
 			$value = trim( $value );
-			if ( '' !== $value )
-				$newArray[] = $value;
+			if ( '' !== $value ) {
+							$newArray[] = $value;
+			}
 		}
 
 		return $newArray;
@@ -110,8 +111,9 @@ 
 		$characters = 'abcdefghijklmnopqrstuvwxyz';
 		$charactersLength = strlen( $characters );
 		$randomString = '';
-		for ( $i = 0; $i < $length; $i++ )
-			$randomString .= $characters[ rand( 0, $charactersLength - 1 ) ];
+		for ( $i = 0; $i < $length; $i++ ) {
+					$randomString .= $characters[ rand( 0, $charactersLength - 1 ) ];
+		}
 
 		return str_shuffle( $randomString );
 	}
@@ -125,8 +127,9 @@ 
 		$stringArray = explode( '.', $string );
 		foreach ( $stringArray as $part ) {
 			$part = self::clearMultipleSpaces( $part );
-			if ( empty( $part ) )
-				continue;
+			if ( empty( $part ) ) {
+							continue;
+			}
 			$stringArrayBacktick[] = '`' . $part . '`';
 		}
 

src/Statements/QueryCustom.php

Spacing +2 added lines, -2 removed lines

@@ -35,7 +35,7 @@ 
 	/**
 	 * @var array
 	 */
-	protected $usedInstanceIds = [];
+	protected $usedInstanceIds = [ ];
 
 	/**
 	 * @var string
@@ -63,7 +63,7 @@ 
 	 * @return $this
 	 * @throws \Qpdb\QueryBuilder\Dependencies\QueryException
 	 */
-	public function withBindParams( array $params = [] )
+	public function withBindParams( array $params = [ ] )
 	{
 		$this->queryStructure->replaceElement( QueryStructure::BIND_PARAMS, $params );
 

src/Statements/Transaction.php

Spacing +6 added lines, -6 removed lines

@@ -37,9 +37,9 @@ 
 	 * @return array
 	 */
 	public function getSyntax( $replacement = self::REPLACEMENT_NONE ) {
-		$queries = [];
+		$queries = [ ];
 		foreach ( $this->transaction as $queryStatement ) {
-			$queries[] = $queryStatement->getSyntax( $replacement );
+			$queries[ ] = $queryStatement->getSyntax( $replacement );
 		}
 
 		return $queries;
@@ -50,7 +50,7 @@ 
 	 * @param array    $params
 	 * @return mixed|null
 	 */
-	public function executeFunction( \Closure $function, array $params = [] ) {
+	public function executeFunction( \Closure $function, array $params = [ ] ) {
 		return PdoWrapperService::getInstance()->transaction( $function, $params );
 	}
 
@@ -58,7 +58,7 @@ 
 	 * @return mixed|null
 	 */
 	public function execute() {
-		$transaction = (array)$this->transaction;
+		$transaction = ( array ) $this->transaction;
 
 		return PdoWrapperService::getInstance()->transaction(
 			function() use ( $transaction ) {
@@ -77,9 +77,9 @@ 
 	 * @return array
 	 */
 	public function getBindParams() {
-		$queries = [];
+		$queries = [ ];
 		foreach ( $this->transaction as $queryStatement ) {
-			$queries[] = $queryStatement->getBindParams();
+			$queries[ ] = $queryStatement->getBindParams();
 		}
 
 		return $queries;

src/Statements/QueryDelete.php

Spacing +8 added lines, -8 removed lines

@@ -53,37 +53,37 @@ 
 		/**
 		 *  Explain
 		 */
-		$syntax[] = $this->getExplainSyntax();
+		$syntax[ ] = $this->getExplainSyntax();
 
 		/**
 		 * UPDATE statement
 		 */
-		$syntax[] = $this->statement;
+		$syntax[ ] = $this->statement;
 
 		/**
 		 * PRIORITY
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
 		/**
 		 * TABLE update
 		 */
-		$syntax[] = 'FROM ' . $this->queryStructure->getElement( QueryStructure::TABLE );
+		$syntax[ ] = 'FROM ' . $this->queryStructure->getElement( QueryStructure::TABLE );
 
 		/**
 		 * WHERE clause
 		 */
-		$syntax[] = $this->getWhereSyntax();
+		$syntax[ ] = $this->getWhereSyntax();
 
 		/**
 		 * ORDER BY clause
 		 */
-		$syntax[] = $this->getOrderBySyntax();
+		$syntax[ ] = $this->getOrderBySyntax();
 
 		/**
 		 * LIMIT clause
 		 */
-		$syntax[] = $this->getLimitSyntax();
+		$syntax[ ] = $this->getLimitSyntax();
 
 		$syntax = implode( ' ', $syntax );
 
@@ -99,7 +99,7 @@ 
 		if ( $this->queryStructure->getElement( ( QueryStructure::WHERE_TRIGGER ) ) && !count( $this->queryStructure->getElement( QueryStructure::WHERE ) ) )
 			throw new QueryException( 'Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
 
-		return PdoWrapperService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS))->rowCount();
+		return PdoWrapperService::getInstance()->query( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) )->rowCount();
 	}
 
 

Braces +3 added lines, -2 removed lines

@@ -96,8 +96,9 @@
 	 */
 	public function execute()
 	{
-		if ( $this->queryStructure->getElement( ( QueryStructure::WHERE_TRIGGER ) ) && !count( $this->queryStructure->getElement( QueryStructure::WHERE ) ) )
-			throw new QueryException( 'Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
+		if ( $this->queryStructure->getElement( ( QueryStructure::WHERE_TRIGGER ) ) && !count( $this->queryStructure->getElement( QueryStructure::WHERE ) ) ) {
+					throw new QueryException( 'Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
+		}
 
 		return PdoWrapperService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS))->rowCount();
 	}

src/Statements/QuerySelect.php

Spacing +13 added lines, -13 removed lines

@@ -120,62 +120,62 @@ 
 		/**
 		 *  Explain
 		 */
-		$syntax[] = $this->getExplainSyntax();
+		$syntax[ ] = $this->getExplainSyntax();
 
 		/**
 		 * SELECT statement
 		 */
-		$syntax[] = $this->statement;
+		$syntax[ ] = $this->statement;
 
 		/**
 		 * PRIORITY
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
 		/**
 		 * DISTINCT clause
 		 */
-		$syntax[] = $this->getDistinctSyntax();
+		$syntax[ ] = $this->getDistinctSyntax();
 
 		/**
 		 * FIELDS
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::FIELDS );
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::FIELDS );
 
 		/**
 		 * FROM table or queryStructure
 		 */
-		$syntax[] = 'FROM ' . $this->queryStructure->getElement( QueryStructure::TABLE );
+		$syntax[ ] = 'FROM ' . $this->queryStructure->getElement( QueryStructure::TABLE );
 
 		/**
 		 * JOIN CLAUSES
 		 */
-		$syntax[] = $this->getJoinSyntax();
+		$syntax[ ] = $this->getJoinSyntax();
 
 		/**
 		 * WHERE clause
 		 */
-		$syntax[] = $this->getWhereSyntax();
+		$syntax[ ] = $this->getWhereSyntax();
 
 		/**
 		 * GROUP BY clause
 		 */
-		$syntax[] = $this->getGroupBySyntax();
+		$syntax[ ] = $this->getGroupBySyntax();
 
 		/**
 		 * HAVING clause
 		 */
-		$syntax[] = $this->getHavingSyntax();
+		$syntax[ ] = $this->getHavingSyntax();
 
 		/**
 		 * ORDER BY clause
 		 */
-		$syntax[] = $this->getOrderBySyntax();
+		$syntax[ ] = $this->getOrderBySyntax();
 
 		/**
 		 * LIMIT clause
 		 */
-		$syntax[] = $this->getLimitSyntax();
+		$syntax[ ] = $this->getLimitSyntax();
 
 		$syntax = implode( ' ', $syntax );
 
@@ -200,7 +200,7 @@ 
 			case $this->queryStructure->getElement( QueryStructure::COLUMN ):
 				return PdoWrapperService::getInstance()->queryFetchAll( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ), \PDO::FETCH_COLUMN );
 			default:
-				return PdoWrapperService::getInstance()->queryFetchAll($this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ), \PDO::FETCH_ASSOC);
+				return PdoWrapperService::getInstance()->queryFetchAll( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ), \PDO::FETCH_ASSOC );
 		}
 	}
 

Braces +6 added lines, -4 removed lines

@@ -56,8 +56,9 @@ 
 			$this->queryStructure->setElement( QueryStructure::TABLE, $tableName );
 
 			$tableSelectParams = $table->getBindParams();
-			foreach ( $tableSelectParams as $key => $value )
-				$this->queryStructure->setParams( $key, $value );
+			foreach ( $tableSelectParams as $key => $value ) {
+							$this->queryStructure->setParams( $key, $value );
+			}
 
 		}
 	}
@@ -112,8 +113,9 @@ 
 			$this->queryStructure->setElement( QueryStructure::DISTINCT, 0 ); //???
 		}
 
-		if ( $this->queryStructure->getElement( QueryStructure::FIRST ) )
-			$this->queryStructure->setElement( QueryStructure::LIMIT, 1 );
+		if ( $this->queryStructure->getElement( QueryStructure::FIRST ) ) {
+					$this->queryStructure->setElement( QueryStructure::LIMIT, 1 );
+		}
 
 		$syntax = array();
 

src/Statements/QueryInsert.php

Spacing +7 added lines, -7 removed lines

@@ -62,32 +62,32 @@ 
 		/**
 		 *  Explain
 		 */
-		$syntax[] = $this->getExplainSyntax();
+		$syntax[ ] = $this->getExplainSyntax();
 
 		/**
 		 * UPDATE statement
 		 */
-		$syntax[] = $this->statement;
+		$syntax[ ] = $this->statement;
 
 		/**
 		 * PRIORITY
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
 		/**
 		 * IGNORE clause
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
 
 		/**
 		 * INTO table
 		 */
-		$syntax[] = 'INTO ' . $this->queryStructure->getElement( QueryStructure::TABLE );
+		$syntax[ ] = 'INTO ' . $this->queryStructure->getElement( QueryStructure::TABLE );
 
 		/**
 		 * FIELDS update
 		 */
-		$syntax[] = $this->getSettingFieldsSyntax();
+		$syntax[ ] = $this->getSettingFieldsSyntax();
 
 		$syntax = implode( ' ', $syntax );
 
@@ -99,7 +99,7 @@ 
 	 * @return bool|mixed|\PDOStatement
 	 */
 	public function execute() {
-		return PdoWrapperService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS))->rowCount();
+		return PdoWrapperService::getInstance()->query( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) )->rowCount();
 	}
 
 

src/Statements/QueryUpdate.php

Spacing +10 added lines, -10 removed lines

@@ -53,47 +53,47 @@ 
 		/**
 		 *  Explain
 		 */
-		$syntax[] = $this->getExplainSyntax();
+		$syntax[ ] = $this->getExplainSyntax();
 
 		/**
 		 * UPDATE statement
 		 */
-		$syntax[] = $this->statement;
+		$syntax[ ] = $this->statement;
 
 		/**
 		 * PRIORITY
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
 		/**
 		 * IGNORE clause
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
 
 		/**
 		 * TABLE update
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::TABLE );
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::TABLE );
 
 		/**
 		 * FIELDS update
 		 */
-		$syntax[] = $this->getSettingFieldsSyntax();
+		$syntax[ ] = $this->getSettingFieldsSyntax();
 
 		/**
 		 * WHERE clause
 		 */
-		$syntax[] = $this->getWhereSyntax();
+		$syntax[ ] = $this->getWhereSyntax();
 
 		/**
 		 * ORDER BY clause
 		 */
-		$syntax[] = $this->getOrderBySyntax();
+		$syntax[ ] = $this->getOrderBySyntax();
 
 		/**
 		 * LIMIT clause
 		 */
-		$syntax[] = $this->getLimitSyntax();
+		$syntax[ ] = $this->getLimitSyntax();
 
 		$syntax = implode( ' ', $syntax );
 
@@ -110,6 +110,6 @@ 
 		if ( $this->queryStructure->getElement( ( QueryStructure::WHERE_TRIGGER ) ) && !count( $this->queryStructure->getElement( QueryStructure::WHERE ) ) )
 			throw new QueryException( 'Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
 
-		return PdoWrapperService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS))->rowCount();
+		return PdoWrapperService::getInstance()->query( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) )->rowCount();
 	}
 }
\ No newline at end of file

Braces +3 added lines, -2 removed lines

@@ -96,8 +96,9 @@
 	 */
 	public function execute()
 	{
-		if ( $this->queryStructure->getElement( ( QueryStructure::WHERE_TRIGGER ) ) && !count( $this->queryStructure->getElement( QueryStructure::WHERE ) ) )
-			throw new QueryException( 'Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
+		if ( $this->queryStructure->getElement( ( QueryStructure::WHERE_TRIGGER ) ) && !count( $this->queryStructure->getElement( QueryStructure::WHERE ) ) ) {
+					throw new QueryException( 'Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
+		}
 
 		return PdoWrapperService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS))->rowCount();
 	}