From b3867a6fc5da5181f9f3d8379dab62f33b313c6b Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 26 Jul 2018 12:03:20 +0200 Subject: lib/mysql-functions: mysql_retrieve_static_information(): retrieve architecture ids, too --- lib/mysql-functions | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/lib/mysql-functions b/lib/mysql-functions index bb58ca0..4a04bd1 100755 --- a/lib/mysql-functions +++ b/lib/mysql-functions @@ -1055,12 +1055,18 @@ done # mysql_retrieve_static_information # retrieve some static information from the database: +# - ids of architectures -> $architecture_ids__$arch # - ids of package repositories -> $repository_ids__$arch_$repo # - names and paths of git_repositories # - ids of repository_stabilities mysql_retrieve_static_information() { eval "$( { + printf 'SELECT REPLACE(CONCAT(' + printf '"architecture_ids__",' + printf '`architectures`.`name`,"=",' + printf '`architectures`.`id`' + printf '),"-","_") FROM `architectures`;\n' printf 'SELECT REPLACE(CONCAT(' printf '"repository_ids__",' printf '`architectures`.`name`,"_",' -- cgit v1.2.3-70-g09d2