Muffin\Queries\Select

Complexity

Total Complexity

9

Size/Duplication

Total Lines	90
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	13

Test Coverage

Coverage

97.56%

Importance

Changes

0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	10	1
A	toString()	0	19	1
A	from()	0	6	1
A	select()	0	6	1
A	having()	0	6	1
A	buildSelect()	0	4	1
A	buildFrom()	0	9	2
A	buildHaving()	0	6	1

<?php

namespace Muffin\Queries;

use Muffin\Query;
use Muffin\Condition;
use Muffin\Traits\EscaperAware;
use Muffin\Snippet;
use Muffin\Queries\Snippets\Builders;
use Muffin\Queries\Snippets\Having;
use Muffin\QueryPartAware;

class Select implements Query, QueryPartAware
{
    use
        EscaperAware,
        Builders\Join,
        Builders\Where,
        Builders\GroupBy,
        Builders\OrderBy,
        Builders\Limit,
        Builders\QueryPart;

    private
        $select,
        $from,
        $having;

    public function __construct($columns = array())
    {
        $this->select = new Snippets\Select();
        $this->where = new Snippets\Where();
        $this->groupBy = new Snippets\GroupBy();
        $this->having = new Snippets\Having();
        $this->orderBy = new Snippets\OrderBy();

        $this->select->select($columns);
    }

    public function toString()
    {
        $snippets = $this->joins;
        $snippets[] = $this->from;
        $this->ensureNeededTablesArePresent($snippets);

        $queryParts = array(
            $this->buildSelect(),
            $this->buildFrom(),
            $this->buildJoin(),
            $this->buildWhere($this->escaper),
            $this->buildGroupBy(),
            $this->buildHaving(),
            $this->buildOrderBy(),
            $this->buildLimit(),
        );

        return implode(' ', array_filter($queryParts));
    }

    public function from($table, $alias = null)
    {
        $this->from = new Snippets\From($table, $alias);

        return $this;
    }

    public function select($columns)

Using PHP4-style constructors that are named like the class is not recommend; better use the more explicit __construct method.

    {
        $this->select->select($columns);

        return $this;
    }

    public function having(Condition $condition)
    {
        $this->having->having($condition);

        return $this;
    }

    private function buildSelect()
    {
        return $this->select->toString();
    }

    private function buildFrom()
    {
        if(!$this->from instanceof Snippet)
        {
            throw new \LogicException('No column for FROM clause');
        }

        return $this->from->toString();
    }

    private function buildHaving()
    {
        $this->having->setEscaper($this->escaper);

        return $this->having->toString();
    }
}