Updating Fields Across All MongoDB Documents Using JavaScript

Question

Updating Fields Across All MongoDB Documents Using JavaScript

I'm currently facing an issue while updating a field for every Document within a MongoDB collection.

After successfully adding the field from the Mongo shell, I am looking to change the value of each field to a random number.

User.find({}, function(err, items){
  if (err){
    console.log('err');
    console.log(err);
  }
  items.forEach(function(item){
    var time = (Math.floor(Math.random() * (1474893715201 - 1474800000000) + 1474800000000));
    item.update({}, {$set:{"lastLogin": time}}, false, true);
  });
});

Upon logging each individual 'item' using console.log(item) within the .forEach loop, it retrieves every document in the collection as expected, indicating that everything is functioning smoothly up until this point.

Could anyone identify where I might be making a mistake?

Thank you!

javascript mongodb

Answer 1

Answer №1

To handle asynchronous Api calls, it is necessary to wrap the operation in a promise or use an async library to manage and execute the build changes effectively.

Another approach is to perform a bulk find and update operation in MongoDB using a single call: https://docs.mongodb.com/manual/reference/method/Bulk.find.update/

var bulk = db.items.initializeUnorderedBulkOp();
bulk.find( { status: "D" } ).update( { $set: { status: "I", points: "0" } } );
bulk.find( { item: null } ).update( { $set: { item: "TBD" } } );
bulk.execute();

Answer 2

To handle asynchronous Api calls, it is necessary to wrap the operation in a promise or use an async library to manage and execute the build changes effectively.

Another approach is to perform a bulk find and update operation in MongoDB using a single call: https://docs.mongodb.com/manual/reference/method/Bulk.find.update/

var bulk = db.items.initializeUnorderedBulkOp();
bulk.find( { status: "D" } ).update( { $set: { status: "I", points: "0" } } );
bulk.find( { item: null } ).update( { $set: { item: "TBD" } } );
bulk.execute();

Answer 3

Answer №2

How about trying something along these lines?

User.fetchAll({}, function(error, data){
  if (error){
    console.log('Error occurred');
    console.log(error);
  }
  data.forEach(function(element){
    var timestamp = (Math.floor(Math.random() * (4765710292013 - 4765700000000) + 4765700000000));
    element.lastVisit = timestamp;
    User.store(element); // or element.save() depending on the database driver
  });
});

Answer 4

How about trying something along these lines?

User.fetchAll({}, function(error, data){
  if (error){
    console.log('Error occurred');
    console.log(error);
  }
  data.forEach(function(element){
    var timestamp = (Math.floor(Math.random() * (4765710292013 - 4765700000000) + 4765700000000));
    element.lastVisit = timestamp;
    User.store(element); // or element.save() depending on the database driver
  });
});

Updating Fields Across All MongoDB Documents Using JavaScript

Answer №1

Answer №2

Similar questions

Having trouble linking npm with webpack? Receive an error message saying "module not

The D3 bar graph is displaying a height value of "Not a Number"

Ensuring form accuracy upon submission in AngularJS 1.5: Understanding the $invalid state in relation to $pristine field

Problem Encountered with Jquery Validation for Name Field (Restriction to Alphabetic

Organize table information using rowspan functionality

How can you apply a class to a different element by hovering over one element?

Deploying a pair of GitHub repositories to a unified Azure web application

problems with using array.concat()

.toggleClass malfunctioning inexplicably

Connecting MongoDB with Docker Compose

Tips on incorporating svgo into a vite react project

Tips for retaining the selected radio button in a Java web application even after a page refresh

The utility of commander.js demonstrated in a straightforward example: utilizing a single file argument

Trigger video to play or pause with every click event

Creating labels dynamically with jQuery and HTML, then retrieving their text values through jQuery

What is the best way to condense this code into just a single line?

Having difficulty refreshing the JGrid with updated content

Error in mongoDB: Attempting to add duplicate data

Guide for converting the initial letter of a key to lowercase in an object

Encountering surprising results while verifying a session token with parse.com