From c7b9db34c9563a460e3f2eaa63978fdf3938cfeb Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 26 Jul 2018 15:15:03 +0200 Subject: lib/mysql-functions: mysql_query_create_toolchain_order() new --- bin/get-assignment | 24 +----------------------- 1 file changed, 1 insertion(+), 23 deletions(-) (limited to 'bin/get-assignment') 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 ' -- cgit v1.2.3