Updating multiple documents in mongoose using Node JS is a breeze

Question

Updating multiple documents in mongoose using Node JS is a breeze

When attempting to update multiple documents using a query generated from an object array, I encountered an issue where only one document was actually modified.

var split = num.toString().split(',');
var list = new Array;
for ( var i in split ) {
    var pk = {
        "_id" : split[i],
        "id" : user.id
    }
    list.push(pk);
}

var vm = {name:"robert",category:"media"};

database.bookModel.findOneAndUpdate(list, vm, { multi: true }, function (err, result) {
....

I have tried the above approach to updating multiple documents but it seems to only affect a single record. Is there a mistake in my code? Is there a way to utilize criteria with an object array?

express mongoose mongodb-query nodes

Answer 1

Answer №1

If you switch from 'findOneAndUpdate' to 'update', you will be able to update multiple documents at once. Give it a try!

Answer 2

If you switch from 'findOneAndUpdate' to 'update', you will be able to update multiple documents at once. Give it a try!

Answer 3

Answer №2

Utilize the power of bulk find and update methods,

var bulkOperation = db.Model.initializeUnorderedBulkOp();
var data = {
  title: "robert",
  type: "video"
};

for (var index in splitData) {
  var query = {
    "_id": splitData[index],
    "userId": user.userId
  }
  bulkOperation.find(query).update({
    $set: data
  });
}

bulkOperation.execute();

Answer 4

Utilize the power of bulk find and update methods,

var bulkOperation = db.Model.initializeUnorderedBulkOp();
var data = {
  title: "robert",
  type: "video"
};

for (var index in splitData) {
  var query = {
    "_id": splitData[index],
    "userId": user.userId
  }
  bulkOperation.find(query).update({
    $set: data
  });
}

bulkOperation.execute();

Answer 5

Answer №3

For your query to be successful, modify it as follows:

database.bookModel.updateAll(records, viewModel, {
    multiple: true
}).then(() => {
    res.status(200).json({
        message: 'Updated data is now live!'
    })
}).catch((error) => {
    res.status(500).json({
        issue: error
    });
});

Answer 6

For your query to be successful, modify it as follows:

database.bookModel.updateAll(records, viewModel, {
    multiple: true
}).then(() => {
    res.status(200).json({
        message: 'Updated data is now live!'
    })
}).catch((error) => {
    res.status(500).json({
        issue: error
    });
});

Updating multiple documents in mongoose using Node JS is a breeze

Answer №1

Answer №2

Answer №3

Similar questions

Node/Express API returning empty body when being accessed through fetch or axios requests

Utilize middleware nesting in Express.js

Having trouble with Socket.io and its io.emit() method refusing to work? If communication from server to client isn't going smoothly, you may need a solution for sending data from the server to

Display inputs based on selections made on the settings page

Passing Express routes through an nginx proxy

Error encountered in NodeJS after refreshing the node server

When working with Express and Axios together, it is important to note that Axios may not handle

What is the best way to return JSON from a 403 error using Express?

Get the csv document from the backend

Is there a way to fix the error "The requested resource does not have the 'Access-Control-Allow-Origin' header" within Express using Firebase functions?

The jade code is causing an error to be displayed

Unidentified authorization token in React/Express

Is it possible to include a parameter in module.exports?

Navigating hierarchical data structures with mongoDB and mongoose: finding the perfect schema

Guide on adding logout feature with jsonwebtoken in node.js

Sending files in Express causes issues

Issue: unable to establish connection. Address is already in use. Attempted all possible solutions

Combining GraphQL: stitching and uniting

What steps can you take to intentionally cause errors in a Node Express application in order to capture them in Sentry?

What are the consequences of submitting a form to a different website through POST method?