diff options
| author | Dennis Fink | 2026-11-18 08:01:26 +0100 |
|---|---|---|
| committer | Dennis Fink | 2026-11-18 08:01:26 +0100 |
| commit | b908ee61770dc78f8d8fbbbfc4f3c00d7877d42a (patch) | |
| tree | 322d85654e5518c2836ce57beafaa7e2abaab741 /webmentions_ssg/views/dashboard.py | |
| parent | 63af533d98aac82b6d4f069b217d3e837285508d (diff) | |
| download | webmentions-ssg-b908ee61770dc78f8d8fbbbfc4f3c00d7877d42a.tar.gz webmentions-ssg-b908ee61770dc78f8d8fbbbfc4f3c00d7877d42a.zip | |
feat(core): add dashboard overview
Replace the root redirect with an authenticated dashboard showing
received and outgoing status counts, recent activity, pending sends,
retries, and queue depth.
Persist the last completed source scan so operational status survives
restarts and only advances after a successful, conclusive scan.
Diffstat (limited to '')
| -rw-r--r-- | webmentions_ssg/views/dashboard.py | 123 |
1 files changed, 123 insertions, 0 deletions
diff --git a/webmentions_ssg/views/dashboard.py b/webmentions_ssg/views/dashboard.py new file mode 100644 index 0000000..26b0134 --- /dev/null +++ b/webmentions_ssg/views/dashboard.py @@ -0,0 +1,123 @@ +# SPDX-FileCopyrightText: 2026 Dennis Fink <me+coding@dennisfink.me> +# +# SPDX-License-Identifier: BSD-3-Clause + +"""A private, single-site overview of incoming and outgoing Webmentions.""" + +from datetime import UTC, datetime, timedelta +from uuid import UUID + +import sqlalchemy as sa +from flask import current_app, render_template +from flask.typing import ResponseReturnValue +from flask_login import login_required + +from ..extensions import db, huey +from ..models.received import ReceivedWebmention, ReceivedWebmentionStatus +from ..models.scan_state import ScanState +from ..models.sources import SentWebmention, SentWebmentionStatus, SourceDocument +from .blueprint import webmentions_bp + + +def uuid7_lower_bound(at: datetime) -> UUID: + """Get the smallest UUIDv7 with a creation time at or after ``at``. + + Received Webmentions store their creation time in their UUIDv7 primary key, + not in a separate timestamp column. UUIDv7 orders by Unix milliseconds. + """ + milliseconds = int(at.timestamp() * 1000) + return UUID(int=(milliseconds << 80) | (7 << 76)) + + +@webmentions_bp.get("/") +@login_required +def index() -> ResponseReturnValue: + """Show persisted site activity, delivery health, and worker queue depth.""" + now = datetime.now(UTC) + + received_counts = dict( + db.session.execute( + sa.select(ReceivedWebmention.status, sa.func.count()).group_by( + ReceivedWebmention.status + ) + ).all() + ) + + sent_counts = dict( + db.session.execute( + sa.select(SentWebmention.status, sa.func.count()) + .where(~SentWebmention.awaiting_processing) + .group_by(SentWebmention.status) + ).all() + ) + + pending_sends = db.session.scalar( + sa.select(sa.func.count()) + .select_from(SentWebmention) + .where(SentWebmention.awaiting_processing) + ) + + # A claimed attempt also has a future deadline, but isn't necessarily a + # retry. Only show failed attempts awaiting their next scheduled retry. + waiting_retries = db.session.scalar( + sa.select(sa.func.count()) + .select_from(SentWebmention) + .where( + SentWebmention.awaiting_processing, + SentWebmention.status == SentWebmentionStatus.FAILED, + SentWebmention.next_retry_at > now, + ) + ) + + recent: dict[int, dict[str, int]] = {} + for days in (7, 30): + cutoff = now - timedelta(days=days) + recent[days] = { + "received": db.session.scalar( + sa.select(sa.func.count()) + .select_from(ReceivedWebmention) + .where(ReceivedWebmention.uuid >= uuid7_lower_bound(cutoff)) + ) + or 0, + "sent": db.session.scalar( + sa.select(sa.func.count()) + .select_from(SentWebmention) + .where(SentWebmention.last_sent_at >= cutoff) + ) + or 0, + } + + try: + queue_size = huey.huey.pending_count() + except Exception: + current_app.logger.exception("Could not read Huey pending queue depth") + queue_size = None + + scan = db.session.get(ScanState, 1) + last_scan = scan.last_completed_at if scan is not None else None + # SQLite drops timezone information when reading DateTime columns. + if last_scan is not None and last_scan.tzinfo is None: + last_scan = last_scan.replace(tzinfo=UTC) + + sources = db.session.scalar(sa.select(sa.func.count()).select_from(SourceDocument)) + + return render_template( + "dashboard.html", + title="Dashboard", + received_counts={ + status.value: received_counts.get(status, 0) + for status in ReceivedWebmentionStatus + }, + received_total=sum(received_counts.values()), + sent_counts={ + status.value: sent_counts.get(status, 0) for status in SentWebmentionStatus + }, + sent_total=sum(sent_counts.values()) + (pending_sends or 0), + not_attempted=sent_counts.get(None, 0), + pending_sends=pending_sends or 0, + waiting_retries=waiting_retries or 0, + recent=recent, + source_count=sources or 0, + last_scan=last_scan, + queue_size=queue_size, + ) |
