Let's see.
> #association table
> user_group_table = Table('t_user_group', metadata,
> Column('user_id', Integer, ForeignKey('t_user.user_id',
> onupdate="CASCADE", ondelete="CASCADE")),
> Column('group_id', Integer, ForeignKey('t_group.group_id',
> onupdate="CASCADE", ondelete="CASCADE")),
> Column('project_id', Integer, ForeignKey('t_project.project_id',
> onupdate="CASCADE", ondelete="CASCADE"))
> )
1. Your table has no primary key.
2. Your table has 3 assotiatin columns. I attempt to avoid 3 columns
in assotiaition table. If I have more than 2 columns, I use surrogate
primary key.
First of all, try:
user_group_table = Table('t_user_group', metadata,
Column('user_id', Integer, ForeignKey('t_user.user_id',
onupdate="CASCADE", ondelete="CASCADE"), primary_key=True),
Column('group_id', Integer, ForeignKey('t_group.group_id',
onupdate="CASCADE", ondelete="CASCADE"), primary_key=True),
Column('project_id', Integer, ForeignKey('t_project.project_id',
onupdate="CASCADE", ondelete="CASCADE"), primary_key=True)
)
Maybe it would be enough.
If not, try another table:
user_group_table = Table('t_user_group', metadata,
Column('id', Integer, autoincrement=True, primary_key=True),
Column('user_id', Integer, ForeignKey('t_user.user_id',
onupdate="CASCADE", ondelete="CASCADE")),
Column('group_id', Integer, ForeignKey('t_group.group_id',
onupdate="CASCADE", ondelete="CASCADE")),
Column('project_id', Integer, ForeignKey('t_project.project_id',
onupdate="CASCADE", ondelete="CASCADE"))
)
I hope, it will be useful info.
Maxim.
--
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears?hl=en.
