BuildParamLimitFixQueries::eagerLoadRelations() - Code Metrics - Inspection of "Refactor code for merge packages" - staudenmeir/eloquent-param-limit-fix - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( c81846...f8bf80 )

by Jonas

created 2022-03-23 21:54 UTC

BuildParamLimitFixQueries::eagerLoadRelations() A

↳ Parent: BuildParamLimitFixQueries

Complexity

Conditions	5
Paths	4

Size

Total Lines	13
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	7
CRAP Score	5

Importance

Changes	1
Bugs	0	Features	0

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

<?php

namespace Staudenmeir\EloquentParamLimitFix\Traits;

use Illuminate\Database\MySqlConnection;
use Illuminate\Database\SQLiteConnection;
use Illuminate\Database\SqlServerConnection;

trait BuildParamLimitFixQueries
{
    /**
     * The maximum number of parameters per query.
     *
     * The values are lower than the actual limits
     * to have a margin for polymorphic relationships
     * and other query parameters.
     *
     * @var array
     */
    protected $parameterLimits = [
        MySqlConnection::class => 65000,
        SQLiteConnection::class => 900,
        SqlServerConnection::class => 2000,
    ];

    /**
     * Eager load the relationships for the models.
     *
     * @param array $models
     * @return array
     */
    public function eagerLoadRelations(array $models)
    {
        foreach ($this->parameterLimits as $class => $limit) {
            if ($this->query->getConnection() instanceof $class && count($models) > $limit) {
                foreach (array_chunk($models, $limit) as $chunk) {
                    $this->eagerLoadRelations($chunk);
                }

                return $models;
            }
        }

        return parent::eagerLoadRelations($models);
    }
}


1		<?php
2
3		namespace Staudenmeir\EloquentParamLimitFix\Traits;
4
5		use Illuminate\Database\MySqlConnection;
6		use Illuminate\Database\SQLiteConnection;
7		use Illuminate\Database\SqlServerConnection;
8
9		trait BuildParamLimitFixQueries
10		{
11		/**
12		* The maximum number of parameters per query.
13		*
14		* The values are lower than the actual limits
15		* to have a margin for polymorphic relationships
16		* and other query parameters.
17		*
18		* @var array
19		*/
20		protected $parameterLimits = [
21		MySqlConnection::class => 65000,
22		SQLiteConnection::class => 900,
23		SqlServerConnection::class => 2000,
24		];
25
26		/**
27		* Eager load the relationships for the models.
28		*
29		* @param array $models
30		* @return array
31		*/
32	1	public function eagerLoadRelations(array $models)
33		{
34	1	foreach ($this->parameterLimits as $class => $limit) {
35	1	if ($this->query->getConnection() instanceof $class && count($models) > $limit) {
36	1	foreach (array_chunk($models, $limit) as $chunk) {
37	1	$this->eagerLoadRelations($chunk);
38		}
39
40	1	return $models;
41		}
42		}
43
44	1	return parent::eagerLoadRelations($models);
45		}
46		}
47

staudenmeir / eloquent-param-limit-fix

Push — master ( c81846...f8bf80 )

BuildParamLimitFixQueries::eagerLoadRelations() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like