Add 4.next branch

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

diff --git a/cgi-bin/show_members.pl b/cgi-bin/show_members.pl
index 5d4a0c97623a417043b7e0bfc3c63827ee1a806f..f35c66acae2656232828a17f9a6241b35e055bc8 100755 (executable)
--- a/cgi-bin/show_members.pl
+++ b/cgi-bin/show_members.pl
@@ -1,17 +1,22 @@
 #!/usr/bin/perl
 
 #!/usr/bin/perl
 

+=comment
+
+Copyright (c) 2003-2010, Andrew Dunstan
+
+See accompanying License file for license details
+
+=cut 
+

 use strict;
 use CGI;
 use DBI;
 use Template;
 
 use strict;
 use CGI;
 use DBI;
 use Template;
 

-
-

 use vars qw($dbhost $dbname $dbuser $dbpass $dbport $template_dir $sort_by);
 
 use vars qw($dbhost $dbname $dbuser $dbpass $dbport $template_dir $sort_by);
 

-
-require "$ENV{BFConfDir}/BuildFarmWeb.pl";
-#require "BuildFarmWeb.pl";
+use FindBin qw($RealBin);
+require "$RealBin/../BuildFarmWeb.pl";

 
 my $query = new CGI;
 my %sort_ok = ('name' => 'lower(name)' , 
 
 my $query = new CGI;
 my %sort_ok = ('name' => 'lower(name)' , 


@@ -26,7 +31,7 @@ my $dsn="dbi:Pg:dbname=$dbname";
 $dsn .= ";host=$dbhost" if $dbhost;
 $dsn .= ";port=$dbport" if $dbport;
 
 $dsn .= ";host=$dbhost" if $dbhost;
 $dsn .= ";port=$dbport" if $dbport;
 

-my $db = DBI->connect($dsn,$dbuser,$dbpass);
+my $db = DBI->connect($dsn,$dbuser,$dbpass,{pg_expand_array => 0});

 
 # there is possibly some redundancy in this query, but it makes
 # a lot of the processing simpler.
 
 # there is possibly some redundancy in this query, but it makes
 # a lot of the processing simpler.


@@ -34,14 +39,15 @@ my $db = DBI->connect($dsn,$dbuser,$dbpass);
 my $statement = q{
 
   select name, operating_system, os_version, compiler, compiler_version, owner_email, 
 my $statement = q{
 
   select name, operating_system, os_version, compiler, compiler_version, owner_email, 

+    sys_notes_ts::date AS sys_notes_date, sys_notes,

     architecture as arch, ARRAY(
     architecture as arch, ARRAY(

-                               select branch || ':' || 
+                               select branch || E':' || 

                                       extract(days from now() - l.snapshot)
                                from latest_snapshot l 
                                where l.sysname = s.name
                                order by branch <> 'HEAD', branch desc 
                                ) as branches, 
                                       extract(days from now() - l.snapshot)
                                from latest_snapshot l 
                                where l.sysname = s.name
                                order by branch <> 'HEAD', branch desc 
                                ) as branches, 

-                         ARRAY(select compiler_version || '\t' ||  os_version || '\t' || effective_date
+                         ARRAY(select compiler_version || E'\t' ||  os_version || E'\t' || effective_date

                                from personality p
                                where p.name = s.name 
                                order by effective_date
                                from personality p
                                where p.name = s.name 
                                order by effective_date


@@ -93,4 +99,3 @@ $template->process('members.tt',
                {statrows=>$statrows});
 
 exit;
                {statrows=>$statrows});
 
 exit;

-