adumitru68 / QueryBuilder

src/Traits/Join.php

Braces +5 added lines, -4 removed lines

@@ -116,10 +116,11 @@
 	{
 		$join = $typeJoin . ' ' . $tableJoin;
 
-		if ( is_null( $onRight ) )
-			$join .= " USING ( $onLeft )";
-		else
-			$join .= " ON $onLeft = $onRight";
+		if ( is_null( $onRight ) ) {
+					$join .= " USING ( $onLeft )";
+		} else {
+					$join .= " ON $onLeft = $onRight";
+		}
 
 		$this->queryStructure->setElement( QueryStructure::JOIN, $join );
 

src/Traits/Replacement.php

Braces +3 added lines, -2 removed lines

@@ -27,8 +27,9 @@
 	{
 		$syntax = QueryHelper::clearMultipleSpaces( $syntax );
 
-		if ( !$withReplacement )
-			return $syntax;
+		if ( !$withReplacement ) {
+					return $syntax;
+		}
 
 		return $this->replaceValues( $syntax );
 	}

Spacing +2 added lines, -2 removed lines

@@ -43,8 +43,8 @@
 		$search = array();
 		$replace = array();
 		foreach ( $bindParams as $key => $value ) {
-			$search[] = ':' . $key;
-			$replace[] = DbConnect::getInstance()->quote( $value );
+			$search[ ] = ':' . $key;
+			$replace[ ] = DbConnect::getInstance()->quote( $value );
 		}
 		$syntax = str_ireplace( $search, $replace, $syntax );
 

src/Traits/InsertMultiple.php

Braces +18 added lines, -12 removed lines

@@ -29,8 +29,9 @@ 
 	{
 		$this->setFieldsList( $fieldsList );
 
-		foreach ( $rowsForInsert as $row )
-			$this->addSingleRow( $row );
+		foreach ( $rowsForInsert as $row ) {
+					$this->addSingleRow( $row );
+		}
 
 		return $this;
 	}
@@ -45,8 +46,9 @@ 
 	{
 		$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 );
 
@@ -59,8 +61,9 @@ 
 	 */
 	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 );
 
@@ -74,13 +77,15 @@ 
 	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, ', ' ) . ' )';
 
@@ -94,8 +99,9 @@ 
 	 */
 	private function getInsertMultipleRowsSyntax()
 	{
-		if ( is_a( $this->queryStructure->getElement( QueryStructure::SET_FIELDS ), QuerySelect::class ) )
-			return $this->getSyntaxWithSelect();
+		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 ), ', ' );

Spacing +1 added lines, -1 removed lines

@@ -80,7 +80,7 @@
 		$pdoRowValues = array();
 
 		foreach ( $rowValues as $value )
-			$pdoRowValues[] = $this->queryStructure->bindParam( 'value', $value );
+			$pdoRowValues[ ] = $this->queryStructure->bindParam( 'value', $value );
 
 		$pdoRowValuesString = '( ' . QueryHelper::implode( $pdoRowValues, ', ' ) . ' )';
 

src/Traits/SetFields.php

Braces +6 added lines, -4 removed lines

@@ -48,8 +48,9 @@ 
 	 */
 	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,8 +60,9 @@ 
 	 */
 	private function getSettingFieldsSyntax()
 	{
-		if ( !count( $this->queryStructure->getElement( QueryStructure::SET_FIELDS ) ) )
-			return '';
+		if ( !count( $this->queryStructure->getElement( QueryStructure::SET_FIELDS ) ) ) {
+					return '';
+		}
 
 		return 'SET ' . implode( ', ', $this->queryStructure->getElement( QueryStructure::SET_FIELDS ) );
 	}

Spacing +1 added lines, -1 removed lines

@@ -24,7 +24,7 @@
 	 */
 	public function setField( $fieldName, $fieldValue )
 	{
-		$fieldName = $this->queryStructure->prepare($fieldName);
+		$fieldName = $this->queryStructure->prepare( $fieldName );
 		$valuePdoString = $this->queryStructure->bindParam( $fieldName, $fieldValue );
 		$this->queryStructure->setElement( QueryStructure::SET_FIELDS, "$fieldName = $valuePdoString" );
 

src/Dependencies/QueryStructure.php

Braces +23 added lines, -16 removed lines

@@ -85,8 +85,9 @@ 
 	{
 		$this->syntaxEL = $this->init();
 
-		foreach ( $this->syntaxEL as $name => $value )
-			$this->typeEL[ $name ] = gettype( $value );
+		foreach ( $this->syntaxEL as $name => $value ) {
+					$this->typeEL[ $name ] = gettype( $value );
+		}
 
 	}
 
@@ -172,16 +173,19 @@ 
 	 */
 	public function setElement( $name, $value )
 	{
-		if ( !array_key_exists( $name, $this->syntaxEL ) )
-			throw new QueryException( 'Invalid Query property', QueryException::QUERY_ERROR_ELEMENT_NOT_FOUND );
+		if ( !array_key_exists( $name, $this->syntaxEL ) ) {
+					throw new QueryException( 'Invalid Query property', QueryException::QUERY_ERROR_ELEMENT_NOT_FOUND );
+		}
 
-		if ( $name == self::TABLE && is_a( $value, QueryStatement::class ) )
-			return true;
+		if ( $name == self::TABLE && is_a( $value, QueryStatement::class ) ) {
+					return true;
+		}
 
-		if ( $this->typeEL[ $name ] === self::ELEMENT_TYPE_ARRAY )
-			$this->syntaxEL[ $name ][] = $value;
-		else
-			$this->syntaxEL[ $name ] = $value;
+		if ( $this->typeEL[ $name ] === self::ELEMENT_TYPE_ARRAY ) {
+					$this->syntaxEL[ $name ][] = $value;
+		} else {
+					$this->syntaxEL[ $name ] = $value;
+		}
 
 		return true;
 	}
@@ -194,8 +198,9 @@ 
 	 */
 	public function replaceElement( $elementName, $elementValue )
 	{
-		if ( !array_key_exists( $elementName, $this->syntaxEL ) )
-			throw new QueryException( 'Invalid Query property', QueryException::QUERY_ERROR_ELEMENT_NOT_FOUND );
+		if ( !array_key_exists( $elementName, $this->syntaxEL ) ) {
+					throw new QueryException( 'Invalid Query property', QueryException::QUERY_ERROR_ELEMENT_NOT_FOUND );
+		}
 
 		$this->syntaxEL[ $elementName ] = $elementValue;
 	}
@@ -243,11 +248,13 @@ 
 	 */
 	public function bindParamsExpression( $expression, array $params = [], $search = '?' )
 	{
-		if ( !count( $params ) )
-			return $expression;
+		if ( !count( $params ) ) {
+					return $expression;
+		}
 
-		if ( strpos( $expression, $search ) === false )
-			return $expression;
+		if ( strpos( $expression, $search ) === false ) {
+					return $expression;
+		}
 
 		$params = array_slice( $params, 0, substr_count( $expression, $search ) );
 

Spacing +7 added lines, -7 removed lines

@@ -60,7 +60,7 @@ 
 	/**
 	 * @var array
 	 */
-	private static $usedInstanceIds = [];
+	private static $usedInstanceIds = [ ];
 
 	/**
 	 * @var array
@@ -144,7 +144,7 @@ 
 		while ( in_array( $instance, self::$usedInstanceIds ) ) {
 			$instance = QueryHelper::random( 5 );
 		}
-		self::$usedInstanceIds[] = $instance;
+		self::$usedInstanceIds[ ] = $instance;
 
 		return $instance;
 	}
@@ -191,7 +191,7 @@ 
 			return true;
 
 		if ( $this->typeEL[ $name ] === self::ELEMENT_TYPE_ARRAY )
-			$this->syntaxEL[ $name ][] = $value;
+			$this->syntaxEL[ $name ][ ] = $value;
 		else
 			$this->syntaxEL[ $name ] = $value;
 
@@ -238,7 +238,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;
@@ -249,12 +249,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/Statements/QueryStatement.php

Spacing +1 added lines, -1 removed lines

@@ -49,7 +49,7 @@
 	/**
 	 * @var array
 	 */
-	protected $usedInstanceIds = [];
+	protected $usedInstanceIds = [ ];
 
 	/**
 	 * @var string

src/Statements/QueryInsertMultiple.php

Spacing +6 added lines, -6 removed lines

@@ -49,32 +49,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->getInsertMultipleRowsSyntax();
+		$syntax[ ] = $this->getInsertMultipleRowsSyntax();
 
 		$syntax = implode( ' ', $syntax );
 

src/Traits/Where.php

Spacing +2 added lines, -2 removed lines

@@ -278,7 +278,7 @@ 
 	 * @param string $glue
 	 * @return $this
 	 */
-	public function whereExpression( $whereString, array $bindParams = [], $glue = 'AND' )
+	public function whereExpression( $whereString, array $bindParams = [ ], $glue = 'AND' )
 	{
 		$whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams );
 
@@ -290,7 +290,7 @@ 
 	 * @param array $bindParams
 	 * @return $this
 	 */
-	public function orWhereExpression( $whereString, array $bindParams = [] )
+	public function orWhereExpression( $whereString, array $bindParams = [ ] )
 	{
 		$whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams );
 

src/Traits/WhereAndHavingBuilder.php

Spacing +2 added lines, -2 removed lines

@@ -139,7 +139,7 @@ 
 
 		$pdoArray = array();
 		foreach ( $value as $item ) {
-			$pdoArray[] = $this->queryStructure->bindParam( 'a', $item );
+			$pdoArray[ ] = $this->queryStructure->bindParam( 'a', $item );
 		}
 		$body = [
 			$field,
@@ -216,7 +216,7 @@ 
 			throw new QueryException( 'Invalid where array!', QueryException::QUERY_ERROR_WHERE_INVALID_PARAM_ARRAY );
 
 		if ( count( $param ) == 2 )
-			$param[] = '=';
+			$param[ ] = '=';
 
 		$param[ 0 ] = $this->queryStructure->prepare( $param[ 0 ] );
 		$param[ 2 ] = trim( strtoupper( $param[ 2 ] ) );

Braces +14 added lines, -10 removed lines

@@ -103,10 +103,11 @@ 
 
 	private function makeInCondition()
 	{
-		if ( is_a( $this->temporaryParam[ 1 ], QuerySelect::class ) )
-			$this->inQuerySelect();
-		elseif ( is_array( $this->temporaryParam[ 1 ] ) )
-			$this->inArray();
+		if ( is_a( $this->temporaryParam[ 1 ], QuerySelect::class ) ) {
+					$this->inQuerySelect();
+		} elseif ( is_array( $this->temporaryParam[ 1 ] ) ) {
+					$this->inArray();
+		}
 	}
 
 	private function inQuerySelect()
@@ -182,8 +183,9 @@ 
 	 */
 	private function getWhereAndHavingSyntax( $clauseType )
 	{
-		if ( count( $this->queryStructure->getElement( $clauseType ) ) == 0 )
-			return '';
+		if ( count( $this->queryStructure->getElement( $clauseType ) ) == 0 ) {
+					return '';
+		}
 
 		$where = '';
 		$last_type = 'where_start';
@@ -212,11 +214,13 @@ 
 	 */
 	private function validateWhereParam( $param )
 	{
-		if ( count( $param ) < 2 )
-			throw new QueryException( 'Invalid where array!', QueryException::QUERY_ERROR_WHERE_INVALID_PARAM_ARRAY );
+		if ( count( $param ) < 2 ) {
+					throw new QueryException( 'Invalid where array!', QueryException::QUERY_ERROR_WHERE_INVALID_PARAM_ARRAY );
+		}
 
-		if ( count( $param ) == 2 )
-			$param[] = '=';
+		if ( count( $param ) == 2 ) {
+					$param[] = '=';
+		}
 
 		$param[ 0 ] = $this->queryStructure->prepare( $param[ 0 ] );
 		$param[ 2 ] = trim( strtoupper( $param[ 2 ] ) );