From 1eb61f044cb3a58534257b046ed1020dc8573b5a Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Tue, 15 May 2018 10:30:11 +0200
Subject: lib/mysql-functions: mysql_retrieve_repository_ids() new

---
 lib/mysql-functions | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

diff --git a/lib/mysql-functions b/lib/mysql-functions
index 55e994e..ef70098 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -1049,3 +1049,21 @@ mysql_show_binary_packages_in_repositories_issues() {
   } | \
     mysql_run_query
 }
+
+# mysql_retrieve_repository_ids
+# retrieve the ids of all known repositories into $repository_ids__$arch_$repo
+mysql_retrieve_repository_ids() {
+  eval "$(
+    {
+      printf 'SELECT CONCAT('
+      printf '"repository_ids__",'
+      printf '`architectures`.`name`,"_",'
+      printf '`repositories`.`name`,"=",'
+      printf '`repositories`.`id`'
+      printf ') FROM `repositories`'
+      mysql_join_repositories_architectures
+    } | \
+      mysql_run_query | \
+      tr -- '-' '_'
+  )"
+}
-- 
cgit v1.2.3-54-g00ecf