BuildsParamLimitFixQueries::eagerLoadRelations() - Code Metrics - staudenmeir/eloquent-param-limit-fix - Measure and Improve Code Quality continuously with Scrutinizer

BuildsParamLimitFixQueries::eagerLoadRelations() A
last analyzed 2024-07-14 00:35 UTC

↳ Parent: BuildsParamLimitFixQueries

Complexity

Conditions	5
Paths	4

Size

Total Lines	13
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	6
CRAP Score	5

Importance

Changes	1
Bugs	0	Features	0

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

<?php

namespace Staudenmeir\EloquentParamLimitFix\Traits;

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

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

staudenmeir / eloquent-param-limit-fix

BuildsParamLimitFixQueries::eagerLoadRelations() A last analyzed 2024-07-14 00:35 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

BuildsParamLimitFixQueries::eagerLoadRelations() A
last analyzed 2024-07-14 00:35 UTC