fix URL to point to current CVS web

[buildfarm-server.git] / cgi-bin / show_status.pl

diff --git a/cgi-bin/show_status.pl b/cgi-bin/show_status.pl
old mode 100644 (file)
new mode 100755 (executable)
index 038776f..d60fb9f
--- a/cgi-bin/show_status.pl
+++ b/cgi-bin/show_status.pl
@@ -18,67 +18,33 @@ my $dsn="dbi:Pg:dbname=$dbname";
 $dsn .= ";host=$dbhost" if $dbhost;
 $dsn .= ";port=$dbport" if $dbport;
 
+
+my $sort_clause = "";
+my $sortby = $query->param('sortby') || 'nosort';
+if ($sortby eq 'name')
+{
+       $sort_clause = 'lower(sysname),';
+}
+elsif ($sortby eq 'os')
+{
+       $sort_clause = 'lower(operating_system), os_version desc,'; 
+}
+elsif ($sortby eq 'compiler')
+{
+       $sort_clause = "lower(compiler), compiler_version,";
+}
+
 my $db = DBI->connect($dsn,$dbuser,$dbpass) or die("$dsn,$dbuser,$dbpass,$!");
 
-# there is possibly some redundancy in this query, but it makes
-# a lot of the processing simpler.
-
-my $statement = <<EOS;
-
-  select (now() at time zone 'GMT')::timestamp(0) - snapshot as when_ago,
-      sysname, snapshot, b.status, stage, branch, build_flags,
-      operating_system, os_version, compiler, compiler_version, architecture 
-  from buildsystems s, 
-       build_status b
-       natural join 
-       (select sysname, branch, max(snapshot) as snapshot
-        from build_status
-        group by sysname, branch
-       having max(snapshot) > now() - '30 days'::interval
-       ) m
-  where name = sysname
-        and s.status = 'approved'
-  order by branch = 'HEAD' desc, 
-        branch desc, 
-        snapshot desc
+my $statement =<<EOS;
 
-EOS
-;
 
-$statement =<<EOS;
-
-
-  select (now() at time zone 'GMT')::timestamp(0) - snapshot as when_ago,
-       sysname, snapshot, b.status, stage, branch, build_flags,
-       operating_system, coalesce(b.os_version,s.os_version) as os_version,
-       compiler, coalesce(b.compiler_version, s.compiler_version) as compiler_version, 
-       architecture 
-  from buildsystems s, 
-        (
-       select distinct on (bs.sysname, bs.branch, bs.report_time) 
-               sysname, snapshot, status, stage, branch, build_flags,
-               report_time ,compiler_version, os_version
-        from build_status bs
-             left join 
-             personality p
-             on (p.name = bs.sysname and p.effective_date <= bs.report_time)
-        order by bs.sysname, bs.branch, bs.report_time, 
-                 p.effective_date is null, p.effective_date desc
-        ) as b
-       natural join 
-               (select sysname, branch, max(snapshot) as snapshot
-        from build_status
-        group by sysname, branch
-       having max(snapshot) > now() - '30 days'::interval
-               ) m
-  where name = sysname
-        and s.status = 'approved'
+  select *
+  from dashboard
   order by branch = 'HEAD' desc,
-        branch desc, 
+        branch desc, $sort_clause 
         snapshot desc
 
-
-
 EOS
 ;
 
@@ -90,7 +56,14 @@ while (my $row = $sth->fetchrow_hashref)
     next if (@members && ! grep {$_ eq $row->{sysname} } @members);
     $row->{build_flags}  =~ s/^\{(.*)\}$/$1/;
     $row->{build_flags}  =~ s/,/ /g;
+       # enable-integer-datetimes is now the default
+       if ($row->{branch} eq 'HEAD' || $row->{branch} gt 'REL8_3_STABLE')
+       {
+               $row->{build_flags} .= " --enable-integer-datetimes "
+                       unless ($row->{build_flags} =~ /--(en|dis)able-integer-datetimes/);
+       }
     $row->{build_flags}  =~ s/--((enable|with)-)?//g;
+       $row->{build_flags} =~ s/libxml/xml/;
     $row->{build_flags}  =~ s/\S+=\S+//g;
     push(@$statrows,$row);
 }
@@ -99,6 +72,7 @@ $sth->finish;
 
 $db->disconnect;
 
+
 my $template = new Template({});
 
 print "Content-Type: text/html\n\n";
@@ -178,7 +152,7 @@ __DATA__
 <table><tr><th class="head" rowspan="2">Legend</th>
 [% FOREACH flagset IN flag_imgs %]
 <td><img src="[% flagset.value %]" title="[% flagset.key %]" alt="[% flagset.key %]" height="16" width="16" class="inline"  align="center"/> =  [% flagset.key %]</td>
-[% IF loop.count == 5 %]</tr><tr>[% END %]
+[% IF loop.count == 6 %]</tr><tr>[% END %]
 [% END %]
 </tr></table>
 <br />
@@ -214,10 +188,10 @@ __DATA__
 </div><!-- main -->
 <hr />
 <p style="text-align: center;">
-Hosting for the PostgreSQL Buildfarm is generously 
-provided by: 
+The PostgreSQL Buildfarm website is provided by: 
 <a href="http://www.commandprompt.com">CommandPrompt, 
-The PostgreSQL Company</a>
+The PostgreSQL Company</a> <br />
+The PostgreSQL community makes it work!
 </p>
 </div><!-- wrapper -->
   </body>