查找并删除所有其"createdDate"为"createdDate"的文档.大一个月了 [英] Find and remove all documents whose "createdDate" is one month older

问题描述

我正在研究MongoDB Collections.我有一组集合，每个集合都有很多文档.我必须编写一个程序来删除所有"createdDate"早于当前日期一个月的文档.

I am working on MongoDB Collections. I have a set of collections each having many documents. I have to write a procedure to delete all those documents whose "createdDate" is older than one month from current date.

为了将其与文档的"createdDate"进行比较，我一直在寻找比当前日期晚一个月的日期.

I am stuck in finding the date which is one month back of the current date in order to compare it with document's "createdDate".

我还必须安排此过程，以便它可以每天自动运行. (操作系统是Windows).我该如何实现?

Also i have to schedule this procedure, so that it can run automatically everyday. (OS is windows). How can i achieve it?

推荐答案

您可以尝试获取一个包含当前日期月份的日期对象(请注意，JavaScript月份日期是基于0的索引)，然后添加1即可从现在起一个月的日期，然后您可以在createdDate字段中的 $gt 运算符中将其用于查询:

You could try getting a date object that takes in the current date's month (bearing in mind that JavaScript month dates are 0-based index) and add 1 to get one month's date from now, which you can then use in your query with $gt operator on the createdDate field:

var now = new Date();
d = new Date(now.getFullYear(), now.getMonth()+1, now.getDate());
db.collection.remove({ createdDate: { $gt: d } })

更新

关于第二个问题，

我必须安排此过程，以便它可以自动运行 每天. (操作系统是Windows).我该如何实现?

i have to schedule this procedure, so that it can run automatically everyday. (OS is windows). How can i achieve it?

MongoDB当前不支持本机Job调度.大多数操作系统都有一种运行计划的程序的方式，例如cron或Windows Task Scheduler等，因此，由于这是一个广泛的问题，我只能建议您使用上述内容编写一个自定义的Shell脚本，然后就可以使用Windows Task Scheduler对其进行调度以每天运行

MongoDB currently has no support for native Job scheduling. Most operating systems have a way to run scheduled programs like cron or Windows Task Scheduler etc so since this is quite a broad question, I can only suggest you write a custom shell script with the above that you can schedule with Windows Task Scheduler to run everyday.

这篇关于查找并删除所有其"createdDate"为"createdDate"的文档.大一个月了的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！