lib/mysql-functions: mysql_query_create_toolchain_order() new

1 files changed, 28 insertions, 0 deletions

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'
+}