record latest status date for member

diff --git a/cgi-bin/pgstatus.pl b/cgi-bin/pgstatus.pl
index 5896761f0d8953fec98d15b78ef5934c9cc1032b..c1c338dbf45f1b17761820cd489159b25947cbd3 100755 (executable)
--- a/cgi-bin/pgstatus.pl
+++ b/cgi-bin/pgstatus.pl
@@ -331,6 +331,32 @@ $row=$sth->fetchrow_arrayref;
 my ($os, $compiler,$arch) = @$row;
 $sth->finish;
 
 my ($os, $compiler,$arch) = @$row;
 $sth->finish;
 

+$db->begin_work;
+my $have_status = $db->selectrow_arrayref( q{
+    select 1 
+    from build_status_latest 
+    where sysname = ? and branch = ?
+}, 
+                                          undef, $animal, $branch);
+if ($have_status) 
+{
+    $db->do(q{
+             update build_status_latest
+                 set latest_snapshot = ?
+                 where sysname = ? and branch = ?
+             },
+           undef, $dbdate, $animal, $branch);
+}
+else
+{
+    $db->do(q{
+             insert into build_status_latest
+                 (sysname, brancn, latest_snapshot)
+             values (?,?,?)
+             },
+           undef, $dbdate, $animal, $branch);
+}
+$db->commit;

 
 $db->begin_work;
 $db->do("delete from dashboard_mat");
 
 $db->begin_work;
 $db->do("delete from dashboard_mat");