Phuria\QueryBuilder\QueryCompiler\SelectQueryCompiler

Complexity

Total Complexity

10

Size/Duplication

Total Lines	65
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Test Coverage

Coverage

100%

Importance

Changes	5
Bugs	0	Features	3

2 Methods

Rating	Name	Duplication	Size	Complexity
A	canHandleQuery()	0	4	1
D	compile()	0	51	9

<?php

namespace Phuria\QueryBuilder\QueryCompiler;

use Phuria\QueryBuilder\Compiler\SeparatedListCompiler;
use Phuria\QueryBuilder\QueryBuilder;

/**
 * @author Beniamin Jonatan Šimko <spam@simko.it>
 */
class SelectQueryCompiler implements QueryCompilerInterface
{
    /**
     * @inheritdoc
     */
    public function canHandleQuery(QueryBuilder $qb)
    {
        return (bool) $qb->getSelectClauses();
    }

    /**
     * @inheritdoc
     */
    public function compile(QueryBuilder $qb)
    {
        $commaSeparated = new SeparatedListCompiler(', ');
        $andSeparated = new SeparatedListCompiler(' AND ');
        $spaceSeparated = new SeparatedListCompiler(' ');

        $select = $commaSeparated->compile($qb->getSelectClauses());
        $afterSelectHints = $spaceSeparated->compile($qb->getHints());
        $where = $andSeparated->compile($qb->getWhereClauses());
        $from = $commaSeparated->compile($qb->getRootTables());
        $join = $spaceSeparated->compile($qb->getJoinTables());
        $orderBy = $commaSeparated->compile($qb->getOrderByClauses());
        $groupBy = $commaSeparated->compile($qb->getGroupByClauses());
        $having = $andSeparated->compile($qb->getHavingClauses());

        $sql = "SELECT";

        if ($afterSelectHints) {
            $sql .= ' ' . $afterSelectHints;
        }

        if ($select) {
            $sql .= ' ' . $select;
        }

        if ($from) {
            $sql .= ' FROM ' . $from;
        }

        if ($join) {
            $sql .= ' ' . $join;
        }

        if ($where) {
            $sql .= ' WHERE ' . $where;
        }

        if ($groupBy) {
            $sql .= ' GROUP BY ' . $groupBy;
        }

        if ($having) {
            $sql .= ' HAVING ' . $having;
        }

        if ($orderBy) {
            $sql .= ' ORDER BY ' . $orderBy;
        }

        return $sql;
    }
}