SQLiteGrammar::compileParentKeyOfFirstPathSegment() - Code Metrics - Inspection of "Support eager loading limits on Descendants relati..." - staudenmeir/eloquent-eager-limit-x-laravel-adjacency-list - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — main ( b3daef...4d79c5 )

by Jonas

created 2022-03-22 19:59 UTC

compileParentKeyOfFirstPathSegment() A

↳ Parent: SQLiteGrammar

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	5
CRAP Score	1

Importance

Changes

Metric	Value
eloc	4
c	0
b	0
f	0
dl	0
loc	7
ccs	5
cts	5
cp	1
rs	10
cc	1
nc	1
nop	3
crap	1

<?php

namespace Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Query\Grammars;

use Illuminate\Database\Query\Builder;
use Illuminate\Database\Query\Grammars\SQLiteGrammar as Base;

class SQLiteGrammar extends Base implements EagerLimitGrammar
{
    /**
     * Compile an extraction of the first path segment.
     *
     * @param string $pathColumn
     * @return string
     */
    public function compileFirstPathSegment(string $pathColumn): string
    {
        $pathColumn = $this->wrap($pathColumn);

        return "case when instr($pathColumn, ?) = 0 then $pathColumn else substr($pathColumn, 0, instr($pathColumn, ?)) end";
    }

    /**
     * Compile an extraction of the first path segment's parent key.
     *
     * @param string $pathColumn
     * @param string $parentKeyColumn
     * @param \Illuminate\Database\Query\Builder $parentKeyQuery
     * @return string
     */
    public function compileParentKeyOfFirstPathSegment(string $pathColumn, string $parentKeyColumn, Builder $parentKeyQuery): string
    {
        $column          = $this->wrap($pathColumn);
        $parentKeyColumn = $this->wrap($parentKeyColumn);
        $sql             = $parentKeyQuery->toSql();

        return "case when instr($column, ?) = 0 then $parentKeyColumn else ($sql) end";
    }
}


1		<?php
2
3		namespace Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Query\Grammars;
4
5		use Illuminate\Database\Query\Builder;
6		use Illuminate\Database\Query\Grammars\SQLiteGrammar as Base;
7
8		class SQLiteGrammar extends Base implements EagerLimitGrammar
9		{
10		/**
11		* Compile an extraction of the first path segment.
12		*
13		* @param string $pathColumn
14		* @return string
15		*/
16	10	public function compileFirstPathSegment(string $pathColumn): string
17		{
18	10	$pathColumn = $this->wrap($pathColumn);
19
20	10	return "case when instr($pathColumn, ?) = 0 then $pathColumn else substr($pathColumn, 0, instr($pathColumn, ?)) end";
21		}
22
23		/**
24		* Compile an extraction of the first path segment's parent key.
25		*
26		* @param string $pathColumn
27		* @param string $parentKeyColumn
28		* @param \Illuminate\Database\Query\Builder $parentKeyQuery
29		* @return string
30		*/
31	2	public function compileParentKeyOfFirstPathSegment(string $pathColumn, string $parentKeyColumn, Builder $parentKeyQuery): string
32		{
33	2	$column = $this->wrap($pathColumn);
34	2	$parentKeyColumn = $this->wrap($parentKeyColumn);
35	2	$sql = $parentKeyQuery->toSql();
36
37	2	return "case when instr($column, ?) = 0 then $parentKeyColumn else ($sql) end";
38		}
39		}
40

staudenmeir / eloquent-eager-limit-x-laravel-adjacency-list

Push — main ( b3daef...4d79c5 )

compileParentKeyOfFirstPathSegment() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like