Update

CapybaraDB allows updating documents using operations that are similar to MongoDB. You can update one or multiple documents by specifying filters, update fields, and an optional upsert parameter. This guide explains how to perform update operations.

Update Operation

The update operation is used to update one or multiple documents in a collection based on a filter.

Example Python Code for update

Here’s how you can update documents by applying a filter and an update operation. This example is designed to be similar to the insertion example, showing how you can seamlessly transition from inserting to updating documents in CapybaraDB:

# Filter to match the document(s) based on email (similar to the insert example)
filter_criteria = {
    "email": "johndoe@example.com"
}
 
# Update operation (e.g., updating the 'age' field and modifying bio)
update = {
    "$set": {
        "age": 31,
        "bio": EmbText("John is now an experienced AI specialist with updated skills.")
    }
}
 
# Optional upsert (set to true if you want to insert a new document if no match is found)
upsert = False
 
response = collection.update(update, filter_criteria, upsert)

Update Response

A successful update operation will return a JSON response indicating the number of matched and modified documents, and whether an upsert was performed:

{
  "matched_count": 1,
  "modified_count": 1,
  "upserted_id": null,
  "task_id": "abc123xyz"
}

If the update object contains EmbJSON data type, the response will include a task_id indicating an asynchronous task is in progress. If no asynchronous processing is required, task_id will be null.

If an upsert was performed, the upserted_id will contain the ID of the new document.

Parameters for Update Operations

How can we improve this documentation?

Got question? Email us