sql in operator

[zkinyo]

Hey David,

Is there a way to use sql in operator in rxjava-jdbc? I would like to use it in a way that enables me to pass a List (or Set) to the builder which substitutes it for my named parameter in the sql string. If it is not possible, what is the best way to use sql in operator? I tried to google it but no result...

Thanks,
Zoltán

[davidmoten]

Hi, find jdbc example of this and I'll look at adding it as a feature. Sorry has been so long for response! Excuse my minimal help on this at the moment, much on!

[zkinyo]

No problem, I made a workaround which will be good enough for now.

Example in JDBC:
SELECT my_column FROM my_table WHERE search_column IN (?,?,?)

The problem with this is that you have to insert as many ? as the number of values you want to search for. It would be much better to put one ? and pass a Collection to insert every element of it, but it is not possible with pure JDBC.

You might be able to do it with this library tho if you could replace the ? with concatenated elements of the Collection (adding ' and , where it is necessery).