Steps to finish (refresh) a mongoDB record

Question

Steps to finish (refresh) a mongoDB record

Currently, I am dealing with the following scenario:

An API request from one service is creating multiple MongoDB documents in a single collection. For example:

[
{_id: 1, test1: 2, test: 3},
{_id: 2, test1: 3, test: 4}
]

Subsequently, a second service reads these documents and retrieves additional information. As a result, I am constructing an object like:

[
{_id: 1,  newValue: 4},
{_id: 2,  newValue: 4}
]

Now comes my question: Is it possible to update all the documents at once using the "_id" value? The challenge is that I want to avoid updating each document individually due to their large number. Therefore, I am considering deleting all the existing documents and inserting them again with all the necessary information. What are your thoughts on this approach?

javascript mongodb api npm

Answer 1

Answer №1

To avoid the negative consequences of mass deletion followed by re-insertion, it is recommended to perform multiple updates in bulk using the bulkWrite method:

var bulkOperations = [];

for each item requiring processing {
        prepare _id and newValue ... ;
        bulkOperations.push({
          "updateOne": {
                    "filter": { "_id": targetId },
                    update: { $set: {"newValue": desiredValue } }
                }
            });
    });

// Execute a single batch of updates. This process could be enclosed within a transaction as well:
printjson( db.foo.bulkWrite(bulkOperations) );

Answer 2

To avoid the negative consequences of mass deletion followed by re-insertion, it is recommended to perform multiple updates in bulk using the bulkWrite method:

var bulkOperations = [];

for each item requiring processing {
        prepare _id and newValue ... ;
        bulkOperations.push({
          "updateOne": {
                    "filter": { "_id": targetId },
                    update: { $set: {"newValue": desiredValue } }
                }
            });
    });

// Execute a single batch of updates. This process could be enclosed within a transaction as well:
printjson( db.foo.bulkWrite(bulkOperations) );

Steps to finish (refresh) a mongoDB record

Answer №1

Similar questions

Demonstrating various elements within an application using Vue3

Error: Router.use() expects a middleware function, but received an object instead

PDFMAKE: A Guide to Duplicating Elements in the 'Content' Array

Passing a return value to ajax success within an Express application

"Explore the convenience of viewing two separate videos on one webpage, each in its own

Nested modal in native app utilizes the React Carbon TextInput component for an uneditable input field

The function is malfunctioning following the alert

Troubleshooting: Issue with append function not functioning properly after click event in Angular

Retrieve information in JSON format using AngularJS by fetching data from SQL through PHP

Warning: An instance of a class does not have a property called "list_data

Upon reinstalling the node_modules in my Nuxt.js project, I encountered the error message "Must use import to load ES Module:~"

Exploring the Power of Ajax Integration with Mongodb

Revamping status and backend systems

JavaScript popup cannot be shown at this time

Adding a MongoDB document at a precise moment of time

Constantly showing blank white pages on my website specifically in Internet Explorer 11

Change the way a button interacts with a different element

Converting Node JS request to an API into React Fetch syntax

Retrieve the current URL upon page load

Unauthorized changes made without verification