Goosees is a wrapper of goose for applying migration to multiple databases.
# "companyDB" group has one database.
companyDB:
- driver: mysql
open: root@tcp(127.0.0.1:3306)/company?parseTime=true
# "employeeDB" group has two databases.
employeeDB:
- driver: mysql
open: root@tcp(127.0.0.1:3306)/employee1?parseTime=true
- driver: mysql
open: root@tcp(127.0.0.1:3306)/employee2?parseTime=true
-
?parseTime=trueMUST be included inopenstring to avoid error at status command. See goose issue #22 -
So far only
mysqlis available as a value ofdriver.
goosees <conf> <group> <subcommand> [subcommand options]
confis path to config file. For convenience, extension(.yml,.yaml) can be omitted.
Migration file is created under a directory which has the same name as group.
$ goosees dev companyDB create CreateCompanies sql
goosees: companyDB/20160128222309_CreateCompanies.sql
Migration is applied to all databases in a group.
$ goosees dev employeeDB up
goose: migrating db environment 'employeeDB[0]', current version: 0, target: 20160128221551
OK 20160128221551_CreateEmployees.sql
goose: migrating db environment 'employeeDB[1]', current version: 0, target: 20160128221551
OK 20160128221551_CreateEmployees.sql $ goosees dev employeeDB up
$ goosees dev employeeDB down
goose: migrating db environment 'employeeDB[0]', current version: 20160128221551, target: 0
OK 20160128221551_CreateEmployees.sql
goose: migrating db environment 'employeeDB[1]', current version: 20160128221551, target: 0
OK 20160128221551_CreateEmployees.sql
$ goosees dev companyDB status
goosees: status for environment 'companyDB[0]'
Applied At Migration
=======================================
Thu Jan 28 22:10:56 2016 -- 20160128220727_CreateCompanies.sql
Thu Jan 28 22:13:44 2016 -- 20160128221155_AddCompanyAddress.sql
$ goosees dev companyDB dbversion
goosees: [companyDB:0] dbversion 20160128221155
$ goosees dev employeeDB dbversion
goosees: [employeeDB:0] dbversion 20160128221551
goosees: [employeeDB:1] dbversion 20160128221551