On Jun 24, 2007, at 10:52 PM, Hong Yuan wrote:
> mapper(Address, address)
>
> person_address_mapper = mapper(PersonAddress, person_address,
> properties={'address': relation(Address, lazy=False)}
> )
>
> personmapper = mapper(Person, person,
> properties={
> 'addresses': relation(person_address_mapper,
> association=PersonAddress,
> lazy=True)
> })
>
the "assocaition" argument is deprecated; you dont need it here.
>
> persons =
> session.query(Person).join('addresses').select(address.c.street.op
> ('like')
> ('Street%'))
session.query(Person).join(['addresses', 'address']).filter
(address.c.street.like('Street%')).list()
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
