在Pymongo中查询纠结数组 [英] Query tangled array in Pymongo

问题描述

我正在尝试查询一个非常复杂的集合.

I am trying to query a very tangled collection.

架构:

{'tags': {'variables': [{'value': '3x9', 'var_name': 's'},
                     {'value': '12:00AM', 'var_name': 'x'},
                     {'value': 'goog', 'var_name': 'y'}]},
                     'url': 'https://www.google.com'}]

查询:

res = mycol.aggregate([{"$unwind":"$tags"}
     ,{'$match': {'tags.tag.name':'A A', 'aR': 98765}}
     ,{'$project': {'url': 1, 'tags.vars': 1, '_id': 0}},])


res = list(res)
for x in res: 
    print(res)

结果:

{'tags': {'variables': [{'value': '3x9', 'var_name': 's'},
                     {'value': '12:00AM', 'var_name': 'x'},
                     {'value': 'goog', 'var_name': 'y'}]},
                     'url': 'https://www.google.com'}]

预期结果:

[{'value': '3x9', 'var_name': 's'},
{'value': '12:00AM', 'var_name': 'x'},
{'value': 'goog', 'var_name': 'y'},
'url': 'https://www.google.com']

我将其用作HttpResponse，并将其用作JSON对象.

I will use it as a HttpResponse and use it as a JSON object.

请帮助！

推荐答案

您能否只说res ['tags'] ['variables']而不是res = list(res)?

Can you just say res['tags']['variables'] instead of res = list(res)?

这篇关于在Pymongo中查询纠结数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！