ArekX\PQL\Drivers\MySql\Builder\Builders\SelectBuilder

Complexity

Total Complexity

13

Size/Duplication

Total Lines	107
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	buildGroupBy()	0	12	3
A	getLastParts()	0	3	1
A	buildHaving()	0	3	1
A	getInitialParts()	0	3	1
A	buildOrderBy()	0	16	5
A	getRequiredParts()	0	3	1
A	getPartBuilders()	0	12	1

<?php
/**
 * Copyright 2021 Aleksandar Panic
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

namespace ArekX\PQL\Drivers\MySql\Builder\Builders;

use ArekX\PQL\Contracts\StructuredQuery;
use ArekX\PQL\Drivers\MySql\Builder\Builders\Traits\AliasTrait;
use ArekX\PQL\Drivers\MySql\Builder\Builders\Traits\FromPartTrait;
use ArekX\PQL\Drivers\MySql\Builder\Builders\Traits\JoinTrait;
use ArekX\PQL\Drivers\MySql\Builder\Builders\Traits\NumberPartTrait;
use ArekX\PQL\Drivers\MySql\Builder\Builders\Traits\WhereTrait;
use ArekX\PQL\Drivers\MySql\Builder\MySqlQueryBuilderState;
use ArekX\PQL\Sql\Query\Select;

/**
 * Represents a query builder for building a SELECT query.
 *
 * @see Select
 */
class SelectBuilder extends QueryPartBuilder
{
    use AliasTrait;
    use FromPartTrait;
    use WhereTrait;
    use NumberPartTrait;
    use JoinTrait;

    /**
     * @inheritDoc
     */
    protected function getInitialParts(): array
    {
        return ['SELECT'];
    }

    /**
     * @inheritDoc
     */
    protected function getRequiredParts(): array
    {
        return [];
    }

    /**
     * @inheritDoc
     */
    protected function getPartBuilders(): array
    {
        return [
            'columns' => fn($part, $state) => $this->buildAliasedNames($part, $state),
            'from' => fn($part, $state) => $this->buildFrom($part, $state),
            'join' => fn($part, $state) => $this->buildJoin($part, $state),
            'where' => fn($part, $state) => $this->buildWhere($part, $state),
            'groupBy' => fn($part, $state) => $this->buildGroupBy($part, $state),
            'having' => fn($part, $state) => $this->buildHaving($part, $state),
            'orderBy' => fn($part, $state) => $this->buildOrderBy($part, $state),
            'limit' => fn($part) => $this->buildLimit($part),
            'offset' => fn($part) => $this->buildOffset($part),
        ];
    }

    /**
     * Build GROUP BY part
     *
     * @param array|StructuredQuery $groupBy Part to be build
     * @param MySqlQueryBuilderState $state Query builder state
     * @return string
     */
    protected function buildGroupBy($groupBy, MySqlQueryBuilderState $state)
    {
        if ($groupBy instanceof StructuredQuery) {
            return 'GROUP BY ' . $this->buildQuery($groupBy, $state);
        }

        $result = [];
        foreach ($groupBy as $name) {
            $result[] = $this->quoteName($name);
        }

        return 'GROUP BY ' . implode(', ', $result);
    }

    /**
     * Build HAVING part
     *
     * @param array|StructuredQuery $condition Condition to be built.
     * @param MySqlQueryBuilderState $state Query builder state
     * @return string
     * @throws \Exception
     */
    protected function buildHaving($condition, MySqlQueryBuilderState $state)
    {
        return 'HAVING ' . $this->buildCondition($condition, $state);
    }

    /**
     * Build ORDER BY part
     *
     * @param array|StructuredQuery $orders Part to be built
     * @param MySqlQueryBuilderState $state Query builder state
     * @return string
     */
    protected function buildOrderBy($orders, $state)
    {
        if ($orders instanceof StructuredQuery) {
            return 'ORDER BY '. $this->buildQuery($orders, $state);
        }

        $result = [];
        foreach ($orders as $by => $order) {
            if (!is_string($order)) {
                $order = $order === SORT_ASC ? 'asc' : 'desc';
            }

            $result[] = $this->quoteName($by) . ' ' . strtoupper($order);
        }

        return 'ORDER BY ' . implode(', ', $result);
    }

    /**
     * @inheritDoc
     */
    protected function getLastParts(): array
    {
        return [];
    }
}