$ curl -L https://github.com/golang-migrate/migrate/releases/download/$version/migrate.$platform-amd64.tar.gz | tar xvz
$ brew install golang-migrate
$ curl -L https://packagecloud.io/golang-migrate/migrate/gpgkey | apt-key add -
$ echo "deb https://packagecloud.io/golang-migrate/migrate/ubuntu/ $(lsb_release -sc) main" > /etc/apt/sources.list.d/migrate.list
$ apt-get update
$ apt-get install -y migrate
$ go get -u -d github.com/golang-migrate/migrate/cmd/migrate
$ cd $GOPATH/src/github.com/golang-migrate/migrate/cmd/migrate
$ git checkout $TAG # e.g. v4.1.0
$ go build -tags 'postgres' -ldflags="-X main.Version=$(git describe --tags)" -o $GOPATH/bin/migrate github.com/golang-migrate/migrate/cmd/migrate
$ go get -tags 'postgres' -u github.com/golang-migrate/migrate/cmd/migrate
- Requires a version of Go that supports modules. e.g. Go 1.11+
- These examples build the cli which will only work with postgres. In order
to build the cli for use with other databases, replace the
postgres
build tag with the appropriate database tag(s) for the databases desired. The tags correspond to the names of the sub-packages underneath thedatabase
package. - Similarly to the database build tags, if you need to support other sources, use the appropriate build tag(s).
- Support for build constraints will be removed in the future: golang-migrate#60
$ migrate -help
Usage: migrate OPTIONS COMMAND [arg...]
migrate [ -version | -help ]
Options:
-source Location of the migrations (driver:https://url)
-path Shorthand for -source=file:https://path
-database Run migrations against this database (driver:https://url)
-prefetch N Number of migrations to load in advance before executing (default 10)
-lock-timeout N Allow N seconds to acquire database lock (default 15)
-verbose Print verbose logging
-version Print version
-help Print usage
Commands:
create [-ext E] [-dir D] [-seq] [-digits N] [-format] NAME
Create a set of timestamped up/down migrations titled NAME, in directory D with extension E.
Use -seq option to generate sequential up/down migrations with N digits.
Use -format option to specify a Go time format string.
goto V Migrate to version V
up [N] Apply all or N up migrations
down [N] Apply all or N down migrations
drop Drop everything inside database
force V Set version V but don't run migration (ignores dirty state)
version Print current migration version
So let's say you want to run the first two migrations
$ migrate -source file:https://path/to/migrations -database postgres:https://localhost:5432/database up 2
If your migrations are hosted on github
$ migrate -source github:https://mattes:personal-access-token@mattes/migrate_test \
-database postgres:https://localhost:5432/database down 2
The CLI will gracefully stop at a safe point when SIGINT (ctrl+c) is received. Send SIGKILL for immediate halt.
$ migrate -database "$MY_MIGRATE_DATABASE"
Check out https://stedolan.github.io/jq/
$ migrate -database "$(cat config.json | jq '.database')"
$ migrate -database "$(cat config/database.yml | ruby -ryaml -e "print YAML.load(STDIN.read)['database']")"
$ migrate -database "$(cat config/database.yml | python -c 'import yaml,sys;print yaml.safe_load(sys.stdin)["database"]')"