From cdb0ff5955e797f2100ba791fa5b089399727681 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 30 May 2018 12:46:39 +0200 Subject: bin/delete-packages: keep `binary_packages_in_repositories` up-to-date --- bin/delete-packages | 12 +++++------- 1 file changed, 5 insertions(+), 7 deletions(-) (limited to 'bin/delete-packages') 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 -- cgit v1.2.3