sqlalchemy

最新推荐文章于 2024-11-27 21:17:43 发布

转载最新推荐文章于 2024-11-27 21:17:43 发布 · 52 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/zhjsll/p/5953577.html

count:

from sqlalchemy import func

# count User records, without
# using a subquery.
session.query(func.count(User.id))

# return count of user "id" grouped
# by "name"
session.query(func.count(User.id)).\
        group_by(User.name)

from sqlalchemy import distinct

# count distinct "name" values
session.query(func.count(distinct(User.name)))

下面展示一个综合的：

self.orm.session.query(NiuceModel.level,func.count(BugDetail.id).label('count')).filter(and_(BugDetail.app_id == app_id,NiuceModel.id == BugDetail.bug_name)).group_by(NiuceModel.level).all()

转载于:https://www.cnblogs.com/zhjsll/p/5953577.html