How to run raw MongoDB operations using the db.command() and NodeJS

Question

I've set of new Mongodb scripts for every release and i'm trying to create NodeJS utility to run the scripts by reading from .txt files which are there in folder.

Ex: In 1.txt file i've this command db.getCollection("users").createIndex({ name: 1 }); and i want to run using NodeJS

I've NodeJs program like below

const { MongoClient } = require("mongodb");

const uri = "mongodb:uri";

const client = new MongoClient(uri);

async function run() {
  try {
    await client.connect();

    const db = client.db("employee");
    // I want to run above script like here. How can i do it?
    const result = await db.command({
      dbStats: 1,
    });
    console.log(result);
  } finally {
    await client.close();
  }
}
run().catch(console.dir);

For further information look at this answer

m0rg4n
– m0rg4n

2023-09-15 12:45:03 +00:00
Commented Sep 15, 2023 at 12:45 — m0rg4n
– m0rg4n, Commented Sep 15, 2023 at 12:45

Paulo · Accepted Answer · 2021-09-08 20:30:55Z

1

I feel your .txt file could be a .js file. You would then feed it to your mongodb instance like so mongo < yourFile.js

But if for some reason this can not be done.

Eval

Disclaimer: Please be advised of the security concerned of using eval

I feel what you are looking for is eval.

Your code could simply look like:

const { MongoClient } = require("mongodb");

const uri = "mongodb:uri";


MongoClient.connect(uri, function(err, db){

    const dbo = db.db("test");
    // Here you get your lines from your .txt file
    let line_to_execute = 'dbo.collection("customers").findOne({}, (err, res)=>{console.log(res)});';

    // Launch the execution of line_to_execute
    eval(line_to_execute);

})

edited Sep 8, 2021 at 20:30

answered Sep 4, 2021 at 18:08

Paulo

11k5 gold badges23 silver badges38 bronze badges

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

9 Comments

Prasad Kanaparthi Over a year ago

Thank you, but where are you executing line_to_execute ? its not working

Paulo Over a year ago

I added some comments to make it more clear. The eval call should be executing the line_to_execute

Prasad Kanaparthi Over a year ago

Eval doesn't execute the query. It's not expression correct

Paulo Over a year ago

What do you mean by it is not expression correct ? It should be able to run any valid js expression. Even those doing queries to the database.

Prasad Kanaparthi Over a year ago

No . Please try a sample program to run above script and let me know.

|

Prasad Kanaparthi · Accepted Answer · 2021-09-04 19:01:24Z

0

Got the solution, we can read from .Json files and pass the cmd like below.

     let userNameIndex = {
        createIndexes: "users",
        indexes: [
            {
                key: { "name": 1 },
                name: "nameIndex"
            }
        ],
        comment: "Prasad test"
    };
    eval(userNameIndex);
    const result = await db.command(userNameIndex);
    console.log(result);

answered Sep 4, 2021 at 19:01

Prasad Kanaparthi

6,5934 gold badges40 silver badges66 bronze badges

Collectives™ on Stack Overflow

How to run raw MongoDB operations using the db.command() and NodeJS

2 Answers 2

Eval

9 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Eval

9 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related