# SPDX-FileCopyrightText: 2026 Dennis Fink # # 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 ..extensions import DATABASE as db from ..models import ReceivedStatus, 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_( (ReceivedStatus.FAILED, ReceivedStatus.DELETED) ), ReceivedWebmention.updated_at < cutoff, ) ), ) db.session.commit() if result.rowcount: current_app.logger.info( "Purged %d old failed/deleted Webmentions", result.rowcount ) return result.rowcount