summaryrefslogtreecommitdiff
path: root/bin/get-assignment
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-01-17 15:24:40 +0100
committerErich Eckner <git@eckner.net>2019-01-17 15:24:40 +0100
commitc9f55c95cb382e22c41a310c1005e3de43379ae9 (patch)
tree38210b816af5645dad7fad10b1de6a32fe89c76b /bin/get-assignment
parent294c66ccc56ee6200b288585833cae1d1bfc3ea8 (diff)
downloadbuilder-c9f55c95cb382e22c41a310c1005e3de43379ae9.tar.xz
style: WHERE,ON,FROM,SELECT,JOIN should be on beginning of source lines
Diffstat (limited to 'bin/get-assignment')
-rwxr-xr-xbin/get-assignment9
1 files changed, 6 insertions, 3 deletions
diff --git a/bin/get-assignment b/bin/get-assignment
index 3fc0d49..27a266a 100755
--- a/bin/get-assignment
+++ b/bin/get-assignment
@@ -253,10 +253,12 @@ next_building=$(
printf ' ON `build_assignments`.`id`=`considered_build_assignments`.`id`'
mysql_join_build_assignments_package_sources
printf ' WHERE NOT EXISTS ('
- printf 'SELECT 1 FROM `toolchain_order`'
+ printf 'SELECT 1'
+ printf ' FROM `toolchain_order`'
printf ' WHERE `toolchain_order`.`pkgbase`=`package_sources`.`pkgbase`'
printf ') AND EXISTS ('
- printf 'SELECT 1 FROM `considered_build_assignments_2`'
+ printf 'SELECT 1'
+ printf ' FROM `considered_build_assignments_2`'
printf ' JOIN `build_assignments`'
printf ' ON `build_assignments`.`id`=`considered_build_assignments_2`.`id`'
mysql_join_build_assignments_package_sources
@@ -282,7 +284,8 @@ next_building=$(
printf 'DELETE `considered_build_assignments`'
printf ' FROM `considered_build_assignments`'
printf ' WHERE EXISTS ('
- printf 'SELECT 1 FROM `considered_build_assignments_2`'
+ printf 'SELECT 1'
+ printf ' FROM `considered_build_assignments_2`'
printf ' JOIN `build_assignments`'
printf ' ON `build_assignments`.`id`=`considered_build_assignments_2`.`id`'
mysql_join_build_assignments_package_sources