Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/bin
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-01-30 10:43:43 +0100
committerErich Eckner <git@eckner.net>2018-01-30 10:43:43 +0100
commitf1a5d0d8305185d40d3c465e0a2b141bcdb3ddbb (patch)
treeaa585348bb9b383c98f00cdf5326bb84ff3b34b9 /bin
parent6c9b41e2ce003a1920daa2ca7b43365d99fa29dc (diff)
bin/get-assignment: myqsl query finished
Diffstat (limited to 'bin')
-rwxr-xr-xbin/get-assignment41
1 files changed, 36 insertions, 5 deletions
diff --git a/bin/get-assignment b/bin/get-assignment
index f4ed82a..270367e 100755
--- a/bin/get-assignment
+++ b/bin/get-assignment
@@ -144,6 +144,11 @@ next_building=$(
# shellcheck disable=SC2016
{
printf 'SELECT'
+ printf ' `package_sources`.`pkgbase`=from_base64("%s") AS `requested`,' \
+ "$(
+ printf '%s' "$1" | \
+ base64 -w0
+ )"
printf '('
printf 'SELECT COUNT(*)'
printf ' FROM `failed_builds`'
@@ -165,17 +170,43 @@ next_building=$(
printf ' SELECT *'
printf ' FROM `build_slaves`'
printf ' WHERE `build_slaves`.`currently_building`=`build_assignments`.`id`'
- printf ' AND `build_assignments`.`is_blocked` IS NULL'
-# TODO: and is element of loop or not exists unbuilt dependency
- printf ' )'
- printf ' ORDER BY `trials`, `build_assignments`.`id`'
+ printf ') AND ('
+ printf '`build_assignments`.`is_blocked` IS NULL'
+ printf ' OR'
+ printf ' `package_sources`.`pkgbase`=from_base64("%s")' \
+ "$(
+ printf '%s' "$1" | \
+ base64 -w0
+ )"
+ printf ') AND ('
+ printf 'EXISTS( '
+ printf 'SELECT * FROM `build_dependency_loops`'
+ printf ' WHERE `build_dependency_loops`.`build_assignment`=`build_assignments`.`id`'
+# TODO: ignore loops which contain a build_assignment currently being handed out (?)
+ printf ') OR'
+ printf ' NOT EXISTS ('
+ printf 'SELECT * FROM `binary_packages` as `to_dos`'
+ printf ' JOIN `%s` ON `%s`.`%s`=`%s`.`%s`' \
+ 'repositories` AS `to_do_repos' 'to_do_repos' 'id' 'to_dos' 'repository' \
+ 'dependencies' 'to_dos' 'id' 'dependencies' 'dependent' \
+ 'install_target_providers' 'dependencies' 'depending_on' 'install_target_providers' 'install_target' \
+ 'binary_packages` AS `bin_deps' 'bin_deps' 'id' 'install_target_providers' 'package' \
+ 'repositories` AS `dep_repos' 'dep_repos' 'id' 'bin_deps' 'repository'
+ printf ' WHERE'
+ printf ' `%s`.`name`="build-list" AND' \
+ 'dep_repos' 'to_do_repos'
+ printf ' `bin_deps`.`build_assignment`!=`to_dos`.`build_assignment` AND'
+ printf ' `to_dos`.`build_assignment`=`build_assignments`.`id`'
+ printf ')'
+ printf ')'
+ printf ' ORDER BY `requested` DESC, `trials`, `build_assignments`.`id`'
printf ' LIMIT 1;\n'
} | \
${mysql_command} --batch --raw | \
sed '
1d
y/\t/ /
- s/^\S\+ //
+ s/^\S\+ \S\+ //
'
)
# not ready yet!