Any thoughts on a workaround?
On Tue, Jul 13, 2010 at 3:40 PM, Michael Bayer <mike...@zzzcomputing.com> wrote:
> that's an intricate trick which currently doesn't work with the ORM. #1852
> is added to see if there's a quick way to fix this (very likely there isn't
> something quick).
>
> You'd have to trick it using column("email") or something like that.
>
>
> On Jul 13, 2010, at 3:02 PM, Andrew Bialecki wrote:
>
>> I tried to write the following code assuming a User class with
>> first_name, last_name, and email:
>>
>> search_term = "Andrew"
>>
>> by_email = session.query(User.email.label("text"),
>> User.email.label("email")).filter(User.email.like("%%%s%%" %
>> search_term)
>> by_first_name = session.query(User.first_name.label("text"),
>> User.email.label("email")).filter(User.first_name.like("%%%s%%" %
>> search_term)
>> matches = by_email.union_all(by_first_name).all()
>>
>> with the hope that this would return rows like so:
>>
>> text email
>> ----- -------
>> and...@test.com and...@test.com
>> Andrew some.ran...@email.com
>>
>> However, I get:
>>
>> text email
>> ----- -------
>> and...@test.com and...@test.com
>> Andrew Andrew
>>
>> When I look at the SQL, the wrapper select for the UNION is wrong.
>> Any idea how to get the behavior I want? Thanks!
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "sqlalchemy" group.
>> To post to this group, send email to sqlalch...@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.
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlalch...@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.
>
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@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.
