From 4697dbe5bb3d088a1007a3d39274a1522e832fc4 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Sun, 21 Jan 2018 21:40:07 +0100
Subject: bin/return-assignment: started to track package movement in database

---
 bin/return-assignment | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

(limited to 'bin')

diff --git a/bin/return-assignment b/bin/return-assignment
index ebaa73a..48c6914 100755
--- a/bin/return-assignment
+++ b/bin/return-assignment
@@ -368,6 +368,21 @@ if ! [ "${destination}" = 'build-support' ]; then
   printf '%s\n' ${packages} > \
     "${work_dir}/package-states/$1.$2.$3.$4.done"
 fi
+# TODO: mark packages in correct repository in database
+${mysql_command} -e "$(
+  # shellcheck disable=SC2016
+  printf 'UPDATE `build_assignments`'
+  # shellcheck disable=SC2016
+  printf ' JOIN `build_slaves` ON `build_slaves`.`currently_building`=`build_assignments`.`id`'
+  # shellcheck disable=SC2016
+  printf ' SET `build_assignments`.`is_broken`=0, `build_slaves`.`currently_building`=NULL'
+  # shellcheck disable=SC2016
+  printf ' WHERE `build_slaves`.`name`=from_base64("%s");\n' \
+    "$(
+      printf '%s' "${slave}" | \
+        base64 -w0
+    )"
+)"
 rm -f \
   "${work_dir}/package-states/$1.$2.$3.$4.locked" \
   "${work_dir}/package-states/$1.$2.$3.$4.broken"
-- 
cgit v1.2.3-54-g00ecf