Hi, >1. Return a list of all User objects meeting a given criteria along >with a field that is a sum of all their order totals. > > You want to create another class and mapper, UserWithSum (or a friendlier name) that maps to an arbitrary select. http://www.sqlalchemy.org/docs/04/mappers.html#advdatamapping_mapper_selects
>2. Find all users in a given state (User.c.state == "NY") with their >sum of all order totals being greater then some number X. > > Once you've achieved 1, this is pretty straightforward. Paul --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
