Scala SlickScala 數(shù)據(jù)庫(kù)訪問(wèn)庫(kù)

Slick 是 TypeSafe 推出的 Scala 數(shù)據(jù)庫(kù)訪問(wèn)庫(kù)。開發(fā)者可以使用 Scala 語(yǔ)言風(fēng)格來(lái)編寫數(shù)據(jù)查詢，而不是用 SQL，示例代碼：

object Coffees extends Table[(String, Int, Double)]("COFFEES") {
  def name = column[String]("COF_NAME", O.PrimaryKey)
  def supID = column[Int]("SUP_ID")
  def price = column[Double]("PRICE")
  def * = name ~ supID ~ price
}
Coffees.insertAll(
  ("Colombian", 101, 7.99),
  ("Colombian_Decaf", 101, 8.99),
  ("French_Roast_Decaf", 49, 9.99)
) 
val q = for {
  c <- Coffees if c.supID === 101
  // ^ comparing Rep[Int] to Rep[Int]!
} yield (c.name, c.price)

println(q.selectStatement)

q.foreach { case (n, p) => println(n + ": " + p) }