MariaDbGrammar::compileOrderByPath() - Code Metrics - staudenmeir/laravel-adjacency-list - Measure and Improve Code Quality continuously with Scrutinizer

MariaDbGrammar::compileOrderByPath() A
last analyzed 2024-07-13 19:17 UTC

↳ Parent: MariaDbGrammar

Complexity

Conditions	2
Paths	2

Size

Total Lines	22
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	11
CRAP Score	2

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	13
c	1
b	0
f	0
dl	0
loc	22
ccs	11
cts	11
cp	1
rs	9.8333
cc	2
nc	2
nop	0
crap	2

<?php

namespace Staudenmeir\LaravelAdjacencyList\Query\Grammars;

use Illuminate\Database\Query\Grammars\MariaDbGrammar as Base;
use Staudenmeir\LaravelAdjacencyList\Query\Grammars\Traits\CompilesMySqlAdjacencyLists;

class MariaDbGrammar extends Base implements ExpressionGrammar
{
    use CompilesMySqlAdjacencyLists;

    /**
     * Compile an "order by path" clause.
     *
     * @return string
     */
    public function compileOrderByPath()
    {
        $column = $this->model->getLocalKeyName();

        $path = $this->wrap(
            $this->model->getPathName()
        );

        $pathSeparator = $this->model->getPathSeparator();

        if (!$this->model->isIntegerAttribute($column)) {
            return "$path asc";
        }

        return <<<SQL
regexp_replace(
    regexp_replace(
        $path,
        '(^|[$pathSeparator])(\\\\d+)',
        '\\\\100000000000000000000\\\\2'
    ),
    '0+(\\\\d\{20\})([$pathSeparator]|$)',
    '\\\\1\\\\2'
) asc
SQL;
    }
}


1		<?php
2
3		namespace Staudenmeir\LaravelAdjacencyList\Query\Grammars;
4
5		use Illuminate\Database\Query\Grammars\MariaDbGrammar as Base;
6		use Staudenmeir\LaravelAdjacencyList\Query\Grammars\Traits\CompilesMySqlAdjacencyLists;
7
8		class MariaDbGrammar extends Base implements ExpressionGrammar
9		{
10		use CompilesMySqlAdjacencyLists;
11
12	5	/**
13		* Compile an "order by path" clause.
14	5	*
15		* @return string
16	5	*/
17	5	public function compileOrderByPath()
18	5	{
19		$column = $this->model->getLocalKeyName();
20	5
21		$path = $this->wrap(
22	5	$this->model->getPathName()
23	1	);
24
25		$pathSeparator = $this->model->getPathSeparator();
26	4
27	4	if (!$this->model->isIntegerAttribute($column)) {
28		return "$path asc";
29	4	}
30	4
31		return <<<SQL
32		regexp_replace(
33	4	regexp_replace(
34		$path,
35		'(^\|[$pathSeparator])(\\\\d+)',
36	4	'\\\\100000000000000000000\\\\2'
37		),
38		'0+(\\\\d\{20\})([$pathSeparator]\|$)',
39		'\\\\1\\\\2'
40		) asc
41		SQL;
42		}
43		}
44

staudenmeir / laravel-adjacency-list

MariaDbGrammar::compileOrderByPath() A last analyzed 2024-07-13 19:17 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

MariaDbGrammar::compileOrderByPath() A
last analyzed 2024-07-13 19:17 UTC