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"