Migrator class

The Migrator Service.

Handles running and tracking database migrations. The migrator keeps track of which migrations have already been executed using a magic_migrations table in the database.

Running Migrations

final migrator = Migrator();

await migrator.run([
  CreateUsersTable(),
  CreatePostsTable(),
  AddAvatarToUsers(),
]);

How It Works

1. Creates the magic_migrations tracking table if it doesn't exist
2. Loads all previously executed migrations
3. Filters the provided migrations to only pending ones
4. Executes each pending migration's up method
5. Records each successful migration in the tracking table
6. Clears the schema cache for affected tables

Rolling Back

// Rollback the last batch
await migrator.rollback([
  CreateUsersTable(),
  CreatePostsTable(),
]);