Scala-Forklift helps manage and apply database migrations for your Scala project.
Write your migrations in plain SQL:
MyMigrations.migrations = MyMigrations.migrations :+ SqlMigration(1)(List(
sqlu"""create table "users" ("id" INTEGER NOT NULL PRIMARY KEY,"first" VARCHAR NOT NULL,"last" VARCHAR NOT NULL)"""
))
Or type-safe Slick queries:
MyMigrations.migrations = MyMigrations.migrations :+ DBIOMigration(2)(
DBIO.seq(Users ++= Seq(
UsersRow(1, "Chris","Vogt"),
UsersRow(2, "Yao","Li")
)))
Or use slick-migration-api:
MyMigrations.migrations = MyMigrations.migrations :+ APIMigration(3)(
TableMigration(Users).
renameColumn(_.first, "firstname").
renameColumn(_.last, "lastname"))
(Note: APIMigration
is not supported in versions prior to v0.2.3
)
Don't worry about keeping the Scala code and your database schema consistent. Our source code generator will have it generated for you.
Key Features:
- Supports for type-safe database migration with Slick and slick-migration-api.
- A source code generator to generate and manage Scala models from your database schemas.
- A tool to help you manage your dev db with git, with supports for branching and merging.
- High customizability.
Scala-Forklift supports both Slick 3.1 and Slick 3.2. The latest versions of Scala-Forklift are given below:
Scala Version | Slick Version | SBT dependency |
---|---|---|
2.11.x | 3.1.x |
libraryDependencies += "com.liyaos" %% "scala-forklift-slick" % "0.2.3" |
2.12.x, 2.11.x | 3.2.x |
libraryDependencies += "com.liyaos" %% "scala-forklift-slick" % "0.3.1" |
2.13.x, 2.12.x | 3.3.x |
libraryDependencies += "com.liyaos" %% "scala-forklift-slick" % "0.3.2" |
For tutorial and example code, please check example.
Here is also a wonderful tutorial written by Andreas Burkard and Julian Tragé.
You can use our start template on GitHub to quickly start a project with Scala-Forklift:
git clone https://github.com/lastland/scala-forklift-start-template.git
- The
reset
command may not correctly handle database schemas with foreign keys.