ArekX\PQL\Drivers\Pdo\MySql\Builders\InsertBuilder

Complexity

Total Complexity

14

Size/Duplication

Total Lines	118
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes

0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	getRequiredParts()	0	3	1
A	buildValues()	0	13	3
A	getInitialParts()	0	3	1
A	buildColumns()	0	13	3
A	buildInto()	0	7	2
A	buildValueItems()	0	9	2
A	getLastParts()	0	3	1
A	getPartBuilders()	0	6	1

<?php
/**
 * Copyright 2021 Aleksandar Panic
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

namespace ArekX\PQL\Drivers\Pdo\MySql\Builders;

use ArekX\PQL\Contracts\StructuredQuery;
use ArekX\PQL\Drivers\Pdo\MySql\Builders\Traits\QuoteNameTrait;
use ArekX\PQL\Drivers\Pdo\MySql\Builders\Traits\SubQueryTrait;
use ArekX\PQL\Drivers\Pdo\MySql\Builders\Traits\WrapValueTrait;
use ArekX\PQL\Drivers\Pdo\MySql\MySqlQueryBuilderState;
use ArekX\PQL\Sql\Query\Insert;

/**
 * Represents a query builder for building an INSERT query
 *
 * @see Insert
 */
class InsertBuilder extends QueryPartBuilder
{
    use QuoteNameTrait;
    use WrapValueTrait;
    use SubQueryTrait;

    /**
     * @inheritDoc
     */
    protected function getInitialParts(): array
    {
        return ['INSERT'];
    }

    /**
     * @inheritDoc
     */
    protected function getRequiredParts(): array
    {
        return ['into', 'values'];
    }

    /**
     * @inheritDoc
     */
    protected function getPartBuilders(): array
    {
        return [
            'into' => fn($part, $state) => $this->buildInto($part, $state),
            'columns' => fn($part, $state) => $this->buildColumns($part, $state),
            'values' => fn($part, $state) => $this->buildValueItems($part, $state),
        ];
    }

    /**
     * Build INTO part.
     *
     * @param StructuredQuery|string $part Table name into the data to be inserted
     * @param MySqlQueryBuilderState $state Query builder state
     * @return string
     */
    protected function buildInto($part, $state)
    {
        if ($part instanceof StructuredQuery) {
            return 'INTO ' . $this->buildQuery($part, $state);
        }

        return 'INTO ' . $this->quoteName($part);
    }

    /**
     * Build specific columns which will be inserted.
     *
     * @param array|StructuredQuery $columns Columns to be inserted
     * @param MySqlQueryBuilderState $state Query builder state
     * @return string
     */
    protected function buildColumns(StructuredQuery|array $columns, MySqlQueryBuilderState $state): string
    {
        if ($columns instanceof StructuredQuery) {
            return $this->buildQuery($columns, $state);
        }

        $result = [];

        foreach ($columns as $column) {
            $result[] = $this->quoteName($column);
        }

        return '(' . implode(', ', $result) . ')';
    }

    /**
     * Build multiple value items.
     *
     * @param array $valuesList List of values
     * @param MySqlQueryBuilderState $state Query builder state
     * @return string
     */
    protected function buildValueItems(array $valuesList, MySqlQueryBuilderState $state): string
    {
        $results = [];

        foreach ($valuesList as $values) {
            $results[] = $this->buildValues($values, $state);
        }

        return 'VALUES ' . implode(' ', $results);
    }

    /**
     * Build specific values which will be inserted.
     *
     * @param array|StructuredQuery $values Values to be inserted
     * @param MySqlQueryBuilderState $state Query builder state
     * @return string
     */
    protected function buildValues(StructuredQuery|array $values, MySqlQueryBuilderState $state): string
    {
        if ($values instanceof StructuredQuery) {
            return $this->buildQuery($values, $state);
        }

        $result = [];

        foreach ($values as $value) {
            $result[] = $this->buildWrapValue($value, $state);
        }

        return '(' . implode(', ', $result) . ')';
    }

    /**
     * @inheritDoc
     */
    protected function getLastParts(): array
    {
        return [];
    }
}