bin/seed-build-list: get repositories from database

1 files changed, 10 insertions, 1 deletions

diff --git a/bin/seed-build-list b/bin/seed-build-list
index 2d636b8..389fdcf 100755
--- a/bin/seed-build-list
+++ b/bin/seed-build-list
@@ -131,7 +131,16 @@ if ${update}; then
   fi
 fi
 
-repos="${stable_package_repositories}"
+# shellcheck disable=SC2016
+repos=$(
+  {
+    printf 'SELECT DISTINCT `repositories`.`name`'
+    printf ' FROM `repositories`'
+    mysql_join_repositories_repository_stabilities
+    printf ' WHERE `repository_stabilities`.`name`="stable";\n'
+  } | \
+    mysql_run_query
+)
 
 # genereate must-haves query from mirror delta
 if [ -s "${tmp_dir}/mirrors" ]; then