Add a new column to developer repo stats

Signed-off-by: Dan McGee <dan@archlinux.org>

1 files changed, 5 insertions, 0 deletions

diff --git a/devel/views.py b/devel/views.py
index 23ff9f74..ea85a901 100644
--- a/devel/views.py
+++ b/devel/views.py
@@ -55,6 +55,11 @@ def index(request):
             total_ct=Count('packages'), flagged_ct=Count('packages__flag_date'))
     repos = Repo.objects.all().annotate(
             total_ct=Count('packages'), flagged_ct=Count('packages__flag_date'))
+    # the join is huge unless we do this separately, so merge the result here
+    repo_maintainers = dict(Repo.objects.all().values_list('id').annotate(
+            Count('userprofile')))
+    for repo in repos:
+        repo.maintainer_ct = repo_maintainers.get(repo.id, 0)
 
     maintainers = get_annotated_maintainers()