View report triggers Django `UPDATE` with no change

[bwbroersma]

In dev mode, enable SQL logging:

docker compose --env-file docker/develop.env exec postgres psql -Uinternetnl internetnl_db1 -c "ALTER SYSTEM SET log_statement TO 'mod';" -c "SELECT pg_reload_conf();"
docker compose --env-file=docker/defaults.env --env-file=docker/develop.env logs -t postgres -f

View a report in the browser, see an UPDATE of checks_{domain,mail}testreport on every report request.

Related:

• Fixes #1246 and #1756 - Removed Hall of Fame task #1754

[bwbroersma]

Cannot reproduce.
Note in case of site (domain) reports with minimal local.env:

postgres-1  | 2025-05-19 22:44:35.545 UTC [173] LOG:  statement: INSERT INTO "checks_mailtestreport" ("timestamp", "domain", "registrar", "score", "ipv6_id", "dnssec_id", "auth_id", "tls_id", "rpki_id") VALUES ('2025-05-19T22:44:35.545390+00:00'::timestamptz, 'www.b6a.nl', '', NULL, NULL, 2, 2, NULL, NULL) RETURNING "checks_mailtestreport"."id"
postgres-1  | 2025-05-19 22:44:35.550 UTC [173] LOG:  statement: UPDATE "checks_mailtestreport" SET "timestamp" = '2025-05-19T22:44:35.545390+00:00'::timestamptz, "domain" = 'www.b6a.nl', "registrar" = 'Internet Service Europe B.V., SIDN BV', "score" = NULL, "ipv6_id" = NULL, "dnssec_id" = 2, "auth_id" = 2, "tls_id" = NULL, "rpki_id" = NULL WHERE "checks_mailtestreport"."id" = 2
postgres-1  | 2025-05-19 22:44:35.551 UTC [173] LOG:  statement: UPDATE "checks_mailtestreport" SET "timestamp" = '2025-05-19T22:44:35.545390+00:00'::timestamptz, "domain" = 'www.b6a.nl', "registrar" = 'Internet Service Europe B.V., SIDN BV', "score" = 100, "ipv6_id" = NULL, "dnssec_id" = 2, "auth_id" = 2, "tls_id" = NULL, "rpki_id" = NULL WHERE "checks_mailtestreport"."id" = 2

So:

1. INSERT with domain name and sub tests
2. UPDATE with registrar
3. UPDATE with score

local.env:

INTERNET_NL_CHECK_SUPPORT_IPV6=False
INTERNET_NL_CHECK_SUPPORT_TLS=False
INTERNET_NL_CHECK_SUPPORT_RPKI=False

COMPOSE_PROFILES=
ENABLE_BATCH=False