问题描述
我想将mongodb导出为json，这是一条记录:
I want to export mongodb as json, here is a record:
{"_id":{"$oid":"554f042c0e81bf483e4a4e2f"}, "batch":"3","bz":NumberInt(1)}
问题是当我使用json加载它时:
the problems is when I use json to loads it:
json.loads('{"_id":{"$oid":"554f042c0e81bf483e4a4e2f"}, "batch":"3","bz":NumberInt(1)}')
它返回ValueError: No JSON object could be decoded.这是因为json无法处理NumberInt(1).
it returns ValueError: No JSON object could be decoded. This is because json can not deal with NumberInt(1).
那么导出时如何将NumberInt(1)转换为1?
So how can I translate NumberInt(1) to 1 when I export?
推荐答案
[更新]如果您的mongo集合不包含NumberInt，并且mongoexport创建了一个包含NumberInt的json文档，则这是一个错误.万一有人遇到与我相同的问题，我会留下答案.
[UPDATE] IF your mongo collection does not include NumberInt, and mongoexport creates a json document that includes NumberInt, this is a bug.I leave my answer in case anyone has the same issue as I had.
似乎确实是一个错误
https://jira.mongodb.org/browse/TOOLS-741 重复的 https://jira.mongodb.org/browse/TOOLS-681 已在3.1.4中修复
https://jira.mongodb.org/browse/TOOLS-741that duplicates https://jira.mongodb.org/browse/TOOLS-681 that was fixed in 3.1.4
我使用3.1.6(最新的开发版本)进行了测试，并且可以正常工作
I tested with 3.1.6 (last dev release) and it works
这篇关于如何在不使用NumberInt(...)进行任何包装的情况下导出mongodb?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！