running JavaScript file to excute mongodb queries

Question

I have for example a list of .find() queries like this:

db.tweets.find({},{"user.name":1}).explain()

I want to run the queries from a javascript file then save outputs to a text file

the important thing for me is getting the results from the .explain() in the text file too

is this possible? and how can I achieve this?

Yes it is possible, here is the manual for this topic: docs.mongodb.org/manual/tutorial/… — user3415653
– user3415653, Commented Apr 27, 2015 at 14:04
the explain() method returns some useful information about the exexution of the query here is a example: docs.mongodb.org/manual/reference/explain-results @IvanJ — mike
– mike, Commented Apr 27, 2015 at 14:19
I have looked at the manual but havent found it useful I was hoping for get a example or easier to understand explaination @user3415653 — mike
– mike, Commented Apr 27, 2015 at 14:21
Not sure how you can save file with JavaScript. If you are trying to write a file on client machine, You can't do this in any cross-browser way. — IvanJ
– IvanJ, Commented Apr 27, 2015 at 14:44

IvanJ · Accepted Answer · 2017-10-17 16:18:09Z

2

Since explain() method returns JSON, you can save it into a variable.

var temp = db.tweets.find({},{"user.name":1}).explain();

edited Oct 17, 2017 at 16:18

answered Apr 27, 2015 at 14:43

IvanJ

6555 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user3415653 · Accepted Answer · 2015-04-27 14:50:47Z

1

example script test.js:

conn = new Mongo('hostname');
db = conn.getDB('dbName');

var temp =  db.collection.find().explain()

// do what ever you want
printjson(temp)

run on command line:

mongo hostname test.js

output:

MongoDB shell version: 2.4.9 connecting to: hostname/test 
{
  "cursor": "BasicCursor",
  "isMultiKey": false,
  "n": 4795,
  "nscannedObjects": 4795,
  "nscanned": 4795,
  "nscannedObjectsAllPlans": 4795,
  "nscannedAllPlans": 4795,
  "scanAndOrder": false,
  "indexOnly": false,
  "nYields": 0,
  "nChunkSkips": 0,
  "millis": 2,
  "indexBounds": {
  },
  "server": "XXX:XXX"
}

answered Apr 27, 2015 at 14:50

user3415653

3353 silver badges15 bronze badges

Collectives™ on Stack Overflow

running JavaScript file to excute mongodb queries

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related