python mongodb查询_python – MongoDB聚合/组/总和查询转换为pymongo查询

我在目标集合中有一组条目,如下所示：

{"user": "adam", "position": "attacker", "goals": 8}

{"user": "bart", "position": "midfielder", "goals": 3}

{"user": "cedric", "position": "goalkeeper", "goals": 1}

我想计算所有目标的总和.在MongoDB shell中我这样做：

> db.goals.aggregate([{$group: {_id: null, total: {$sum: "$goals"}}}])

{ "_id" : null, "total" : 12 }

现在我想在Python中使用pymongo做同样的事情.我尝试使用db.goals.aggregate()和db.goals.group(),但到目前为止没有成功.

非工作查询：

> query = db.goals.aggregate([{"$group": {"_id": None, "total": {"$sum": "$goals"}}}])

{u'ok': 1.0, u'result': []}

> db.goals.group(key=None, condition={}, initial={"sum": "goals"}, reduce="")

SyntaxError: Unexpected end of input at $group reduce setup

任何想法如何做到这一点？