Repo2\QueryBuilder\Query\InsertQuery

Complexity

Total Complexity

13

Size/Duplication

Total Lines	93
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Test Coverage

Coverage

100%

Importance

Changes	5
Bugs	2	Features	2

6 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	7	2
A	init()	0	5	1
A	pipe()	0	16	4
A	compileValues()	0	8	2
A	compileFields()	0	11	3
A	compile()	0	5	1

<?php

/**
 * The MIT License (MIT)
 *
 * Copyright (c) 2015 Repo2
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all
 * copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
 * SOFTWARE.
 */

namespace Repo2\QueryBuilder\Query;

use Repo2\QueryBuilder\DriverInterface;
use Repo2\QueryBuilder\Exception\CompileException;
use Repo2\QueryBuilder\Expression\Reference;
use Repo2\QueryBuilder\ExpressionInterface;
use Repo2\QueryBuilder\ExpressionBag;

class InsertQuery implements ExpressionInterface
{
    /** @var Reference */
    private $table;

    /** @var array<integer,string> */
    private $fields;

    /** @var array */
    private $values;

    /**
     * @param Reference $table
     * @param array<string,integer|string> $firstRow
     */
    public function __construct(Reference $table, array $firstRow = [])
    {
        $this->table = $table;
        if (!empty($firstRow)) {
            $this->init($firstRow);
        }
    }

    /**
     * @param array<string,integer|string> $firstRow
     */
    private function init(array $firstRow)
    {
        $this->fields = array_keys($firstRow);
        $this->values = [array_values($firstRow)];
    }

    /**
     * @param array<string,integer|string> $row
     * @return $this
     * @throws \InvalidArgumentException
     */
    public function pipe(array $row)
    {
        if (empty($this->fields)) {
            $this->init($row);
        } else {
            $values = [];
            foreach ($this->fields as $index => $name) {
                if (!array_key_exists($name, $row)) {
                    throw new \InvalidArgumentException(sprintf('The field "%s" is not found in the row.', $name));
                }
                $values[$index] = $row[$name];
            }
            $this->values[] = $values;
        }
        return $this;
    }

    /**
     * @param DriverInterface $driver
     * @return string
     */
    private function compileValues(DriverInterface $driver)
    {
        $rows = [];
        foreach ($this->values as $values) {
            $rows[] = '"'. implode('", "', $driver->escapeValues($values)) . '"';
        }
        return '(' . implode('), (', $rows) . ')';
    }

    /**
     * @param DriverInterface $driver
     * @return string
     * @throws CompileException
     */
    private function compileFields(DriverInterface $driver)
    {
        if (empty($this->fields)) {
            throw new CompileException('No fields found for insert query.');
        }
        $fields = new ExpressionBag();
        foreach ($this->fields as $field) {
            $fields->add(new Reference($field));
        }
        return $fields->concat($driver, ', ');
    }

    /**
     * @inheritDoc
     */
    public function compile(DriverInterface $driver)
    {
        return 'INSERT INTO ' . $this->table->compile($driver)
            . '(' .  $this->compileFields($driver) . ') VALUES ' . $this->compileValues($driver);
    }
}