Sirius\Sql\Bindings

Complexity

Total Complexity

17

Size/Duplication

Total Lines	90
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

86.36%

Importance

Changes

0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	value()	0	7	2
A	getType()	0	16	4
A	values()	0	6	2
A	getArrayCopy()	0	4	1
A	remove()	0	4	1
A	inline()	0	16	3
A	inlineArray()	0	13	2
A	sprintf()	0	10	2

<?php
declare(strict_types=1);

namespace Sirius\Sql;

use PDO;

class Bindings
{
    protected $values = [];

    protected $inlineCount = 0;

    public function value(string $key, $value, int $type = -1)
    {
        if ($type === -1) {
            $type = $this->getType($value);
        }
        $this->values[$key] = [$value, $type];
    }

    protected function getType($value)
    {
        if (is_null($value)) {
            return PDO::PARAM_NULL;
        }

        if (is_bool($value)) {
            return PDO::PARAM_BOOL;
        }

        if (is_int($value)) {
            return PDO::PARAM_INT;
        }

        return PDO::PARAM_STR;
    }

    public function values(array $values, int $type = -1)
    {
        foreach ($values as $key => $value) {
            $this->value($key, $value, $type);
        }
    }

    public function getArrayCopy(): array
    {
        return $this->values;
    }

    public function remove(string $key)
    {
        unset($this->values[$key]);
    }

    public function inline($value, int $type = -1): string
    {
        if ($value instanceof Select) {
            return '(' . $value->getStatement() . ')';
        }

        if (is_array($value)) {
            return $this->inlineArray($value, $type);
        }

        $this->inlineCount++;
        $key = "__{$this->inlineCount}__";
        $this->value($key, $value, $type);

        return ":{$key}";
    }

    protected function inlineArray(array $array, int $type): string
    {
        $keys = [];

        foreach ($array as $value) {
            $this->inlineCount++;
            $key = "__{$this->inlineCount}__";
            $this->value($key, $value, $type);
            $keys[] = ":{$key}";
        }

        return '(' . implode(', ', $keys) . ')';
    }

    public function sprintf(string $format, ...$values): string
    {
        $tokens = [];

        foreach ($values as $value) {
            $tokens[] = $this->inline($value);
        }

        return sprintf($format, ...$tokens);
    }
}