summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rwxr-xr-xbin/build-master-status12
1 files changed, 10 insertions, 2 deletions
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'