From 3acd055e71a5de6d770f09a9875d6fd3e6f95bd5 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 7 Aug 2019 13:58:44 +0200 Subject: lib/mysql-functions: mysql_join_dependencies_install_target_providers_with_versions(): extract list of non-any repos into shell variable, too --- lib/mysql-functions | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'lib/mysql-functions') diff --git a/lib/mysql-functions b/lib/mysql-functions index 548ee00..2b09f6b 100755 --- a/lib/mysql-functions +++ b/lib/mysql-functions @@ -1379,6 +1379,7 @@ mysql_join_dependencies_install_target_providers_with_versions() { # mysql_retrieve_static_information # retrieve some static information from the database: # - ids of architectures -> $architecture_ids__$arch +# - ids of non-any architectures -> $non_any_architecture_ids # - ids of package repositories -> $repository_ids__$arch_$repo # - names, paths and heads of git_repositories # - ids of repository_stabilities @@ -1391,6 +1392,14 @@ mysql_retrieve_static_information() { printf '`architectures`.`id`' printf '),"-","_")' printf ' FROM `architectures`;\n' + printf 'SELECT CONCAT(' + printf '"non_any_architecture_ids=",' + printf 'GROUP_CONCAT(' + printf '`architectures`.`id`' + printf ' ORDER BY `architectures`.`id`' + printf '))' + printf ' FROM `architectures`' + printf ' WHERE `architectures`.`name`!="any";\n' printf 'SELECT REPLACE(CONCAT(' printf '"repository_ids__",' printf '`architectures`.`name`,"_",' -- cgit v1.2.3-54-g00ecf