Update_one in pymongo with different fields type [duplicate]

manpreet Best Answer 2 years ago

In mongoDB collection I have different field types. Is it possible update doc in this collection with update_one method?

doc = {"upd_time": datetime.datetime.now(), "categories": [1,2,3]}
mng_collection.update_one({"_id": id}, {"$set": doc}, upsert=True)

That code replace existing array in categories field, but I need to add values from doc["categories"] array if not existing in collection doc array.

manpreet 2 years ago

You need to use $push with $each to add elements to the existing array. $set will always replace existing value with new one.

You can try this:

doc = {"upd_time": datetime.datetime.now(), "categories": [1,2,3]}
mng_collection.update_one({"_id": id}, {
    "$set": { "doc.upd_time" : doc.upd_time},
    $push : {categories : {$each : doc.categories}}
}, upsert=True)