def analysis_sku(sku):
'''
根据sku查询所需要数据
:param sku:
:return:
'''
total_qty_picked = session.query(func.sum(Cvg.qty_picked)).filter(Cvg.aws_sku==sku).scalar()
print('total qty picked',total_qty_picked)
session.query(func.sum(Money.amount)).filter(.....).scalar()
参考
https://blog.csdn.net/weixin_43303732/article/details/86476069