From: Andrew Dunstan <andrew@dunslane.net>
Date: Mon, 11 Oct 2010 17:17:45 +0000 (+0000)
Subject: record latest status date for member
X-Git-Url: https://git.exim.org/buildfarm-server.git/commitdiff_plain/cecc743a874e1f875224965fa546031b64bb4e11?ds=sidebyside

record latest status date for member
---

diff --git a/cgi-bin/pgstatus.pl b/cgi-bin/pgstatus.pl
index 5896761..c1c338d 100755
--- 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;
 
+$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");