Add a max_days param, default 10, to failures page.

diff --git a/cgi-bin/show_failures.pl b/cgi-bin/show_failures.pl
index ba6837b138a353d4ac7258e0202532d35ee3292f..15b0be5e3c628e7288080f2ba36895487df2b766 100755 (executable)
--- a/cgi-bin/show_failures.pl
+++ b/cgi-bin/show_failures.pl
@@ -21,6 +21,7 @@ require "$ENV{BFConfDir}/BuildFarmWeb.pl";
 my $query = new CGI;
 my @members = $query->param('member');
 map { s/[^a-zA-Z0-9_ -]//g; } @members;
+my $max_days =  $query->param('max_days') + 0 || 10;
 
 my $dsn="dbi:Pg:dbname=$dbname";
 $dsn .= ";host=$dbhost" if $dbhost;
@@ -52,6 +53,7 @@ my $statement =<<EOS;
   from nrecent_failures_db_data b
        left join  dashboard_mat d
                on (d.sysname = b.sysname and d.branch = b.branch)
+  where (now()::timestamp(0) without time zone - b.snapshot) < (? * interval '1 day')
   order by $presort_clause 
         b.branch = 'HEAD' desc,
         b.branch desc, 
@@ -63,7 +65,7 @@ EOS
 
 my $statrows=[];
 my $sth=$db->prepare($statement);
-$sth->execute;
+$sth->execute($max_days);
 while (my $row = $sth->fetchrow_hashref)
 {
     next if (@members && ! grep {$_ eq $row->{sysname} } @members);
@@ -100,6 +102,7 @@ print "Content-Type: text/html\n\n";
 $template->process('fstatus.tt',
                {statrows=>$statrows, 
                 sortby => $sortby,
+                max_days => $max_days,
                 members=> \@members} );
 
 exit;

diff --git a/templates/fstatus.tt b/templates/fstatus.tt
index e88b4887bd76290989ffba8f04b0677db4cfd608..7df7d32404894c9d633f41350b3ca76595121046 100644 (file)
--- a/templates/fstatus.tt
+++ b/templates/fstatus.tt
@@ -38,7 +38,7 @@ See accompanying License file for license details
 %]
     <h1>PostgreSQL BuildFarm Recent Failures</h1>
     <p>
-      Shown here are build failures that occurred in the last 90 days.
+      Shown here are build failures that occurred in the last [% max_days %] days. For a longer (or shorter) time span, up to 90 days, add a query parameter of "max_days=nn".
     </p>
     <p>
        Use the farm member link for history of that member