Simple MySQL migrations in Go. No dependencies, simple API, migration change detection and status tracking, and a cute cow.
It might work with other SQL databases, but I haven't tried. I wrote this as part of another project and put it in this repo for my own convenience of reuse. I doubt it's ready for production.
Migrations should be defined using the Migration struct type and registered using the
Register function, like so:
moogration.Register(
&Migration{
Name: "001_create_table_user",
Up: `CREATE TABLE user (
...
);`,
Down: `DROP TABLE user;`,
}
)Migrations registered with Register will be sorted ascending by the name key
and run in order. Previously run migrations will be skipped unless force is set to true.
moogration.RunLatest(db, down, force, logger)You can also roll back a specified number of migration batches with moogration.Rollback().
Pass a *log.Logger to log migration status. Pass nil to silence migration logging.
This package assumes that database migrations are application critical and thus panics upon encountering an error.