Valkyrja\Orm\QueryBuilder\SqlSelectQueryBuilder

Complexity

Total Complexity

22

Size/Duplication

Total Lines	182
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

14 Methods

Rating	Name	Duplication	Size	Complexity
A	getOrderByQuery()	0	5	3
A	getGroupByQuery()	0	5	3
A	getOffsetQuery()	0	5	3
A	getLimitQuery()	0	5	3
A	isCount()	0	3	1
A	__toString()	0	12	1
A	withAddedGroupBy()	0	7	1
A	withAddedColumns()	0	7	1
A	withColumns()	0	7	1
A	withGroupBy()	0	7	1
A	withOffset()	0	7	1
A	withOrderBy()	0	7	1
A	withAddedOrderBy()	0	7	1
A	withLimit()	0	7	1

<?php

declare(strict_types=1);

/*
 * This file is part of the Valkyrja Framework package.
 *
 * (c) Melech Mizrachi <melechmizrachi@gmail.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace Valkyrja\Orm\QueryBuilder;

use Valkyrja\Orm\Constant\Statement;

The type Valkyrja\Orm\Constant\Statement was not found. Maybe you did not declare it correctly or list all dependencies?

use Valkyrja\Orm\Data\OrderBy;
use Valkyrja\Orm\QueryBuilder\Contract\SelectQueryBuilder as Contract;

/**
 * Class SqlSelectQueryBuilder.
 *
 * @author Melech Mizrachi
 */
class SqlSelectQueryBuilder extends SqlQueryBuilder implements Contract
{
    /** @var non-empty-string[] */

The doc comment non-empty-string[] at position 0 could not be parsed: Unknown type name 'non-empty-string' at position 0 in non-empty-string[].

    protected array $columns = ['*'];
    /** @var string[] */
    protected array $groupBy = [];
    /** @var OrderBy[] */
    protected array $orderBy = [];
    /** @var int|null */
    protected int|null $limit = null;
    /** @var int|null */
    protected int|null $offset = null;

    /**
     * @inheritDoc
     */
    public function withColumns(string ...$columns): static
    {
        $new = clone $this;

        $new->columns = $columns;

        return $new;
    }

    /**
     * @inheritDoc
     */
    public function withAddedColumns(string ...$columns): static
    {
        $new = clone $this;

        $new->columns = array_merge($new->columns, $columns);

        return $new;
    }

    /**
     * @inheritDoc
     */
    public function withGroupBy(string ...$groupBy): static
    {
        $new = clone $this;

        $new->groupBy = $groupBy;

        return $new;
    }

    /**
     * @inheritDoc
     */
    public function withAddedGroupBy(string ...$groupBy): static
    {
        $new = clone $this;

        $new->groupBy = array_merge($new->groupBy, $groupBy);

        return $new;
    }

    /**
     * @inheritDoc
     */
    public function withOrderBy(OrderBy ...$orderBy): static
    {
        $new = clone $this;

        $new->orderBy = $orderBy;

        return $new;
    }

    /**
     * @inheritDoc
     */
    public function withAddedOrderBy(OrderBy ...$orderBy): static
    {
        $new = clone $this;

        $new->orderBy = array_merge($new->orderBy, $orderBy);

        return $new;
    }

    /**
     * @inheritDoc
     */
    public function withLimit(int $limit): static
    {
        $new = clone $this;

        $new->limit = $limit;

        return $new;
    }

    /**
     * @inheritDoc
     */
    public function withOffset(int $offset): static
    {
        $new = clone $this;

        $new->offset = $offset;

        return $new;
    }

    /**
     * @inheritDoc
     */
    public function __toString(): string
    {
        return Statement::SELECT
            . ' ' . implode(', ', $this->columns)
            . ' ' . Statement::FROM
            . " $this->from"
            . $this->getJoinQuery()
            . $this->getWhereQuery()
            . $this->getGroupByQuery()
            . $this->getOrderByQuery()
            . $this->getLimitQuery()
            . $this->getOffsetQuery();
    }

    /**
     * Get the GROUP BY part of a query statement.
     *
     * @return string
     */
    protected function getGroupByQuery(): string
    {
        return empty($this->orderBy) || $this->isCount()
            ? ''
            : ' ' . Statement::GROUP_BY . ' ' . implode(', ', $this->groupBy);
    }

    /**
     * Get the ORDER BY part of a query statement.
     *
     * @return string
     */
    protected function getOrderByQuery(): string
    {
        return empty($this->orderBy) || $this->isCount()
            ? ''
            : ' ' . Statement::ORDER_BY . ' ' . implode(', ', $this->orderBy);
    }

    /**
     * Get the LIMIT part of a query statement.
     *
     * @return string
     */
    protected function getLimitQuery(): string
    {
        return $this->limit === null || $this->isCount()
            ? ''
            : ' ' . Statement::LIMIT . ' ' . ((string) $this->limit);
    }

    /**
     * Get the OFFSET part of a query statement.
     *
     * @return string
     */
    protected function getOffsetQuery(): string
    {
        return $this->offset === null || $this->isCount()
            ? ''
            : ' ' . Statement::OFFSET . ' ' . ((string) $this->offset);
    }

    /**
     * Determine whether this is a count statement.
     *
     * @return bool
     */
    protected function isCount(): bool
    {
        return str_starts_with($this->columns[0], 'COUNT');
    }
}