9 use vars qw($dbhost $dbname $dbuser $dbpass $dbport
12 require "$ENV{BFConfDir}/BuildFarmWeb.pl";
14 die "no dbname" unless $dbname;
15 die "no dbuser" unless $dbuser;
17 my %opts = ( outfile => "/etc/mail/lists/farmers" );
22 my $dsn="dbi:Pg:dbname=$dbname";
23 $dsn .= ";host=$dbhost" if $dbhost;
24 $dsn .= ";port=$dbport" if $dbport;
26 my $db = DBI->connect($dsn,$dbuser,$dbpass);
28 die $DBI::errstr unless $db;
30 my $sth = $db->prepare(q[
32 FROM buildsystems AS b
33 ORDER BY owner_email ASC
38 while (my $row = $sth->fetchrow_hashref)
40 $list{$row->{owner_email}}++;
44 open(my $fh, ">", $opts{outfile});
46 print $fh (join "\n", (keys %list));