Kir\MySQL\Databases\MySQL\MySQLQuoter

Complexity

Total Complexity

14

Size/Duplication

Total Lines	69
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
B	quote()	0	30	10
A	quoteExpression()	0	17	3

<?php
namespace Kir\MySQL\Databases\MySQL;

use DateTimeInterface;
use DateTimeZone;
use Kir\MySQL\Builder\DBExpr;
use Kir\MySQL\Builder\Select;
use PDO;
use phpDocumentor\Reflection\Types\Scalar;

class MySQLQuoter {
	/** @var PDO */
	private $pdo;
	/** @var DateTimeZone */
	private $timeZone;

	public function __construct(PDO $pdo, DateTimeZone $timeZone) {
		$this->timeZone = $timeZone;
		$this->pdo = $pdo;
	}

	/**
	 * @param null|bool|int|float|string|array<int, null|scalar>|DBExpr|Select|DateTimeInterface $value
	 * @return string
	 */
	public function quote($value): string {
		if(is_null($value)) {
			return 'NULL';
		}

		if(is_bool($value)) {
			return $value ? '1' : '0';
		}

		if(is_array($value)) {
			return implode(', ', array_map([$this, __FUNCTION__], $value));
		}

		if($value instanceof DBExpr) {
			return $value->getExpression();
		}

		if($value instanceof Select) {
			return sprintf('(%s)', (string) $value);
		}

		if(is_int($value) || is_float($value)) {
			return (string) $value;
		}

		if($value instanceof DateTimeInterface) {
			$value = date_create_immutable($value->format('c'))->setTimezone($this->timeZone)->format('Y-m-d H:i:s');
		}

		return $this->pdo->quote($value);
	}

	/**
	 * @param string $expression
	 * @param array<int, null|scalar|array<int, string>|DBExpr|Select> $arguments
	 * @return string
	 */
	public function quoteExpression(string $expression, array $arguments = []): string {
		$index = -1;
		$func = function () use ($arguments, &$index) {
			$index++;
			if(array_key_exists($index, $arguments)) {
				$argument = $arguments[$index];
				$value = $this->quote($argument);
			} elseif(count($arguments) > 0) {
				$args = $arguments;
				$value = array_pop($args);
				$value = $this->quote($value);
			} else {
				$value = 'NULL';
			}
			return $value;
		};
		return (string) preg_replace_callback('{(\\?)}', $func, $expression);
	}
}