From c1ccc88d0769afc16363ceb06e5bdcd8605455bf Mon Sep 17 00:00:00 2001 From: Dan McGee Date: Tue, 17 Apr 2012 15:36:33 -0500 Subject: 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 --- releng/views.py | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) (limited to 'releng') diff --git a/releng/views.py b/releng/views.py index d8ea59f9..fc81d410 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 } -- cgit v1.2.3-55-g3dc8