QB\Generic\Statement\Update

Complexity

Total Complexity

21

Size/Duplication

Total Lines	156
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

11 Methods

Rating	Name	Duplication	Size	Complexity
A	setValues()	0	5	1
A	addFrom()	0	5	1
A	addModifier()	0	5	1
A	getCommand()	0	10	1
A	getSet()	0	8	2
A	addWhere()	0	7	3
A	isValid()	0	3	3
A	__toString()	0	15	2
A	getWhere()	0	8	2
A	values()	0	3	1
A	getParams()	0	15	4

<?php

declare(strict_types=1);

namespace QB\Generic\Statement;

use QB\Generic\Clause\Table;
use QB\Generic\Expr\Expr;
use QB\Generic\IQueryPart;

class Update implements IUpdate
{
    /** @var array<int,string|Table> */
    protected array $tables = [];

    /** @var string[] */
    protected array $modifiers = [];

    /** @var array<string,mixed> */
    protected array $rawValues = [];

    /** @var IQueryPart[] */
    protected array $whereParts = [];

    /**
     * @param string|Table ...$tables
     *
     * @return $this
     */
    public function addFrom(string|Table ...$tables): static
    {
        $this->tables = array_merge($this->tables, $tables);

        return $this;
    }

    /**
     * @param string ...$modifiers
     *
     * @return $this
     */
    public function addModifier(string ...$modifiers): static
    {
        $this->modifiers = array_merge($this->modifiers, $modifiers);

        return $this;
    }

    /**
     * @param array<string,mixed> $values
     *
     * @return $this
     */
    public function setValues(array $values): static
    {
        $this->rawValues = $values;

        return $this;
    }

    /**
     * @param string|IQueryPart ...$whereParts
     *
     * @return $this
     */
    public function addWhere(string|IQueryPart ...$whereParts): static
    {
        foreach ($whereParts as $wherePart) {
            $this->whereParts[] = is_string($wherePart) ? new Expr($wherePart) : $wherePart;
        }

        return $this;
    }

    /**
     * @return string
     */
    public function __toString(): string
    {
        if (!$this->isValid()) {
            throw new \RuntimeException('Under-initialized UPDATE query. Table, values and where are necessary');
        }

        $sqlParts = array_merge(
            [$this->getCommand()],
            $this->getSet(),
            $this->getWhere(),
        );

        $sqlParts = array_filter($sqlParts);

        return implode(PHP_EOL, $sqlParts);
    }

    public function isValid(): bool
    {
        return count($this->tables) === 1 && count($this->rawValues) > 0 && count($this->whereParts) > 0;
    }

    /**
     * @return string
     */
    protected function getCommand(): string
    {
        $sql   = [];
        $sql[] = 'UPDATE';
        $sql[] = implode(' ', $this->modifiers);
        $sql[] = $this->tables[0];

        $sql = array_filter($sql);

        return implode(' ', $sql);
    }

    /**
     * @return string[]
     */
    protected function getSet(): array
    {
        $values = [];
        foreach ($this->rawValues as $column => $value) {
            $values[] = sprintf('%s = %s', $column, $value);
        }

        return ['SET ' . implode(', ', $values)];
    }

    /**
     * @return string[]
     */
    protected function getWhere(): array
    {
        $whereParts = [];
        foreach ($this->whereParts as $wherePart) {
            $whereParts[] = (string)$wherePart;
        }

        return ['WHERE ' . implode(' AND ', $whereParts)];
    }

    /**
     * @return array
     */
    public function getParams(): array
    {
        $params = [];

        foreach ($this->rawValues as $values) {
            if ($values instanceof IQueryPart) {
                $params = array_merge($params, $values->getParams());
            }
        }

        foreach ($this->whereParts as $wherePart) {
            $params = array_merge($params, $wherePart->getParams());
        }

        return $params;
    }

    /**
     * @return array
     */
    public function values(): array
    {
        return array_values($this->rawValues);
    }
}