Passing bash shell variables into a mongo shell command

Question

I am trying to execute a bash shell that calls the mongo shell with a command created dynamically. The bash shell looks like this:

#!/bin/bash

TODAY=`date '+%Y-%m-%d'`

CMD=" 'printjson(db.collection.aggregate([{$match:{processedtime:{$gte:\"$TODAY"}}},{$project:{_id:$field",count:{$sum:1}}}]))'"

echo "CMD: $CMD"

mongo host/mdb --eval $CMD

Note the processedtime field in the collection is a sting value formatted as an ISODate object.

When executed as a bash shell I get an "Unexpected token ILLEGAL" error. If I execute the command echoed to the screen I get the desired results.

My question is, Is there a way to pass in shell defined variables into the mongo shell and if there is what do I need to change to do this?

glenn jackman · Accepted Answer · 2014-11-11 22:30:04Z

2

You're note escaping enough, and I believe you don't want the literal single quotes:

CMD="printjson(db.collection.aggregate([{\$match:{processedtime:{\$gte:\"$TODAY\"}}},{\$project:{_id:\$field",count:{\$sum:1}}}]))"
# ...^.. single quote unneeded ..........^.......................^.....^.......&......^..............^...............^............^
mongo host/mdb --eval "$CMD"
# ....................^....^  crucial double quotes here

answered Nov 11, 2014 at 22:30

glenn jackman

249k42 gold badges233 silver badges362 bronze badges

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

Collectives™ on Stack Overflow

Passing bash shell variables into a mongo shell command

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related