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
|
<?php
namespace Illuminate\Tests\Integration\Database;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
/**
* @group integration
*/
class EloquentWhereTest extends DatabaseTestCase
{
protected function setUp(): void
{
parent::setUp();
Schema::create('users', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('email');
$table->string('address');
});
}
public function testWhereAndWhereOrBehavior()
{
/** @var UserWhereTest $firstUser */
$firstUser = UserWhereTest::create([
'name' => 'test-name',
'email' => 'test-email',
'address' => 'test-address',
]);
/** @var UserWhereTest $secondUser */
$secondUser = UserWhereTest::create([
'name' => 'test-name1',
'email' => 'test-email1',
'address' => 'test-address1',
]);
$this->assertTrue($firstUser->is(UserWhereTest::where('name', '=', $firstUser->name)->first()));
$this->assertTrue($firstUser->is(UserWhereTest::where('name', $firstUser->name)->first()));
$this->assertTrue($firstUser->is(UserWhereTest::where('name', $firstUser->name)->where('email', $firstUser->email)->first()));
$this->assertNull(UserWhereTest::where('name', $firstUser->name)->where('email', $secondUser->email)->first());
$this->assertTrue($secondUser->is(UserWhereTest::where('name', 'wrong-name')->orWhere('email', $secondUser->email)->first()));
$this->assertTrue($firstUser->is(UserWhereTest::where(['name' => 'test-name', 'email' => 'test-email'])->first()));
$this->assertNull(UserWhereTest::where(['name' => 'test-name', 'email' => 'test-email1'])->first());
$this->assertTrue($secondUser->is(
UserWhereTest::where(['name' => 'wrong-name', 'email' => 'test-email1'], null, null, 'or')->first())
);
$this->assertSame(
1,
UserWhereTest::where(['name' => 'test-name', 'email' => 'test-email1'])
->orWhere(['name' => 'test-name1', 'address' => 'wrong-address'])->count()
);
$this->assertTrue(
$secondUser->is(
UserWhereTest::where(['name' => 'test-name', 'email' => 'test-email1'])
->orWhere(['name' => 'test-name1', 'address' => 'wrong-address'])
->first()
)
);
}
public function testFirstWhere()
{
/** @var UserWhereTest $firstUser */
$firstUser = UserWhereTest::create([
'name' => 'test-name',
'email' => 'test-email',
'address' => 'test-address',
]);
/** @var UserWhereTest $secondUser */
$secondUser = UserWhereTest::create([
'name' => 'test-name1',
'email' => 'test-email1',
'address' => 'test-address1',
]);
$this->assertTrue($firstUser->is(UserWhereTest::firstWhere('name', '=', $firstUser->name)));
$this->assertTrue($firstUser->is(UserWhereTest::firstWhere('name', $firstUser->name)));
$this->assertTrue($firstUser->is(UserWhereTest::where('name', $firstUser->name)->firstWhere('email', $firstUser->email)));
$this->assertNull(UserWhereTest::where('name', $firstUser->name)->firstWhere('email', $secondUser->email));
$this->assertTrue($firstUser->is(UserWhereTest::firstWhere(['name' => 'test-name', 'email' => 'test-email'])));
$this->assertNull(UserWhereTest::firstWhere(['name' => 'test-name', 'email' => 'test-email1']));
$this->assertTrue($secondUser->is(
UserWhereTest::firstWhere(['name' => 'wrong-name', 'email' => 'test-email1'], null, null, 'or'))
);
}
}
class UserWhereTest extends Model
{
protected $table = 'users';
protected $guarded = [];
public $timestamps = false;
}
|
