lib/mysql-functions: mysql_query_create_toolchain_order() new

2 files changed, 29 insertions, 23 deletions

diff --git a/bin/get-assignment b/bin/get-assignment
index f3028e2..c84fdb3 100755
--- a/bin/get-assignment
+++ b/bin/get-assignment
@@ -139,29 +139,7 @@ fi
 next_building=$(
   # shellcheck disable=SC2016
   {
-    # We force the following build order of the tool-chain:
-    # linux-api-headers->glibc->binutils->gcc->binutils->glibc
-    for suffix in '' '_copy'; do
-      printf 'CREATE TEMPORARY TABLE `toolchain_order%s` (' \
-        "${suffix}"
-        printf '`number` SMALLINT,'
-        printf '`pkgbase` VARCHAR(64),'
-        printf 'PRIMARY KEY `number`(`number`)'
-      printf ');\n'
-    done
-    printf 'INSERT INTO `toolchain_order` (`number`,`pkgbase`) VALUES '
-    printf '(%s,"%s"),' \
-      0 'linux-api-headers' \
-      1 'glibc' \
-      2 'binutils' \
-      3 'gcc' \
-      4 'binutils' \
-      5 'glibc' | \
-      sed 's/,$/;\n/'
-    printf 'INSERT INTO `toolchain_order_copy` (`number`,`pkgbase`)'
-    printf ' SELECT `toolchain_order`.`number`,`toolchain_order`.`pkgbase`'
-    printf ' FROM `toolchain_order`;\n'
-
+    mysql_query_create_toolchain_order
     printf 'SELECT `q`.`ba_id` FROM'
     printf '('
       printf 'SELECT '
diff --git a/lib/mysql-functions b/lib/mysql-functions
index 4a04bd1..a4cca4e 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -1114,3 +1114,31 @@ mysql_query_and_delete_unneeded_binary_packages() {
     printf ' WHERE `binary_packages_in_repositories`.`package`=`binary_packages`.`id`'
   printf ');\n'
 }
+
+# mysql_query_create_toolchain_order
+# write query, creating `toolchain_order` and `toolchain_order_copy`
+# temporary tables
+mysql_query_create_toolchain_order() {
+  # We force the following build order of the tool-chain:
+  # linux-api-headers->glibc->binutils->gcc->binutils->glibc
+  for suffix in '' '_copy'; do
+    printf 'CREATE TEMPORARY TABLE `toolchain_order%s` (' \
+      "${suffix}"
+      printf '`number` SMALLINT,'
+      printf '`pkgbase` VARCHAR(64),'
+      printf 'PRIMARY KEY `number`(`number`)'
+    printf ');\n'
+  done
+  printf 'INSERT INTO `toolchain_order` (`number`,`pkgbase`) VALUES '
+  printf '(%s,"%s"),' \
+    0 'linux-api-headers' \
+    1 'glibc' \
+    2 'binutils' \
+    3 'gcc' \
+    4 'binutils' \
+    5 'glibc' | \
+    sed 's/,$/;\n/'
+  printf 'INSERT INTO `toolchain_order_copy` (`number`,`pkgbase`)'
+  printf ' SELECT `toolchain_order`.`number`,`toolchain_order`.`pkgbase`'
+  printf ' FROM `toolchain_order`;\n'
+}