How to update a mongodb string field from command line?

Question

I am trying to update a field from command line (NOT from mongo shell)

mongo mydb --eval "db.users.update({}, { $set : {  email : "[email protected]" } })"

results into

Fri Oct 24 12:23:46.102 JavaScript execution failed: SyntaxError: Unexpected token :

Again trying

mongo mydb --eval "db.users.update({}, { $set : {  email : \"[email protected]\" } })"

same results

Fri Oct 24 12:24:05.559 JavaScript execution failed: SyntaxError: Unexpected token :

Any help for the same ?

had updated the question entirely. but thanks to Neil Lunn for pointing out. now i have updated this question back to previous one. and asked another one here stackoverflow.com/questions/26543376/… — codeofnode
– codeofnode, Commented Oct 24, 2014 at 7:32

Neil Lunn · Accepted Answer · 2014-10-24 07:07:16Z

2

This is basically just quoting. The shell is generally more forgiving internally but does expect valid JSON otherwise:

mongo mydb --eval "db.users.update({}, { '$set': {  'email' : '[email protected]' } })"
MongoDB shell version: 2.6.5
connecting to: mydb
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })

Actually, to play more nicely with other modifiers such a multi then reverse the type of quotes used:

mongo mydb --eval 'db.users.update({}, { "$set": {  "email": "[email protected]" } },{ "multi": true })

answered Oct 24, 2014 at 7:07

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

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

8 Comments

codeofnode Over a year ago

you answer is absolutely perfect. But actually my core requirement is little different for the question i asked previously. please review the question again.

Neil Lunn Over a year ago

@Koka You should ask a different question rather than change your question. But why use a command process when you could just use the driver to connect to the database and issue an update?

codeofnode Over a year ago

actually i am having 100s of other mongodb operations to perform over approx 10 databases, so i thought using a mongo shell script is better approach.

codeofnode Over a year ago

IMO first question had no special significance as you answered in question 'This is basically just quoting'.. and also my requirement is little different than what i asked in first question. But i will keep in mind not repeat this mistake again.

Neil Lunn Over a year ago

@Koka No it will not be a better approach and in fact far worse. You should ask another question to explain what you want to do.

|

Collectives™ on Stack Overflow

How to update a mongodb string field from command line?

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related