blocks|key|1658574|text|Javascript外壳使用MongoDB，所以答案很简单:使用JSON.stringify()。如果您的命令是db.serverStatus()，那么您可以简单地执行以下操作：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1658575|JSON.stringify(db.serverStatus())|code-block|syntax|javascript|1658576|这不会输出每个字段的正确的“严格模式”表示({+"floatApprox":+<number>+}而不是{+"$numberLong":+"<number>"+})，但是如果您关心的是获得符合标准的JSON，那么这样就可以了。|1658577|entityMap^0|W|G|1K|H|0|0|M|R|1G|T|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|N|$]]

The MongoDB shell speaks Javascript, so the answer is simple: use <code>JSON.stringify()</code>. If your command is <code>db.serverStatus()</code>, then you can simply do this:

<pre><code>JSON.stringify(db.serverStatus())
</code></pre>

This won't output the proper "strict mode" representation of each of the fields (<code>{ "floatApprox": &lt;number&gt; }</code> instead of <code>{ "$numberLong": "&lt;number&gt;" }</code>), but if what you care about is getting standards-compliant JSON out, this'll do the trick.

blocks|key|1873018|text|我还没有在mongo+shell中找到这样做的方法，但是作为一种变通方法，mongoexport可以运行查询，它的输出使用严格模式，并且可以通过管道传递到其他需要JSON输入的命令中(比如json_pp或jq)。例如，假设您有以下mongo+shell命令来运行查询，并且您希望使用该数据创建一个管道：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1873019|db.myItemsCollection.find({creationDate:+{$gte:+ISODate("2016-09-29")}}).pretty()|code-block|syntax|javascript|1873020|将mongo+shell命令转换为以下shell命令，出于示例目的，通过管道连接到`json_pp：|1873021|mongoexport+--jsonArray+-d+myDbName+-c+myItemsCollection+-q+'{"creationDate":+{"$gte":+{"$date":+"2016-09-29T00:00Z"}}}'+%7C+json_pp|1873022|您将需要将查询转换为严格模式格式，并将数据库名称和集合名称作为参数传递，并正确引用您的shell，如下所示。|1873023|entityMap^0|11|B|2M|7|2U|2|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|12|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|13|8|@]|D|@]|E|$]]]|R|$]]

I have not found a way to do this in the mongo shell, but as a workaround, <code>mongoexport</code> can run queries and its output uses strict mode and can be piped into other commands that expect JSON input (such as <code>json_pp</code> or <code>jq</code>). For example, suppose you have the following mongo shell command to run a query, and you want to create a pipeline using that data:

<pre><code>db.myItemsCollection.find({creationDate: {$gte: ISODate("2016-09-29")}}).pretty()
</code></pre>

Convert that mongo shell command into this shell command, piping for the sake of example to `json_pp:

<pre><code>mongoexport --jsonArray -d myDbName -c myItemsCollection -q '{"creationDate": {"$gte": {"$date": "2016-09-29T00:00Z"}}}' | json_pp
</code></pre>

You will need to convert the query into strict mode format, and pass the database name and collection name as arguments, as well as quote properly for your shell, as shown here.

blocks|key|1658996|text|要构建@jbyler的答案，您可以在获得数据后使用sed剥离numberLongs+-如果您使用的是linux。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1658997|mongoexport+--jsonArray+-d+dbName+-c+collection+-q+'{fieldName:+{$regex:+".*turkey.*"}}'+%7C+sed+-r+'s/\{+"[$]numberLong"+:+"([0-9]%2B)"+}/"\1"/g'+%7C+json_pp|code-block|syntax|javascript|1658998|entityMap|0|LINK|mutability|MUTABLE|url|https://www.gnu.org/software/sed/manual/sed.html^0|P|3|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

To build on the answer from @jbyler, you can strip out the numberLongs using <a href="https://www.gnu.org/software/sed/manual/sed.html" rel="nofollow noreferrer">sed</a> after you get your data - that is if you're using linux.

<pre><code>mongoexport --jsonArray -d dbName -c collection -q '{fieldName: {$regex: ".*turkey.*"}}' | sed -r 's/\{ "[$]numberLong" : "([0-9]+)" }/"\1"/g' | json_pp
</code></pre>

blocks|key|1873218|text|编辑:这将转换给定的文档，但不适用于文档列表。已将find更改为findOne。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1873219|添加|1873220|.forEach(function(results){results._id=results._id.toString();printjson(results)})`|code-block|syntax|javascript|1873221|转换为findOne()将输出有效的JSON。|1873222|示例：|1873223|db
++.users
++.findOne()
++.forEach(function+(results)+{
++++results._id+=+results._id.toString();
++++printjson(results)
++})|1873224|来源：https://www.mydbaworld.com/mongodb-shell-output-valid-json/|1873225|entityMap|0|LINK|mutability|MUTABLE|url|https://www.mydbaworld.com/mongodb-shell-output-valid-json/^0|P|4|W|7|0|0|0|3|9|0|0|0|3|1N|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@$9|13|A|14|B|C]|$9|15|A|16|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|17|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|18|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|19|8|@$9|1A|A|1B|B|C]]|D|@]|E|$]]|$1|O|3|P|5|6|7|1C|8|@]|D|@]|E|$]]|$1|Q|3|R|5|J|7|1D|8|@]|D|@]|E|$K|L]]|$1|S|3|T|5|6|7|1E|8|@]|D|@$9|1F|A|1G|1|1H]]|E|$]]|$1|U|3|-4|5|6|7|1I|8|@]|D|@]|E|$]]]|V|$W|$5|X|Y|Z|E|$10|11]]]]

EDIT: This will transform a given document, but will not work on a list of documents. Changed <code>find</code> to <code>findOne</code>.
Adding
<pre><code>.forEach(function(results){results._id=results._id.toString();printjson(results)})`
</code></pre>
to a <code>findOne()</code> will output valid JSON.
Example:
<pre><code>db
 .users
 .findOne()
 .forEach(function (results) {
 results._id = results._id.toString();
 printjson(results)
 })
</code></pre>
Source: <a href="https://www.mydbaworld.com/mongodb-shell-output-valid-json/" rel="nofollow noreferrer">https://www.mydbaworld.com/mongodb-shell-output-valid-json/</a>

I want to consume the raw output of some MongoDB commands in other programs that speak JSON. When I run commands in the mongo shell, they represent <a href="http://docs.mongodb.org/manual/reference/mongodb-extended-json/" rel="noreferrer">Extended JSON</a>, fields in "shell mode", with special fields like <code>NumberLong</code> , <code>Date</code>, and <code>Timestamp</code>. I see references in the documentation to "strict mode", but I see no way to turn it on for the shell, or a way to run commands like <code>db.serverStatus()</code> in things that do output strict JSON, like <code>mongodump</code>. How can I force Mongo to output standards-compliant JSON?

There are <a href="https://stackoverflow.com/questions/5761053/is-there-a-way-to-run-mongodb-shell-or-tojson-method-in-strict-json-mode">several</a> <a href="https://stackoverflow.com/questions/32079600/mongo-db-export-in-json-extended-mode">other</a> <a href="https://stackoverflow.com/questions/11867538/how-can-i-use-python-to-transform-mongodbs-bsondump-into-json">questions</a> on this topic, but I don't find any of their answers particularly satisfactory.

Force mongodb to output strict JSON

数据库

MongoDB

JSON

我想在其他使用JSON的程序中使用一些MongoDB命令的原始输出。当我在mongo shell中运行命令时，它们表示"shell模式“中的字段，以及NumberLong、Date和Timestamp等特殊字段。我在文档中看到对“严格模式”的引用，但我找不到在shell中打开它的方法，也没有办法在输出严格JSON的东西...

问强制mongodb输出严格的JSON
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问强制mongodb输出严格的JSONEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问强制mongodb输出严格的JSON
EN