SQLAlchemy在删除有外键约束的记录时，外键约束未起作用，何解？

class maintenanceZone(Base):
    __tablename__ = "maintenanceZone"  # 区域信息
    __table_args__ = {
        "mysql_engine": "InnoDB",
    }

    id = sa.Column(sa.Integer(), primary_key=True, autoincrement=True)
    cityName = sa.Column(sa.String(100), nullable=False )
    countyName = sa.Column(sa.String(100), nullable=False)




class maintainerInfo(Base):
    __tablename__ = "maintainerInfo"  #人员信息
    __table_args__ = {
        "mysql_engine": "InnoDB",
    }

    id = sa.Column(sa.Integer(), primary_key=True, autoincrement=True)
    userName = sa.Column(sa.String(100), unique=True, nullable=False, comment="人员姓名")
    userPhone = sa.Column(sa.String(20), unique=True, comment="人员联系电话")
    zoneID = sa.Column(sa.Integer(),
                       sa.ForeignKey("maintenanceZone.id", ondelete="RESTRICT", onupdate="CASCADE"), comment="区域ID")

    zoneinfo = relationship("maintenanceZone", backref=backref('maintainerInfo', order_by=id))
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.

zoneOne = session.query(maintenanceZone).filter(maintenanceZone.cityName == old_city,maintenanceZone.countyName == old_country).one()
session.delete(zoneOne)
session.commit()
1.
2.
3.

dburl = "mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8".format(dbIni["user"], dbIni["password"],dbIni["host"], dbIni["port"], dbIni["db"])
engine = create_engine(
            url=dburl,
            max_overflow=0, 
            pool_size=5,
            pool_timeout=20,
            pool_recycle=-1,
        )
1.
2.
3.
4.
5.
6.
7.
8.

2022-06-24 18:12:03,245 INFO sqlalchemy.engine.Engine [generated in 0.00021s] {'param_1': 19}
2022-06-24 18:12:03,249 INFO sqlalchemy.engine.Engine UPDATE `maintainerInfo` SET `zoneID`=%(zoneID)s WHERE `maintainerInfo`.id = %(maintainerInfo_id)s
2022-06-24 18:12:03,249 INFO sqlalchemy.engine.Engine [generated in 0.00021s] {'zoneID': None, 'maintainerInfo_id': 1}
2022-06-24 18:12:03,267 INFO sqlalchemy.engine.Engine DELETE FROM `maintenanceZone` WHERE `maintenanceZone`.id = %(id)s
2022-06-24 18:12:03,267 INFO sqlalchemy.engine.Engine [generated in 0.00016s] {'id': 19}
2022-06-24 18:12:03,268 INFO sqlalchemy.engine.Engine COMMIT
1.
2.
3.
4.
5.
6.