How can I use a list , tuple or any iterable in an in clause using the
plain sql expression and bindparams.
e.g.
engine.execute(sql.expression.text('''
select * from users where id in :ids
'''), ids=[1,2,3,4])
what do I need to change to make this work.
I tried this, and it generates not sql:
engine.execute(sql.expression.text('''
select * from users where id in (:ids)
'''), ids='1,2,3,4')
Any ideas to make this just work? I would prefer to use the bindparams
as above.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
