Work that happens while you sleep.

# two keys, and only these two.
# the parser ignores anything else.
[[cron]]
path     = "/api/jobs/daily-digest"
schedule = "0 13 * * *"  # 13:00 UTC

import { db, email } from 'hatchable';

// 404 to the public internet. only the
// scheduler can reach this route.
export const access = 'scheduler';

export default async function (req, res) {
  const isCron =
    req.headers['x-hatchable-trigger'] === 'cron';

  const { rows } = await db.query(
    `SELECT email FROM subscribers
       WHERE digest_enabled = true
         AND (last_digest_at IS NULL
              OR last_digest_at < now() - interval '23 hours')
       ORDER BY id
       LIMIT 8`
  );

  for (const sub of rows) {
    await email.send({
      to: sub.email,
      subject: 'Your daily digest',
      html: renderDigest(sub),
    });
    await db.query(
      'UPDATE subscribers SET last_digest_at = now() WHERE email = $1',
      [sub.email]
    );
  }

  res.json({ sent: rows.length, cron: isCron });
}