Muffin\Queries\Snippets\Select

Complexity

Total Complexity

14

Size/Duplication

Total Lines	76
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	0

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	1

7 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	6	1
A	select()	0	6	1
A	toString()	0	9	2
A	buildColumnsString()	0	16	3
A	addColumns()	0	8	1
A	validateColumns()	0	10	4
A	ensureIsArray()	0	9	2

<?php

namespace Muffin\Queries\Snippets;

use Muffin\Snippet;

class Select implements Snippet
{
    private
        $columns;

    public function __construct($columns = array())
    {
        $this->columns = array();

        $this->addColumns($columns);
    }

    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->addColumns($columns);

        return $this;
    }

    public function toString()
    {
        if(empty($this->columns))
        {
            throw new \LogicException('No columns defined for SELECT clause');
        }

        return sprintf('SELECT %s', $this->buildColumnsString());
    }

    private function buildColumnsString()
    {
        $columns = array();

        foreach($this->columns as $column)
        {
            if($column instanceof Selectable)
            {
                $column = $column->toString();
            }

            $columns[] = $column;
        }

        return implode(', ', array_unique($columns));
    }

    private function addColumns($columns)
    {
        $columns = array_filter($this->ensureIsArray($columns));

        $this->validateColumns($columns);

        $this->columns = array_merge($this->columns, $columns);
    }

    private function validateColumns($columns)
    {
        foreach($columns as $column)
        {
            if(! is_string($column) && (!$column instanceof Selectable))
            {
                throw new \InvalidArgumentException('Column name must be a string.');
            }
        }
    }

    private function ensureIsArray($select)
    {
        if(! is_array($select))
        {
            $select = array($select);
        }

        return $select;
    }
}