diff options
| author | Erich Eckner <git@eckner.net> | 2018-05-30 12:46:39 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-05-30 12:46:39 +0200 |
| commit | cdb0ff5955e797f2100ba791fa5b089399727681 (patch) | |
| tree | d3d835feb44eb65f73fdea1817541862f3d8e741 | |
| parent | ae3074f6657ea7dc2945244cbb7f4620626a2c18 (diff) | |
| download | builder-cdb0ff5955e797f2100ba791fa5b089399727681.tar.xz | |
bin/delete-packages: keep `binary_packages_in_repositories` up-to-date
| -rwxr-xr-x | bin/delete-packages | 12 |
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 |