On Wed, Jan 26, 2011 at 8:17 PM, Yang Zhang <yanghates...@gmail.com> wrote:
> Is there something similar to the .get() method in SqlSoup and Session > but which allows me to fetch more than one object by ID, so as to save > on round trips to the DB? (This could be done by composing using the > IN operator in SQL.) Thanks in advance. Did you try something like session.query(MyClass).filter(MyClass.id.in_([...list of ids...])).all() -- Mike Conley -- 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.