moogration

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.

Defining migrations

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;`,
    }
)

Running migrations

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().

Logging

Pass a *log.Logger to log migration status. Pass nil to silence migration logging.

Errors

This package assumes that database migrations are application critical and thus panics upon encountering an error.