You can update multiple documents using the updateMany() method on a MongoCollection object. The method accepts a filter that matches the document you want to update and an update statement that instructs the driver how to change the matching document. The updateMany() method updates all the documents in the collection that match the filter.
To perform an update with the updateMany() method, you must pass a query filter and an update document. The query filter specifies which documents in the collection to match and the update document provides instructions on what changes to make to them.
You can optionally pass an instance of UpdateOptions to the updateMany() method in order to modify the behavior of the call. For example, if you set the upsert field of the UpdateOptions object to true and no documents match the specified query filter, the operation inserts a new document composed of the fields from both the query and update document.
Upon successful execution, the updateMany() method returns an instance of UpdateResult. You can retrieve information such as the number of documents modified by calling the getModifiedCount() method. If you specified upsert(true) in an UpdateOptions object and the operation results in an insert, you can retrieve the _id field of the new document by calling the getUpsertedId() method on the UpdateResult instance.
If your update operation fails, the driver raises an exception and does not update any of the documents matching the filter. For example, if you try to set a value for the immutable field _id in your update document, the updateMany() method does not update any documents and throws a MongoWriteException with the message:
Performing an update on the path '_id' would modify the immutable field '_id'If your update document contains a change that violates unique index rules, the method throws a MongoWriteException with an error message that should look something like this:
E11000 duplicate key error collection: ...For more information on the types of exceptions raised under specific conditions, see the API documentation for updateMany(), linked at the bottom of this page.
In this example, we use a Filters builder to filter our query for movies in the genre "Frequently Discussed".
Next, we update documents that match our query in the movies collection of the sample_mflix database. We perform the following updates to the matching documents:
Add Frequently Discussed to the array of genres only if it does not already exist
Set the value of lastUpdated to the current time.
We use the Updates builder, a factory class that contains static helper methods to construct the update document. While you can pass an update document instead of using the builder, the builder provides type checking and simplified syntax. Read our guide on Updates in the Builders section for more information.
This example connects to an instance of MongoDB using a connection URI. To learn more about connecting to your MongoDB instance, see the connection guide.
import com.mongodb.MongoExceptionimport com.mongodb.client.model.Filtersimport com.mongodb.client.model.Updatesimport com.mongodb.kotlin.client.coroutine.MongoClientimport kotlinx.coroutines.runBlockingimport java.time.LocalDateTimedata class Movie( val num_mflix_comments: Int, val genres: List<String>, val lastUpdated: LocalDateTime)fun main() = runBlocking { val uri = "<connection string uri>" val mongoClient = MongoClient.create(uri) val database = mongoClient.getDatabase("sample_mflix") val collection = database.getCollection<Movie>("movies") val query = Filters.gt(Movie::num_mflix_comments.name, 50) val updates = Updates.combine( Updates.addToSet(Movie::genres.name, "Frequently Discussed"), Updates.currentDate(Movie::lastUpdated.name) ) try { val result = collection.updateMany(query, updates) println("Modified document count: " + result.modifiedCount) } catch (e: MongoException) { System.err.println("Unable to update due to an error: $e") } mongoClient.close()}Modified document count: 53After you run the example, you should see a similar output.
If you query the updated document or documents, they should look something like this:
Movie(num_mflix_comments=100, genres=[ ... Frequently Discussed], lastUpdated= ... )For additional information on the classes and methods mentioned on this page, see the following API Documentation:
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4