Remove Old Data

If you regularly need to purge old data, CronJob is a great fit.

api/remove-old-data.ts
import db from "db";
import { CronJob } from "quirrel/blitz";
import { subDays } from "date-fns";
export default CronJob(
"api/remove-old-data", // ๐Ÿ‘ˆ the route that it's reachable on
"0 * * * *", // same as @hourly (see https://crontab.guru/)
async () => {
await db.logs.deleteMany({
where: {
customer: {
isPremium: false,
},
date: {
lt: subDays(Date.now(), 3),
},
},
});
}
);