Log to console In Mongodb

Question

When I run this command in robomongo, I get a output with different rows:

 db.getCollection('houses').find({})

Now I tried to run the same command in the mongo shell:

I wrote a script mongo.js:

 conn = new Mongo(); db = conn.getDB("development"); db.getCollection('houses').find({});

Opened the console with:

 mongo --shell

And tried to run the command:

 > load('mongo.js') true

I do not understand why I get only true as output. I want to see the query output! What do I wrong? Thanks

codeofnode · Accepted Answer · 2015-04-30 19:21:42Z

In the shell script, instead of console.log you can use

print() // for plain texts,

or printjson() // for json

usage :

printjson(db.getCollection('houses').find({}));

maskillbt · Accepted Answer · 2017-07-18 10:00:14Z

When using

printjson(db.getCollection('houses').find({}));

I get the output from the find object.

{ "_mongo" : connection to ***.***.***.***, "_db" : *****, "_collection" : ***.houses, "_ns" : "*****.houses", "_query" : { }, "_fields" : null, "_limit" : 0, "_skip" : 0, "_batchSize" : 0, "_options" : 4, "_cursor" : null, "_numReturned" : 0, "_special" : false, "help" : function () { print("find(<predicate>, <projection>) modifiers") print("\t.sort({...})") ........... }

if you use

db.getCollection('houses').find({}).forEach(printjson)

I get the desired output.

RoBeaToZ · Accepted Answer · 2020-08-12 09:03:12Z

An advancement for bigger scripts to keep the overview:

executeCommandAndLogResult( "Rename the collection", () => db.getCollection('collection_a').renameCollection("collection_b") ); function executeCommandAndLogResult(commandName, command) { printjson("--------------------------- Result of '" + commandName + "'-----------------------------") printjson(command()); printjson("------------------------------ End of '" + commandName + "'-----------------------------") }

The result will look like this if the renaming was successfull:

"--------------------------- Result of 'Rename the collection'-----------------------------" { "ok" : 1 } "------------------------------ End of 'Rename the collection'-----------------------------"

Or like this if not:

"--------------------------- Result of 'Rename the collection'-----------------------------" { "ok" : 0, "errmsg" : "source namespace does not exist", "code" : 26, "codeName" : "NamespaceNotFound" } "------------------------------ End of 'Rename the collection'-----------------------------"

Stanislaw Pak · Accepted Answer · 2021-08-25 22:28:38Z

Instead of using:

printjson(db.getCollection('houses').find({}));

Use the findOne:

printjson(db.getCollection('houses').findOne({...}));

Or, if you want to print multiple results, make sure to convert them to the array first:

printjson(db.getCollection('houses').find({}).toArray());

Collectives™ on Stack Overflow

Log to console In Mongodb

4 Answers 4

Comments

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Related