Divergence\IO\Database\Query\Select

Complexity

Total Complexity

15

Size/Duplication

Total Lines	65
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	order()	0	6	2
A	where()	0	4	1
A	expression()	0	4	1
A	having()	0	4	1
A	calcFoundRows()	0	4	1
A	limit()	0	6	2
B	__toString()	0	16	7

<?php

namespace Divergence\IO\Database\Query;

class Select extends AbstractQuery
{
    public ?string $where;
    public ?string $having;
    public ?string $limit;
    public ?string $order;
    public string $expression = '*';
    public bool $calcFoundRows = false;

    public function expression(string $expression): Select
    {
        $this->expression = $expression;
        return $this;
    }

    public function where(string $where): Select
    {
        $this->where = $where;
        return $this;
    }

    public function having(string $having): Select
    {
        $this->having = $having;
        return $this;
    }

    public function limit(string $limit): Select
    {
        if (!empty($limit)) {
            $this->limit = $limit;
        }
        return $this;
    }

    public function order(string $order): Select
    {
        if (!empty($order)) {
            $this->order = $order;
        }
        return $this;
    }

    public function calcFoundRows(): Select
    {
        $this->calcFoundRows = true;
        return $this;
    }

    public function __toString(): string
    {
        $expression = ($this->calcFoundRows ? 'SQL_CALC_FOUND_ROWS ' : '') . $this->expression;

        if (isset($this->tableAlias)) {
            $from = sprintf('`%s` AS `%s`', $this->table, $this->tableAlias);
        } else {
            $from = sprintf('`%s`', $this->table);
        }

        $limit = isset($this->limit) ? ' LIMIT '.$this->limit : '';
        $where = isset($this->where) ? ' WHERE ('.$this->where.')' : '';
        $having = isset($this->having) ? ' HAVING ('.$this->having.')' : '';
        $order = isset($this->order) ? ' ORDER BY '.$this->order : '';

        return sprintf('SELECT %s FROM %s %s %s %s %s', $expression, $from, $where, $having, $order, $limit);
    }
}