sqlalchemy

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()

 

 

..

posted @ 2016-10-12 17:00  HuijunZhang  阅读(169)  评论(0编辑  收藏
中国