- 如果是继承关系,查询子表,不能直接删除,需要使用add and commit
delete = mysql_store.session.query(Shop).filter_by(user_id=user_id).first()
mysql_store.session.delete(delete)
mysql_store.session.commit()
- 如果是one to many ,需要删除子表,不可以直接使用remove,需要使用cascade=“all, delete-orphan”
model.py
brands = relationship("Brand", cascade="all, delete-orphan")
logic.py
user.brands.remove(_user_brand[i])