HexMakina\Crudites\Grammar\Query\Query

Complexity

Total Complexity

23

Size/Duplication

Total Lines	141
Duplicated Lines	0 %

Importance

Changes

0

15 Methods

Rating	Name	Duplication	Size	Complexity
A	addBindings()	0	7	2
A	table()	0	3	1
A	alias()	0	3	1
A	add()	0	4	1
A	clause()	0	3	1
A	addBinding()	0	10	1
A	set()	0	4	1
A	__toString()	0	3	1
A	getBindingNames()	0	3	1
A	tableLabel()	0	3	1
A	__debugInfo()	0	21	4
A	bindLabel()	0	3	1
A	compare()	0	14	4
A	tableAlias()	0	7	2
A	bindings()	0	3	1

<?php

namespace HexMakina\Crudites\Grammar\Query;

use HexMakina\BlackBox\Database\QueryInterface;
use HexMakina\Crudites\Grammar\Clause\Clause;

abstract class Query implements QueryInterface
{

    
    protected array $bindings = [];
    protected array $binding_names = [];
    
    protected string $table;
    protected ?string $alias = null;
    
    protected $table_alias = null;
    
    protected array $clauses = [];
    
    abstract public function statement(): string;
    
    /**
     * Provides debugging information about the object.
     * This method returns an array of object properties and their values,
     * excluding properties that are not set.
     */
    public function __debugInfo(): array
    {
        $dbg = get_object_vars($this);

        foreach (array_keys($dbg) as $k) {
            if (!isset($dbg[$k])) {
                unset($dbg[$k]);
            }
        }

        $dbg['statement()'] = $this->statement();

        
        if (empty($this->bindings)) {
            unset($dbg['bindings']);
        }
        else{
            $dbg['bindings'] = json_encode($dbg['bindings']);
        }

        return $dbg;
    }

    public function __toString()
    {
        return $this->statement();
    }

    public function table(): string
    {
        return $this->table;

The expression return $this->table returns the type string which is incompatible with the return type mandated by HexMakina\BlackBox\Database\QueryInterface::table() of HexMakina\BlackBox\Database\TableInterface.

    }

    public function alias(): string
    {
        return $this->alias ?? $this->table;
    }

    public function clause(string $name): ?Clause
    {
        return $this->clauses[$name] ?? null;
    }

    public function add(Clause $clause): self
    {
        $this->clauses[$clause->name()] = $clause;
        return $this;
    }

    public function set(Clause $clause): self
    {
        unset($this->clauses[$clause->name()]);
        return $this->add($clause);
    }

    //------------------------------------------------------------  PREP::FIELDS
    public function tableLabel(string $force = null)
    {
        return $force ?? $this->tableAlias();
    }

    public function tableAlias($setter = null): string
    {
        if ($setter !== null) {
            $this->table_alias = $setter;
        }

        return $this->table_alias ?? $this->table;
    }

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

    public function getBindingNames(): array
    {
        return $this->binding_names;
    }

    public function addBinding($field, $value, $table_name = null, $bind_label = null): string
    {
        $table_label = $this->tableLabel($table_name);
        $bind_label ??= $this->bindLabel($field, $table_name);

        $this->binding_names[$table_label] ??= [];
        $this->binding_names[$table_label][$field] = $bind_label;
        $this->bindings[$bind_label] = $value;

        return $bind_label;
    }

    public function bindLabel($field, $table_name = null): string
    {
        return ':' . $this->tableLabel($table_name) . '_' . $field;
    }

    public function addBindings($assoc_data): array
    {
        $ret = [];
        foreach ($assoc_data as $column_name => $value) {
            $ret[$column_name] = $this->addBinding($column_name, $value, $this->table);
        }
        return $ret;
    }

    public function compare($query)
    {
        if ($this->statement() !== $query->statement()) {
            return 'statement';
        }

        if (!empty(array_diff($this->bindings(), $query->bindings()))) {
            return 'bindings';
        }
        if (!empty(array_diff($query->bindings(), $this->bindings()))) {
            return 'bindings';
        }

        return true;
    }
}