heres the output of:
sel = users.select(users.c.id.in_([7, 8])).alias()
sess.query(User).options(eagerload('addresses')).select_from(sel)[1]
SELECT anon_1.anon_2_id AS anon_1_anon_2_id, anon_1.anon_2_name AS
anon_1_anon_2_name, addresses_1.id AS addresses_1_id,
addresses_1.user_id AS addresses_1_user_id, addresses_1.email_address
AS addresses_1_email_address
FROM (SELECT anon_2.id AS anon_2_id, anon_2.name AS anon_2_name,
anon_2.id AS anon_2_oid
FROM (SELECT users.id AS id, users.name AS name
FROM users
WHERE users.id IN (%(users_id_1)s, %(users_id_2)s)) AS anon_2 ORDER BY
anon_2.id
LIMIT 1 OFFSET 1) AS anon_1 LEFT OUTER JOIN addresses AS addresses_1
ON anon_1.anon_2_id = addresses_1.user_id ORDER BY anon_1.anon_2_id,
addresses_1.id
thats a mouthful.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
