43 lines
1.5 KiB
PHP
43 lines
1.5 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
declare(strict_types=1);
|
||
|
|
|
||
|
|
use App\Enums\Post\CreatedVia;
|
||
|
|
use App\Models\Post;
|
||
|
|
use Illuminate\Support\Facades\DB;
|
||
|
|
use Illuminate\Support\Facades\Schema;
|
||
|
|
|
||
|
|
beforeEach(function () {
|
||
|
|
$this->tables = [
|
||
|
|
'automations' => '2026_05_22_211640_create_automations_table',
|
||
|
|
'automation_trigger_items' => '2026_05_22_211641_create_automation_trigger_items_table',
|
||
|
|
'automation_runs' => '2026_05_22_211642_create_automation_runs_table',
|
||
|
|
'automation_node_runs' => '2026_05_22_211643_create_automation_node_runs_table',
|
||
|
|
'automation_node_states' => '2026_05_23_164734_create_automation_node_states_table',
|
||
|
|
];
|
||
|
|
|
||
|
|
foreach ($this->tables as $table => $migration) {
|
||
|
|
if (! Schema::hasTable($table)) {
|
||
|
|
(require database_path("migrations/{$migration}.php"))->up();
|
||
|
|
}
|
||
|
|
}
|
||
|
|
});
|
||
|
|
|
||
|
|
test('rewrites automation-created posts to web and drops the automation tables in FK order', function () {
|
||
|
|
$post = Post::factory()->create(['created_via' => CreatedVia::Web]);
|
||
|
|
DB::table('posts')->where('id', $post->id)->update(['created_via' => 'automation']);
|
||
|
|
|
||
|
|
foreach (array_keys($this->tables) as $table) {
|
||
|
|
expect(Schema::hasTable($table))->toBeTrue();
|
||
|
|
}
|
||
|
|
|
||
|
|
$migration = require database_path('migrations/2026_09_05_124637_drop_automation_tables.php');
|
||
|
|
$migration->up();
|
||
|
|
|
||
|
|
expect($post->fresh()->created_via)->toBe(CreatedVia::Web);
|
||
|
|
|
||
|
|
foreach (array_keys($this->tables) as $table) {
|
||
|
|
expect(Schema::hasTable($table))->toBeFalse();
|
||
|
|
}
|
||
|
|
});
|