How to do "insert if not exist else update" with mongoengine?

python django mongodb mongoengine
wong2 picture wong2 · Dec 9, 2011 · Viewed 15.9k times · Source

I'm working with mongoengine in Django,
this is my document defination: 

class Location(mongoengine.Document):  
    user_id = mongoengine.IntField(required=True)  
    point = mongoengine.GeoPointField(required=True)

I want to do this:
given a user_id and a point:
if there is no document that have this user_id, create one with the user_id and point and save it;
else update the document with user_id with point.
Can I do this in one statement with mongoengine?

Answer

Nicolas Cortot picture Nicolas Cortot · Apr 19, 2013

Note that get_or_create is now scheduled to be deprecated, because with no transaction support in MongoDB it cannot ensure atomicity.

The preferred way is update with upsert:

Location.objects(user_id=user_id).update_one(set__point=point, upsert=True)

More on upserts on the MongoDB documentation.

Related questions

PyMongo vs MongoEngine for Django

For one of my projects I prefered using Django+Mongo. Why should I use MongoEngine, but not just PyMongo? What are advantages? Querying with PyMongo gives results that are allready objects, aren't they? So what is the purpose of MongoEngine?

Read More
Mongoengine creation_time attribute in Document

I am trying to add a creation_time attribute to my documents. The following would be an example: import datetime class MyModel(mongoengine.Document): creation_date = mongo.DateTimeField() modified_date = mongo.DateTimeField(default=datetime.datetime.now) Django models have built …

Read More
Mongoengine: ConnectionError: You have not defined a default connection

In my new Django project I set up a MongoDb database and use mongoengine module but I can't properly access to dabase nore in shell no in views. "ConnectionError: You have not defined a default connection" My settings.py includes …

Read More