diff options
Diffstat (limited to 'webmentions_ssg/views/sources.py')
| -rw-r--r-- | webmentions_ssg/views/sources.py | 17 |
1 files changed, 13 insertions, 4 deletions
diff --git a/webmentions_ssg/views/sources.py b/webmentions_ssg/views/sources.py index a3dbb45..22cabb6 100644 --- a/webmentions_ssg/views/sources.py +++ b/webmentions_ssg/views/sources.py @@ -13,7 +13,6 @@ import sqlalchemy as sa from flask import abort, current_app, flash, redirect, render_template, request, url_for from flask.typing import ResponseReturnValue from flask_login import login_required -from sqlalchemy.orm import selectinload from ..extensions import db from ..forms.admin import ConfirmActionForm @@ -68,9 +67,7 @@ def source_list() -> ResponseReturnValue: """Display source documents with filters for outgoing delivery problems.""" filter_form = source_filter_form() filters = source_filter_args(filter_form) - query = sa.select(SourceDocument).options( - selectinload(SourceDocument.sent_webmentions) - ) + query = sa.select(SourceDocument) # EXISTS avoids duplicate source rows when several Webmentions match. sent = sa.select(SentWebmention.uuid).where( @@ -144,6 +141,17 @@ def source_list() -> ResponseReturnValue: max_per_page=current_app.config["SOURCES_MAX_PAGE_SIZE"], ) + statistics = {} + if sources.items: + statistics = { + row.source_uuid: row + for row in db.session.execute( + SourceDocument.sent_webmention_statistics( + [source.uuid for source in sources.items] + ) + ) + } + sort_urls = {} for key in sort_columns: if key == sort_key: @@ -157,6 +165,7 @@ def source_list() -> ResponseReturnValue: "sent.html", title="Sent Webmentions", sources=sources, + statistics=statistics, filters=filters, sort_key=sort_key, sort_order=sort_order, |
