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
|
<?php
namespace Illuminate\Tests\Integration\Database;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;
include_once 'Enums.php';
class QueryingWithEnumsTest extends DatabaseTestCase
{
protected function afterRefreshingDatabase()
{
Schema::create('enum_casts', function (Blueprint $table) {
$table->increments('id');
$table->string('string_status', 100)->nullable();
$table->integer('integer_status')->nullable();
});
}
public function testCanQueryWithEnums()
{
DB::table('enum_casts')->insert([
'string_status' => 'pending',
'integer_status' => 1,
]);
$record = DB::table('enum_casts')->where('string_status', StringStatus::pending)->first();
$record2 = DB::table('enum_casts')->where('integer_status', IntegerStatus::pending)->first();
$record3 = DB::table('enum_casts')->whereIn('integer_status', [IntegerStatus::pending])->first();
$this->assertNotNull($record);
$this->assertNotNull($record2);
$this->assertNotNull($record3);
$this->assertSame('pending', $record->string_status);
$this->assertEquals(1, $record2->integer_status);
}
public function testCanInsertWithEnums()
{
DB::table('enum_casts')->insert([
'string_status' => StringStatus::pending,
'integer_status' => IntegerStatus::pending,
]);
$record = DB::table('enum_casts')->where('string_status', StringStatus::pending)->first();
$this->assertNotNull($record);
$this->assertSame('pending', $record->string_status);
$this->assertEquals(1, $record->integer_status);
}
}
|
