mysql - Slick:如何从 MySQL 读取 Blob？

Question

我有一个 MySQL 表映射为

class HealthReport(tag: Tag) extends Table[(Int, Int, Int, String, Timestamp, Blob)](tag, "LogProcessorHealthReport") {

  def id = column[Int]("id")
  def usersId = column[Int]("Users_Id")
  def tenantId = column[Int]("Tenant_Id")
  def ecId = column[String]("EcId")
  def reportedOn = column[Timestamp]("ReportedOn")
  def healthInfo = column[Blob]("HealthInfo")

  def * = (id, usersId, tenantId, ecId, reportedOn, healthInfo)
}

我想读取healthInfo的内容，我该怎么做？

谢谢

Answer 1

光滑 2:

import slick.driver.MySQLDriver.simple._

val db = Database.forConfig("db")
val fourthHealthInfo: Option[Blob] = db withSession { implicit session =>
  TableQuery[HealthReport].filter(_.id === 4).map(_.healthInfo).list.headOption
}
val healthInfos: List[Blob] = db withSession { implicit session =>
  TableQuery[HealthReport].map(_.healthInfo).list
}

光滑 3:

import slick.driver.MySQLDriver.api._

val db = Database.forConfig("db")
val fourthHealthInfo: Future[Option[Blob]] = db run {
  TableQuery[HealthReport].filter(_.id === 4).map(_.healthInfo).result.headOption
}
val healthInfos: Future[Seq[Blob]] = db run {
  TableQuery[HealthReport].map(_.healthInfo).result
}