[sqlalchemy] eager loading and a self-referential composite primary key

2011-05-06 Thread Taavi Burns
We have a multi-tenant database that includes a heirarchical layout. We tried to apply subqueryloads across the board, but tests fail in this one case. class Folder(Base): __tablename__ = 'folder' __table_args__ = ( ForeignKeyConstraint(['accountid', 'parent'],

Re: [sqlalchemy] eager loading and a self-referential composite primary key

2011-05-06 Thread Taavi Burns
Okay, that's fair. I figured it was a bit pathological, even though it's a real-world use case. :) Sorry I didn't find #1401 in my searches. Wrong keywords! I'll see if I can find some time to write up a sqla test case out of my repro script. Too bad my netbook seems dead set on corrupting my