HasEagerLimit::addGroupLimit() - Code Metrics - staudenmeir/eloquent-eager-limit-x-laravel-adjacency-list - Measure and Improve Code Quality continuously with Scrutinizer

HasEagerLimit::addGroupLimit() A
last analyzed 2024-03-09 13:08 UTC

↳ Parent: HasEagerLimit

Complexity

Conditions	1
Paths	1

Size

Total Lines	21
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	16
CRAP Score	1

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	11
c	1
b	0
f	0
dl	0
loc	21
ccs	16
cts	16
cp	1
rs	9.9
cc	1
nc	1
nop	1
crap	1

<?php

namespace Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Eloquent\Relations\Traits;

use Illuminate\Database\Query\Expression;
use RuntimeException;
use Staudenmeir\EloquentEagerLimit\Relations\HasLimit;
use Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Query\Grammars\EagerLimitGrammar;
use Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Query\Grammars\MySqlGrammar;
use Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Query\Grammars\PostgresGrammar;
use Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Query\Grammars\SQLiteGrammar;

trait HasEagerLimit
{
    use HasLimit;

    /**
     * Add group limit.
     *
     * @param int $value
     * @return void
     */
    protected function addGroupLimit(int $value): void
    {
        $grammar = $this->getEagerLimitGrammar();

        $sql = $grammar->compileFirstPathSegment(
            $this->related->qualifyColumn(
                $this->related->getPathName()
            )
        );

        $column = new Expression($sql);

        $this->query->groupLimit($value, $column);

        $this->query->getQuery()->addBinding(
            array_fill(
                0,
                substr_count($sql, '?'),
                $this->related->getPathSeparator()
            ),
            'select'
        );
    }

    /**
     * Get the eager limit grammar.
     *
     * @return \Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Query\Grammars\EagerLimitGrammar
     */
    protected function getEagerLimitGrammar(): EagerLimitGrammar
    {
        $connection = $this->query->getQuery()->getConnection();
        $driver = $connection->getDriverName();

        switch ($driver) {
            case 'mysql':
                return $connection->withTablePrefix(
                    new MySqlGrammar()
                );
            case 'pgsql':
                return $connection->withTablePrefix(
                    new PostgresGrammar()
                );
            case 'sqlite':
                return $connection->withTablePrefix(
                    new SQLiteGrammar()
                );
        }

        throw new RuntimeException('This database is not supported.'); // @codeCoverageIgnore
    }
}


1		<?php
2
3		namespace Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Eloquent\Relations\Traits;
4
5		use Illuminate\Database\Query\Expression;
6		use RuntimeException;
7		use Staudenmeir\EloquentEagerLimit\Relations\HasLimit;
8		use Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Query\Grammars\EagerLimitGrammar;
9		use Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Query\Grammars\MySqlGrammar;
10		use Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Query\Grammars\PostgresGrammar;
11		use Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Query\Grammars\SQLiteGrammar;
12
13		trait HasEagerLimit
14		{
15		use HasLimit;
16
17		/**
18		* Add group limit.
19		*
20		* @param int $value
21		* @return void
22		*/
23	32	protected function addGroupLimit(int $value): void
24		{
25	32	$grammar = $this->getEagerLimitGrammar();
26
27	32	$sql = $grammar->compileFirstPathSegment(
28	32	$this->related->qualifyColumn(
29	32	$this->related->getPathName()
30	32	)
31	32	);
32
33	32	$column = new Expression($sql);
34
35	32	$this->query->groupLimit($value, $column);
36
37	32	$this->query->getQuery()->addBinding(
38	32	array_fill(
39	32	0,
40	32	substr_count($sql, '?'),
41	32	$this->related->getPathSeparator()
42	32	),
43	32	'select'
44	32	);
45		}
46
47		/**
48		* Get the eager limit grammar.
49		*
50		* @return \Staudenmeir\EloquentEagerLimitXLaravelAdjacencyList\Query\Grammars\EagerLimitGrammar
51		*/
52	40	protected function getEagerLimitGrammar(): EagerLimitGrammar
53		{
54	40	$connection = $this->query->getQuery()->getConnection();
55	40	$driver = $connection->getDriverName();
56
57		switch ($driver) {
58	40	case 'mysql':
59	20	return $connection->withTablePrefix(
60	20	new MySqlGrammar()
61	20	);
62	20	case 'pgsql':
63	10	return $connection->withTablePrefix(
64	10	new PostgresGrammar()
65	10	);
66	10	case 'sqlite':
67	10	return $connection->withTablePrefix(
68	10	new SQLiteGrammar()
69	10	);
70		}
71
72		throw new RuntimeException('This database is not supported.'); // @codeCoverageIgnore
73		}
74		}
75

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

HasEagerLimit::addGroupLimit() A last analyzed 2024-03-09 13:08 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

HasEagerLimit::addGroupLimit() A
last analyzed 2024-03-09 13:08 UTC