[sqlalchemy] Re: join_depth in two directions with adjancency lists

2008-12-26 Thread Wichert Akkerman
On 12/25/08 4:37 PM, Michael Bayer wrote: On Dec 25, 2008, at 6:45 AM, Wichert Akkerman wrote: I have a reasonably standard hierarchical datastructure which I'm trying to store in SQL. The basic model looks like this: class Page(BaseObject): __tablename__ = page id =

[sqlalchemy] Re: join_depth in two directions with adjancency lists

2008-12-26 Thread Michael Bayer
On Dec 26, 2008, at 5:08 AM, Wichert Akkerman wrote: It did not though: I only got the direct parent. if you could save me some time and post a full example that I can run that would be helpful. To roll those up into a single set of result columns in a single SQL statement would be

[sqlalchemy] Re: join_depth in two directions with adjancency lists

2008-12-25 Thread Michael Bayer
On Dec 25, 2008, at 6:45 AM, Wichert Akkerman wrote: I have a reasonably standard hierarchical datastructure which I'm trying to store in SQL. The basic model looks like this: class Page(BaseObject): __tablename__ = page id = schema.Column(types.Integer(), primary_key=True,