我正在try 设置一个postgresql表,其中有两个外键指向另一个表中的同一主键.
当我运行脚本时,我得到了错误
炼金术.exc.AmbiguousForeignKeyError:无法确定关系公司上父/子表之间的联接条件.涉众-有多个外键路径链接表.指定'foreign_keys'参数,提供应计为包含对父表的外键引用的列的列表.
这正是SQLAlchemy Documentation人中的错误,但当我复制他们提供的解决方案时,错误并没有消失.我可能做错了什么?
#The business case here is that a company can be a stakeholder in another company.
class Company(Base):
__tablename__ = 'company'
id = Column(Integer, primary_key=True)
name = Column(String(50), nullable=False)
class Stakeholder(Base):
__tablename__ = 'stakeholder'
id = Column(Integer, primary_key=True)
company_id = Column(Integer, ForeignKey('company.id'), nullable=False)
stakeholder_id = Column(Integer, ForeignKey('company.id'), nullable=False)
company = relationship("Company", foreign_keys='company_id')
stakeholder = relationship("Company", foreign_keys='stakeholder_id')
我在这里看到过类似的问题,但some of the answers建议使用primaryjoin
,但在文档中,它指出在这种情况下不需要primaryjoin
.