summaryrefslogtreecommitdiff
path: root/lib/mysql-functions
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-07-26 15:15:03 +0200
committerErich Eckner <git@eckner.net>2018-07-26 15:15:03 +0200
commitc7b9db34c9563a460e3f2eaa63978fdf3938cfeb (patch)
treeb40f407a011a2e6f2fd27a39db16e7213cded080 /lib/mysql-functions
parentbab7e4ea534004ba47c7206a89490ab3afc001aa (diff)
downloadbuilder-c7b9db34c9563a460e3f2eaa63978fdf3938cfeb.tar.xz
lib/mysql-functions: mysql_query_create_toolchain_order() new
Diffstat (limited to 'lib/mysql-functions')
-rwxr-xr-xlib/mysql-functions28
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'
+}