MongoDB - Update or Create an object in nested Array in Pymongo

Question

This is my collection

{
    "_id" : '50001',
    "data" : 
        [
            {
                    "name" : "ram",
                    "grade" : 'A'
            },
            {
                    "name" : "jango",
                    "grade" : 'B'
            },
            {
                    "name" : "remo",
                    "grade" : 'A'
            }
        ]  
}

Here I want to update the object corresponds to "name": "jango" and have to create a new entry to the Array if "jango" is absent.

I can create a new entry but failed in "create or update".

I tried this way in mongo interpreter

db.MyCollection.update({'_id': '50001', "data.name" :"jango"}, {'$set':{'data': {'data.$.grade':'A'}}}, upsert=true)

but showing

not okForStorage

Neo-coder · Accepted Answer · 2014-11-21 14:22:24Z

1

Mongo nested update so you should know the position or $ of update values below may help

db.collecionName.update(
   {'_id': '50001', "data.name" :"jango"}, 
   {'$set':{'data.1.grade':'A'}}, upsert=true)

or

   db.collecionName.update(
   {'_id': '50001', "data.name" :"jango"}, 
   {'$set':{'data.$.grade':'A'}}, upsert=true)

answered Nov 21, 2014 at 14:22

Neo-coder

7,8585 gold badges36 silver badges54 bronze badges

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

3 Comments

V Manikandan Over a year ago

But I need to search irrespective of the array index. Only I am able to know the name.

V Manikandan Over a year ago

This will not create a new entry to the Array if the searching name does not exist.

Neo-coder Over a year ago

for this you should try mongo map reduce it will help you.

vav · Accepted Answer · 2014-11-21 14:19:26Z

0

You almost there:

db.YourCollection.update(
   { '_id':'50001', <-- to find document
     'data.name': 'jango' < -- to find element of the array
   },
   { '$set': { "data.$.grade" : 'A' } } <-- with .$ you reference array element from first argument
)

Link to documentation

answered Nov 21, 2014 at 14:19

vav

4,6942 gold badges22 silver badges40 bronze badges

1 Comment

V Manikandan Over a year ago

But I just need to create a new entry like {'name': 'jango', 'grade': 'A'} to the array if the name I searching is not there.

Collectives™ on Stack Overflow

MongoDB - Update or Create an object in nested Array in Pymongo

2 Answers 2

3 Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Related