JAQB\Statement\UnionStatement

Complexity

Total Complexity

5

Size/Duplication

Total Lines	57
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes	3
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	addQuery()	0	6	1
A	getQueries()	0	4	1
B	build()	0	24	3

<?php

/**
 * @author Jared King <j@jaredtking.com>
 *
 * @link http://jaredtking.com
 *
 * @copyright 2015 Jared King
 * @license MIT
 */
namespace JAQB\Statement;

use JAQB\Query\SelectQuery;

class UnionStatement extends Statement
{
    /**
     * @var array
     */
    protected $queries = [];

    /**
     * Adds a query to the statement.
     *
     * @param SelectQuery  $query
     * @param string|false $type
     *
     * @return self
     */
    public function addQuery(SelectQuery $query, $type = false)
    {
        $this->queries[] = [$query, $type];

        return $this;
    }

    /**
     * Gets the queries for this statement.
     *
     * @return array
     */
    public function getQueries()
    {
        return $this->queries;
    }

    public function build()
    {
        // reset the parameterized values
        $this->values = [];

        // build each select query and concatenate
        $queries = [];
        foreach ($this->queries as $row) {
            list($query, $type) = $row;

            $prefix = 'UNION ';
            if ($type) {
                $prefix .= $type.' ';
            }

            $queries[] = $prefix.$query->build();

            $this->values = array_merge(
                $this->values,
                $query->getValues());
        }

        return implode(' ', $queries);
    }
}