From c9f55c95cb382e22c41a310c1005e3de43379ae9 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 17 Jan 2019 15:24:40 +0100 Subject: style: WHERE,ON,FROM,SELECT,JOIN should be on beginning of source lines --- bin/get-assignment | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) (limited to 'bin/get-assignment') 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 -- cgit v1.2.3