From e81196e242a3de0c3b9c4394c7aedbb84bdc87b6 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Wed, 30 May 2018 11:10:15 +0200
Subject: repo_names and repo_paths__* is read from the database on the
 buildmaster, now

---
 lib/load-configuration | 12 +++++-------
 lib/mysql-functions    | 19 +++++++++++++++----
 2 files changed, 20 insertions(+), 11 deletions(-)

(limited to 'lib')

diff --git a/lib/load-configuration b/lib/load-configuration
index 5a1fd84..01c27b5 100755
--- a/lib/load-configuration
+++ b/lib/load-configuration
@@ -28,14 +28,12 @@ if pgrep -x mysqld >/dev/null 2>&1; then
   . "${base_dir}/lib/mysql-functions"
 else
   i_am_the_master=false
-fi
 
-# TODO: some of this should be read from the database instead
-# (in mysql_retrieve_static_information)
-repo_names='packages community archlinux32'
-repo_paths__packages="${work_dir}/repos/packages"
-repo_paths__community="${work_dir}/repos/community"
-repo_paths__archlinux32="${work_dir}/repos/packages32"
+  repo_names='packages community archlinux32'
+  repo_paths__packages="${work_dir}/repos/packages"
+  repo_paths__community="${work_dir}/repos/community"
+  repo_paths__archlinux32="${work_dir}/repos/packages32"
+fi
 
 master_build_server="buildmaster.archlinux32.org"
 master_build_server_port="22"
diff --git a/lib/mysql-functions b/lib/mysql-functions
index 12de251..196e03b 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -1043,15 +1043,26 @@ mysql_show_binary_packages_in_repositories_issues() {
 mysql_retrieve_static_information() {
   eval "$(
     {
-      printf 'SELECT CONCAT('
+      printf 'SELECT REPLACE(CONCAT('
       printf '"repository_ids__",'
       printf '`architectures`.`name`,"_",'
       printf '`repositories`.`name`,"=",'
       printf '`repositories`.`id`'
-      printf ') FROM `repositories`'
+      printf '),"-","_") FROM `repositories`'
       mysql_join_repositories_architectures
+      printf ';\n'
+      printf 'SELECT CONCAT('
+      printf '"repo_names=\\"",'
+      printf 'REPLACE(GROUP_CONCAT(`git_repositories`.`name`),","," "),'
+      printf '"\\"")'
+      printf ' FROM `git_repositories`'
+      printf ' GROUP BY "1";\n'
+      printf 'SELECT CONCAT('
+      printf '"repo_paths__",'
+      printf '`git_repositories`.`name`,"=",'
+      printf '"\\"",`git_repositories`.`directory`,"\\"")'
+      printf ' FROM `git_repositories`;\n'
     } | \
-      mysql_run_query | \
-      tr -- '-' '_'
+      mysql_run_query
   )"
 }
-- 
cgit v1.2.3-54-g00ecf