Kir\MySQL\Builder\Internal\ConditionBuilder

Complexity

Total Complexity

10

Size/Duplication

Total Lines	59
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	buildCondition()	0	4	1
A	build()	0	22	6
A	formatKey()	0	10	3

<?php
namespace Kir\MySQL\Builder\Internal;

use Kir\MySQL\Builder\Expr\OptionalExpression;
use Kir\MySQL\Database;
use Kir\MySQL\Builder;

final class ConditionBuilder {
	/**
	 * @param Database $db
	 * @param string $query
	 * @param array<int, array{string|array<string, mixed>|object|OptionalExpression, array<int, null|string|array<int, null|scalar>|Builder\DBExpr|Builder\Select>}> $conditions

The doc comment array<int, array{string|array<string, mixed>|object|OptionalExpression, array<int, null|string|array<int, null|scalar>|Builder\DBExpr|Builder\Select>}> at position 6 could not be parsed: Expected ':' at position 6, but found 'string'.

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

	/**
	 * @param array<int, string> $conditions
	 * @param string $expression
	 * @param array<int, null|string|array<int, null|scalar>|Builder\DBExpr|Builder\Select> $arguments
	 * @param Database $db
	 * @return array<int, string>
	 */
	private static function buildCondition(array $conditions, string $expression, array $arguments, Database $db): array {
		$expr = $db->quoteExpression($expression, $arguments);
		$conditions[] = "\t({$expr})";
		return $conditions;
	}

	/**
	 * @param string $key
	 * @return string
	 */
	private static function formatKey(string $key): string {
		if(strpos($key, '`') !== false || strpos($key, '(') !== false) {
			return $key;
		}
		$keyParts = explode('.', $key);
		$fn = static function (string $part) {
			return "`{$part}`";
		};
		$enclosedKeyParts = array_map($fn, $keyParts);
		return implode('.', $enclosedKeyParts);
	}
}