#!/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} -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 | \
sed '
s,,\0\n,g
' | \
sed '
\,$, {
s,| pkgbase | ,currently building | ,
y,_, ,
}
\,$, ! {
s,NULL | ,\ | ,
}
1 i list of build slaves
$ a
' | \
sponge "${webserver_directory}/build-slaves.html"
mysql_sanity_check | \
sed '
s,^-.*$,\0,
s,^+.*$,\0,
s/$/
/
1 i sanity of the buildmaster'"'"'s mysql database
$ a
' | \
sponge "${webserver_directory}/mysql-sanity.html"