essential-slick icon indicating copy to clipboard operation
essential-slick copied to clipboard

Plain SQL and IN clauses

Open d6y opened this issue 10 years ago • 2 comments

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]

d6y avatar Sep 19 '15 09:09 d6y

This feels like a resonable way to resolve this:

https://github.com/d6y/plain-in

d6y avatar Sep 29 '20 08:09 d6y

See also: https://github.com/tarao/slick-jdbc-extension-scala/

d6y avatar Sep 29 '20 09:09 d6y