-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello.
Let's say I have users, and groups of users, related by a many-to-one relationship. My data looks like this: Group1 User1 - Male User2 - Female Group2 User3 - Male User4 - Male I can query the groups, eager-loading their users to avoid the additionial queries, and iterate over the groups to dump the user list. Now, how can I keep the same data organisation (groups containing many users), but filtering users by a random criteria ? I'd like to write a query returning the following results: Group1 User1 - Male Group2 User3 - Male User4 - Male The solution we're using for now is to fetch a tuple of Group, User and then to use python itertools.groupby function to build a tree of group and users, but I'm sure sqlalchemy can provide us a more elegant solution. - -- Ronan Dunklau -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.18 (GNU/Linux) iQEcBAEBAgAGBQJOzgS8AAoJECTYLCgFy323mVQH/19akIU4bLXeXE41ulR5obV6 MVk9rOQZYujHcys4kq99xHKP1EBXTtQ9fDVYBVnwVq8bc+50DOxmMaP0qtE+Rdtt l9z1kkfmjrK+v3eIt3hUT+US4z9HV4ySshPj2uvKwxLjRLyJLKfht9J38ShWnDHr l0ABOFXTtKKhQBtNh4NlbpReXWlnSju2rCTyhtFEHVd+wIxk0fqBmTPTVupiLjOz dAz4Ce12ER0Bqbh8WuzV11TCfRnprBKe+80TtOzedYDr9oji2xFgUA1TB2m3GRCB sOEY9m4S4FRX1OCuHNc8y91IQrVLJePn+i1CAjeSm2erkBNxFIXPzwaLDyz3GCc= =uyjn -----END PGP SIGNATURE----- -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.