1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
<?php
namespace Illuminate\Tests\Integration\Database\EloquentModelLoadMaxTest;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;
use Illuminate\Tests\Integration\Database\DatabaseTestCase;
class EloquentModelLoadMaxTest extends DatabaseTestCase
{
protected function afterRefreshingDatabase()
{
Schema::create('base_models', function (Blueprint $table) {
$table->increments('id');
});
Schema::create('related1s', function (Blueprint $table) {
$table->increments('id');
$table->unsignedInteger('base_model_id');
$table->integer('number');
});
Schema::create('related2s', function (Blueprint $table) {
$table->increments('id');
$table->unsignedInteger('base_model_id');
$table->integer('number');
});
BaseModel::create();
Related1::create(['base_model_id' => 1, 'number' => 10]);
Related1::create(['base_model_id' => 1, 'number' => 11]);
Related2::create(['base_model_id' => 1, 'number' => 12]);
Related2::create(['base_model_id' => 1, 'number' => 13]);
}
public function testLoadMaxSingleRelation()
{
$model = BaseModel::first();
DB::enableQueryLog();
$model->loadMax('related1', 'number');
$this->assertCount(1, DB::getQueryLog());
$this->assertEquals(11, $model->related1_max_number);
}
public function testLoadMaxMultipleRelations()
{
$model = BaseModel::first();
DB::enableQueryLog();
$model->loadMax(['related1', 'related2'], 'number');
$this->assertCount(1, DB::getQueryLog());
$this->assertEquals(11, $model->related1_max_number);
$this->assertEquals(13, $model->related2_max_number);
}
}
class BaseModel extends Model
{
public $timestamps = false;
protected $guarded = [];
public function related1()
{
return $this->hasMany(Related1::class);
}
public function related2()
{
return $this->hasMany(Related2::class);
}
}
class Related1 extends Model
{
public $timestamps = false;
protected $fillable = ['base_model_id', 'number'];
public function parent()
{
return $this->belongsTo(BaseModel::class);
}
}
class Related2 extends Model
{
public $timestamps = false;
protected $fillable = ['base_model_id', 'number'];
public function parent()
{
return $this->belongsTo(BaseModel::class);
}
}
|
