From c43c80543417c803000bcca55ad1c93b6f212e11 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Mon, 4 Jun 2018 12:00:30 +0200 Subject: lib/mysql-functions, lib/common-functions: mysql_query_and_delete_unneeded_binary_packages() new --- lib/common-functions | 14 +------------- 1 file changed, 1 insertion(+), 13 deletions(-) (limited to 'lib/common-functions') diff --git a/lib/common-functions b/lib/common-functions index cb39509..921a7b3 100755 --- a/lib/common-functions +++ b/lib/common-functions @@ -218,19 +218,7 @@ remove_old_package_versions() { "${tmp_dir}/db-removes" printf 'DELETE `binary_packages_in_repositories` FROM `binary_packages_in_repositories`' printf ' JOIN `del` ON `binary_packages_in_repositories`.`id`=`del`.`id`;\n' - printf 'SELECT CONCAT("pool/",' - mysql_package_name_query - printf ') FROM `binary_packages`' - mysql_join_binary_packages_architectures - printf ' WHERE NOT EXISTS (' - printf 'SELECT 1 FROM `binary_packages_in_repositories`' - printf ' WHERE `binary_packages_in_repositories`.`package`=`binary_packages`.`id`' - printf ');\n' - printf 'DELETE `binary_packages` FROM `binary_packages`' - printf ' WHERE NOT EXISTS (' - printf 'SELECT 1 FROM `binary_packages_in_repositories`' - printf ' WHERE `binary_packages_in_repositories`.`package`=`binary_packages`.`id`' - printf ');\n' + mysql_query_and_delete_unneeded_binary_packages } | \ mysql_run_query | \ sort -u >> \ -- cgit v1.2.3-54-g00ecf