lib/mysql-functions: mysql_join_dependencies_install_target_providers_with_versions(): extract list of non-any repos into shell variable, too

1 files changed, 9 insertions, 0 deletions

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`,"_",'