Skip to main content

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),        },      },    });  });