Flask-SQLAlchemy初始化报错：'Table'对象无'sender_id'属性

错误信息 #

sqlalchemy.exc.InvalidRequestError: One or more mappers failed to initialize - can't proceed with initialization of other mappers. Triggering mapper: 'mapped class User->users'. Original exception was: 'Table' object has no attribute 'sender_id'

关联模型代码 #

User模型 #

class User(UserMixin, db.Model):
    __tablename__ = 'users'
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(64), index=True, unique=True)
    email = db.Column(db.String(120), index=True, unique=True)
    password_hash = db.Column(db.String(128))
    about_me = db.Column(db.String(140))
    last_seen = db.Column(db.DateTime, default=datetime.utcnow)
    #relations
    posts = db.relationship('Post', back_populates='author', lazy='dynamic')
    messages_sent = db.relationship('Message', foreign_keys='messages.sender_id',
                                    back_populates='author', lazy='dynamic')
    messages_received = db.relationship('Message', foreign_keys='messages.recipient_id',
                                        back_populates='recipient', lazy='dynamic')
    last_message_read_time = db.Column(db.DateTime)
    followed = db.relationship(
        'User', secondary=followers,
        primaryjoin=(followers.c.follower_id == id),
        secondaryjoin=(followers.c.followed_id == id),
        backref=db.backref('followers', lazy='dynamic'), lazy='dynamic')

    def __repr__(self):
        return '<User {}>'.format(self.username)

Message模型 #

class Message(db.Model):
    __tablename__ = 'messages'
    id = db.Column(db.Integer, primary_key=True)
    sender_id = db.Column(db.Integer, db.ForeignKey('users.id'))
    recipient_id = db.Column(db.Integer, db.ForeignKey('users.id'))
    body = db.Column(db.String(140))
    timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow)
    #relations
    author = db.relationship('User', back_populates='messages_sent', lazy='dynamic')
    recipient = db.relationship('User', back_populates='messages_received', lazy='dynamic')

    def __repr__(self):
        return '<Message {}>'.format(self.body)

已尝试的排查步骤 #

• 确认数据库中messages表存在sender_id字段
• 修改foreign_keys参数为Message.sender_id
• 调整关联的lazy属性

以上操作均未解决错误。

解决方案 #

问题根源在于User模型中foreign_keys参数的写法错误：

当使用字符串形式指定外键时，需要引用模型类的属性名，而非数据库表的字段名。原代码中使用小写的messages.sender_id会被SQLAlchemy识别为数据库表对象，而表对象无法直接通过.sender_id访问字段（正确表字段访问方式是messages.c.sender_id），因此触发错误。

修改User模型中的关联代码，将foreign_keys参数改为大写开头的Message.sender_id：

messages_sent = db.relationship('Message', foreign_keys='Message.sender_id',
                                back_populates='author', lazy='dynamic')
messages_received = db.relationship('Message', foreign_keys='Message.recipient_id',
                                    back_populates='recipient', lazy='dynamic')

修改后，SQLAlchemy会正确识别到Message模型的sender_id和recipient_id属性，完成映射初始化。

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