[sqlalchemy] Re: Queries in historical db's, where the join depends on having an overlapping timestamp (or other filter condition)

I believe that I asked Michael a similar question, in a different way, a few days ago. The answer was to use contains_eager. I used something like the following and it worked great to query what the membership of a group was at a specific time. The two tables remain simple, related by a

[sqlalchemy] controlling the contents of a collection in an ORM object

I want to maintain some groups that change over time. Specifically, I have a group table with group names and other attributes. Every time an item enters a group, a record is created in an item table with an entry timestamp (and some other attributes). Whenever an item leaves a group, its item

[sqlalchemy] Re: controlling the contents of a collection in an ORM object

Thank you very much. contains_eager does the trick. --~--~-~--~~~---~--~~ 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