Staudenmeir\LaravelCte\Query\Grammars\SQLiteGrammar

Complexity

Total Complexity

14

Size/Duplication

Total Lines	74
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	getBindingsForUpdate()	0	7	3
A	compileUpdate()	0	7	3
A	compileDelete()	0	7	3
A	compileUnion()	0	13	5

<?php

namespace Staudenmeir\LaravelCte\Query\Grammars;

use Illuminate\Database\Query\Builder;
use Illuminate\Database\Query\Grammars\SQLiteGrammar as Base;
use Staudenmeir\LaravelCte\Query\Builder as CteBuilder;

class SQLiteGrammar extends Base
{
    use CompilesExpressions {

The trait Staudenmeir\LaravelCte\Query\Grammars\CompilesExpressions requires some properties which are not provided by Staudenmeir\LaravelCte\Query\Grammars\SQLiteGrammar: $unionExpressions, $expressions, $recursionLimit, $unionRecursionLimit

        compileUpdate as compileUpdateTrait;
        compileDelete as compileDeleteTrait;
    }

    /**
     * Compile a single union statement.
     *
     * @param array $union
     * @return string
     */
    protected function compileUnion(array $union)
    {
        $backtrace = debug_backtrace(DEBUG_BACKTRACE_IGNORE_ARGS, 9);

        for ($i = 6; $i <= 8; $i++) {
            if (($backtrace[$i]['class'] === CteBuilder::class && $backtrace[$i]['function'] === 'withExpression')) {
                $conjunction = $union['all'] ? ' union all ' : ' union ';

                return $conjunction.$union['query']->toSql();
            }
        }

        return parent::compileUnion($union);
    }

    /**
     * Compile an update statement into SQL.
     *
     * @param \Illuminate\Database\Query\Builder $query
     * @param array $values
     * @return string
     */
    public function compileUpdate(Builder $query, array $values)
    {
        if (isset($query->joins) || isset($query->limit)) {
            return parent::compileUpdate($query, $values);
        }

        return $this->compileUpdateTrait($query, $values);
    }

    /**
     * Get the bindings for an update statement.
     *
     * @param \Illuminate\Database\Query\Builder $query
     * @param array $bindings
     * @param array $values
     * @return array
     */
    public function getBindingsForUpdate(Builder $query, array $bindings, array $values)
    {
        if (isset($query->joins) || isset($query->limit)) {
            return parent::prepareBindingsForUpdate($bindings, $values);
        }

        return $this->prepareBindingsForUpdate($bindings, $values);
    }

    /**
     * Compile a delete statement into SQL.
     *
     * @param \Illuminate\Database\Query\Builder $query
     * @return string
     */
    public function compileDelete(Builder $query)
    {
        if (isset($query->joins) || isset($query->limit)) {
            return parent::compileDelete($query);
        }

        return $this->compileDeleteTrait($query);
    }
}