mysql - How to execute DDL only when tables don't exist?

Question

I'm using Slick 1.0 with Play Framework 2.1 and MySQL.

I'd like to control the ddl table creation so that it only takes place if the tables don't exist. That is to say that the tables should only get created the first time I start play.

How to do it in Slick?

Answer 1

Since I like to control the creation of my tables individually and keep it DRY, I just tend to add a utility method to my apps:

def createIfNotExists(tables: TableQuery[_ <: Table[_]]*)(implicit session: Session) {
  tables foreach {table => if(MTable.getTables(table.baseTableRow.tableName).list.isEmpty) table.ddl.create}
}

Then you can just create your tables with the implicit session:

db withSession {
  implicit session =>
    createIfNotExists(table1, table2, ..., tablen)
}