[sqlalchemy] join_depth in two directions with adjancency lists

2008-12-25 Thread Wichert Akkerman
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, autoincrement=True) path = schema.Column(types.Unicode(128),

[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,