Tan Yi wrote:
I want to create a table, say:
employee_table = Table(
'employee',metadata,
Column('id',Integer,primary_key=True),
Column('name',String(255))
)
staffGroup_Table = Table(
'role',metadata,
Column('manager',None,ForeignKey('employee.id')),
Column('worker',None,ForeignKey('employee.id')),
Column('janitorr',None,ForeignKey('employee.id'))
)
metadata.create_all()
however this will generate circular dependency, I tried to use use_alt
= True with ForeignKey constraint , but no luck.
What is the correct way of creating table for this kind of situation :
a table refers to another table with a composite foreign keys on the
same column?
the name of the flag is use_alter, and there is also no circular
dependency above. employee is created first, role second. there's
also no composite foreign key represented above; a composite foreign key
is one that references a composite primary key, i.e. a primary key that
consists of more than one column.
Thank you!
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.