[sqlalchemy] Self-referencing table without Foreign-Key SQLAlchemy

2011-03-30 Thread Mene
Hello, often when you have a table with selfrefernece, say in a tree, you have an attribute as a foreign key, which is pointing to the primary key of the table. (like in the Adjacency List Relationships example from the docs) However, I have a natural key, which works like this: is the root a,

Re: [sqlalchemy] Self-referencing table without Foreign-Key SQLAlchemy

2011-03-30 Thread Michael Bayer
On Mar 30, 2011, at 2:58 PM, Mene wrote: Hello, often when you have a table with selfrefernece, say in a tree, you have an attribute as a foreign key, which is pointing to the primary key of the table. (like in the Adjacency List Relationships example from the docs) However, I have a