Update and insert together in mongodb using pymongo?

Question

I have a list of dictionaries as follows:

data=[{
      "uni_id": '101',
      "name":"abc",
      "age": 10,
    },
    { 
     "uni_id": '102',
      "name":"def",
      "age": 12,

     }]

I want to use this dictionary to update my database only if the "uni_id" exists in the database, if it doesn't exist in my database then I want to insert that particular "uni_id" and also its corresponding "name" and "age":

My update statement is as follows, however I would also like to use insert with it to satisfy the above mentioned conditions. How to write the insert statement? Or is there a way to write some if-else statements to do update and insert?

db.students.update_one(
    {"uni_id":data[0]['uni_id']},
    {
    "$set":
   {
    "name":"abc_1",
   }})

score 1 · Accepted Answer · edited Jun 10 '18 at 14:40

1

Set upsert to true... It creates a new document if the updated document is not existed in the collection

db.students.update_one(
  { "uni_id": data[0]['uni_id']},
  { "$set": { "name":"abc_1" }},
  True
)

edited Jun 10 '18 at 14:40

user9463814

199
11

answered Jun 10 '18 at 14:08

Ashh

44,693
14
105
132

I am using pymongo to make the updates, its giving me an error when I use upsert. – user9463814 Jun 10 '18 at 14:21
@user9463814 pymongo version? – Ashh Jun 10 '18 at 14:22
Pymongo version: 3.3.0 – user9463814 Jun 10 '18 at 14:25
@user9463814 please check the updated answer... it should work – Ashh Jun 10 '18 at 14:26

Update and insert together in mongodb using pymongo?

1 Answers1