migrate

Goose migrations as app modules.

Install

go get gitea.auvem.com/go-toolkit/migrate

Quick start

//go:embed migrations/*.sql
var migrations embed.FS

mod, err := migrate.ModuleMigrations(&migrate.MigrationOpts{
    SQLO:     dbx.SQLO,
    Dialect:  goose.DialectMySQL,
    FS:       migrations,
    BasePath: "migrations",
})

Register mod and optionally migrate.ModuleAutoMigrate(true) after the database module.

CLI

Use migrate/cli with appcli — not the removed migrate/cmd package.

Production notes

• Require a goose zero-version migration for empty databases
• Do not run ModuleMigrateBlank in production
• When auto-migration is disabled, pending migrations return ErrPendingMigrations

Breaking changes (V1)

Before	After
migrate.Migration global	migrate.Provider()
ModuleMigrations(cfg) *Module (panic)	ModuleMigrations(cfg) (*Module, error) + MustModuleMigrations
ModuleMigrateUp var	ModuleMigrateUp() factory
MigrationsConfig() *MigrationOpts	MigrationsConfig() MigrationOpts (copy)
migrate/cmd	removed — use migrate/cli