why dont you try:
query(Post.id, Post.user_id).from_statement(statement1.union
(statement2))
?
On Sep 8, 2009, at 8:27 PM, Seth wrote:
>
> Michael,
>
> I was using SA 0.5.1. Upgrading to 0.5.5 resolved the AttributeError.
>
> I am, however, having one final issue with my query:
>
>>>> users = DBSession.query(Post.id.label('post_id'),
>>>> Post.user_id.label('user_id')).union(Discussion.__table__.select
>>>> ().with_only_columns(['post_id', 'user_id']),
>>>> DiscussionComment.__table__.select().with_only_columns
>>>> (['post_id', 'user_id']))
>
>>>> print users
> SELECT anon_1.post_id AS post_id, anon_1.user_id AS user_id
> FROM (SELECT posts.id AS post_id, posts.user_id AS user_id
> FROM posts UNION SELECT post_id, user_id
> FROM discussions UNION SELECT post_id, user_id
> FROM discussion_comments) AS anon_1
>
>
> As far as I can tell, I don't really need the first "SELECT anon"; so
> this seems redundant to me (and may be a performance issues as well?).
> Can I get it to output without the aliases like:
>
> SELECT posts.id AS post_id, posts.user_id AS user_id
> FROM posts UNION SELECT post_id, user_id
> FROM discussions UNION SELECT post_id, user_id
> FROM discussion_comments
>
>
> Thanks again,
> Seth
>
>
> On Sep 8, 2:38 pm, "Michael Bayer" <mike...@zzzcomputing.com> wrote:
>> Seth wrote:
>>
>>> Thank you Michael,
>>
>>> What about using this type of thing inside another query?
>>
>>> I keep getting:
>>
>>> AttributeError: 'Select' object has no attribute '_nested_statement'
>>
>> the identifier '_nested_statement' is not part of SQLAlchemy so
>> that's
>> something on your end (or perhaps you're using an extremely old
>> version of
>> SQLAlchemy, which is never recommended).
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
