是否可以在普通的 sql Slick 中使用 IN 子句? [英] Is it possible to use IN clause in plain sql Slick?

问题描述

例如，我想创建以下查询:

For example, I want to create the following query:

SELECT c.* FROM Coffees c WHERE c.name IN ('robusta', 'arabica')

我的尝试失败了:

val cnames = List("robusta", "arabica")
sql""" SELECT c.* FROM Coffees c WHERE c.name IN ${cnames} """
  could not find implicit value for parameter pconv: 
  scala.slick.jdbc.SetParameter[List[String]]

是否可以在 Slick 普通 sql 查询中以某种方式使用 in 子句?

Is it possible to somehow use in clause in Slick plain sql queries?

推荐答案

我没有看到任何现成的东西来处理这个问题.你最好打赌可能是这样的:

I don't see anything out of the box to handle this. You're best bet is probably something like this:

val cnames = List("robusta", "arabica").mkString("'", "','", "'")
val query = sql""" SELECT c.* FROM Coffees c WHERE c.name IN (${cnames}) """

这篇关于是否可以在普通的 sql Slick 中使用 IN 子句?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！