diff options
Diffstat (limited to 'webmentions_ssg/tasks/retention.py')
| -rw-r--r-- | webmentions_ssg/tasks/retention.py | 41 |
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 |
