Flask-Marshmallow关联查询返回空对象及ma.Nested导入问题求助

一、查询Author时关联Books返回空值的问题及解决 #

问题原因 #

1. SQLAlchemy懒加载机制：默认情况下，db.relationship采用懒加载（lazy='select'），执行Author.query.all()时不会自动加载关联的Book数据。序列化dump操作时，数据库上下文已结束，无法触发懒加载查询，导致books字段为空。
2. 虽通过Book模型的backref="books"在Author上自动创建了关联属性，但未显式定义关系可能增加序列化时的识别风险（核心问题仍为懒加载）。

解决方法 #

方法1：查询时预加载关联数据（推荐）

使用joinedload预加载books关联，确保查询时一次性获取所有所需数据：

from sqlalchemy.orm import joinedload

@app.route('/', methods=["GET"])
def get_hello_world():
    queryDB = Author.query.options(joinedload(Author.books)).all()
    result = author_schema.dump(queryDB)
    print(result)
    return jsonify(result)

方法2：修改关系的懒加载属性

在Book模型的关联中设置lazy='joined'，让查询Author时自动加载关联的books：

# 修改Book模型的关联定义
author = db.relationship("Author", backref=db.backref("books", lazy='joined'))

或显式在Author模型中定义关系（更清晰）：

class Author(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(255))
    # 显式定义关联，指定懒加载方式
    books = db.relationship("Book", backref="author", lazy='joined')

# Book模型仅保留外键即可
class Book(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(255))
    author_id = db.Column(db.Integer, db.ForeignKey("author.id"))

方法3：配置Schema的关联包含

在AuthorSchema的Meta类中添加include_relationships=True，配合正确的关系定义使用：

class AuthorSchema(ma.SQLAlchemySchema):
    class Meta:
        model = Author
        include_relationships = True

    id = ma.auto_field()
    name = ma.auto_field()
    books = ma.Nested("BookSchema", many=True)

二、PyCharm无法识别ma.Nested()的问题及解决 #

问题原因 #

Nested是marshmallow核心库的类，而非flask_marshmallow特有。虽可通过ma（Marshmallow实例）访问，但PyCharm的类型提示无法正确识别实例属性。

解决方法 #

方法1：显式导入Nested

直接从marshmallow导入Nested替换ma.Nested：

from marshmallow import Nested

class AuthorSchema(ma.SQLAlchemySchema):
    class Meta:
        model = Author

    id = ma.auto_field()
    name = ma.auto_field()
    books = Nested("BookSchema", many=True)

方法2：添加类型提示（可选）

若坚持使用ma.Nested，给ma变量添加类型提示帮助PyCharm识别：

from flask_marshmallow import Marshmallow

ma: Marshmallow = Marshmallow(app)

完整修正代码示例 #

from flask import Flask, jsonify
from flask_sqlalchemy import SQLAlchemy
from flask_marshmallow import Marshmallow
from marshmallow import Nested
from sqlalchemy.orm import joinedload

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///test.db'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False

db = SQLAlchemy(app)
ma = Marshmallow(app)

class Author(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(255))
    books = db.relationship("Book", backref="author", lazy='select')

class Book(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(255))
    author_id = db.Column(db.Integer, db.ForeignKey("author.id"))

class BookSchema(ma.SQLAlchemySchema):
    class Meta:
        model = Book
        include_fk = True

    id = ma.auto_field()
    title = ma.auto_field()
    author_id = ma.auto_field()

class AuthorSchema(ma.SQLAlchemySchema):
    class Meta:
        model = Author

    id = ma.auto_field()
    name = ma.auto_field()
    books = Nested(BookSchema, many=True)

with app.app_context():
    db.create_all()

author_schema = AuthorSchema(many=True)
book_schema = BookSchema(many=True)

@app.route('/', methods=["GET"])
def get_hello_world():
    queryDB = Author.query.options(joinedload(Author.books)).all()
    result = author_schema.dump(queryDB)
    print(result)
    return jsonify(result)

if __name__ == '__main__':
    app.run(debug=True)

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