Slick 3.1.x.中的不正确更新语句

Question

我有以下光滑的动作，该动作更新了2016年的所有日期，不包括星期六和周日

  val action = dates.filter( d => d.year === 2016 && 
            d.weekDay != "Sat" && d.weekDay != "Sun").map(x => (x.isHoliday)).update(0)
  Await.result(db.run(action), Duration.Inf).value
  val sql = action.statements.head
  println(sql)

问题是该更新无法按预期工作，SQL PRINTS

update `dates` set `is_holiday` = ? where ((`dates`.`year` = 2016) and true) and true

何时应该打印

update `dates` set `is_holiday` = ? where `dates`.`year` = 2016 
        and `dates`.`week_day` != 'Sat' and `dates`.`week_day` != 'Sun'

此语句有什么问题？

Answer 1

我相信您是在意外使用Scala !=操作员而不是光滑的=!=函数。尝试以下操作：

val action = dates.filter(d => d.year === 2016 && d.weekDay =!= "Sat" && d.weekDay =!= "Sun").map(x => (x.isHoliday)).update(0)

您也可以尝试以下方法：

val weekendDays = Set("Sat", "Sun")
val action = dates.filter(d => d.year === 2016 && !d.weekDay.inSet(weekendDays))