commit | 5645143baaaa479d247ca06258b641c607fd8964 | [log] [tgz] |
---|---|---|
author | Matthias Kadenbach <matthias.kadenbach@gmail.com> | Thu Feb 23 21:13:02 2017 |
committer | Matthias Kadenbach <matthias.kadenbach@gmail.com> | Thu Feb 23 21:13:02 2017 |
tree | 23a679722ba91a335188333b2b71738b71f83892 | |
parent | ec5c0ac3e0e0ba3c12fe9c1fa09142a340f9382b [diff] |
add example dockerfile
Database migrations written in Go. Use as CLI or import as library.
Database drivers run migrations. Add a new database?
Source drivers read migrations from local or remote sources. Add a new source?
$ brew install migrate --with-postgres $ migrate -database postgres://localhost:5432/database up 2
GracefulStop chan bool
.io.Reader
streams internally for low memory overhead.import (
"github.com/mattes/migrate/migrate"
_ "github.com/mattes/migrate/database/postgres"
_ "github.com/mattes/migrate/source/github"
)
func main() {
m, err := migrate.New(
"github://mattes:personal-access-token@mattes/migrate_test",
"postgres://localhost:5432/database?sslmode=enable")
m.Steps(2)
}
Want to use an existing database client?
import (
"database/sql"
_ "github.com/lib/pq"
"github.com/mattes/migrate/migrate"
"github.com/mattes/migrate/database/postgres"
)
func main() {
db, err := sql.Open("postgres", "postgres://localhost:5432/database?sslmode=enable")
driver, err := postgres.WithInstance(db, &postgres.Config{})
m, err := migrate.NewWithDatabaseInstance(
"file:///migrations",
"postgres", driver)
m.Steps(2)
}
Each migration has an up and down migration. Why?
1481574547_create_users_table.up.sql 1481574547_create_users_table.down.sql
Best practices: How to write migrations.
Yes, please! Makefile
is your friend, read the development guide.
Also have a look at the FAQ.
Alternatives
https://bitbucket.org/liamstask/goose, https://github.com/tanel/dbmigrate,
https://github.com/BurntSushi/migration, https://github.com/DavidHuie/gomigrate,
https://github.com/rubenv/sql-migrate