Prune expired email verifications

[chadwhitacre]

@dowski points out at #4335 (comment) that we might consider regularly pruning expired email verifications (and, by extension, package claims).

gratipay::MAROON=> select count(*) from emails where verification_end is null and verification_start < now() - '1 day'::interval;
┌───────┐
│ count │
├───────┤
│  1702 │
└───────┘
(1 row)

gratipay::MAROON=> select count(*) from emails where verification_end is null;
┌───────┐
│ count │
├───────┤
│  1703 │
└───────┘
(1 row)

gratipay::MAROON=> select count(*) from emails;
┌───────┐
│ count │
├───────┤
│  7911 │
└───────┘
(1 row)

gratipay::MAROON=>

[rohitpaulk]

Interesting

[chadwhitacre]

Maybe after 30 days so we have them around for a while for debugging if need be?

[rohitpaulk]

One way to do this is to add a cron task that purges old verifications.

Resources that might help:

• Example of a PR that adds a cron job
• Code that registers cron tasks