update materialised dashboard table
authorAndrew Dunstan <andrew@dunslane.net>
Wed, 11 Feb 2009 01:27:09 +0000 (01:27 +0000)
committerAndrew Dunstan <andrew@dunslane.net>
Wed, 11 Feb 2009 01:27:09 +0000 (01:27 +0000)
cgi-bin/pgstatus.pl

index aa83566d95357ff8a530c1d52936ef349a2d0ab5..614fcf302099fb1530c1e88086524779fe66bd3b 100755 (executable)
@@ -322,6 +322,12 @@ $row=$sth->fetchrow_arrayref;
 my ($os, $compiler,$arch) = @$row;
 $sth->finish;
 
 my ($os, $compiler,$arch) = @$row;
 $sth->finish;
 
+
+$db->begin_work;
+$db->do("delete from dashboard_mat");
+$db->do("insert into dashboard_mat select * from dashboard_mat_data");
+$db->commit;
+
 $db->disconnect;
 
 print "Content-Type: text/plain\n\n";
 $db->disconnect;
 
 print "Content-Type: text/plain\n\n";