Prune down table rows on ISO testing overview page

This table is getting very long as we have upwards of 210 ISOs in the
production database. However, it doesn't make much sense to list ISOs
that no longer exist and were never tested, so omit these from the
results page if we know this to be the case.

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

1 files changed, 8 insertions, 2 deletions

diff --git a/releng/views.py b/releng/views.py
index d8ea59f..fc81d41 100644
--- a/releng/views.py
+++ b/releng/views.py
@@ -177,12 +177,18 @@ def submit_test_thanks(request):
 
 def iso_overview(request):
     isos = Iso.objects.all().order_by('-pk')
-    successes = dict(Iso.objects.values_list('pk').filter(test__success=True).annotate(ct=Count('test')))
-    failures = dict(Iso.objects.values_list('pk').filter(test__success=False).annotate(ct=Count('test')))
+    successes = dict(Iso.objects.values_list('pk').filter(
+        test__success=True).annotate(ct=Count('test')))
+    failures = dict(Iso.objects.values_list('pk').filter(
+        test__success=False).annotate(ct=Count('test')))
     for iso in isos:
         iso.successes = successes.get(iso.pk, 0)
         iso.failures = failures.get(iso.pk, 0)
 
+    # only show "useful" rows, currently active ISOs or those with results
+    isos = [iso for iso in isos if
+            iso.active == True or iso.successes > 0 or iso.failures > 0]
+
     context = {
         'isos': isos
     }