Staudenmeir\LaravelAdjacencyList\Query\Grammars\FirebirdGrammar

Complexity

Total Complexity

12

Size/Duplication

Total Lines	73
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

11 Methods

Rating	Name	Duplication	Size	Complexity
A	selectPathList()	0	5	1
A	compileInitialPath()	0	3	1
A	compileRecursivePath()	0	7	2
A	getRecursivePathBindings()	0	3	1
A	getCycleDetectionBindings()	0	3	1
A	compileCycleDetection()	0	6	1
A	compileCycleDetectionRecursiveSelect()	0	3	1
A	compilePivotColumnNullValue()	0	3	1
A	compileCycleDetectionInitialSelect()	0	3	1
A	supportsUnionInRecursiveExpression()	0	3	1
A	compileCycleDetectionStopConstraint()	0	3	1

<?php

namespace Staudenmeir\LaravelAdjacencyList\Query\Grammars;

use HarryGulliford\Firebird\Query\Grammars\FirebirdGrammar as Base;

The type HarryGulliford\Firebird\Query\Grammars\FirebirdGrammar was not found. Maybe you did not declare it correctly or list all dependencies?

use Illuminate\Database\Query\Builder;
use RuntimeException;

class FirebirdGrammar extends Base implements ExpressionGrammar
{
    use OrdersByPath;

    public function compileInitialPath($column, $alias)
    {
        return 'cast(' . $this->wrap($column) . ' as varchar(8191)) as ' . $this->wrap($alias);
    }

    public function compileRecursivePath($column, $alias, bool $reverse = false)
    {
        $wrappedColumn = $this->wrap($column);
        $wrappedAlias = $this->wrap($alias);
        $placeholder = 'cast(? as varchar(8191))';

        return $reverse ? "($wrappedColumn || $placeholder || $wrappedAlias)" : "($wrappedAlias || $placeholder || $wrappedColumn)";
    }

    public function getRecursivePathBindings($separator)
    {
        return [$separator];
    }

    public function selectPathList(Builder $query, $expression, $column, $pathSeparator, $listSeparator)
    {
        return $query->selectRaw(
            'list(' . $this->wrap($column) . ", '$listSeparator')"
        )->from($expression);
    }

    /**
     * Compile a pivot column null value.
     *
     * @param string $typeName
     * @param string $type
     * @return string
     */
    public function compilePivotColumnNullValue(string $typeName, string $type): string
    {
        throw new RuntimeException('This graph relationship feature is not supported on Firebird.'); // @codeCoverageIgnore
    }

    public function compileCycleDetection(string $localKey, string $path): string
    {
        $localKey = $this->wrap($localKey);
        $path = $this->wrap($path);

        return "position($localKey || ?, $path) > 0 or position(? || $localKey || ?, $path) > 0";
    }

    public function getCycleDetectionBindings(string $pathSeparator): array
    {
        return [$pathSeparator, $pathSeparator, $pathSeparator];
    }

    public function compileCycleDetectionInitialSelect(string $column): string
    {
        return 'false as ' . $this->wrap($column);
    }

    public function compileCycleDetectionRecursiveSelect(string $sql, string $column): string
    {
        return $sql;
    }

    public function compileCycleDetectionStopConstraint(string $column): string
    {
        return 'not ' . $this->wrap($column);
    }

    public function supportsUnionInRecursiveExpression(): bool
    {
        return false;
    }
}