slqalchemy 多个外键指向同一个表报错

supertree_l

于 2020-02-04 19:35:33 发布

阅读量934

点赞数

CC 4.0 BY-SA版权

分类专栏： Python

本文链接：https://blog.youkuaiyun.com/supertree_l/article/details/104173838

在使用SQLAlchemy时遇到错误，当多个外键指向同一个表时，系统无法确定关联条件。错误信息提示需指定'foreign_keys'参数来明确外键列。解决方案是明确设置foreign_keys参数，列出所有关联到父表的外键列。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ERROR in server: Could not determine join condition between parent/child tables on relationship TestUser.tasks - there are multiple foreign key paths linking the tables. Specify the 'foreign_keys' argument, providing a list of those columns which should be counted as containing a foreign key reference to the parent table.
Traceback (most recent call last):

直接贴出解决方案

class TestUser(db.Model):
    __tablename__ = 'testUsers'
    id = db.Column(db.Integer, primary_key=True)
    # tasks = db.relationship('TestTask', back_populates='initiator')
    # orders = db.relationship('TestTask', back_populates='errandor')
   
class TestTask(db.Model):
    __tablename__ = 'testTasks'
    id = db.Column(db.Integer, primary_key=True)
    initiatorId = db.Column(db.Integer, db.ForeignKey("testUsers.id"))
    errandorId = db.Column(db.Integer, db.ForeignKey("testUsers.id"))
    init