from sqlalchemy import func
from sqlalchemy import distinct
# count distinct project by project.name
# using a subquery
db.session.query(sqlalchemy.func.count(distinct(Project.name))).scalar()
# using filter
db.session.query(sqlalchemy.func.count(distinct(Project.name))).filter(
Project.deleted == '00'
).scalar()
# using group_by
db.session.query(sqlalchemy.func.count(distinct(Project.id))).group_by(Project.name).filter(
Project.deleted == '00'
).scalar()
sqlalchemy统计记录条数
最新推荐文章于 2024-04-02 11:45:02 发布