From e708441a8c782c9304d2e1ab97fce320a7f09a2c Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Wed, 17 Oct 2018 14:14:45 +0200
Subject: bin/build-master-status: explicitely insert date, so it is equal for
 all architectures

---
 bin/build-master-status | 12 ++++++++++--
 1 file changed, 10 insertions(+), 2 deletions(-)

(limited to 'bin/build-master-status')

diff --git a/bin/build-master-status b/bin/build-master-status
index 455eb8f..c38d491 100755
--- a/bin/build-master-status
+++ b/bin/build-master-status
@@ -98,6 +98,10 @@ rm -f "${tmp_dir}/todos"
 
 # TODO: accellerate this query by using "GROUP BY"?
 if [ ! -s "${work_dir}/build-master-sanity" ]; then
+  now=$(
+    date '+%F %H:%M:%S' | \
+      base64 -w0
+  )
   # shellcheck disable=SC2016
   {
     printf 'SELECT `architectures`.`id`'
@@ -119,7 +123,8 @@ if [ ! -s "${work_dir}/build-master-sanity" ]; then
         'locked_tasks_count' \
         'blocked_tasks_count' \
         'next_tasks_count' \
-        'architecture' | \
+        'architecture' \
+        'date' | \
         sed 's/,$//'
       printf ') VALUES ('
       # stable_packages_count
@@ -249,8 +254,11 @@ if [ ! -s "${work_dir}/build-master-sanity" ]; then
       printf ' AND `build_assignments`.`architecture`=%s),' \
         "${arch_id}"
       # architecture
-      printf '%s' \
+      printf '%s,' \
         "${arch_id}"
+      # date
+      printf 'from_base64("%s")' \
+        "${now}"
       printf ');\n'
     done | \
     mysql_run_query 'unimportant'
-- 
cgit v1.2.3