From 1dca50324cdeb4c88460cd59b5684705c8e5b70a Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Sun, 18 Feb 2018 20:58:12 +0100
Subject: bin/mysql-functions: remove binary_packages from to-be-decided, style

---
 bin/mysql-functions | 23 +++++++++++++++++------
 1 file changed, 17 insertions(+), 6 deletions(-)

(limited to 'bin')

diff --git a/bin/mysql-functions b/bin/mysql-functions
index 5850ab5..185d9a9 100755
--- a/bin/mysql-functions
+++ b/bin/mysql-functions
@@ -771,6 +771,15 @@ mysql_cleanup() {
     exit 2
   fi
   {
+    # remove to-be-decided binary_packages
+    printf '%s ' \
+      "${operator}"
+    if [ "${operator}" = 'DELETE' ]; then
+      printf '`binary_packages` '
+    fi
+    printf 'FROM `binary_packages`'
+    mysql_join_binary_packages_repositories
+    printf ' WHERE `repositories`.`name`="to-be-decided";\n'
     # remove dependencies w/o binary_package or install_target
     printf '%s FROM `dependencies` ' \
       "${operator}"
@@ -804,13 +813,15 @@ mysql_cleanup() {
       printf 'WHERE `binary_packages`.`build_assignment`=`build_assignments`.`id`'
     printf ');\n'
     # remove failed_builds with unbroken build_assignments
-    printf '%s FROM `failed_builds` ' \
+    printf '%s ' \
       "${operator}"
-    printf 'WHERE ('
-      printf 'SELECT NOT `build_assignments`.`is_broken`'
-      printf ' FROM `build_assignments` '
-      printf ' WHERE `failed_builds`.`build_assignment`=`build_assignments`.`id`'
-    printf ');\n'
+    if [ "${operator}" = 'DELETE' ]; then
+      printf '`failed_builds` '
+    fi
+    printf 'FROM `failed_builds` '
+    mysql_join_failed_builds_build_assignments
+    printf 'WHERE NOT `build_assignments`.`is_broken`'
+    printf ';\n'
     # remove failed_builds w/o build_assignment
     printf '%s FROM `failed_builds` ' \
       "${operator}"
-- 
cgit v1.2.3-70-g09d2