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
|
<?php
namespace Illuminate\Tests\Integration\Database;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;
use Orchestra\Testbench\Attributes\RequiresDatabase;
use PHPUnit\Framework\Attributes\DataProvider;
require_once 'Enums.php';
class QueryBuilderUpdateTest extends DatabaseTestCase
{
protected function afterRefreshingDatabase()
{
Schema::create('example', function (Blueprint $table) {
$table->increments('id');
$table->string('name')->nullable();
$table->string('title')->nullable();
$table->string('status')->nullable();
$table->json('payload')->nullable();
});
}
#[DataProvider('jsonValuesDataProvider')]
#[RequiresDatabase(['sqlite', 'mysql', 'mariadb'])]
public function testBasicUpdateForJson($column, $given, $expected)
{
DB::table('example')->insert([
'name' => 'Taylor Otwell',
'title' => 'Mr.',
]);
DB::table('example')->update([$column => $given]);
$this->assertDatabaseHas('example', [
'name' => 'Taylor Otwell',
'title' => 'Mr.',
$column => $column === 'payload' ? $this->castAsJson($expected) : $expected,
]);
}
public static function jsonValuesDataProvider()
{
yield ['payload', ['Laravel', 'Founder'], ['Laravel', 'Founder']];
yield ['payload', collect(['Laravel', 'Founder']), ['Laravel', 'Founder']];
yield ['status', StringStatus::draft, 'draft'];
}
}
|
