aboutsummaryrefslogtreecommitdiff
path: root/webmentions_ssg/tasks/retention.py
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--webmentions_ssg/tasks/retention.py29
1 files changed, 12 insertions, 17 deletions
diff --git a/webmentions_ssg/tasks/retention.py b/webmentions_ssg/tasks/retention.py
index 754c891..86283b7 100644
--- a/webmentions_ssg/tasks/retention.py
+++ b/webmentions_ssg/tasks/retention.py
@@ -5,12 +5,11 @@
"""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 ..db_helpers import rows_affected
from ..extensions import db
from ..models import ReceivedStatus, ReceivedWebmention
@@ -26,22 +25,18 @@ def purge_old_received_webmentions() -> int:
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,
- )
- ),
+ result = 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
- )
+ count = rows_affected(result)
+ if count:
+ current_app.logger.info("Purged %d old failed/deleted Webmentions", count)
- return result.rowcount
+ return count