adumitru68 / QueryBuilder

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 ) );
 

src/Traits/TableValidation.php

Braces +12 added lines, -8 removed lines

@@ -46,22 +46,26 @@
 	{
 		$table = trim( $table );
 
-		if ( '' === $table )
-			throw new QueryException( 'Table name is empty string!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT );
+		if ( '' === $table ) {
+					throw new QueryException( 'Table name is empty string!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT );
+		}
 
-		if ( DbConfig::getInstance()->useTablePrefix() )
-			$table = str_ireplace( '::', DbConfig::getInstance()->getTablePrefix(), $table );
+		if ( DbConfig::getInstance()->useTablePrefix() ) {
+					$table = str_ireplace( '::', DbConfig::getInstance()->getTablePrefix(), $table );
+		}
 
 		return QueryHelper::addBacktick($table);
 	}
 
 	private function validateTableSubQuery( $table )
 	{
-		if ( $this->statement !== QueryStatement::QUERY_STATEMENT_SELECT )
-			throw new QueryException( 'Invalid subQuery statement!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT );
+		if ( $this->statement !== QueryStatement::QUERY_STATEMENT_SELECT ) {
+					throw new QueryException( 'Invalid subQuery statement!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT );
+		}
 
-		if ( !is_a( $table, QuerySelect::class ) )
-			throw new QueryException( 'Invalid subQuery statement!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT );
+		if ( !is_a( $table, QuerySelect::class ) ) {
+					throw new QueryException( 'Invalid subQuery statement!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT );
+		}
 
 		return $table;
 	}

src/Traits/Limit.php

Braces +9 added lines, -6 removed lines

@@ -28,8 +28,9 @@ 
 	{
 		$limit = trim( $limit );
 
-		if ( !QueryHelper::isInteger( $limit ) )
-			throw new QueryException( 'Invalid Limit value', QueryException::QUERY_ERROR_INVALID_LIMIT );
+		if ( !QueryHelper::isInteger( $limit ) ) {
+					throw new QueryException( 'Invalid Limit value', QueryException::QUERY_ERROR_INVALID_LIMIT );
+		}
 
 		$limit = $this->queryStructure->bindParam('lim', (int)$limit);
 
@@ -41,8 +42,9 @@ 
 
 		$offset = trim( $offset );
 
-		if ( !QueryHelper::isInteger( $offset ) )
-			throw new QueryException( 'Invalid Limit offset', QueryException::QUERY_ERROR_INVALID_LIMIT_OFFSET );
+		if ( !QueryHelper::isInteger( $offset ) ) {
+					throw new QueryException( 'Invalid Limit offset', QueryException::QUERY_ERROR_INVALID_LIMIT_OFFSET );
+		}
 
 		$offset = $this->queryStructure->bindParam('ofs', (int)$offset);
 
@@ -53,8 +55,9 @@ 
 
 	private function getLimitSyntax()
 	{
-		if ( !$this->queryStructure->getElement( QueryStructure::LIMIT ) )
-			return '';
+		if ( !$this->queryStructure->getElement( QueryStructure::LIMIT ) ) {
+					return '';
+		}
 
 		return 'LIMIT ' . $this->queryStructure->getElement( QueryStructure::LIMIT );
 	}

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

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

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/AbstractCruds/AbstractTableCrud.php

Braces +24 added lines, -16 removed lines

@@ -50,8 +50,9 @@ 
 		$this->setPrimaryKey();
 		$this->setOrderField();
 
-		if ( !is_array( $this->primary ) )
-			$this->primary = [ $this->primary ];
+		if ( !is_array( $this->primary ) ) {
+					$this->primary = [ $this->primary ];
+		}
 	}
 
 	/**
@@ -64,8 +65,9 @@ 
 	{
 		$conditions = $this->getPrimaryKeyConditions( $id );
 		$result = QueryBuild::select( $this->table )->fields( $fields );
-		foreach ( $conditions as $field => $value )
-			$result->whereEqual( $field, $value );
+		foreach ( $conditions as $field => $value ) {
+					$result->whereEqual( $field, $value );
+		}
 
 		return $result->first()->execute();
 	}
@@ -80,8 +82,9 @@ 
 	{
 		$conditions = $this->getPrimaryKeyConditions( $id );
 		$result = QueryBuild::delete( $this->table );
-		foreach ( $conditions as $field => $value )
-			$result->whereEqual( $field, $value );
+		foreach ( $conditions as $field => $value ) {
+					$result->whereEqual( $field, $value );
+		}
 
 		return $result->execute();
 	}
@@ -96,8 +99,9 @@ 
 	{
 		$conditions = $this->getPrimaryKeyConditions( $id );
 		$result = QueryBuild::update( $this->table );
-		foreach ( $conditions as $field => $value )
-			$result->whereEqual( $field, $value );
+		foreach ( $conditions as $field => $value ) {
+					$result->whereEqual( $field, $value );
+		}
 		$result->setFieldsByArray( $arrayUpdater );
 
 		return $result->execute();
@@ -133,8 +137,9 @@ 
 	 */
 	public function saveOrder( $updates_ord = array() )
 	{
-		if ( empty( $this->orderField ) )
-			throw new QueryException( 'Order field is not defined' );
+		if ( empty( $this->orderField ) ) {
+					throw new QueryException( 'Order field is not defined' );
+		}
 
 		$query = /** @lang text */
 			"UPDATE `{$this->table}` SET `{$this->orderField}` = CASE `{$this->primary[0]}` \r\n";
@@ -155,16 +160,19 @@ 
 	 */
 	protected function getPrimaryKeyConditions( $id )
 	{
-		if ( !is_array( $id ) )
-			$id = [ $id ];
+		if ( !is_array( $id ) ) {
+					$id = [ $id ];
+		}
 
-		if ( count( $this->primary ) !== count( $id ) )
-			throw new QueryException( 'Invalid primary key', QueryException::QUERY_CRUD_INVALID_PRIMARY );
+		if ( count( $this->primary ) !== count( $id ) ) {
+					throw new QueryException( 'Invalid primary key', QueryException::QUERY_CRUD_INVALID_PRIMARY );
+		}
 
 		$conditions = [];
 
-		foreach ( $this->primary as $index => $key )
-			$conditions[ $key ] = $id[ $index ];
+		foreach ( $this->primary as $index => $key ) {
+					$conditions[ $key ] = $id[ $index ];
+		}
 
 		return $conditions;
 	}