On Nov 26, 2007, at 5:19 AM, svilen wrote:

>
> hi
> i have following scenario (excluse the very brief "syntax"):
>
> class BaseAddress:
>  street = ... text
> class Office( BaseAddress):
>  some_fields
> class Home( BaseAddress):
>  other_fields
>
> class Person:
> home = reference-to-HomeAdrress
> office = reference-to-MainAdrress
> otherstuff
>
> now, i need something like
> query(Person).filter(
>       (Person.home.street == 'foo')
>       & (Person.office.street == 'bar')
> )
>
> should that be something with .join() and then restoring joinpoint, or
> what?
>

how about join() using aliased=True ?  the joinpoint gets reset each  
time you call join() again.



--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to