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
|
<?php
namespace Illuminate\Tests\Integration\Database\Sqlite;
use Illuminate\Support\Facades\DB;
use Orchestra\Testbench\Attributes\RequiresDatabase;
use Orchestra\Testbench\Concerns\InteractsWithPublishedFiles;
use Orchestra\Testbench\TestCase;
use PHPUnit\Framework\Attributes\RequiresOperatingSystem;
use function Orchestra\Testbench\remote;
#[RequiresDatabase('sqlite')]
class SchemaStateTest extends TestCase
{
use InteractsWithPublishedFiles;
protected $files = [
'database/schema',
];
protected function setUp(): void
{
parent::setUp();
remote('migrate:install')->mustRun();
}
protected function tearDown(): void
{
remote('db:wipe')->mustRun();
parent::tearDown();
}
#[RequiresOperatingSystem('Linux|Darwin')]
public function testSchemaDumpOnSqlite()
{
if ($this->usesSqliteInMemoryDatabaseConnection()) {
$this->markTestSkipped('Test cannot be run using :in-memory: database connection');
}
$connection = DB::connection();
$connection->getSchemaBuilder()->createDatabase($connection->getConfig('database'));
$connection->statement('CREATE TABLE IF NOT EXISTS migrations (id integer primary key autoincrement not null, migration varchar not null, batch integer not null);');
$connection->statement('CREATE TABLE users (id integer primary key autoincrement not null, email varchar not null, name varchar not null);');
$connection->statement('INSERT INTO users (email, name) VALUES ("taylor@laravel.com", "Taylor Otwell");');
$this->assertTrue($connection->table('sqlite_sequence')->exists());
$this->app['files']->ensureDirectoryExists(database_path('schema'));
$connection->getSchemaState()->dump($connection, database_path('schema/sqlite-schema.sql'));
$this->assertFileContains([
'CREATE TABLE migrations',
'CREATE TABLE users',
], 'database/schema/sqlite-schema.sql');
$this->assertFileNotContains([
'sqlite_sequence',
], 'database/schema/sqlite-schema.sql');
}
}
|
