dbapi2 select where IN (...)

[yota.news]

hello,

I couldn't find how the dbapi2 planned to handle the sql IN statement.

ex :
SELECT * FROM table WHERE num IN (2,3,8,9);

I'd be glad to take advantage of the ? mechanism, but what about
tuples !

execute("""SELECT * FROM table WHERE num IN ?;""" ,
((2,3,8,9),)) ...fail...

what would be the most pythonic way to do this ?

 

[Gerhard Häring]

hello,

I couldn't find how the dbapi2 planned to handle the sql IN statement.

ex :
SELECT * FROM table WHERE num IN (2,3,8,9);

I'd be glad to take advantage of the ? mechanism, but what about
tuples !

execute("""SELECT * FROM table WHERE num IN ?;""" ,
((2,3,8,9),)) ...fail... [...]

You cannot use parameter binding when the number of parameters is
unknown in advance. So you'll have to create this part of the SQL query
differently.

For example:

ids = [2, 3, 8, 9]
in_clause = " (" + ",".join([str(id) for id in ids]) + ")"
query = "select * from table where num in" + in_clause

-- Gerhard