各位大神,菜鸟一枚我有一个文章表模型是

class Post(db.Model): __tablename__ = \'post\' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(32), unique=True) body = db.Column(db.Text) author_id = db.Column(db.Integer, db.ForeignKey(\'user.id\')) category_id = db.Column(db.Integer, db.ForeignKey(\'category.id\'))

有一个分类表模型是

class Category(db.Model): __tablename__ = \'category\' id = db.Column(db.Integer, primary_key=True) posts = db.relationship(\'Post\', backref=\'postcategory\', lazy=\'dynamic\') categoryName = db.Column(db.String(32), unique=True, index=True)

我想查出category 文章分类每个分类有多少篇文章

我有 sql 能查,语句是

SELECT COUNT(id),(SELECT categoryName from category WHERE post.category_id=category.id) as N FROM post GROUP BY category_id

请教一下各位大神,如果用 flask-sqlalchemy 怎么写呀谢谢各位了