SQLAlchemy一对多关联报错求助：InvalidRequestError排查

错误原因分析 #

报错提示name 'address_from' is not defined，结合代码来看，主要存在以下几处错误：

• ForeignKey拼写错误：User模型中address_to字段的外键指向了不存在的表addess（应为address）。
• relationship的foreign_keys参数格式错误：User模型中定义关系时，foreign_keys直接使用字段名字符串，SQLAlchemy无法识别，需要指定类属性或带类名的字符串。
• 反向关系关联类错误：Address模型中定义反向关系时，错误地关联了自身（'Address'），实际应该关联'User'类。
• 反向关系命名不匹配：Address模型中第二个反向关系命名为address_to，与User模型中back_populates指定的user_address_to不对应。

修正后的代码 #

User模型 #

from config import db
from models.mixins import *
from models.decorators import *
import uuid
from sqlalchemy import Column, String, ForeignKey
from sqlalchemy.orm import relationship
from sqlalchemy.sql import func
from sqlalchemy.dialects import mysql

class User(db.Base):
    __tablename__ = 'user'

    id = Column(GUID(), primary_key=True, default=uuid.uuid4, unique=True)
    name = Column(String(255), nullable=True)
    # 修正ForeignKey的表名拼写错误
    address_to = Column(GUID(), ForeignKey('address.id'), nullable=True)
    address_from = Column(GUID(), ForeignKey('address.id'), nullable=True)

    # 修正foreign_keys参数，使用带类名的字符串
    u_address_from = relationship('Address', foreign_keys='User.address_from', 
                                  back_populates='user_address_from')
    u_address_to = relationship('Address', foreign_keys='User.address_to', 
                                back_populates='user_address_to')

Address模型 #

from config import db
from models.decorators import *
import uuid
from sqlalchemy import Column, String, ForeignKey
from sqlalchemy.orm import relationship
from sqlalchemy.sql import func
from sqlalchemy.dialects import mysql

class Address(db.Base):
    __tablename__ = 'address'

    id = Column(GUID(), primary_key=True, default=uuid.uuid4, unique=True)
    street = Column(String(64), nullable=False)
    city = Column(String(64), nullable=False)

    # 修正关联类为'User'，并匹配反向关系命名
    user_address_from = relationship('User', foreign_keys='User.address_from', 
                                     back_populates='u_address_from')
    user_address_to = relationship('User', foreign_keys='User.address_to', 
                                   back_populates='u_address_to')

说明 #

修正后，SQLAlchemy可以正确识别外键关联和反向关系，调用查询函数时就不会再出现初始化映射器的错误。

内容的提问来源于stack exchange，提问作者Sheriff 505