how to pass a value to mongoDB command?

Question

below is the bash script and I want to pass the value of 'a' from for loop to mongoDB command but I am getting $a is not defined error. How to pass the value to mongo command.

{ "account_id" : $a } is the part of the below command.

#!/usr/bin/bash

for a in `cat /tmp/account.txt`;
do
    mongo --authenticationDatabase admin -u 'xxxxxx' -p 'xxxxxxxxx' --quiet --eval 'db.executions.find({ $and : [  { "account_id" : $a }, { "status" : "running" }, { "created_at" : { "$gt" : ISODate("2022-09-01T00:00:00.000Z") } }, {  "created_at" : { "$lt" : ISODate("2022-10-01T00:00:00.000Z") } } ] } ,{"account_id":1,"created_at":1} ).count()' selfservice_production;
done

account.txt

Maybe try swapping the single and double quotes per this answer about environment variables in bash scripts? — user20042973
– user20042973, Commented Sep 28, 2022 at 16:31
Maybe instead of establish a connection for every single line you may also read the file in mongo shell (see cat) and process in the shell. Might be more efficient. — Wernfried Domscheit
– Wernfried Domscheit, Commented Sep 28, 2022 at 20:23

Renu prashanth M · Accepted Answer · 2022-09-28 18:23:26Z

0

need to add the variable in single quotes. Its working for me.

{ "account_id" : "'$a'" } is what I changed.

#!/usr/bin/bash

for a in `cat /tmp/account.txt`
do
    mongo --authenticationDatabase admin -u "xxxx" -p "xxxxxxxxxx" --quiet selfservice_production --eval 'db.executions.find({ $and : [  { "account_id" : "'$a'" }, { "status" : "running" }, { "created_at" : { "$gt" : ISODate("2022-08-01T00:00:00.000Z") } }, {  "created_at" : { "$lt" : ISODate("2022-09-01T00:00:00.000Z") } } ] } ,{"account_id":1,"created_at":1} ).count()' 
done

Reference: Use variables with --eval in mongodb

answered Sep 28, 2022 at 18:23

Renu prashanth M

11 bronze badge

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

Collectives™ on Stack Overflow

how to pass a value to mongoDB command?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related