summaryrefslogtreecommitdiff
path: root/bin/build-master-status
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-10-17 18:56:02 +0200
committerErich Eckner <git@eckner.net>2018-10-17 18:56:02 +0200
commit1b9d3dc4ca9125859194192aa159b06dac564af3 (patch)
tree3267443bb902a4a781913b6f570ea2fe682aaae3 /bin/build-master-status
parentc7bc6b6f6bc59456cf878bea8350701ac7545cc5 (diff)
downloadbuilder-1b9d3dc4ca9125859194192aa159b06dac564af3.tar.xz
bin/build-master-status: build-assignment statistics should only care about packages which are on the build-list
Diffstat (limited to 'bin/build-master-status')
-rwxr-xr-xbin/build-master-status9
1 files changed, 9 insertions, 0 deletions
diff --git a/bin/build-master-status b/bin/build-master-status
index 2a71d8d..ec02136 100755
--- a/bin/build-master-status
+++ b/bin/build-master-status
@@ -183,6 +183,15 @@ if [ ! -s "${work_dir}/build-master-sanity" ]; then
mysql_join_build_assignments_binary_packages
mysql_join_binary_packages_binary_packages_in_repositories
mysql_join_binary_packages_in_repositories_repositories
+ printf ' JOIN ('
+ printf 'SELECT `binary_packages`.`build_assignment`'
+ printf ' FROM `binary_packages`'
+ mysql_join_binary_packages_binary_packages_in_repositories
+ printf ' WHERE `binary_packages_in_repositories`.`repository`=%s' \
+ "${repository_ids__any_build_list}"
+ printf ' GROUP BY `binary_packages`.`build_assignment`'
+ printf ') AS `bp_subq`'
+ printf ' ON `bp_subq`.`build_assignment`=`build_assignments`.`id`'
printf ' LEFT'
mysql_join_build_assignments_build_slaves
printf ' LEFT'