From 0feb62912c518b0e031146d4337580eb9bfd93a2 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 26 Jul 2018 15:42:31 +0200 Subject: bin/return-assignment: use temp table instead of parsing package-ids --- bin/return-assignment | 16 +++++----------- 1 file changed, 5 insertions(+), 11 deletions(-) (limited to 'bin') diff --git a/bin/return-assignment b/bin/return-assignment index b837cac..17a742b 100755 --- a/bin/return-assignment +++ b/bin/return-assignment @@ -681,17 +681,11 @@ trigger_mirror_refreshs # TODO: do not remove toolchain build assignments if they need to be compiled a second time # remove from build-list - printf 'DELETE FROM `binary_packages_in_repositories`' - printf ' WHERE `binary_packages_in_repositories`.`package` IN (' - cut -d' ' -f1 < \ - "${tmp_dir}/package-ids" | \ - base64_encode_each | \ - sed ' - s/^/from_base64("/ - s/$/"),/ - $ s/,$// - ' - printf ') AND `binary_packages_in_repositories`.`repository`=%s;\n' \ + printf 'DELETE `binary_packages_in_repositories`' + printf ' FROM `binary_packages_in_repositories`' + printf ' JOIN `pkg_hashes`' + printf ' ON `pkg_hashes`.`pkgid`=`binary_packages_in_repositories`.`package`' + printf ' WHERE `binary_packages_in_repositories`.`repository`=%s;\n' \ "${repository_ids__any_build_list}" printf 'COMMIT;\n' -- cgit v1.2.3-54-g00ecf