summaryrefslogtreecommitdiff
path: root/bin/why-dont-you
diff options
context:
space:
mode:
Diffstat (limited to 'bin/why-dont-you')
-rwxr-xr-xbin/why-dont-you13
1 files changed, 9 insertions, 4 deletions
diff --git a/bin/why-dont-you b/bin/why-dont-you
index a3c2aa2..9fb13f5 100755
--- a/bin/why-dont-you
+++ b/bin/why-dont-you
@@ -46,7 +46,8 @@ case "${action}" in
printf '`to_build`.`baa_name`,'
printf 'If(`to_build`.`is_broken`,1,0),'
printf '('
- printf 'SELECT COUNT(1) FROM `failed_builds`'
+ printf 'SELECT COUNT(1)'
+ printf ' FROM `failed_builds`'
printf 'WHERE `failed_builds`.`build_assignment`=`to_build`.`ba_id`'
printf ')'
printf ',replace(to_base64(`%s`.`%s`),"\\n","")' \
@@ -98,7 +99,8 @@ case "${action}" in
printf ') AS `deps`'
printf ' ON `deps`.`dependent`=`to_build`.`bin_id`'
# now we join with build slaves to see if someone builds this
- printf ' LEFT JOIN `build_slaves` ON `build_slaves`.`currently_building`=`to_build`.`ba_id`'
+ printf ' LEFT JOIN `build_slaves`'
+ printf ' ON `build_slaves`.`currently_building`=`to_build`.`ba_id`'
printf ';\n'
} | \
mysql_run_query | \
@@ -315,7 +317,8 @@ case "${action}" in
printf ' ON `rsr`.`more_stable`=`r_r`.`stability`'
printf ' AND `rsr`.`less_stable`=`m_r`.`stability`'
printf ' WHERE NOT EXISTS ('
- printf 'SELECT 1 FROM `binary_packages_in_repositories` AS `subst_bpir`'
+ printf 'SELECT 1'
+ printf ' FROM `binary_packages_in_repositories` AS `subst_bpir`'
mysql_join_binary_packages_in_repositories_repositories 'subst_bpir' 'subst_r'
mysql_join_binary_packages_in_repositories_binary_packages 'subst_bpir' 'subst_bp'
printf ' JOIN `repository_stability_relations` AS `rsr_a`'
@@ -364,7 +367,9 @@ case "${action}" in
printf ' FROM `install_targets`;\n'
# create copy
- printf 'INSERT INTO `knots_copy` SELECT * FROM `knots`;\n'
+ printf 'INSERT INTO `knots_copy`'
+ printf ' SELECT *'
+ printf ' FROM `knots`;\n'
# "available" bpir requires available install_target
printf 'INSERT INTO `edges` (`cause`,`impact`,`invert`)'