Env migrate
Use github.com/rubenv/sql-migrate
and env, auto run migrate.
启用 sql-migrate
func main(){
env_migrate.Auto(db,dbName) // db is database/sql *sql.DB, dbName is dataBaseName like 'mysql'
}
启动服务/迁移数据库
migrate 会读取 migrations/*.sql
进行迁移
启动并执行所有迁移
up_migrate=all go run main.go
执行回滚,1 次, down_migrate 结束会自动退出
down_migrate=1 go run main.go
执行跳过,2 次, skip_migrate 结束会自动退出
skip_migrate=2 go run main.go
使用其他 migrations 路径
up_migrate=all dir_migrate=sql/migrations go run main.go