On Jul 17, 2009, at 4:07 PM, AF wrote:
>
> Hello,
>
>
> I have tables: Users & Departments. (SQlite)
>
> Each "User" is assigned to one Department. (User.dept_id =
> Department.id )
>
> Now, I want to make once User in each Dept the "default user".
>
> As in:
> Department.default_user_id = User.id
> i.,e. Column('default_user_id', ForeignKey('users.id'))
>
> However I get a CircularDependencyError from SQLAlchemy.
>
> Any ideas?
please see
http://www.sqlalchemy.org/docs/05/mappers.html#rows-that-point-to-themselves-mutually-dependent-rows
>
>
> Thank you,
> :)
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---