4 Flask开发进阶：记下一次级联删除的报错：Cannot delete or update a parent row: a foreign key constraint fails

中间表

class Permission(object):
    LOGIN = 0x01
    EDITOR = 0x02
    OPERATOR = 0x04
    ADMINISTER = 0xff
    PERMISSION_MAP = {
        LOGIN: ('login', 'Login user'),
        EDITOR: ('editor', 'Editor'),
        OPERATOR: ('op', 'Operator'),
        ADMINISTER: ('admin', 'Super administrator')
    }


# 中间表
roles_users = db.Table(
    'tbl_roles_users',
    db.Column('user_id', db.Integer, ForeignKey(
        'tbl_user.id', ondelete='CASCADE', onupdate='CASCADE')),
    db.Column('role_id', db.Integer, ForeignKey(
        'tbl_role.id', ondelete='CASCADE', onupdate='CASCADE'))
)

User表和delete接口

class User(UserMixin, db.Model):
    __tablename__ = 'tbl_user'
    # __table_args__ = {'extend_existing': True}
    # User 是一个保存用户数据的 model
    id = db.Column(db.Integer, 
                    # db.ForeignKey('tbl_roles_users.user_id', onupdate="CASCADE", ondelete="CASCADE"),
                    primary_key=True,
                   nullable=False, autoincrement=True)
    name = db.Column(db.String(32), unique=True)
    _passwd = db.Column(db.String(128))
    # passwd = db.Column(db.String(128))
    company = db.Column(db.String(64))
    email = db.Column(db.String(64), unique=True)
    status = db.Column(db.Integer)
    create_time = db.Column(db.TIMESTAMP(True), nullable=False)
    exp_time = db.Column(db.String(50))
    role_id = db.Column(db.Integer)
    phone = db.Column(db.String(16))
    login_count = db.Column(db.Integer, default=0)
    last_login_ip &#