rkrx / php-mysql-query-builder

src/Builder/Insert.php

Spacing +21 added lines, -21 removed lines

@@ -89,7 +89,7 @@ 
 	 * @return $this
 	 */
 	public function addExpr(string $str, ...$args) {
-		if(count($args) > 0) {
+		if (count($args) > 0) {
 			$this->fields[] = func_get_args();
 		} else {
 			$this->fields[] = $str;
@@ -103,7 +103,7 @@ 
 	 * @return $this
 	 */
 	public function updateExpr(string $str, ...$args) {
-		if(count($args) > 0) {
+		if (count($args) > 0) {
 			$this->update[] = func_get_args();
 		} else {
 			$this->update[] = $str;
@@ -117,7 +117,7 @@ 
 	 * @return $this
 	 */
 	public function addOrUpdateExpr(string $expr, ...$args) {
-		if(count($args) > 0) {
+		if (count($args) > 0) {
 			$this->fields[] = func_get_args();
 			$this->update[] = func_get_args();
 		} else {
@@ -134,7 +134,7 @@ 
 	 * @return $this
 	 */
 	public function addAll(array $data, ?array $mask = null, ?array $excludeFields = null) {
-		$this->addAllTo($data, $mask, $excludeFields, function ($field, $value) {
+		$this->addAllTo($data, $mask, $excludeFields, function($field, $value) {
 			$this->add($field, $value);
 		});
 		return $this;
@@ -147,8 +147,8 @@ 
 	 * @return $this
 	 */
 	public function updateAll(array $data, ?array $mask = null, ?array $excludeFields = null) {
-		$this->addAllTo($data, $mask, $excludeFields, function ($field, $value) {
-			if($field !== $this->keyField) {
+		$this->addAllTo($data, $mask, $excludeFields, function($field, $value) {
+			if ($field !== $this->keyField) {
 				$this->update($field, $value);
 			}
 		});
@@ -192,7 +192,7 @@ 
 	 * @return string
 	 */
 	public function __toString(): string {
-		if($this->table === null) {
+		if ($this->table === null) {
 			throw new RuntimeException('Specify a table-name');
 		}
 
@@ -202,21 +202,21 @@ 
 		$ignoreStr = $this->ignore ? ' IGNORE' : '';
 		$queryArr[] = "INSERT{$ignoreStr} INTO\n\t{$tableName}\n";
 
-		if($this->from !== null) {
+		if ($this->from !== null) {
 			$fields = $this->from->getFields();
 			$queryArr[] = sprintf("\t(%s)\n", implode(', ', array_keys($fields)));
 			$queryArr[] = $this->from;
 		} else {
 			$fields = $this->fields;
 			$insertData = $this->buildFieldList($fields);
-			if(!count($insertData)) {
+			if (!count($insertData)) {
 				throw new RuntimeException('No field-data found');
 			}
 			$queryArr[] = sprintf("SET\n%s\n", implode(",\n", $insertData));
 		}
 
 		$updateData = $this->buildUpdate();
-		if($updateData) {
+		if ($updateData) {
 			$queryArr[] = "{$updateData}\n";
 		}
 
@@ -230,7 +230,7 @@ 
 	 * @return array<string|int, mixed>
 	 */
 	private function addTo(array $fields, string $field, $value): array {
-		if(!$this->isFieldNameValid($field)) {
+		if (!$this->isFieldNameValid($field)) {
 			throw new UnexpectedValueException('Field name is invalid');
 		}
 		$sqlField = $field;
@@ -246,18 +246,18 @@ 
 	 * @param callable(string, mixed): void $fn
 	 */
 	private function addAllTo(array $data, ?array $mask, ?array $excludeFields, $fn): void {
-		if($mask !== null) {
+		if ($mask !== null) {
 			$data = array_intersect_key($data, array_combine($mask, $mask));
 		}
-		if($excludeFields !== null) {
-			foreach($excludeFields as $excludeField) {
-				if(array_key_exists($excludeField, $data)) {
+		if ($excludeFields !== null) {
+			foreach ($excludeFields as $excludeField) {
+				if (array_key_exists($excludeField, $data)) {
 					unset($data[$excludeField]);
 				}
 			}
 		}
 		$data = $this->clearValues($data);
-		foreach($data as $field => $value) {
+		foreach ($data as $field => $value) {
 			$fn($field, $value);
 		}
 	}
@@ -267,10 +267,10 @@ 
 	 */
 	private function buildUpdate(): string {
 		$queryArr = [];
-		if(!empty($this->update)) {
+		if (!empty($this->update)) {
 			$queryArr[] = "ON DUPLICATE KEY UPDATE\n";
 			$updateArr = [];
-			if($this->keyField !== null) {
+			if ($this->keyField !== null) {
 				$updateArr[] = "\t`{$this->keyField}` = LAST_INSERT_ID({$this->keyField})";
 			}
 			$updateArr = $this->buildFieldList($this->update, $updateArr);
@@ -293,7 +293,7 @@ 
 	 * @return array<string, mixed>
 	 */
 	private function clearValues(array $values): array {
-		if(!count($values)) {
+		if (!count($values)) {
 			return [];
 		}
 
@@ -301,8 +301,8 @@ 
 		$fields = $this->db()->getTableFields($tableName);
 		$result = [];
 
-		foreach($values as $fieldName => $fieldValue) {
-			if(in_array($fieldName, $fields)) {
+		foreach ($values as $fieldName => $fieldValue) {
+			if (in_array($fieldName, $fields)) {
 				$result[$fieldName] = $fieldValue;
 			}
 		}

src/Builder/Helpers/RecursiveStructureAccess.php

Spacing +10 added lines, -10 removed lines

@@ -28,9 +28,9 @@ 
 		if (!$count) {
 			return $default;
 		}
-		foreach($arrayPath as $idxValue) {
+		foreach ($arrayPath as $idxValue) {
 			$part = $idxValue;
-			if(!array_key_exists($part, $data)) {
+			if (!array_key_exists($part, $data)) {
 				return $default;
 			}
 			$data = $data[$part];
@@ -45,14 +45,14 @@ 
 	 */
 	private static function _recursiveHas($structure, array $path): bool {
 		$data = self::ensureArrayIsArray($structure);
-		if($data === null) {
+		if ($data === null) {
 			return false;
 		}
-		if(!count($path)) {
+		if (!count($path)) {
 			return false;
 		}
 		$key = array_shift($path);
-		if(count($path)) {
+		if (count($path)) {
 			return self::_recursiveHas($data[$key] ?? null, $path);
 		}
 		return array_key_exists($key, $data);
@@ -63,11 +63,11 @@ 
 	 * @return string[]
 	 */
 	private static function getArrayPath($path): array {
-		if(is_array($path)) {
+		if (is_array($path)) {
 			return $path;
 		}
 		$parts = preg_split('{(?<!\\x5C)(?:\\x5C\\x5C)*\\.}', $path);
-		if($parts === false) {
+		if ($parts === false) {
 			return [$path];
 		}
 		return $parts;
@@ -78,13 +78,13 @@ 
 	 * @return array<mixed, mixed>
 	 */
 	private static function ensureArrayIsArray($array): ?array {
-		if($array instanceof ArrayObject) {
+		if ($array instanceof ArrayObject) {
 			return $array->getArrayCopy();
 		}
-		if(is_object($array)) {
+		if (is_object($array)) {
 			return (array) $array;
 		}
-		if(is_array($array)) {
+		if (is_array($array)) {
 			return $array;
 		}
 		return null;

src/Builder/Helpers/ConditionAddHelper.php

Spacing +5 added lines, -5 removed lines

@@ -16,13 +16,13 @@ 
 	 * @param array<DBParameterValueType> $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);
@@ -35,7 +35,7 @@ 
 	 * @param array<int, DBParameterValueType> $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/InsertUpdateStatement.php

Spacing +3 added lines, -3 removed lines

@@ -34,13 +34,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)) {
 					// @phpstan-ignore-next-line
 					$fieldValue = $this->db()->quoteExpression($fieldValue[0], array_slice($fieldValue, 1));

src/Builder/Update.php

Spacing +13 added lines, -13 removed lines

@@ -33,7 +33,7 @@ 
 	 * @return $this
 	 */
 	public function table($alias, $table = null): self {
-		if($table === null) {
+		if ($table === null) {
 			[$alias, $table] = [$table, $alias];
 		}
 		$this->addTable($alias, $table);
@@ -68,7 +68,7 @@ 
 	 * @return $this
 	 */
 	public function setExpr(string $expr, ...$args): self {
-		if(count($args) > 0) {
+		if (count($args) > 0) {
 			$this->fields[] = func_get_args();
 		} else {
 			$this->fields[] = $expr;
@@ -82,15 +82,15 @@ 
 	 * @return $this
 	 */
 	public function setAll(array $data, ?array $allowedFields = null): self {
-		if($allowedFields !== null) {
-			foreach($data as $fieldName => $value) {
-				if(in_array($fieldName, $allowedFields)) {
+		if ($allowedFields !== null) {
+			foreach ($data as $fieldName => $value) {
+				if (in_array($fieldName, $allowedFields)) {
 					$this->set($fieldName, $value);
 				}
 			}
 		} else {
 			$values = $this->clearValues($data);
-			foreach($values as $fieldName => $value) {
+			foreach ($values as $fieldName => $value) {
 				$this->set($fieldName, $value);
 			}
 		}
@@ -125,7 +125,7 @@ 
 	 */
 	private function buildAssignments(string $query): string {
 		$sqlFields = $this->buildFieldList($this->fields);
-		if(!count($sqlFields)) {
+		if (!count($sqlFields)) {
 			throw new RuntimeException('No field-data found');
 		}
 		return sprintf("%s%s\n", $query, implode(",\n", $sqlFields));
@@ -136,14 +136,14 @@ 
 	 * @return array<string, mixed>
 	 */
 	private function clearValues(array $values): array {
-		if(!count($values)) {
+		if (!count($values)) {
 			return [];
 		}
 		$tables = $this->getTables();
-		if(!count($tables)) {
+		if (!count($tables)) {
 			throw new RuntimeException('Table name is missing');
 		}
-		if(count($tables) > 1) {
+		if (count($tables) > 1) {
 			throw new RuntimeException('Batch values only work with max. one table');
 		}
 
@@ -151,11 +151,11 @@ 
 		$tableName = $table['name'];
 
 		$result = [];
-		if(is_string($tableName)) {
+		if (is_string($tableName)) {
 			$fields = $this->db()->getTableFields($tableName);
 
-			foreach($values as $fieldName => $fieldValue) {
-				if(in_array($fieldName, $fields, true)) {
+			foreach ($values as $fieldName => $fieldValue) {
+				if (in_array($fieldName, $fields, true)) {
 					$result[$fieldName] = $fieldValue;
 				}
 			}

src/Builder/Delete.php

Spacing +3 added lines, -3 removed lines

@@ -33,10 +33,10 @@ 
 	 * @return $this
 	 */
 	public function from($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);
@@ -55,7 +55,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/Databases/MySQL/MySQLSelect.php

Spacing +1 added lines, -1 removed lines

@@ -123,7 +123,7 @@
 	 * @return $this
 	 */
 	public function from($alias, $table = null) {
-		if($table === null) {
+		if ($table === null) {
 			[$alias, $table] = [$table, $alias];
 			$this->addTable($alias, (string) $table);
 		} else {

src/Tools/JsonTable.php

Spacing +2 added lines, -2 removed lines

@@ -40,8 +40,8 @@
 	 */
 	private function translateColumns(Database $db, $columns) {
 		$result = [];
-		foreach($columns as $column) {
-			if(!is_string($column)) {
+		foreach ($columns as $column) {
+			if (!is_string($column)) {
 				$column = sprintf('%s %s PATH \'%s\'', $column['name'], $column['type'], $column['jsonPath']);
 			}
 			$result[] = $column;

src/Builder/Expr/DBExprFilter.php

Spacing +8 added lines, -8 removed lines

@@ -26,19 +26,19 @@ 
 	public function __construct(
 		private string $expression,
 		array $data,
-		string|array $keyPath,
+		string | array $keyPath,
 		$validator = null,
 		$validationResultHandler = null
 	) {
 		$this->keyPath = $this->buildKey($keyPath);
 		$this->value = RecursiveStructureAccess::recursiveGet($data, $this->keyPath, null);
 		$this->hasValue = is_scalar($this->value) ? trim((string) $this->value) !== '' : !empty($this->value);
-		if($validator === null) {
+		if ($validator === null) {
 			$validator = static fn() => true;
 		}
 		$this->validator = $validator;
-		if($validationResultHandler === null) {
-			$validationResultHandler = static function () {};
+		if ($validationResultHandler === null) {
+			$validationResultHandler = static function() {};
 		}
 		$this->validationResultHandler = $validationResultHandler;
 	}
@@ -54,10 +54,10 @@ 
 	 * @return bool
 	 */
 	public function isValid(): bool {
-		if(!$this->hasValue) {
+		if (!$this->hasValue) {
 			return false;
 		}
-		if($this->validator !== null) {
+		if ($this->validator !== null) {
 			$result = call_user_func($this->validator, $this->value);
 			call_user_func($this->validationResultHandler, $result, [
 				'value' => $this->value,
@@ -80,10 +80,10 @@ 
 	 * @return string[]
 	 */
 	private function buildKey($keyPath): array {
-		if(is_string($keyPath)) {
+		if (is_string($keyPath)) {
 			$keyPath = explode('.', $keyPath);
 		}
-		if(!is_array($keyPath)) {
+		if (!is_array($keyPath)) {
 			throw new RuntimeException('Invalid key');
 		}
 		return $keyPath;