sqlalchemy 的表关联和联级删除

from app import db domains_accounts_relation =
db.Table('domains_accounts_relation', db.Column('domain_id', db.String(8),
db.ForeignKey('domain_domains.id', ondelete='CASCADE'), primary_key=True),
db.Column('notice_user_id', db.Integer, db.ForeignKey('account_accounts.id',
ondelete='CASCADE'), primary_key=True) ) class Domains(db.Model): __tablename__
= 'domain_domains' id = db.Column(db.String(8), primary_key=True) name =
db.Column(db.String(64)) creation_date = db.Column(db.DateTime)
registry_expiry_date = db.Column(db.DateTime) expiration_notice =
db.Column(db.Boolean) notice_users = db.relationship('Account',
secondary=domains_accounts_relation, backref=db.backref('notice_user_domains',
lazy='dynamic'), lazy='dynamic', cascade='all, delete', passive_deletes=True )



relationship中设置cascade='all, delete-orphan' 与 passive_deletes = True，
ForeignKey中设置ondelete = 'CASCADE'。
即可完成删除User的同时，删除与该user对象相关的task对象。

• « 上一篇：python变量和变量赋值的几种形式
• » 下一篇：人工智能名词表 持续更新