From f8ffc4a1e58df67045f9e88e6b8c99490f0e1134 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Mon, 22 Jan 2018 08:54:47 +0100
Subject: bin/build-master-status-from-mysql: style

---
 bin/build-master-status-from-mysql | 19 ++++++++++---------
 1 file changed, 10 insertions(+), 9 deletions(-)

(limited to 'bin/build-master-status-from-mysql')

diff --git a/bin/build-master-status-from-mysql b/bin/build-master-status-from-mysql
index 6dacc5e..85185b7 100755
--- a/bin/build-master-status-from-mysql
+++ b/bin/build-master-status-from-mysql
@@ -8,15 +8,16 @@
 . "${base_dir}/bin/mysql-functions"
 
 # shellcheck disable=SC2016
-${mysql_command} -e '
-  SELECT `build_slaves`.`name`,`build_slaves`.`operator`,`package_sources`.`pkgbase`,`build_slaves`.`last_connection`
-  FROM `build_slaves`
-  LEFT JOIN `build_assignments` ON
-  `build_slaves`.`currently_building`=`build_assignments`.`id`
-  LEFT JOIN `package_sources` ON
-  `build_assignments`.`package_source`=`package_sources`.`id`
-  ORDER BY `build_slaves`.`last_connection`
-' --html | \
+{
+  printf 'SELECT `build_slaves`.`name`,`build_slaves`.`operator`,`package_sources`.`pkgbase`,`build_slaves`.`last_connection`'
+  printf ' FROM `build_slaves`'
+  printf ' LEFT JOIN `build_assignments` ON'
+  printf ' `build_slaves`.`currently_building`=`build_assignments`.`id`'
+  printf ' LEFT JOIN `package_sources` ON'
+  printf ' `build_assignments`.`package_source`=`package_sources`.`id`'
+  printf ' ORDER BY `build_slaves`.`last_connection`'
+} | \
+  ${mysql_command} --html | \
   sed '
     s,</TR>,\0\n,g
   ' | \
-- 
cgit v1.2.3-54-g00ecf