diff options
| -rwxr-xr-x | bin/build-master-status-from-mysql | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/bin/build-master-status-from-mysql b/bin/build-master-status-from-mysql new file mode 100755 index 0000000..9626b27 --- /dev/null +++ b/bin/build-master-status-from-mysql @@ -0,0 +1,30 @@ +#!/bin/sh + +# report about status of build master - according to mysql database + +# shellcheck source=conf/default.conf +. "${0%/*}/../conf/default.conf" +# shellcheck source=bin/mysql-functions +. "${base_dir}/bin/mysql-functions" + +# shellcheck disable=SC2016 +${mysql_command} ' + 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` +' --html | \ + sed ' + s,</TR>,\0\n,g + ' | \ + sed ' + \,</TH></TR>$, { + s,<TH>pkgbase</TH>,<TH>currently building</TH>, + y,_, , + } + 1 i <html><head><title>list of build slaves</title></head><body> + $ a </body></html> + ' > \ + "${webserver_directory}/build-slaves.html" |