Simple Laravel database state system to ensure database content is up-to-date (in addition to its schema using migrations).

2021_01_01_000003_ensure_owner_user_exists.php

<?php

declare(strict_types=1);

use App\Domain\Users\User;
use App\State;
use Illuminate\Support\Facades\Hash;

return new class extends State {
    public function up(): void
    {
        $attributes = array_merge(
            ['email_verified_at' => now()],
            config('app.owner'),
        );

        $attributes['password'] = Hash::make($attributes['password']);

        User::create($attributes);
    }

    public function skipIf(): bool
    {
        return User::query()
            ->where('email', config('app.owner.email'))
            ->exists();
    }
};

2022_08_04_000000_ensure_old_elasticsearch_numeric_mapping_is_removed.php

<?php

declare(strict_types=1);

use App\Domain\Elasticsearch\Elasticsearch;
use App\State;

return new class extends State {
    public function up(): bool
    {
        return Elasticsearch::indices()
            ->deleteIndexTemplate(['name' => 'map_numerics_to_doubles'])
            ->asBool();
    }

    public function skipIf(): bool
    {
        return ! Elasticsearch::indices()
            ->existsIndexTemplate(['name' => 'map_numerics_to_doubles'])
            ->asBool();
    }
};

EnsureDatabaseState.php

<?php

declare(strict_types=1);

namespace App\Console\Commands;

use App\State;
use Illuminate\Console\Command;
use Illuminate\Filesystem\Filesystem;
use RuntimeException;

class EnsureDatabaseState extends Command
{
    /**
     * @var string
     */
    protected $signature = 'db:ensure-state';

    /**
     * @var string
     */
    protected $description = 'Ensure the database is in the correct state';

    public function __construct(private readonly Filesystem $filesystem)
    {
        parent::__construct();
    }

    public function handle(): int
    {
        $this->components->info('Preparing state of database.');

        $files = $this->filesystem->files(database_path('states'));

        collect($files)
            ->map(fn (string $path): array => [
                'path' => basename($path, '.php'),
                'state' => $this->filesystem->getRequire($path),
            ])
            ->each($this->verify(...))
            ->each($this->runUp(...));

        return static::SUCCESS;
    }

    private function verify(array $file): void
    {
        ['state' => $state] = $file;

        if ($state instanceof State) {
            return;
        }

        throw new RuntimeException(sprintf('State "%s" must be an instance of "App\State"', $state));
    }

    private function runUp(array $file): void
    {
        ['path' => $path, 'state' => $state] = $file;

        if (method_exists($state, 'skipIf') && $state->skipIf()) {
            $success = true;
        } else {
            $success = $state->up() ?? true;
        }

        $this->components->task($path, static fn (): bool => $success);
    }
}