mysql 删除记录预计_如何修复SQLAlchemy：SAWarning：DELETE语句在表上预计删除1行; 0匹配...

我正在使用SQLAlchemy和PostgreSQL构建一个带有有向图数据模型的

Python Flask应用程序.我有

设置删除级联时遇到问题.虽然删除似乎在初步检查时起作用,但我不确定是否可以

可能会以我不理解的方式破坏事物,因为我收到以下警告：

SAWarning: DELETE statement on table 'edges' expected to delete 1 row(s); 0 were matched.

Please set confirm_deleted_rows=False within the mapper configuration to prevent this warning. (table.description, expected,rows_matched)

这是我的数据模型的核心.

class Node(db.Model):

__tablename__ = 'nodes'

__mapper_args__ = {

'polymorphic_on': type,

'polymorphic_identity': 'node'

}

id = Column(BigInteger, primary_key=True)

type = Column(String)

in_edges = relationship("Edge", cascade="save-update, merge, delete", foreign_keys="Edge.dest", back_populates='dest_node')

out_edges =