MySqlGrammar::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

MySqlGrammar::compileParentKeyOfFirstPathSegment() A

↳ Parent: MySqlGrammar

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\MySqlGrammar as Base;

class MySqlGrammar 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 "substring_index($pathColumn, ?, 1)";
    }

    /**
     * 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 "if(instr($column, ?) = 0, $parentKeyColumn, ($sql))";
    }
}


1		<?php
2
3		namespace Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Query\Grammars;
4
5		use Illuminate\Database\Query\Builder;
6		use Illuminate\Database\Query\Grammars\MySqlGrammar as Base;
7
8		class MySqlGrammar 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	20	public function compileFirstPathSegment(string $pathColumn): string
17		{
18	20	$pathColumn = $this->wrap($pathColumn);
19
20	20	return "substring_index($pathColumn, ?, 1)";
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	4	public function compileParentKeyOfFirstPathSegment(string $pathColumn, string $parentKeyColumn, Builder $parentKeyQuery): string
32		{
33	4	$column = $this->wrap($pathColumn);
34	4	$parentKeyColumn = $this->wrap($parentKeyColumn);
35	4	$sql = $parentKeyQuery->toSql();
36
37	4	return "if(instr($column, ?) = 0, $parentKeyColumn, ($sql))";
38		}
39		}
40

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

Push — main ( b3daef...4d79c5 )

MySqlGrammar::compileParentKeyOfFirstPathSegment() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like