Comment by j on "MongoDB: How to change data in db on a specific day and time?"

I would just use integers for the workdays -> 0-6 for the weekdays and online would be a boolean so i don't have any natural language semantics in the database.

as for the change I would do that in the application which would be a simple logic there was a beautiful java solution for this kind of problem

hashnode.com/post/need-explanation-on-shift-and-b…

but not everyone likes bit operations.

but Usually every date function can return you the day numbered by from 0-7 depends on your logic as well as the date.

docs.mongodb.com/manual/reference/operator/aggreg…

or you could use these methods and just create a shell script that triggeres every minute (because that's basically is the persistent interval) to update all users who should be offline or online.

but maybe I misunderstand the problem.

Sorry if I was not clear, the idea is to let the users submit their schedule and then to run a script or whatever which set their status online according to the schedule they submitted by itself. Please let me know if I am not clear again..

@argjendhaxhiu so basically you wanna run a cronjob which uses the aggregations ?

@chilimatic yeah, I want to get all the user.schedule and run a cronjob where I change the user.status to "online" in a specific day&time as they submitted. Am I clear ?

but that's so easy that's why I'm confused....

stackoverflow.com/questions/30385663/mongodb-set-… something like this ?

or do you need an explicit example ?

I know how to update a document, what I am asking for is how can I do it using cronjob or any other tool which runs automatically on every specific day & time @chilimatic

@argjendhaxhiu ah I see, sorry. So the question is "how to schedule a recurring job" I am slow sometimes :)

there are job schedulers, but usually you start with a simple cronjob that just triggers an npm run script

* * * * * cd /mypathToMy/to/my/application/root && npm run myscriptnamefortheupdate

the && in the same line just means you are still in the same directory you changed to

that would be the easiest solution atm. unless you're already large scale than ofc you could look at this http://nerds.airbnb.com/airflow/

But it seams a little bit overkill for this trivial task.

Search Hashnode