Flask SQLAlchemy查询:从自身外键关系中过滤记录

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))
    posts = db.relationship('Post', backref='user', lazy=True)

class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(100))
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))

# 假设已经创建了Flask应用和数据库连接

# 从User模型中过滤出名字为"John"的用户的所有帖子
user = User.query.filter_by(name='John').first()
posts = user.posts

# 从Post模型中过滤出标题包含"Flask"的帖子，并获取对应的用户
posts = Post.query.filter(Post.title.like('%Flask%')).all()
users = [post.user for post in posts]