This is the documentation for self referential mapper: http://www.sqlalchemy.org/docs/mappers.html#adjacency-list-relationships
I guess you have found the recipes for doing it the declarative way. 2010/8/26 waugust <[email protected]>: > I'm guessing that the answer would be as at: > http://www.sqlalchemy.org/trac/wiki/UsageRecipes/DeclarativeSelfReferencingTable > > ? > > On Aug 26, 8:02 pm, waugust <[email protected]> wrote: >> I've been looking through the documentation and I could have sworn I >> saw it before but It seem I can't find it once more... >> I'm looking for how to set up a self referencing column like in this >> pseudo scenerio: >> >> class Action(DeclarativeBase): >> >> __tablename__ = 'action' >> >> id = Column(Integer, autoincrement=True, primary_key=True) >> >> >>> onsuccess = Column(Integer, ForeignKey=('action.id') <<< >> >> I would want to have an id of an action upon the "success" of an >> action... > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > -- Alex twitter.com/alexconrad -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
