Slide 4
Slide 4 text
Copyright © 2009-2015 eureka, Inc. All rights reserved.
goose
https://bitbucket.org/liamstask/goose
postgres
mysql
sqlite3
-- +migrate Up
-- SQL in section 'Up' is executed when this migration is applied
INSERT INTO book (category_id,title) VALUES (10,'αϧͷࢁ຺');
-- +migrate Down
-- SQL section 'Down' is executed when this migration is rolled back
DELETE FROM book WHERE title = “αϧͷࢁ຺”;
$ goose create SampleData —sql
20130106093224_SampleData.sql
generator
$ goose -env="development" up
$ goose: migrating db environment
'development', current version: 0, target: 3
$ OK 20130106093224_SampleData.sql
$ OK 20130123094859_AlterColumn.sql
$ OK 20130506098921_ChangeMaster.sql
execute migration
mysql> select * from goose_db_version;
+----+----------------+------------+---------------------+
| id | version_id | is_applied | tstamp |
+----+----------------+------------+---------------------+
| 1 | 0 | 1 | 2015-05-25 13:30:21 |
| 2 | 20150417203037 | 1 | 2015-05-25 13:30:22 |
| 3 | 20150422123037 | 1 | 2015-05-25 13:30:22 |
+----+----------------+------------+---------------------+
>
※ϑΝΠϧ໊ॱ alphabetical order