aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDennis Fink2026-11-18 08:01:26 +0100
committerDennis Fink2026-11-18 08:01:26 +0100
commitb908ee61770dc78f8d8fbbbfc4f3c00d7877d42a (patch)
tree322d85654e5518c2836ce57beafaa7e2abaab741
parent63af533d98aac82b6d4f069b217d3e837285508d (diff)
downloadwebmentions-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.
-rw-r--r--tests/tasks/test_scanner.py57
-rw-r--r--tests/test_cli.py1
-rw-r--r--tests/views/test_dashboard.py202
-rw-r--r--tests/views/test_session.py4
-rw-r--r--webmentions_ssg/migrations/versions/2b4c6e8a0d12_last_completed_source_scan.py38
-rw-r--r--webmentions_ssg/models/scan_state.py23
-rw-r--r--webmentions_ssg/tasks/scanner.py6
-rw-r--r--webmentions_ssg/templates/base.html2
-rw-r--r--webmentions_ssg/templates/dashboard.html148
-rw-r--r--webmentions_ssg/views/__init__.py3
-rw-r--r--webmentions_ssg/views/dashboard.py123
-rw-r--r--webmentions_ssg/views/session.py9
12 files changed, 604 insertions, 12 deletions
diff --git a/tests/tasks/test_scanner.py b/tests/tasks/test_scanner.py
index dbeeac9..af5a64e 100644
--- a/tests/tasks/test_scanner.py
+++ b/tests/tasks/test_scanner.py
@@ -17,6 +17,7 @@ from huey.exceptions import RetryTask
from pytest import MonkeyPatch
from webmentions_ssg import db
+from webmentions_ssg.models.scan_state import ScanState
from webmentions_ssg.models.sources import (
SentWebmention,
SentWebmentionStatus,
@@ -1464,3 +1465,59 @@ def test_scan_sources_ignores_root_index(
assert len(sources) == 1
assert sources[0].path == "example/index.html"
+
+
+def test_scan_records_only_completed_source_scans(
+ app: Flask, scanner_module: ModuleType, tmp_path: Path
+) -> None:
+ configure_scanner(app, tmp_path)
+ with app.app_context():
+ assert db.session.get(ScanState, 1) is None
+
+ # Empty traversals are inconclusive and do not report completion.
+ run_scan(app, scanner_module)
+ with app.app_context():
+ assert db.session.get(ScanState, 1) is None
+
+ write_post(tmp_path, "completed", "Completed scan")
+ before = datetime.now(UTC)
+ run_scan(app, scanner_module)
+ after = datetime.now(UTC)
+ with app.app_context():
+ state = db.session.get(ScanState, 1)
+ assert state is not None
+ recorded = state.last_completed_at.replace(tzinfo=UTC)
+ assert before <= recorded <= after
+
+ # Another inconclusive pass must preserve the completion time.
+ (tmp_path / "completed" / "index.html").unlink()
+ run_scan(app, scanner_module)
+ with app.app_context():
+ state = db.session.get(ScanState, 1)
+ assert state is not None
+ assert state.last_completed_at.replace(tzinfo=UTC) == recorded
+
+
+def test_failed_scan_does_not_update_completion_time(
+ app: Flask, scanner_module: ModuleType, tmp_path: Path, monkeypatch: MonkeyPatch
+) -> None:
+ configure_scanner(app, tmp_path)
+ write_post(tmp_path, "existing", "Scan succeeded")
+ run_scan(app, scanner_module)
+
+ with app.app_context():
+ previous = db.session.get(ScanState, 1)
+ assert previous is not None
+ previous_time = previous.last_completed_at
+
+ def fail(*args: Any, **kwargs: Any) -> None:
+ raise RuntimeError("parse failed")
+
+ monkeypatch.setattr(scanner_module, "reconcile_source_tree", fail)
+ with pytest.raises(RuntimeError, match="parse failed"):
+ run_scan(app, scanner_module)
+
+ with app.app_context():
+ state = db.session.get(ScanState, 1)
+ assert state is not None
+ assert state.last_completed_at == previous_time
diff --git a/tests/test_cli.py b/tests/test_cli.py
index 5e71e2a..5699bb3 100644
--- a/tests/test_cli.py
+++ b/tests/test_cli.py
@@ -148,6 +148,7 @@ def test_create_db_builds_schema_and_records_latest_migration(
"users",
"received_webmentions",
"source_documents",
+ "scan_state",
} <= table_names
assert "sources" not in table_names
assert {
diff --git a/tests/views/test_dashboard.py b/tests/views/test_dashboard.py
new file mode 100644
index 0000000..05730dd
--- /dev/null
+++ b/tests/views/test_dashboard.py
@@ -0,0 +1,202 @@
+# SPDX-FileCopyrightText: 2026 Dennis Fink <me+coding@dennisfink.me>
+#
+# SPDX-License-Identifier: BSD-3-Clause
+
+from datetime import UTC, datetime, timedelta
+from http import HTTPStatus
+from uuid import UUID
+
+import pytest
+from bs4 import BeautifulSoup
+from flask import Flask
+from flask.testing import FlaskClient
+
+from webmentions_ssg import db
+from webmentions_ssg.models.received import ReceivedWebmention, ReceivedWebmentionStatus
+from webmentions_ssg.models.scan_state import ScanState
+from webmentions_ssg.models.sources import (
+ SentWebmention,
+ SentWebmentionStatus,
+ SourceDocument,
+)
+from webmentions_ssg.views import dashboard
+
+from .helpers import log_in
+
+
+def received_uuid(at: datetime, sequence: int) -> UUID:
+ """Construct a UUIDv7 at a controlled creation time for activity tests."""
+ return UUID(
+ int=(int(at.timestamp() * 1000) << 80) | (7 << 76) | (2 << 62) | sequence
+ )
+
+
+def test_dashboard_is_private_and_empty_by_default(
+ app: Flask, client: FlaskClient
+) -> None:
+ response = client.get("/")
+ assert response.status_code == HTTPStatus.FOUND
+ assert response.headers["Location"].startswith("/login?")
+
+ log_in(app, client)
+ response = client.get("/")
+ assert response.status_code == HTTPStatus.OK
+ soup = BeautifulSoup(response.get_data(as_text=True), "html.parser")
+ received = soup.find("section", attrs={"aria-labelledby": "received-summary"})
+ outgoing = soup.find("section", attrs={"aria-labelledby": "sent-summary"})
+ assert received is not None
+ assert outgoing is not None
+ assert "0 total" in received.get_text(" ", strip=True)
+ assert "0 total" in outgoing.get_text(" ", strip=True)
+ assert "No completed scan yet" in response.get_data(as_text=True)
+ assert "Huey pending tasks" in response.get_data(as_text=True)
+ assert 'href="/received?status=declined"' in response.get_data(as_text=True)
+ assert 'href="/"' in response.get_data(as_text=True)
+
+
+def test_dashboard_counts_statuses_windows_retries_and_queue(
+ app: Flask, client: FlaskClient, monkeypatch: pytest.MonkeyPatch
+) -> None:
+ log_in(app, client)
+ now = datetime.now(UTC)
+ with app.app_context():
+ for sequence, (status, days) in enumerate(
+ (
+ (ReceivedWebmentionStatus.RECEIVED, 1),
+ (ReceivedWebmentionStatus.VERIFYING, 8),
+ (ReceivedWebmentionStatus.VERIFIED, 31),
+ (ReceivedWebmentionStatus.FAILED, 2),
+ (ReceivedWebmentionStatus.SOURCE_REMOVED, 3),
+ ),
+ start=1,
+ ):
+ db.session.add(
+ ReceivedWebmention(
+ uuid=received_uuid(now - timedelta(days=days), sequence),
+ source=f"https://source.example/{sequence}",
+ target="https://site.example/post",
+ status=status,
+ # Old updates must not change creation-based activity counts.
+ updated_at=now,
+ )
+ )
+ source = SourceDocument(
+ path="post/index.html",
+ url="https://site.example/post",
+ content_hash="0" * 32,
+ revision=2,
+ last_seen_at=now,
+ revised_at=now,
+ )
+ source.sent_webmentions.extend(
+ [
+ SentWebmention(
+ target="https://target.example/success",
+ desired_revision=2,
+ processed_revision=2,
+ status=SentWebmentionStatus.SENT,
+ last_sent_at=now - timedelta(days=3),
+ ),
+ SentWebmention(
+ target="https://target.example/unsupported",
+ desired_revision=2,
+ processed_revision=2,
+ status=SentWebmentionStatus.NO_ENDPOINT,
+ ),
+ SentWebmention(
+ target="https://target.example/failed",
+ desired_revision=2,
+ processed_revision=2,
+ status=SentWebmentionStatus.FAILED,
+ ),
+ SentWebmention(
+ target="https://target.example/retry",
+ desired_revision=2,
+ status=SentWebmentionStatus.FAILED,
+ attempt_count=1,
+ next_retry_at=now + timedelta(hours=1),
+ ),
+ SentWebmention(
+ target="https://target.example/pending", desired_revision=2
+ ),
+ SentWebmention(
+ target="https://target.example/not-attempted",
+ desired_revision=2,
+ processed_revision=2,
+ linked=False,
+ ),
+ # A claimed in-flight send has a future deadline but no
+ # recorded failure and must not count as waiting to retry.
+ SentWebmention(
+ target="https://target.example/inflight",
+ desired_revision=2,
+ next_retry_at=now + timedelta(hours=1),
+ ),
+ ]
+ )
+ db.session.add(source)
+ db.session.add(ScanState(id=1, last_completed_at=now))
+ db.session.commit()
+
+ monkeypatch.setattr(dashboard.huey.huey, "pending_count", lambda: 4)
+ response = client.get("/")
+ assert response.status_code == HTTPStatus.OK
+ soup = BeautifulSoup(response.get_data(as_text=True), "html.parser")
+
+ received = soup.find("section", attrs={"aria-labelledby": "received-summary"})
+ outgoing = soup.find("section", attrs={"aria-labelledby": "sent-summary"})
+ assert received is not None
+ assert outgoing is not None
+ received_text = received.get_text(" ", strip=True)
+ outgoing_text = outgoing.get_text(" ", strip=True)
+ assert "5 total" in received_text
+ assert "Pending 1" in received_text
+ assert "Verifying 1" in received_text
+ assert "Verified 1" in received_text
+ assert "Declined 2" in received_text
+ assert "Failed: 1 · Source removed: 1" in received_text
+ assert "7 total" in outgoing_text
+ assert "Sent 1" in outgoing_text
+ assert "No endpoint 1" in outgoing_text
+ assert "Failed (final) 1" in outgoing_text
+ assert "Not attempted 1" in outgoing_text
+ assert "Pending 3" in outgoing_text
+ assert "Waiting to retry: 1" in outgoing_text
+
+ recent = soup.find("section", attrs={"aria-labelledby": "recent-activity"})
+ assert recent is not None
+ rows = recent.find_all("tr")
+ received_cells = rows[1].find_all(["td", "th"])
+ assert [cell.get_text(" ", strip=True) for cell in received_cells] == [
+ "New received Webmentions",
+ "3",
+ "4",
+ ]
+ sent_cells = rows[2].find_all(["td", "th"])
+ assert [cell.get_text(" ", strip=True) for cell in sent_cells] == [
+ "Webmentions last sent successfully",
+ "1",
+ "1",
+ ]
+ operations = soup.find("section", attrs={"aria-labelledby": "operations"})
+ assert operations is not None
+ assert "Source documents 1" in operations.get_text(" ", strip=True)
+ assert "Huey pending tasks 4" in operations.get_text(" ", strip=True)
+ assert "Last completed source scan" in operations.get_text(" ", strip=True)
+ assert operations.find("time") is not None
+
+
+def test_dashboard_handles_unavailable_queue(
+ app: Flask, client: FlaskClient, monkeypatch: pytest.MonkeyPatch
+) -> None:
+ log_in(app, client)
+
+ def unavailable() -> int:
+ raise RuntimeError("backend unavailable")
+
+ monkeypatch.setattr(dashboard.huey.huey, "pending_count", unavailable)
+ response = client.get("/")
+
+ assert response.status_code == HTTPStatus.OK
+ assert "Huey pending tasks" in response.get_data(as_text=True)
+ assert "Unavailable" in response.get_data(as_text=True)
diff --git a/tests/views/test_session.py b/tests/views/test_session.py
index 7edee71..f110a26 100644
--- a/tests/views/test_session.py
+++ b/tests/views/test_session.py
@@ -436,8 +436,8 @@ def test_logout_ends_session(app: Flask, client: FlaskClient) -> None:
assert "/login" in protected_response.headers["Location"]
-def test_index_redirects_to_received(client: FlaskClient) -> None:
+def test_index_requires_login(client: FlaskClient) -> None:
response = client.get("/")
assert response.status_code == HTTPStatus.FOUND
- assert response.headers["Location"].endswith("/received")
+ assert "/login" in response.headers["Location"]
diff --git a/webmentions_ssg/migrations/versions/2b4c6e8a0d12_last_completed_source_scan.py b/webmentions_ssg/migrations/versions/2b4c6e8a0d12_last_completed_source_scan.py
new file mode 100644
index 0000000..168647f
--- /dev/null
+++ b/webmentions_ssg/migrations/versions/2b4c6e8a0d12_last_completed_source_scan.py
@@ -0,0 +1,38 @@
+# SPDX-FileCopyrightText: 2026 Dennis Fink <me+coding@dennisfink.me>
+#
+# SPDX-License-Identifier: BSD-3-Clause
+
+"""Track the last successful source scan.
+
+Revision ID: 2b4c6e8a0d12
+Revises: ef8a9b6c2d41
+"""
+
+import sqlalchemy as sa
+from alembic import op
+
+revision = "2b4c6e8a0d12"
+down_revision = "ef8a9b6c2d41"
+branch_labels = None
+depends_on = None
+
+
+def upgrade():
+ op.create_table(
+ "scan_state",
+ sa.Column("id", sa.Integer(), primary_key=True),
+ sa.Column("last_completed_at", sa.DateTime(timezone=True), nullable=False),
+ )
+ # Seed a best-effort historical completion time from previously scanned
+ # sources. The next completed scan will update the authoritative value.
+ op.execute(
+ sa.text(
+ "INSERT INTO scan_state (id, last_completed_at) "
+ "SELECT 1, MAX(last_seen_at) FROM source_documents "
+ "HAVING COUNT(*) > 0"
+ )
+ )
+
+
+def downgrade():
+ op.drop_table("scan_state")
diff --git a/webmentions_ssg/models/scan_state.py b/webmentions_ssg/models/scan_state.py
new file mode 100644
index 0000000..924c15d
--- /dev/null
+++ b/webmentions_ssg/models/scan_state.py
@@ -0,0 +1,23 @@
+# SPDX-FileCopyrightText: 2026 Dennis Fink <me+coding@dennisfink.me>
+#
+# SPDX-License-Identifier: BSD-3-Clause
+
+"""Persist the last completed source scan for this single-site service."""
+
+from datetime import datetime
+
+from sqlalchemy import DateTime, Integer
+from sqlalchemy.orm import Mapped, mapped_column
+
+from ..extensions import Base
+
+
+class ScanState(Base):
+ """The single row tracking the most recent successful source scan."""
+
+ __tablename__ = "scan_state"
+
+ id: Mapped[int] = mapped_column(Integer, primary_key=True)
+ last_completed_at: Mapped[datetime] = mapped_column(
+ DateTime(timezone=True), nullable=False
+ )
diff --git a/webmentions_ssg/tasks/scanner.py b/webmentions_ssg/tasks/scanner.py
index 1f98702..9058b9b 100644
--- a/webmentions_ssg/tasks/scanner.py
+++ b/webmentions_ssg/tasks/scanner.py
@@ -14,6 +14,7 @@ from huey.exceptions import RetryTask, TaskLockedException
from sqlalchemy.orm import selectinload
from ..extensions import db, huey
+from ..models.scan_state import ScanState
from ..models.sources import SentWebmention, SourceDocument
from ..net import is_http_url
from .sender import send_webmention
@@ -304,6 +305,11 @@ def _scan_and_enqueue() -> None:
db.session.commit()
pending_count = enqueue_due_sends(scan_time)
+ # Mark a scan complete only after reconciliation and task enqueueing have
+ # succeeded. An inconclusive or interrupted scan keeps the previous value.
+ db.session.merge(ScanState(id=1, last_completed_at=datetime.now(UTC)))
+ db.session.commit()
+
current_app.logger.info(
"Webmention source scan complete: %d sources scanned, "
"%d missing sources, %d pending sends",
diff --git a/webmentions_ssg/templates/base.html b/webmentions_ssg/templates/base.html
index 4fffb38..115f193 100644
--- a/webmentions_ssg/templates/base.html
+++ b/webmentions_ssg/templates/base.html
@@ -43,6 +43,8 @@ SPDX-License-Identifier: BSD-3-Clause
</a>
{% if current_user.is_authenticated %}
<div class="navbar-nav flex-row gap-3">
+ <a class="nav-link{% if request.endpoint == 'webmentions.index' %} active{% endif %}"
+ href="{{ url_for('webmentions.index') }}">Dashboard</a>
<a class="nav-link{% if request.endpoint in ('webmentions.received_list', 'webmentions.received_detail') %} active{% endif %}"
href='{{ url_for("webmentions.received_list") }}'>Received</a>
<a class="nav-link{% if request.endpoint and request.endpoint.startswith('webmentions.moderation') %} active{% endif %}"
diff --git a/webmentions_ssg/templates/dashboard.html b/webmentions_ssg/templates/dashboard.html
new file mode 100644
index 0000000..a7f968e
--- /dev/null
+++ b/webmentions_ssg/templates/dashboard.html
@@ -0,0 +1,148 @@
+<!--
+SPDX-FileCopyrightText: 2026 Dennis Fink <me+coding@dennisfink.me>
+
+SPDX-License-Identifier: BSD-3-Clause
+-->
+{% extends "base.html" %}
+
+{% block content %}
+ <div class="d-flex justify-content-between align-items-center mb-4">
+ <h1 class="mb-0">Dashboard</h1>
+ <span class="text-body-secondary">Single-site overview</span>
+ </div>
+
+ <div class="row g-4 mb-4">
+ <section class="col-lg-6" aria-labelledby="received-summary">
+ <div class="card h-100">
+ <div class="card-body">
+ <div class="d-flex justify-content-between align-items-center mb-3">
+ <h2 class="h4 mb-0" id="received-summary">Received</h2>
+ <a href="{{ url_for('webmentions.received_list') }}">View all</a>
+ </div>
+ <p class="display-6 mb-3">{{ received_total }} <span class="fs-6 text-body-secondary">total</span></p>
+ <div class="row row-cols-2 g-3">
+ <div class="col">
+ <a href="{{ url_for('webmentions.received_list', status='pending') }}">Pending</a>
+ <div class="h3">{{ received_counts.received }}</div>
+ </div>
+ <div class="col">
+ <a href="{{ url_for('webmentions.received_list', status='verifying') }}">Verifying</a>
+ <div class="h3">{{ received_counts.verifying }}</div>
+ </div>
+ <div class="col">
+ <a href="{{ url_for('webmentions.received_list', status='verified') }}">Verified</a>
+ <div class="h3">{{ received_counts.verified }}</div>
+ </div>
+ <div class="col">
+ <a href="{{ url_for('webmentions.received_list', status='declined') }}">Declined</a>
+ <div class="h3">{{ received_counts.failed + received_counts.source_removed }}</div>
+ <p class="small text-body-secondary mb-0">Failed: {{ received_counts.failed }} · Source removed: {{ received_counts.source_removed }}</p>
+ </div>
+ </div>
+ </div>
+ </div>
+ </section>
+
+ <section class="col-lg-6" aria-labelledby="sent-summary">
+ <div class="card h-100">
+ <div class="card-body">
+ <div class="d-flex justify-content-between align-items-center mb-3">
+ <h2 class="h4 mb-0" id="sent-summary">Outgoing</h2>
+ <a href="{{ url_for('webmentions.source_list') }}">View sources</a>
+ </div>
+ <p class="display-6 mb-3">{{ sent_total }} <span class="fs-6 text-body-secondary">total</span></p>
+ <div class="row row-cols-2 g-3">
+ <div class="col">
+ <div>Sent</div>
+ <div class="h3">{{ sent_counts.sent }}</div>
+ </div>
+ <div class="col">
+ <div>No endpoint</div>
+ <div class="h3">{{ sent_counts.no_endpoint }}</div>
+ </div>
+ <div class="col">
+ <div>Failed (final)</div>
+ <div class="h3">{{ sent_counts.failed }}</div>
+ </div>
+ <div class="col">
+ <div>Not attempted</div>
+ <div class="h3">{{ not_attempted }}</div>
+ </div>
+ <div class="col">
+ <div>Pending</div>
+ <div class="h3">{{ pending_sends }}</div>
+ <p class="small text-body-secondary mb-0">Waiting to retry: {{ waiting_retries }}</p>
+ </div>
+ </div>
+ </div>
+ </div>
+ </section>
+ </div>
+
+ <section class="mb-4" aria-labelledby="recent-activity">
+ <h2 class="h4" id="recent-activity">Recent activity</h2>
+ <div class="table-responsive">
+ <table class="table table-bordered align-middle">
+ <thead>
+ <tr>
+ <th scope="col">Activity (UTC)</th>
+ <th scope="col">Last 7 days</th>
+ <th scope="col">Last 30 days</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <th scope="row">New received Webmentions</th>
+ <td>{{ recent[7].received }}</td>
+ <td>{{ recent[30].received }}</td>
+ </tr>
+ <tr>
+ <th scope="row">Webmentions last sent successfully</th>
+ <td>{{ recent[7].sent }}</td>
+ <td>{{ recent[30].sent }}</td>
+ </tr>
+ </tbody>
+ </table>
+ </div>
+ </section>
+
+ <section aria-labelledby="operations">
+ <h2 class="h4" id="operations">Operations</h2>
+ <div class="row g-3">
+ <div class="col-md-4">
+ <div class="card h-100">
+ <div class="card-body">
+ <h3 class="h6 text-body-secondary">Source documents</h3>
+ <p class="h3 mb-0">{{ source_count }}</p>
+ </div>
+ </div>
+ </div>
+ <div class="col-md-4">
+ <div class="card h-100">
+ <div class="card-body">
+ <h3 class="h6 text-body-secondary">Last completed source scan</h3>
+ {% if last_scan %}
+ <time datetime="{{ last_scan.isoformat() }}" class="fs-5">
+ {{ last_scan.strftime("%Y-%m-%d %H:%M:%S") }} UTC
+ </time>
+ {% else %}
+ <p class="text-body-secondary mb-0">No completed scan yet</p>
+ {% endif %}
+ </div>
+ </div>
+ </div>
+ <div class="col-md-4">
+ <div class="card h-100">
+ <div class="card-body">
+ <h3 class="h6 text-body-secondary">Huey pending tasks</h3>
+ {% if queue_size is not none %}
+ <p class="h3 mb-0">{{ queue_size }}</p>
+ {% else %}
+ <p class="text-body-secondary mb-0">Unavailable</p>
+ {% endif %}
+ </div>
+ </div>
+ </div>
+ </div>
+ </section>
+{% endblock %}
diff --git a/webmentions_ssg/views/__init__.py b/webmentions_ssg/views/__init__.py
index a4954b6..5abaa14 100644
--- a/webmentions_ssg/views/__init__.py
+++ b/webmentions_ssg/views/__init__.py
@@ -4,10 +4,11 @@
"""Collect and expose the routes for the blueprint."""
-from . import endpoint, moderation, received, session, sources, user
+from . import dashboard, endpoint, moderation, received, session, sources, user
from .blueprint import webmentions_bp
__all__ = [
+ "dashboard",
"endpoint",
"moderation",
"received",
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,
+ )
diff --git a/webmentions_ssg/views/session.py b/webmentions_ssg/views/session.py
index 78d1ed6..99c0a1c 100644
--- a/webmentions_ssg/views/session.py
+++ b/webmentions_ssg/views/session.py
@@ -17,15 +17,6 @@ from ..models.user import User
from .blueprint import webmentions_bp
-@webmentions_bp.route("/")
-def index() -> ResponseReturnValue:
- """Redirect to the received Webmentions view.
-
- :returns: Redirect response to the received Webmentions view.
- """
- return redirect(url_for("webmentions.received_list"))
-
-
@webmentions_bp.route("/login", methods=["GET", "POST"])
@limiter.limit(
lambda: current_app.config["LOGIN_USERNAME_RATE_LIMIT"],