Is there a way to ‘pretty’ print MongoDB shell output to a file?

by

The shell provides some nice but hidden features because it’s an interactive environment.

When you run commands from a javascript file via mongo commands.js you won’t get quite identical behavior.

There are two ways around this.

(1) fake out the shell and make it think you are in interactive mode

$ mongo dbname << EOF > output.json
db.collection.find().pretty()
EOF

or
(2) use Javascript to translate the result of a find() into a printable JSON

mongo dbname command.js > output.json

where command.js contains this (or its equivalent):

printjson( db.collection.find().toArray() )

This will pretty print the array of results, including [ ] – if you don’t want that you can iterate over the array and printjson() each element.

By the way if you are running just a single Javascript statement you don’t have to put it in a file and instead you can use:

$ mongo --quiet dbname --eval 'printjson(db.collection.find().toArray())' > output.json

More Related Contents:

  1. How to properly reuse connection to Mongodb across NodeJs application and modules
  2. Render basic HTML view?
  3. MongoDB dot (.) in key name
  4. Mongoose auto increment
  5. How do I remove documents using Node.js Mongoose?
  6. node.js shell command execution
  7. How do you put an image file in a json object?
  8. Aggregation filter after $lookup
  9. Mongoose difference between .save() and using update()
  10. Convert ObjectID (Mongodb) to String in JavaScript
  11. How can I promisify the MongoDB native Javascript driver using bluebird?
  12. When to close MongoDB database connection in Nodejs
  13. How to exclude some fields from the document
  14. Mongoose subdocuments vs nested schema
  15. Formatting ISODate from Mongodb
  16. How to get updated document back from the findOneAndUpdate method?
  17. Why is an _id with ObjectID added to when using MongoDB’s $push to add new object to an array?
  18. Can I determine if a string is a MongoDB ObjectID?
  19. Mongoose.js: Find user by username LIKE value
  20. How to use MongoDB with promises in Node.js?
  21. Create an ISO date object in javascript
  22. Getting timestamp from mongodb id
  23. Node.js mongodb driver async/await queries
  24. Storing data stream from POST request in GridFS, express, mongoDB, node.js
  25. What is the difference between id and _id in mongoose?
  26. Does MongoDB have a native REST interface?
  27. Cannot connect to MongoDB because of wrong URI
  28. How to return only value of a field in mongodb
  29. Group by Date with Local Time Zone in MongoDB
  30. Mongoose find() not returning result

Leave a Comment