bin/get-assignment: mark assignment as handed out to slave in mysql database

1 files changed, 27 insertions, 0 deletions

diff --git a/bin/get-assignment b/bin/get-assignment
index f1199cc..a81a54d 100755
--- a/bin/get-assignment
+++ b/bin/get-assignment
@@ -50,6 +50,33 @@ hand_out_assignment() {
   } | \
     sort -u | \
     sponge "${work_dir}/package-states/$1.$2.$3.$4.locked"
+  ${mysql_command} -e "$(
+    # shellcheck disable=SC2016
+    printf 'UPDATE `build_slaves`'
+    # shellcheck disable=SC2016
+    printf ' SET `currently_building` = ('
+    # shellcheck disable=SC2016
+    printf ' SELECT `build_assignments`.`id`'
+    # shellcheck disable=SC2016
+    printf ' FROM `build_assignments`'
+    # shellcheck disable=SC2016
+    printf ' JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id`'
+    # shellcheck disable=SC2016
+    printf ' JOIN `upstream_repositories` ON `package_sources`.`upstream_package_repository`=`upstream_repositories`.`id`'
+    printf ' WHERE'
+    # shellcheck disable=SC2016
+    printf ' `package_sources`.`%s` = from_base64("%s") AND' \
+      'pkgbase'          "$(printf '%s' "$1" | base64 -w0)" \
+      'git_revision'     "$(printf '%s' "$2" | base64 -w0)" \
+      'mod_git_revision' "$(printf '%s' "$3" | base64 -w0)"
+    # shellcheck disable=SC2016
+    printf ' `upstream_repositories`.`name` = from_base64("%s")' \
+      "$(printf '%s' "$4" | base64 -w0)"
+    printf ')'
+    # shellcheck disable=SC2016
+    printf ' WHERE `build_slaves`.`name`=from_base64("%s");' \
+      "$(printf '%s' "${slave}" | base64 -w0)"
+  )"
 
   # lock every loop this package breaks
   find "${work_dir}/build-list.loops" -maxdepth 1 -regextype grep \