8 die "Must pass one and only one sysname to delete\n"
9 unless scalar @ARGV == 1;
11 use vars qw($dbhost $dbname $dbuser $dbpass $dbport
13 require "$ENV{BFConfDir}/BuildFarmWeb.pl";
15 die "no dbname" unless $dbname;
16 die "no dbuser" unless $dbuser;
18 my $dsn="dbi:Pg:dbname=$dbname";
19 $dsn .= ";host=$dbhost" if $dbhost;
20 $dsn .= ";port=$dbport" if $dbport;
22 my $db = DBI->connect($dsn,$dbuser,$dbpass);
24 die $DBI::errstr unless $db;
26 my @tables = qw/alerts buildsystems build_status build_status_log
27 build_status_recent_500 dashboard_mat latest_snapshot
28 nrecent_failures personality/;
30 for my $loop (0 .. (scalar @tables - 1) ) {
31 my $field = ($tables[$loop] eq 'personality') ? 'name' :
32 ($tables[$loop] eq 'buildsystems') ? 'name':
34 printf "Deleting from %s with field %s\n", $tables[$loop], $field;
36 DELETE FROM $tables[$loop]
39 $sth->execute($ARGV[0]);