python - $ne 不适用于 pymongo

Question

我的 $ne : "" 无法与 pymongo 正常工作。

hashtable['ACR-WEB-01']=db.logs.find({"host_name" : "WEB-01"}, {"service_description": {"$ne" : ""}}).distinct("service_description")
print hashtable['ACR-WEB-01']

打印结果为:

[u'Disks', u'', u'Mem', u'VM Tools', u'Cpu', u'vm-alarm-CPU', u'vm-alarm-MEM', u'vm-alarm-VMTOOLS', u'Uptime']

如您所见，我明白u''为什么？

如果我直接在 mongodb 中执行它，它会起作用:

> db.logs.distinct( "service_description" , { "host_name" : "WEB-01", service_description: {$ne : ""}} )
[
    "Cpu",
    "Disks",
    "Mem",
    "Uptime",
    "VM Tools",
    "vm-alarm-CPU",
    "vm-alarm-MEM",
    "vm-alarm-VMTOOLS"
]

感谢您的帮助

Answer 1

您需要将两个 find 查询项放入相同哈希对象中:

hashtable['ACR-WEB-01']=db.logs
    .find({"host_name": "WEB-01", "service_description": {"$ne" : ""}})
    .distinct("service_description")