Re: [sqlalchemy] multiple many-to-one to same class

2011-11-29 Thread Michael Bayer
On Nov 29, 2011, at 11:19 AM, Nathan Finstein wrote: > "teacher" has two many-to-one relationships with "student". > A teacher can have a favorite student and a worst student. > A student can be the favorite (or worst) of many teachers > > 1) Error is not surprising, since there is nothing to in

[sqlalchemy] multiple many-to-one to same class

2011-11-29 Thread Nathan Finstein
"teacher" has two many-to-one relationships with "student". A teacher can have a favorite student and a worst student. A student can be the favorite (or worst) of many teachers 1) Error is not surprising, since there is nothing to indicate whether "favorite" relationship uses "favorite_id" Foreign