essential-slick
essential-slick copied to clipboard
Plain SQL and IN clauses
Via the Mailing list:
Slick 3 does not support IN clause for plain SQL. You can use a third party lib like "com.github.tarao" %% "slick-jdbc-extension" % "0.0.3" to support it.
Check that fact, and see what the approach is if you need to do something like this...
val rooms = Seq(1,2)
val action = sql"select content where room in $rooms".as[String]
This feels like a resonable way to resolve this:
https://github.com/d6y/plain-in
See also: https://github.com/tarao/slick-jdbc-extension-scala/