X-Git-Url: https://git.exim.org/buildfarm-server.git/blobdiff_plain/0c72c10e5d8a9413bd1cb79b94b6a224062d693f..05882f7025c36d8eb175bba2d4e6e1accd21e853:/cgi-bin/show_members.pl?ds=sidebyside diff --git a/cgi-bin/show_members.pl b/cgi-bin/show_members.pl old mode 100644 new mode 100755 index 341103e..2b6e0be --- a/cgi-bin/show_members.pl +++ b/cgi-bin/show_members.pl @@ -7,7 +7,7 @@ use Template; -use vars qw($dbhost $dbname $dbuser $dbpass $dbport $sort_by); +use vars qw($dbhost $dbname $dbuser $dbpass $dbport $template_dir $sort_by); require "$ENV{BFConfDir}/BuildFarmWeb.pl"; @@ -35,15 +35,13 @@ my $statement = < 'HEAD', branch) - branch || ':' || - extract(days from now() - snapshot) - from build_status - where name = sysname - order by branch <> 'HEAD', branch desc, - snapshot desc + select branch || ':' || + extract(days from now() - latest_snapshot) + from build_status_latest l + where l.sysname = s.name + order by branch <> 'HEAD', branch desc ) as branches - from buildsystems + from buildsystems s where status = 'approved' order by $sort_by @@ -67,97 +65,13 @@ $db->disconnect; # use Data::Dumper; print "Content-Type: text/plain\n\n",Dumper($statrows),"VERSION: ",$DBD::Pg::VERSION,"\n"; exit; -my $template = new Template({}); +my $template_opts = { INCLUDE_PATH => $template_dir}; +my $template = new Template($template_opts); print "Content-Type: text/html\n\n"; -$template->process(\*DATA,{statrows=>$statrows}); +$template->process('members.tt', + {statrows=>$statrows}); exit; - -__DATA__ - - - - - PostgreSQL BuildFarm Members - - - - - - -

- -

PostgreSQL BuildFarm Members

Click branch links to see build history. Click the heading links to resort the list. Select members by checkbox and hit the button at the bottom to create a status custom filter.

- - - - - - - - - -[% alt = true %] -[% FOREACH row IN statrows %] - [% alt = ! alt %] - - - - - - - -[% END %] -

	Name Owner	OS / Version	Compiler / Version	Arch	Branches reported on (most recent report)
	[% row.name %] [% row.owner_email %]	[% row.operating_system %] [% row.os_version %]	[% row.compiler %] [% row.compiler_version %]	[% row.arch %]	[% IF ! row.branches ; ' ' ; END -%] - - [%- - FOREACH branch_days IN row.branches.split(',') ; - branch_fields = branch_days.split(':'); - branch = branch_fields.0; - branch_day = branch_fields.1; - %] [% branch %] ([% branch_day %] days ago) [% END %]

- -

-Hosting for the PostgreSQL Buildfarm is generously -provided by: -CommandPrompt, -The PostgreSQL Company -

- - - - - - - - - -