commit | 53630f5ff10bd64712e91978e9cb92473cf7c537 | [log] [tgz] |
---|---|---|
author | Matthias Kadenbach <matthias.kadenbach@gmail.com> | Wed Feb 15 07:25:19 2017 |
committer | Matthias Kadenbach <matthias.kadenbach@gmail.com> | Wed Feb 15 07:25:19 2017 |
tree | 65aa721cc941bb72f836d62b9c54c0a133a8aa90 | |
parent | 3feee5958a4238bfca6c5473b0baf73519d04424 [diff] |
add NewWithDatabaseInstance example
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