Python Business Intelligence Cookbook

Updating a single record using PyMongo

A common operation in every application is that of updating a single record. For that, we'll use find_one_and_update() provided by PyMongo.

Getting ready

The find_one_and_update() method requires a filter to determine the record to be updated.

How to do it…

The following code tells us how to update a single record using PyMongo:

# Find the record you want to update and save the ID
from pymongo import MongoClient
client = MongoClient('localhost', 27017)
db = client.pythonbicookbook
customers = db.customers
customers.find_one_and_update(
    {"first_name": "Bob", "last_name": "Smith"},
    {'$set': {'contacted': False,
 'updated_at': datetime.datetime.utcnow()}})

How it works…

The first thing we do is create a filter for the ...