Re: [sqlalchemy] Trying to apply result of raw sql to an 'in_' clause of mapped table

[Ralph Heinkel]

Hi Michael,

thanks for your reply.
but with that aside, you can use text():

from sqlalchemy import text, bindparam
Person.status_id.in_(text("select status_id ...",
bindparams=[bindparam('n1', 'hired')]))

and the bind values you can add later too:

from sqlalchemy import text
Person.status_id.in_(text("select status_id ...")).params(n1='hired')


The latter was my favorite, but this seems to fail with

[...]
  File 
"/usr/local/lib/python2.7/site-packages/SQLAlchemy-0.5.8-py2.7.egg/sqlalchemy/sql/expression.py", 
line 1390, in in_
    return self._in_impl(operators.in_op, operators.notin_op, other)
  File 
"/usr/local/lib/python2.7/site-packages/SQLAlchemy-0.5.8-py2.7.egg/sqlalchemy/sql/expression.py", 
line 1409, in _in_impl
    for o in seq_or_selectable:
TypeError: '_TextClause' object is not iterable

Any idea how to fix this?

Thanks,

Ralph

--
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.