letsencrypt / boulder / 11482

66%

push

travis-ci

janitor: add cleanup of Orders and assoc. rows. (#4544)

The `boulder-janitor` is extended to cleanup rows from the `orders` table that
have expired beyond the configured grace period, and the associated referencing
rows in `requestedNames`, `orderFqdnSets`, and `orderToAuthz2`.

To make implementing the transaction work for the deletions easier/consistent
I lifted the SA's `WithTransaction` code and assoc. functions to a new shared
`db` package. This also let me drop the one-off `janitorDb` interface from the
existing code.

There is an associated change to the `GRANT` statements for the `janitor` DB
user to allow it to find/delete the rows related to orders.

Resolves https://github.com/letsencrypt/boulder/issues/4527

108 of 108 new or added lines in 11 files covered. (100.0%)

11735 of 18285 relevant lines covered (64.18%)

0.72 hits per line