nafg / slick-migration-api   0.10.0

Apache License 2.0 GitHub

Schema manipulation dialects and DSL for Slick

Scala versions: 3.x 2.13 2.12

Write typesafe and typo-safe database migrations, using your existing Slick table definitions.

Pipeline Status

Coverage Status

Maven Central

Dependency

Slick version SBT dependency Supported scala versions
3.4.0 "io.github.nafg.slick-migration-api" %% "slick-migration-api" % "0.9.0" 2.12, 2.13
3.3.3 "io.github.nafg.slick-migration-api" %% "slick-migration-api" % "0.8.2" 2.12, 2.13
3.3.2 "io.github.nafg" %% "slick-migration-api" % "0.8.0" 2.12, 2.13
3.3.0 "io.github.nafg" %% "slick-migration-api" % "0.6.1" 2.11, 2.12
3.2.3 "io.github.nafg" %% "slick-migration-api" % "0.4.4" 2.11, 2.12
3.2.1 "io.github.nafg" %% "slick-migration-api" % "0.4.2" 2.11, 2.12
3.2.0 "io.github.nafg" %% "slick-migration-api" % "0.4.0" 2.11, 2.12
3.1.1 "io.github.nafg" %% "slick-migration-api" % "0.3.0" 2.11
3.0.3 "io.github.nafg" %% "slick-migration-api_slick30" % "0.3.0" 2.10, 2.11
2.1.0 "io.github.nafg" %% "slick-migration-api" % "0.1.1" 2.10

Artifacts are deployed to Maven Central.

Example

import slick.jdbc.H2Profile.api._
import slick.migration.api._

val db = Database.forConfig("example-config")

implicit val dialect: H2Dialect = new H2Dialect

class MyTable(tag: Tag) extends Table[(Int, String)](tag, "my_table") {
  val col1 = column[Int]("col1")
  val col2 = column[String]("col2")
  val index1 = index("idx1", col1)
  def * = (col1, col2)
}
val MyTable = TableQuery[MyTable]
val init =
  TableMigration(MyTable)
    .create
    .addColumns(_.col1, _.col2)
    .addIndexes(_.index1)
    .renameColumn(_.col1, "col3")
val seed =
  SqlMigration("insert into myTable (col1, col2) values (10, 20)")
  
val migration = init & seed

db.run(migration())