I defined several tables in my module file: mymodule.py. For example I have
table T1 and T2 defined:
class T1(Base):
__tablename__ = 't1'
id = Column(Integer, primary_key = True)
name = Column(String(15))
class T2(Base):
__tablename__ = 't2'
id = Column(Integer, primary_key = True)
fid = Column(Integer, ForeignKey('t1.id', onupdate='CASCADE',
ondelete='CASCADE'), nullable = False)
name = Column(String(15))
After running 'alembic revision --autogenerate', in table 't2' migration code,
I can just see something like that:
sa.ForeignKeyConstraint(['fid'], ['t1.id'],) without clause
"onupdate='CASCADE', ondelete='CASCADE'" anymore.
So I manually added "onupdate='CASCADE', ondelete='CASCADE'", but I have more
than 100 tables. Did I miss something in my module file mymodule.py?
Thank you very much!
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sqlalchemy/-/-STd7sjYnlYJ.
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.
