migrate.go

package migrate

type Migration struct {
	// Pre and Post are commands to execute before and after a migration.
	//
	// If nil, these fields are ignored.
	Pre  func(tx *sql.Tx) error
	Post func(tx *sql.Tx) error
  
	// Migration is a list of SQL commands to run.
	Migration []string
}

func Migrate(db *sql.DB, migrations ...Migration) error {
	tx, err := db.Begin()
	if err != nil {
		return err
	}
	defer tx.Rollback()
	
	// ... Determine what migration needs to be maded based on some table in the DB.
	
	for _, migration := range migrations {
		if migration.Pre != nil {
			if err := migration.Pre(tx); err != nil {
				return err
			}
		}
		
		// do migration
		
		if migration.Post != nil {
			if err := migration.Post(tx); err != nil {
				return err
			}
		}
	}
	return tx.Commit()
}