DB Migration
Flyway
DB migration is provided by Flyway.
Simple Usage
Just run the following command.
./skinny db:migrate [env] [dbname]
This command expects src/main/resources/db/migration/V***__***.sql files.
Note the double underscore in the filename.
When your migration file is invalid and migration failed, you must do db:repair before retrying the migration.
./skinny db:repair [env] [dbname]
# fix your invalid migration file
./skinny db:migrate [env] [dbname]
Customizing Migration
If you need to change the location of SQL files or need to migrate several DBs, modify {env}.db.{dbname}.migration.locations in application.conf.
In the following example, db:migrate command scans under src/main/resources/db/migration/development/default.
development {
db {
default {
driver="org.h2.Driver"
url="jdbc:h2:file:db/example-development"
user="sa"
password="sa"
migration {
locations: ["development.default"]
}
}
}
}
Yet another DB migration example:
development {
db {
yetanother {
driver="org.h2.Driver"
url="jdbc:h2:file:db/yetanother"
user="sa"
password="sa"
migration {
locations: ["development.yetanother"]
}
}
}
}
Command is like this:
./skinny db:migrate development yetanother
Try now
Scaffolding generates a migration SQL file. Try it with skinny-blank-app.zip!
./skinny g scaffold:jade members member name:String birthday:LocalDate
./skinny db:migrate
./skinny db:migrate test
When your migration failed, Run db:repair command and fix migration files.
./skinny db:repair
// fix migration files...
// retry!
./skinny db:migrate
FAQ
How to access schema_version table?
Flyway creates a table named "schema_version" for H2 database.
sql"""select "version" from "schema_version" """.map(_.string(1)).list.apply()
FYI: