diff options
Diffstat (limited to 'bin/build-master-status-from-mysql')
| -rwxr-xr-x | bin/build-master-status-from-mysql | 19 |
1 files changed, 10 insertions, 9 deletions
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 ' | \ |