zipcode_meta_join_subquery = session.query(us_zipcode_table.c.city_id,
us_zipcode_table.c.zipcode_population,
us_zipcode_table.c.average_house_value).group_by(us_zipc
ode_table.c.city_id).subquery()
mapper(USCity, us_city_table, properties={
'state':relation(USState, backref=backref('cities')),
'zipcode_meta':relation(USZipCode, primaryjoin=
(zipcode_meta_join_subquery,
zipcode_meta_join_subquery.c.city_id==us_city_table.c.city_id))
})
The above code obviously doesn't work. How do I add a join to the
above subquery in my mapper?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
