How To Update A MongoDB Collection Automatically Every Midnight?

I currently have an SPA built with MERN and I want to improve it further by adding a scheduled update to a particular collection in my MongoDB database by setting a boolean field i

Solution 1:

you can use cron job

const moment = require('moment');
const CronJob = require('cron').CronJob;

const updateCollections = async ()=>{
  await someQueriesServices()
}

new CronJob('0 0 * * *', async () => {
  await updateCollections()
}, null, true, 'America/Los_Angeles');

or you can use setInterval

const timeInSec = moment().endOf('day').valueOf()
const Interval = Date.now() - timeInSec;

setInterval(async ()=>{
    await updateCollections()
},Interval)

Solution 2:

I usually use node-schedule

const schedule = require('node-schedule');

const j = schedule.scheduleJob('42 * * * *', function(){
  console.log('The answer to life, the universe, and everything!');
});