mysql - 如何将此 sql 转换为 sqlalchemy 查询？ (MySQL 中的年、月、计数)

Question

如何将此sql转换为sqlalchemy代码？

SELECT YEAR(post.released_time), MONTH(post.released_time), COUNT(*) \
FROM post GROUP BY YEAR(post.released_time) AND MONTH(post.released_time)

感谢您的帮助^_^!

Answer 1

终于解决了~

db.session.query(sqlalchemy.func.year(Post.released_time), sqlalchemy.func.month(Post.released_time), sqlalchemy.func.count('*')).\
group_by(sqlalchemy.func.year(Post.released_time), sqlalchemy.func.month(Post.released_time)).all()