How to update MongoDb document using python

Question

I have 2 documents in a collection with a structure like below. I want to update "Source" as Home where environment is "QA" and Name is "Alan".

{
  environment: DevA,
  data: [
   { 
     Name: "John",
     Source: "Home"
   },
   { 
     Name: "Alan",
     Source: "Office"
   },
   { 
     Name: "Susan",
     Source: "Office"
   }
  ],
},
{
  environment: DevB,
  data: [
   { 
     Name: "John",
     Source: "Home"
   },
   { 
     Name: "Alan",
     Source: "Office"
   },
   { 
     Name: "Susan",
     Source: "Office"
   }
  ],
}

I tried the following code below. But it did not update it, neither gave an error.

 collection1.update_one({ 'environment':'QA', 'data.Name':'Alan'},
                          { $'set': {
                                     "data":"Source":"NewValue"
                                    }
                          })

Possibly because you have spelled environment as environemnt? Although I suspect that would raise an error. — Jeremy Savage
– Jeremy Savage, Commented Sep 28, 2022 at 13:54
umm, no. That's a typo here in question only. I'll correct. May be I have given multiple filter condn.. Could that be issue? — Krypto456
– Krypto456, Commented Sep 28, 2022 at 16:07
When you say that you have a document with a structure shown in the question, does that represent two different documents? In either case, those documents do not match the condition of environment: 'QA' so it would make sense that no update was performed if that was the data the operation was tested against. To your overall question - you'll probably want to look into arrayFilters since you want to manipulate the data array. See here — user20042973
– user20042973, Commented Sep 28, 2022 at 17:10
@user20042973 I am able to do it for one nested array [answer posted below] in the document say for name = "Alan" using below answer. However, I also want to update for more than one nested arrays elements like for where name="Alan" *& name="John", update source as "Office". — Krypto456
– Krypto456, Commented Sep 29, 2022 at 8:34
Great, looks like we're making progress! Two thoughts regarding your latest comment and the answer, the first is that you don't need $elemMatch here if you are only searching a single field (Name) in the data array. You'd only need it if you added a second field in there. The second thing is to search for multiple names you probably want $in. So the second predicate should probably change to 'data.Name': { $in: [ "Alan", "John" ] } — user20042973
– user20042973, Commented Sep 29, 2022 at 12:45

Krypto456 · Accepted Answer · 2022-09-29 08:28:21Z

1

I was able to update it using following code:

collection1.update_one( 
{
  "environment":"DevB",
  "data" {"$elemMatch": { "Name": "Alan"} }
},
{
  "$set" : {
          "data.$.source":"ABC"
           }   
 })

answered Sep 29, 2022 at 8:28

Krypto456

4914 bronze badges

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

Collectives™ on Stack Overflow

How to update MongoDb document using 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