lib/mysql-functions: mysql_query_create_toolchain_order() new

1 files changed, 1 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 '