Adding multiple fields to documents in mongodb using pymongo

Question

I have a sample collection of documents in mongo db like below

[{"name":"hans","age":30,"test":"pass","pre":"no","calc":"no"},
{"name":"abs","age":20,"test":"not_pass","pre":"yes","calc":"no"},
{"name":"cdf","age":40,"test":"pass"},
{"name":"cvf","age":30,"test":"not_pass","pre":"no","calc":"yes"},
{"name":"cdf","age":23,"test":"pass"},
{"name":"asd","age":35,"test":"not_pass"}]

For some documents the fields pre and calc are not present. I want to add those two fields to the documents which dont have those fields with value null for both "pre":"null", "calc":"null".

The final document should look like

[{"name":"hans","age":30,"test":"pass","pre":"no","calc":"no"},
{"name":"abs","age":20,"test":"not_pass","pre":"yes","calc":"no"},
{"name":"cdf","age":40,"test":"pass","pre":"null","calc":"null"},
{"name":"cvf","age":30,"test":"not_pass","pre":"no","calc":"yes"},
{"name":"cdf","age":23,"test":"pass","pre":"null","calc":"null"},
{"name":"asd","age":35,"test":"not_pass","pre":"null","calc":"null"}]

I tried this way but didnt work.

db.users.update({}, { "$set" : { "pre":"null","calc":"null" }}, false,true)

I think you should use db.users.aggregate function to make updation of your db, please refere to this link this will be helpful for your case i hope mongodb.com/docs/manual/reference/operator/aggregation/… — y051
– y051, Commented Jul 21, 2022 at 12:49

Yong Shun · Accepted Answer · 2022-07-21 13:10:19Z

2

Thinking that you need an update with the aggregation pipeline.

And use $ifNull operator.

db.users.update({},
[
  {
    "$set": {
      "pre": {
        $ifNull: [
          "$pre",
          "null"
        ]
      },
      "calc": {
        $ifNull: [
          "$calc",
          "null"
        ]
      }
    }
  }
],
false,
true
)

Sample Mongo Playground

edited Jul 21, 2022 at 13:10

answered Jul 21, 2022 at 12:50

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

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

3 Comments

imhans4305 Over a year ago

Thanks for the reply. I am getting an error TypeError: upsert must be True or False

Yong Shun Over a year ago

Not PyMongo developer, but your code should be: db.users.update({}, [...], false, true). which [...] is the aggregation pipeline.

imhans4305 Over a year ago

In pymongo this is not working. Unfortunately I am working with pymongo. ` $ifNull: [ "$pre", "null" ]` This is considered as an array in pymongo. This replaces every pre and calc field with an array object

R2D2 · Accepted Answer · 2022-07-21 14:31:24Z

1

The easiest option is to run this query for every missing field that you have , for example for pre:

db.collection.update({
pre: {
    $exists: false
  }
},
{
 "$set": {
   "pre": null
 }
},
{
  multi: true
})

Playground

answered Jul 21, 2022 at 14:31

R2D2

10.9k2 gold badges20 silver badges41 bronze badges

Collectives™ on Stack Overflow

Adding multiple fields to documents in mongodb using pymongo

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related