2024-07-22SAWarning: relationship X will copy column Q to column P, which conflicts with relationship(s): Y在sqlalchemy之中,当一个字段对应多个relationship的时候。因为ORM要处理flush操作,而两个relationship可能都涉及到flush,以至于ORM无法同时兼顾。这时,sqlalchemy就会发出一个SAWarning。为了避免该类事件,可以通过以下配置来实现。假设,存在Parent和Child两个表,其中Child.parent_id