Execute mongo query with parameter through shell scripts, is it possible?

Question

I don't know if this is even possible, I can see that there might be issues with using bash parameters in a mongo eval query. What I'm trying to do is to update documents in mongo where a value date is greater than todays date.

Example: Today's date is less(<) than tomorrows date, thus update field X of same document.

I've got the following, but I'm wondering how to pass the date variable to the mongo query. Is it even possible? Is there another way to Rome?

#!/bin/sh
today="$(date +'%Y-%m-%d')"

mongo db --eval 'db.Scheme.update({"FutureDate":{$gte: $today}},{$set:{"X":"$today"}});'

Alternately I've tried to switch $today with new Date().setHours(0,0,0,0) but are unable to perform the query.

Help or constructive feedback is much appreciated, thanks! :)

shell variables don't get expanded in single quotes. Try enclosing your variable inside double quotes like command 'previous'"$var"'next" — user000001
– user000001, Commented Oct 5, 2015 at 16:55
Thanks @user000001! Worked as a charm, hm, dont know why I didn't try that, any idea on how I can $today as a real date value? and not as string? Like with javascript, var from = ISODate("2011-11-24") Any idea on how I can do the same in shell/bash? — gudbrand3
– gudbrand3, Commented Oct 5, 2015 at 18:59
I don't think that you can do that from bash. You'll probably have to do it from mongo, but I don't know how... — user000001
– user000001, Commented Oct 5, 2015 at 19:02

Community · Accepted Answer · 2020-06-20 09:12:55Z

3

I came to a solution to my problem, it solves (I would say 95%) of my case. I found that I didn't need to pass a parameter although I was able to do it using '"$variable"' inside the mongo query while testing (see To pass variable for more).

My query solution is below (does not include passing variable):

db.Scheme.update({"FutureDate":{$gte: new Date()}},{$set :{"X":Value}},{multi:true});

{multi:true} allows all documents in Scheme to be looped.

Full query in script

!/bin/sh

mongo databaseurl:port/database -u username -p password --eval 'db.Scheme.update({"FutureDate":{$gte: new Date()}},{$set :{"X":Value}},{multi:true});'

To pass variable (example):

!/bin/sh

Value="Example"

mongo databaseurl:port/database -u username -p password --eval 'db.Scheme.update({"FutureDate":{$gte: new Date()}},{$set :{"X":'"$Value"'}},{multi:true});'

Hope it can help someone else as well! Thanks user000001 for help along the way :)

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Nov 1, 2015 at 18:59

gudbrand3

931 silver badge10 bronze badges

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

Comments

MOtius · Accepted Answer · 2018-09-30 02:22:36Z

0

try following

#!/bin/bash
Value="Example"

mongo databaseurl:port/database -u username -p password --eval  \ 
"db.Scheme.update({\"FutureDate\":{$gte: new Date()}},{$set :{\"X\":\"${Value}\"}},\{multi:true});"

edited Sep 30, 2018 at 2:22

answered Sep 29, 2018 at 17:05

MOtius

296 bronze badges

Collectives™ on Stack Overflow

Execute mongo query with parameter through shell scripts, is it possible?

2 Answers 2

!/bin/sh

!/bin/sh

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

!/bin/sh

!/bin/sh

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related