BuildsParamLimitFixQueries   A
last analyzed

Complexity

Total Complexity 5

Size/Duplication

Total Lines 37
Duplicated Lines 0 %

Test Coverage

Coverage 100%

Importance

Changes 2
Bugs 0 Features 0
Metric Value
eloc 12
c 2
b 0
f 0
dl 0
loc 37
ccs 7
cts 7
cp 1
rs 10
wmc 5

1 Method

Rating   Name   Duplication   Size   Complexity  
A eagerLoadRelations() 0 13 5
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