Trouble invoking MongoDB update using shell --eval switch from Powershell

Question

I am trying to invoke a MongoDB javascript fragment using the mongo.exe --eval command line switch. This works fine when run from the Windows command line, but I want to invoke it from a Powershell script like so:

Invoke-Expression "& `"C:\MongoDB\bin\mongo.exe`" localhost:27017/mydb --eval `"db.mydata.update({}, {`$set : {v : 1}})`" --quiet"

There is only one document in the mydata collection, and I want to set its v field to 1. But, the above expression returns SyntaxError: invalid property id (shell eval):1 when run from a Powershell script and does not update the document.

What makes this even more confusing is that the follow works as expected:

Invoke-Expression "& `"C:\MongoDB\bin\mongo.exe`" localhost:27017/mydb --eval `"printjson(db.mydata.findOne())`" --quiet"

Any ideas what I might be doing wrong?

Update:

The solution:

Invoke-Expression '& "C:\MongoDB\bin\mongo.exe" localhost:27017/mydb --eval "db.mydata.update({}, {`$set : {v : 2}})" --quiet'

Eve Freeman · Accepted Answer · 2012-01-25 14:10:27Z

20

Try using single quotes instead of double quotes around the eval statement.

answered Jan 25, 2012 at 14:10

Eve Freeman

33.3k5 gold badges89 silver badges104 bronze badges

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

1 Comment

Dave Over a year ago

I had the same issue and this fixed it.

DarylChymko · Accepted Answer · 2013-09-03 21:16:32Z

1

FYI this isn't just specific to PowerShell, it's applicable to running mongo on any platform (Windows, OSX, etc)

answered Sep 3, 2013 at 21:16

DarylChymko

1,0781 gold badge8 silver badges11 bronze badges

Comments

webDEVILopers · Accepted Answer · 2013-08-01 07:47:31Z

0

@Wes Freeman saved my day!

MongoDB Reference mongo program use

Use single quotes (e.g. ') to enclose the JavaScript, as well as the additional JavaScript required to generate this output.

answered Aug 1, 2013 at 7:47

webDEVILopers

1,9261 gold badge23 silver badges35 bronze badges

Collectives™ on Stack Overflow

Trouble invoking MongoDB update using shell --eval switch from Powershell

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related