I posted this to Stack Overflow without any luck. Seeing that MB
hangs around here, this should be the first place I try.
I'm using SA 0.6.6, Python 2.66 and Postgres 8.3.
I have certain queries which require somewhat complex security check
that can be handled with a WITH RECURSIVE query. What I'm trying to do
is combine a textual query with a query object so I can apply filters
as necessary.
My original thought was was to create my text query as a subquery and
then combine that with the user's query and filters. Unfortunately,
this isn't working.
subquery = session.query(sharedFilterAlias).\
from_statement(sharedFilterQuery).subquery()
This results in this error: AttributeError: 'Annotated_TextClause'
object has no attribute 'alias'
Is there anyway to combine a textual query with SQLAlchemy's query
object?
I just need to apply the Query and filter to my text query with
something like: where Entity.id in (textQueryResult).
--
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.
