mongodb: insert if not exists

by

Sounds like you want to do an “upsert”. MongoDB has built-in support for this. Pass an extra parameter to your update() call: {upsert:true}. For example:

key = {'key':'value'}
data = {'key2':'value2', 'key3':'value3'};
coll.update(key, data, upsert=True); #In python upsert must be passed as a keyword argument

This replaces your if-find-else-update block entirely. It will insert if the key doesn’t exist and will update if it does.

Before:

{"key":"value", "key2":"Ohai."}

After:

{"key":"value", "key2":"value2", "key3":"value3"}

You can also specify what data you want to write:

data = {"$set":{"key2":"value2"}}

Now your selected document will update the value of “key2” only and leave everything else untouched.

More Related Contents:

  1. Query Mongodb on month, day, year… of a datetime
  2. Append item to MongoDB document array in PyMongo without re-insertion
  3. Append item to MongoDB document array in PyMongo without re-insertion
  4. How to convert a pymongo.cursor.Cursor into a dict?
  5. How to continue insertion after duplicate key error using PyMongo
  6. “Large data” workflows using pandas [closed]
  7. How to speed up bulk insert to MS SQL Server using pyodbc
  8. TypeError: ObjectId(”) is not JSON serializable
  9. How to import data from mongodb to pandas?
  10. search by ObjectId in mongodb with pymongo
  11. Insert a Pandas Dataframe into mongodb using PyMongo
  12. How to sort mongodb with pymongo
  13. Why is PyMongo 3 giving ServerSelectionTimeoutError?
  14. Authenticate After Picking the Database
  15. Fast or Bulk Upsert in pymongo
  16. How to make a query date in mongodb using pymongo?
  17. How to Ignore Duplicate Key Errors Safely Using insert_many
  18. Getting Spark, Python, and MongoDB to work together
  19. Using .sort with PyMongo
  20. mongodb cursor id not valid error
  21. Delete every non utf-8 symbols from string
  22. How to run raw mongodb commands from pymongo
  23. ImportError: No module named objectid
  24. Use binary COPY table FROM with psycopg2
  25. Does MongoDB’s $in clause guarantee order
  26. Is there any way to kill a Thread?
  27. pytz localize vs datetime replace
  28. Replace comma with dot Pandas
  29. Proper use of mutexes in Python
  30. Sort a part of a list in place

Leave a Comment