Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Flyway plugin for Play >= 2.1

This branch is 64 commits behind master

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
playapp
plugin/src
project
.gitignore
README.md
screenshot1.png
screenshot2.png

README.md

play-flyway

Flyway plugin for Play 2.1. It aims to be a substitute for play-evolutions.

Features

  • Based on Flyway
  • No 'Downs' part.
  • Independent of DBPlugin(play.api.db).

Install

For Play 2.2.x

In Build.scala/build.sbt

libraryDependencies += "com.github.tototoshi" %% "play-flyway" % "1.0.0"

and write play.plugins.

1000:com.github.tototoshi.play2.flyway.Plugin

For Play 2.1.x

In Build.scala/build.sbt

libraryDependencies += "com.github.tototoshi" %% "play-flyway" % "0.2.0"

and write play.plugins.

1000:com.github.tototoshi.play2.flyway.Plugin

Usage

Sample

seratch/devteam-app is using play-flyway. Maybe this is a good example.

Place migration scripts

A migration script is just a simple SQL file.

CREATE TABLE FOO (.............

Place your migration scripts in conf/db/migration/${dbName} .

playapp
├── app
│   ├── controllers
│   ├── models
│   └── views
├── conf
│   ├── application.conf
│   ├── db
│   │   └── migration
│   │       ├── default
│   │       │   ├── V1__Create_person_table.sql
│   │       │   └── V2__Add_people.sql
│   │       └── secondary
│   │           ├── V1__create_job_table.sql
│   │           └── V2__Add_job.sql
│   ├── play.plugins
│   └── routes

Please see flyway's documents about the naming convention for migration scripts.

http://flywaydb.org/documentation/migration/sql.html

Dev

screenshot

For existing schema, Flyway has a option called 'initOnMigrate'. This option is enabled when -Ddb.${dbName}.migration.initOnMigrate=true. For example,

$ play -Ddb.default.migration.initOnMigrate=true

Of course, You can write this in your application.conf.

Manual migration is also supported. Click 'Other operations' or open /@flyway/${dbName} directly.

screenshot

Test

In Test mode, migration is done automatically.

Prod

In production mode, migration is done automatically if db.${dbName}.migration.auto is set to be true in application.conf. Otherwise it failed to start when migration is needed.

$ play -Ddb.default.migration.auto=true start
Something went wrong with that request. Please try again.