A database migration plugin for Gradle. This was inspired from Laravel artisan migration tool.
- JDK 1.6+
- Gralde 2.3+
- Mysql
- Sqlite
- Postgres
Inside your build.gralde
apply plugin:"kante.goose.migration"
Make sure kante.goose:goose:1.0-SNAPSHOT is in your builscript classpath
Goose database credentials are read from an external configuration file goose.properties
db.url = jdbc:mysql://localhost/my_db
db.user = test
db.password = test
db.driver = com.mysql.jdbc.Driver
The default location of goose.properties is your current directory. You can change that with extensions property goose.configDir.
goose {
configDir = 'custom/directory'
}
Goose also supports profiles, a profile provides a way to load specific configuration for your environment. You define a profile by passing the system property -Dprofile=prod then goose will search for goose-prod.properties. If your profile doesn't exist, goose will NOT fallback to goose.properties.
Here is the general format of a profile
goose-{profile}.properties
Don't forget to add the correct JDBC connector to classpath. Checkout Maven repoository
To create a migration, use the goose-make task:
gradle goose-make -i
The new migration will be placed in your src/main/resources/migrations directory. Each migration file name contains a timestamp which allows Goose to determine the order of the migrations.
The -Dname=some_name property may also be used to indicate the name of the file.
gradle goose-make -Dname=create_users_table -i
A migration directory contains two files: up.sql and down.sql. The up.sql file is used to add new tables, columns, or indexes to your database, while the down.sql method should simply reverse the operations performed by the up method.
Within both of these files you may use the SQL statements support my your database to expressively create and modify tables.
// Inside up.sql
CREATE TABLE users (
id INT PRIMAY KEY,
name VARCHAR(200),
email VARCHAR(200),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
// Inside down.sql
DROP TABLE users;
To run all outstanding migrations for your application, use the goose-migrate task.
gradle goose-migrate -i
The goose-next task will run the next migration of your application:
gradle goose-next -i
To rollback the latest migration "operation", you may use the goose-rollback task. Note that this rolls back the last "batch" of migrations that ran, which may include multiple migration files:
gradle goose-rollback -i
The goose-reset task will roll back all of your application's migrations:
gradle goose-reset -i
Goose plugin will add following tasks to your project.
goose
goose-init
goose-make
goose-migrate
goose-next
goose-rollback
goose-reset
To initialize the migration table and directory. You are required to call this task before any other commands.
The default migration cache table is goose_migrations and the default directory is src/main/resources/goose/migrations.
You cant change those settings with:
goose {
...
dir = 'some/path/relatif/to/the/project'
table = 'custom_migrations'
}
Create a new migration.
To run all new migrations
To run the next migration
To rollback the last migration
To reset all migrations