Slick有没有办法接受动态查询大小?

动态查询筛选器 slick-doc

def selectByHotelIdAndStartTimeAndEndTimeAndPerpageAndOffset(
      hotelId: Option[String],
      caseTimeFilter: Option[CaseTimeFilter[Timestamp]],
      perPage: Int,
      offset: Int
  ): Future[Seq[GoodsOrderMstinfoTRow]] =
    db.run(
      tableQ
        .filter { goodsOrderMstinfoT: GoodsOrderMstinfoT =>
          List(
            hotelId.map(goodsOrderMstinfoT.hotelid === _),
            caseTimeFilter.map(t => goodsOrderMstinfoT.createTime between (t.start, t.end))
          ).collect({ case Some(repBoolean) => repBoolean })
            .reduceLeftOption(_ && _)
            .getOrElse(true: Rep[Boolean])
        }
        .drop(offset)
        .take(perPage)
        .sortBy(_.gomtId.desc)
        .result
    )

2.第二种方式

def selectCountByHotelIdAndStartTimeAndEndTime(
      optionHotelId: Option[String],
      rmiSerialno: Option[String],
      caseTimeFilter: Option[CaseTimeFilter[Timestamp]]
  ): Future[Int] =
    db.run(
      tableQ
        .filter { RoomReviewT: RoomReviewT =>
          optionHotelId match {
            case Some(hotelid) => RoomReviewT.hotelid === hotelid
            case None          => true: Rep[Boolean]
          }
        }
        .filter { RoomReviewT: RoomReviewT =>
          rmiSerialno match {
            case Some(rmiSerialNo) => RoomReviewT.rmiSerialno === rmiSerialNo
            case None              => true: Rep[Boolean]
          }
        }
        .filter { RoomReviewT: RoomReviewT =>
          caseTimeFilter match {
            case Some(timeFilter) =>
              RoomReviewT.createTime between (timeFilter.start, timeFilter.end)
            case None => true: Rep[Boolean]
          }
        }
        .length
        .result
    )

`

take 使用常规 Option

def query(taking: Option[Int]) = {
  val baseQuery = table.filter(...).map(...)
  taking.map(size => baseQuery.take(size)) getOrElse baseQuery
}

MaybeFilter .