Group

package models

import javax.inject.{Inject, Singleton}
import play.api.db.slick.{HasDatabaseConfigProvider, DatabaseConfigProvider}
import slick.driver.JdbcProfile
import scala.concurrent.ExecutionContext.Implicits.global

case class Group(id: Long = 0, name: String)

@Singleton()
class GroupsDAO @Inject()(val dbConfigProvider: DatabaseConfigProvider,
                           topicsDAO: TopicsDAO)
  extends HasDatabaseConfigProvider[JdbcProfile] {

  import driver.api._

  val groups = TableQuery[GroupsTable]
  val topics = TableQuery[topicsDAO.TopicsTable]

  class GroupsTable(tag: Tag) extends Table[Group](tag, "groups") {
    def id = column[Long]("id", O.PrimaryKey, O.AutoInc)
    def name = column[String]("name")

    def nameIndex = index("group_name_index", name, unique = true)

    def * = (id, name) <>(Group.tupled, Group.unapply)
  }

  // ...
}