aboutsummaryrefslogtreecommitdiff
path: root/webmentions_ssg/tasks/retention.py
diff options
context:
space:
mode:
authorDennis Fink2026-10-31 17:42:00 +0100
committerDennis Fink2026-10-31 17:42:00 +0100
commit6924ad7e52033365c55d5afacdd916c502cc80cb (patch)
tree8a52b8e8fbae7a6bcc85d250cac2436a2c42e748 /webmentions_ssg/tasks/retention.py
parent3494eab1208dc18478485e02c61e292556502fa6 (diff)
downloadwebmentions-ssg-6924ad7e52033365c55d5afacdd916c502cc80cb.tar.gz
webmentions-ssg-6924ad7e52033365c55d5afacdd916c502cc80cb.zip
feat(receiver): add resource limits and retention
Bound incoming request and URL sizes so untrusted Webmention submissions cannot consume unbounded application or database resources. Purge old failed and deleted received Webmentions on a schedule, and use portable SHA-256 URL fingerprints to preserve uniqueness for long URLs.
Diffstat (limited to '')
-rw-r--r--webmentions_ssg/tasks/retention.py41
1 files changed, 41 insertions, 0 deletions
diff --git a/webmentions_ssg/tasks/retention.py b/webmentions_ssg/tasks/retention.py
new file mode 100644
index 0000000..727b186
--- /dev/null
+++ b/webmentions_ssg/tasks/retention.py
@@ -0,0 +1,41 @@
+# SPDX-FileCopyrightText: 2026 Dennis Fink <me+coding@dennisfink.me>
+#
+# SPDX-License-Identifier: BSD-3-Clause
+
+"""Delete old received Webmentions in terminal unsuccessful states."""
+
+from datetime import UTC, datetime, timedelta
+from typing import Any, cast
+
+import sqlalchemy as sa
+from flask import current_app
+from sqlalchemy.engine import CursorResult
+
+from .. import DATABASE as db
+from ..models import ReceivedWebmention
+
+
+def purge_old_received_webmentions() -> int:
+ """Delete old failed/deleted received rows, retaining verified and in-flight ones.
+
+ The status/time predicate is checked by the database in one DELETE, so a
+ row recently requeued for verification is not purged based on a stale read.
+ Outgoing sources and Webmentions are intentionally unaffected.
+ """
+ cutoff = datetime.now(UTC) - timedelta(
+ days=current_app.config["RECEIVED_RETENTION_DAYS"]
+ )
+ result = cast(
+ CursorResult[Any],
+ db.session.execute(
+ sa.delete(ReceivedWebmention).where(
+ ReceivedWebmention.status.in_(("failed", "deleted")),
+ ReceivedWebmention.updated_at < cutoff,
+ )
+ ),
+ )
+ db.session.commit()
+ removed = result.rowcount
+ if removed:
+ current_app.logger.info("Purged %d old failed/deleted Webmentions", removed)
+ return removed