[sqlalchemy] Re: Multiple self-referential relations

2009-05-19 Thread Michael Bayer
because SurveySession extends from TreeNode, you have to disambiguate SurveySession.id from TreeNode.id: class SurveySession(TreeNode): __tablename__ = "session" __mapper_args__ = dict(polymorphic_identity="session") survey_id = schema.Column('id', types.Integer(), primary_key=True

[sqlalchemy] Re: Multiple self-referential relations

2009-05-19 Thread Wichert Akkerman
Previously Michael Bayer wrote: > > > On May 18, 2009, at 7:01 AM, Wichert Akkerman wrote: > > > > >session = orm.relation("SurveySession", cascade="all", > >remote_side=["SurveySession.id"], > >primaryjoin="SurveySession.id==TreeNode.session_id") > >parent = orm

[sqlalchemy] Re: Multiple self-referential relations

2009-05-19 Thread Michael Bayer
On May 18, 2009, at 7:01 AM, Wichert Akkerman wrote: > >session = orm.relation("SurveySession", cascade="all", >remote_side=["SurveySession.id"], >primaryjoin="SurveySession.id==TreeNode.session_id") >parent = orm.relation("TreeNode", cascade="all", >r