From 68750f39f1745fc4251dfb2b9fb9c194ac29c70d Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Wed, 30 May 2018 10:10:12 +0200
Subject: bin/sanity-check: get archs and repos from the database

---
 bin/sanity-check | 24 ++++++++++++++++++++++--
 1 file changed, 22 insertions(+), 2 deletions(-)

(limited to 'bin/sanity-check')

diff --git a/bin/sanity-check b/bin/sanity-check
index bad927b..502ab63 100755
--- a/bin/sanity-check
+++ b/bin/sanity-check
@@ -44,8 +44,28 @@ eval set -- "$(
 
 block_flag='-n'
 silence=0
-repos="${standalone_package_repositories} ${stable_package_repositories} ${testing_package_repositories} ${staging_package_repositories}"
-archs='i686'
+# shellcheck disable=SC2016
+repos=$(
+  {
+    printf 'SELECT DISTINCT `repositories`.`name`'
+    printf ' FROM `repositories`'
+    printf ' WHERE `repositories`.`is_on_master_mirror`;\n'
+  } | \
+    mysql_run_query
+)
+# shellcheck disable=SC2016
+archs=$(
+  {
+    printf 'SELECT DISTINCT `architectures`.`name`'
+    printf ' FROM `architectures`'
+    printf ' WHERE EXISTS ('
+      printf 'SELECT 1 FROM `repositories`'
+      printf ' WHERE `repositories`.`architecture`=`architectures`.`id`'
+      printf ' AND `repositories`.`is_on_master_mirror`'
+    printf ');\n'
+  } | \
+    mysql_run_query
+)
 
 while true
 do
-- 
cgit v1.2.3-70-g09d2