From 5abb605487bad908e3688e0137d14480e99cae8b Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Tue, 5 Jun 2018 14:16:11 +0200 Subject: lib/mysql-functions: use ids instead of select queries (not yet completely) --- lib/mysql-functions | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/lib/mysql-functions b/lib/mysql-functions index 30f235f..51632cd 100755 --- a/lib/mysql-functions +++ b/lib/mysql-functions @@ -786,10 +786,11 @@ mysql_find_build_assignment_loops() { mysql_join_install_target_providers_binary_packages '' 'packages_dependency' mysql_join_dependencies_binary_packages '' 'packages_dependent' mysql_join_binary_packages_binary_packages_in_repositories 'packages_dependency' 'packages_in_repository_dependency' - mysql_join_binary_packages_in_repositories_repositories 'packages_in_repository_dependency' 'repositories_dependency' mysql_join_binary_packages_binary_packages_in_repositories 'packages_dependent' 'packages_in_repository_dependent' - mysql_join_binary_packages_in_repositories_repositories 'packages_in_repository_dependent' 'repositories_dependent' - printf ' WHERE `repositories_dependent`.`name`="build-list" AND `repositories_dependency`.`name`="build-list"' + printf ' WHERE `packages_in_repositories_dependent`.`repository`=%s' \ + "${repository_ids__any_build_list}" + printf ' AND `packages_in_repositories_dependency`.`repository`=%s;\n' \ + "${repository_ids__any_build_list}" } | \ mysql_run_query | \ tr '\t' ' ' | \ -- cgit v1.2.3-70-g09d2