notifycat-reconcile

Overview ¶

Command notifycat-reconcile is a one-time maintenance tool that marks slack_messages rows closed when their PR is no longer open on GitHub.

It exists for the migration to stuck-PR digest tracking: rows created before the close handler recorded closed_at all have closed_at = NULL and look open to the digest — including PRs that were already merged. Run it once (it is idempotent) to drop that backlog out of the digest.

Usage:

notifycat-reconcile            — mark closed PRs from their GitHub state
notifycat-reconcile -dry-run   — report what would change, write nothing

It reads PR state from GitHub, so GITHUB_TOKEN must be set with read access to the repos, and DATABASE_URL must point at the same database the server uses.