MIGRATIONS.md

Migrations

Database migration guide.

Usage

make migrate-up          # Run pending migrations
make migrate-status      # Show status
make migrate-down        # Rollback last migration

Or use the binary:

go run cmd/migrate/main.go -action=up
go run cmd/migrate/main.go -action=down -steps=3

Creating Migrations

1. Create file in versions/: YYYYMMDD_XXXXXX_description.go

package versions

import (
  "gorm.io/gorm"
)

type Migration20240212_000002 struct{}

func (m Migration20260212_000002) Version() string {
  return "20240212_000002"
}

func (m Migration20260212_000002) Name() string {
  return "add_profile_table"
}

func (m Migration20260212_000002) Up(db *gorm.DB) error {
  return db.Exec(`
    CREATE TABLE IF NOT EXISTS profiles (
      id INTEGER PRIMARY KEY AUTOINCREMENT,
      user_id INTEGER NOT NULL,
      name TEXT NOT NULL,
      created_at DATETIME NOT NULL,
      FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    )
  `).Error
}

func (m Migration20260212_000002) Down(db *gorm.DB) error {
  return db.Exec("DROP TABLE IF EXISTS profiles").Error
}

2. Register in migrations.go:

func GetAllMigrations() []migrator.Script {
  return []migrator.Script{
  versions.Migration20260212_000001{},
  versions.Migration20260212_000002{},
  }
}