文章内容
2019/7/10 15:27:40,作 者: 黄兵
SQLAlchemy 求和
最近需要计算符合条件列的总和，具体查询如下：
from sqlalchemy.sql import func
total_price = db.session.query(func.sum(UserShoppingCart.price))\
.filter_by(user_id=user)\
.first()通过用户ID过滤查询条件，之后统计价格。
另外一个查询实例：
from sqlalchemy.sql import func
def search(self, **kwds):
'''Finds entities in the table that satisfy certain criteria.
:param order: Order rows by specified column.
:type order: string
'''
request = Session.query(func.sum(ckanextRequestDataCounters.requests))\
.all()
replied = Session.query(func.sum(ckanextRequestDataCounters.replied))\
.all()
declined_sum = func.sum(ckanextRequestDataCounters.declined)
declined = Session.query(declined_sum).all()
shared = Session.query(func.sum(ckanextRequestDataCounters.shared))\
.all()
counters = {
'requests': request,
'replied': replied,
'declined': declined,
'shared': shared
}
return counters
评论列表