使用Scala Slick从SQL db中检索日期位于上个月或上周的所有记录。

import slick.jdbc.MySQLProfile.api._
import java.time.LocalDate

case class Record(id: Int, date: LocalDate, data: String)

class Records(tag: Tag) extends Table[Record](tag, "records") {
  def id = column[Int]("id", O.PrimaryKey)
  def date = column[LocalDate]("date")
  def data = column[String]("data")

  def * = (id, date, data).mapTo[Record]
}

val records = TableQuery[Records]

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

val lastMonth = LocalDate.now().minusMonths(1)
val lastWeek = LocalDate.now().minusWeeks(1)

val query = records.filter(record => record.date >= lastMonth && record.date <= lastWeek)

val result = db.run(query.result)