Database version automatic migration

jaronnieLess than 1 minute

jzero implements database migration capability based on migrate
jzero detects files under desc/sql_migration directory by default, executes migration
Refer to best practices on how to write database migration files

Configuration

migrate:
  driver: "mysql"
  datasource-url: "root:123456@tcp(127.0.0.1:3306)/jzero-admin"

# Upgrade to latest by default
jzero migrate up
# Upgrade n migrations
jzero migrate up 3

# Rollback all by default
jzero migrate down
# Rollback n migrations
jzero migrate down 3

jzero migrate version

jzero migrate goto <your_version>