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