bin/delete-packages: keep `binary_packages_in_repositories` up-to-date

1 files changed, 5 insertions, 7 deletions

diff --git a/bin/delete-packages b/bin/delete-packages
index df51593..7b48a3f 100755
--- a/bin/delete-packages
+++ b/bin/delete-packages
@@ -261,13 +261,11 @@ fi
   printf 'UPDATE `binary_packages` '
   printf ' JOIN `to_deletes` ON `to_deletes`.`id`=`binary_packages`.`id`'
   mysql_join_binary_packages_binary_packages_in_repositories
-  mysql_join_binary_packages_in_repositories_repositories
-  mysql_join_binary_packages_architectures
-  printf ' SET `repository`=('
-    printf 'SELECT `repositories`.`id`'
-    printf ' FROM `repositories`'
-    printf ' WHERE `repositories`.`name`="deletion-list"'
-  printf ');\n'
+  # shellcheck disable=SC2154
+  printf ' SET `binary_packages`.`repository`=%s,' \
+    "${repository_ids__any_deletion_list}"
+  printf '`binary_packages_in_repositories`.`repository`=%s;\n' \
+    "${repository_ids__any_deletion_list}"
 } | \
   mysql_run_query