rkrx / php-mysql-query-builder

src/Builder/Traits/GroupByBuilder.php

Spacing +5 added lines, -5 removed lines

@@ -14,9 +14,9 @@ 
 	 * @return $this
 	 */
 	public function groupBy(...$args) {
-		foreach($args as $expression) {
-			if(is_array($expression)) {
-				if(!count($expression)) {
+		foreach ($args as $expression) {
+			if (is_array($expression)) {
+				if (!count($expression)) {
 					continue;
 				}
 				$expression = $this->quoteExpr($expression[0], array_slice($expression, 1));
@@ -31,12 +31,12 @@ 
 	 * @return string
 	 */
 	protected function buildGroups(string $query): string {
-		if(!count($this->groupBy)) {
+		if (!count($this->groupBy)) {
 			return $query;
 		}
 		$query .= "GROUP BY\n";
 		$arr = [];
-		foreach($this->groupBy as $expression) {
+		foreach ($this->groupBy as $expression) {
 			$arr[] = "\t{$expression}";
 		}
 		return $query.implode(",\n", $arr)."\n";

src/Builder/Traits/TableBuilder.php

Spacing +2 added lines, -2 removed lines

@@ -26,10 +26,10 @@
 	 */
 	protected function buildTables(string $query): string {
 		$arr = [];
-		foreach($this->tables as $table) {
+		foreach ($this->tables as $table) {
 			$arr[] = "\t".$this->buildTableName($table['alias'], $table['name']);
 		}
-		if(count($arr)) {
+		if (count($arr)) {
 			$query .= implode(",\n", $arr)."\n";
 		}
 		return $query;

src/Builder/InsertUpdateStatement.php

Spacing +3 added lines, -3 removed lines

@@ -31,13 +31,13 @@
 	 */
 	protected function buildFieldList(array $fields, array $query = []): array {
 		foreach ($fields as $fieldName => $fieldValue) {
-			if($fieldValue instanceof DefaultValue) {
+			if ($fieldValue instanceof DefaultValue) {
 				$fieldValue = 'DEFAULT';
 			}
-			if(is_array($this->mask) && !in_array($fieldName, $this->mask, true)) {
+			if (is_array($this->mask) && !in_array($fieldName, $this->mask, true)) {
 				continue;
 			}
-			if(is_int($fieldName)) {
+			if (is_int($fieldName)) {
 				if (is_array($fieldValue)) {
 					$fieldValue = $this->db()->quoteExpression($fieldValue[0], array_slice($fieldValue, 1));
 				}

src/Builder/Delete.php

Spacing +3 added lines, -3 removed lines

@@ -29,10 +29,10 @@ 
 	 * @return $this
 	 */
 	public function from(string $alias, $table = null) {
-		if($table !== null) {
+		if ($table !== null) {
 			$this->aliases[] = $alias;
 		}
-		if($table === null) {
+		if ($table === null) {
 			[$alias, $table] = [$table, $alias];
 		}
 		$this->addTable($alias, $table);
@@ -51,7 +51,7 @@ 
 	public function __toString(): string {
 		$query = "DELETE ";
 		$query .= implode(', ', $this->aliases);
-		$query = trim($query) . " FROM\n";
+		$query = trim($query)." FROM\n";
 		$query = $this->buildTables($query);
 		$query = $this->buildJoins($query);
 		$query = $this->buildWhereConditions($query);

src/Builder/Helpers/ConditionAddHelper.php

Spacing +5 added lines, -5 removed lines

@@ -10,13 +10,13 @@ 
 	 * @param array<int, mixed> $args
 	 */
 	public static function addCondition(callable $addFn, $expression, array $args): void {
-		if($expression instanceof OptionalExpression) {
-			if($expression->isValid()) {
+		if ($expression instanceof OptionalExpression) {
+			if ($expression->isValid()) {
 				$addFn($expression->getExpression(), [$expression->getValue()]);
 			}
-		} elseif(is_object($expression)) {
+		} elseif (is_object($expression)) {
 			self::addAsArray($addFn, (array) $expression, $args);
-		} elseif(is_array($expression)) {
+		} elseif (is_array($expression)) {
 			self::addAsArray($addFn, $expression, $args);
 		} else {
 			$addFn($expression, $args);
@@ -29,7 +29,7 @@ 
 	 * @param array<int, mixed> $args
 	 */
 	private static function addAsArray(callable $addFn, array $expression, array $args): void {
-		if(count($expression) > 0) {
+		if (count($expression) > 0) {
 			$addFn($expression, $args);
 		}
 	}

src/Builder/Helpers/FieldValueConverter.php

Spacing +2 added lines, -2 removed lines

@@ -9,8 +9,8 @@
 	 */
 	public static function convertValues(array $row, array $columnDefinitions): array {
 		$result = [];
-		foreach($row as $key => $value) {
-			if($value !== null) {
+		foreach ($row as $key => $value) {
+			if ($value !== null) {
 				$result[$key] = self::convertValue($value, $columnDefinitions[$key]);
 			} else {
 				$result[$key] = $value;

src/Builder/Helpers/FieldTypeProvider.php

Spacing +1 added lines, -1 removed lines

@@ -10,7 +10,7 @@
 	 */
 	public static function getFieldTypes(QueryStatement $statement): array {
 		$fieldTypes = [];
-		for($i = 0; $column = $statement->getColumnMeta($i); $i++) {
+		for ($i = 0; $column = $statement->getColumnMeta($i); $i++) {
 			$fieldTypes[(string) $column['name']] = self::getTypeFromNativeType($column['native_type']);
 		}
 		return $fieldTypes;

src/Builder/Internal/ConditionBuilder.php

Spacing +5 added lines, -5 removed lines

@@ -13,15 +13,15 @@
 	 * @return string
 	 */
 	public static function build(Database $db, string $query, array $conditions, string $token): string {
-		if(!count($conditions)) {
+		if (!count($conditions)) {
 			return $query;
 		}
 		$query .= "{$token}\n";
 		$arr = [];
-		foreach($conditions as [$expression, $arguments]) {
-			if(is_array($expression)) {
-				foreach($expression as $key => $value) {
-					if($value === null) {
+		foreach ($conditions as [$expression, $arguments]) {
+			if (is_array($expression)) {
+				foreach ($expression as $key => $value) {
+					if ($value === null) {
 						$arr = self::buildCondition($arr, "ISNULL(`{$key}`)", [$value], $db);
 					} else {
 						$arr = self::buildCondition($arr, "`{$key}`=?", [$value], $db);

src/Builder/Internal/DDLRunnable.php

Spacing +1 added lines, -1 removed lines

@@ -28,7 +28,7 @@
 	public function run(array $params = []) {
 		$this->query->execute($params);
 		$response = $this->query->getStatement()->rowCount();
-		if($this->callbackFn !== null) {
+		if ($this->callbackFn !== null) {
 			$response = call_user_func($this->callbackFn);
 		}
 		return $response;