SQLAlchemy多外键关联报错AmbiguousForeignKeysError求助

错误原因在于Point类的反向关联（start_point和finish_point）未明确指定对应外键列，导致SQLAlchemy无法区分两条关联的外键路径。虽然Route类的正向关联已配置foreign_keys，但反向关联也需要同步指定匹配规则。

修改后的完整代码如下：

from sqlalchemy import ForeignKey, String
from sqlalchemy.orm import Mapped, mapped_column, relationship, DeclarativeBase
from typing_extensions import Annotated

intpk = Annotated[int, mapped_column(primary_key=True)]
str100 = Annotated[str, mapped_column(String(100))]

class Base(DeclarativeBase):
    pass

class Point(Base):
    __tablename__ = 'point'

    id_point: Mapped[intpk]
    name_point: Mapped[str100] = mapped_column(unique=True)
    cost: Mapped[int]

    # 反向关联指定对应外键列，用字符串避免循环引用
    start_point: Mapped[list['Route']] = relationship(
        back_populates='point_start',
        foreign_keys='[Route.id_start_point]'
    )
    finish_point: Mapped[list['Route']] = relationship(
        back_populates='finish_point',
        foreign_keys='[Route.id_finish_point]'
    )


class Route(Base):
    __tablename__ = 'route'

    id_route: Mapped[intpk]
    id_start_point: Mapped[int] = mapped_column(ForeignKey('point.id_point'))
    id_finish_point: Mapped[int] = mapped_column(ForeignKey('point.id_point'))
    distance: Mapped[int]

    point_start: Mapped['Point'] = relationship(
        back_populates='start_point',
        foreign_keys=[id_start_point]
    )
    point_finish: Mapped['Point'] = relationship(
        back_populates='finish_point',
        foreign_keys=[id_finish_point]
    )

关键修改点：

• 在Point类的两个反向关联中，通过foreign_keys参数明确绑定Route表对应的外键列，让SQLAlchemy能准确匹配正向/反向关联的对应关系
• 使用字符串形式'[Route.id_start_point]'是因为Route类定义在Point之后，避免循环引用报错

内容的提问来源于stack exchange，提问作者Николай