mongodb add a new field to an existing array with python

Question

Collection in database:

'_id' : ObjectId("sdhsndi66822dsxsd"),
'values' : {
        "ping" : [ 
            {
                "key" : "5ef9ac6eb1272e16729b17f6",
                "name" : "sdsadsadsa"
            },
           {
                "key" : "5ef9ac6eb1272e16729b17f6",
                "name" : "sdsadsadsa"
            }
              ]
           }

Here I need to add/update a new key value pair. So the expected output should be:

'_id' : ObjectId("sdhsndi66822dsxsd"),
    'values' : {
            "ping" : [ 
                {
                    "key" : "5ef9ac6eb1272e16729b17f6",
                    "name" : "sdsadsadsa",
                    "new":"added_new"
                },
               {
                    "key" : "5ef9ac6eb1272e16729b17f6",
                    "name" : "sdsadsadsa",
                    "new":"added_new"
                }
                  ]
               }

I need to achieve this with pymongo(mongo query also helpful). I have tried using $addtoset but doesnot help.

If you answer helps you please tick and upvote to help people who seek this kind of question — varman
– varman, Commented Aug 23, 2020 at 8:45

varman · Accepted Answer · 2020-08-19 13:53:48Z

1

You can use $addFields.

[
  {
    $addFields: {
      "values.ping.new": "added_new"
    }
  }
]

Working Mongo playground

answered Aug 19, 2020 at 13:53

varman

8,9226 gold badges25 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

mongodb add a new field to an existing array with python

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