Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/bin/build-master-status-from-mysql
blob: a0c2b4f9c1cdde462209851440df7add76486913 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
#!/bin/sh

# report about status of build master - according to mysql database

# shellcheck source=conf/default.conf
. "${0%/*}/../conf/default.conf"

{
  mysql_sanity_check || true
  {
    # shellcheck disable=SC2016
    {
      printf 'SELECT `package_sources`.`pkgbase`,`package_sources`.`git_revision`,`package_sources`.`mod_git_revision`,`upstream_repositories`.`name`'
      printf ' FROM `package_sources`'
      printf ' JOIN `%s` ON `%s`.`%s`=`%s`.`id`' \
        'upstream_repositories' 'package_sources' 'upstream_package_repository' 'upstream_repositories' \
        'build_assignments' 'build_assignments' 'package_source' 'package_sources' \
        'binary_packages' 'binary_packages' 'build_assignment' 'build_assignments' \
        'repositories' 'binary_packages' 'repository' 'repositories'
      printf ' WHERE `repositories`.`name`="build-list"'
    } | \
      ${mysql_command} --batch | \
      sed '
        1d
        y/\t/ /
        s/^/+ /
      '
    sed 's/^/- /' "${work_dir}/build-list"
  } | \
    sort -k2 -k1,1 | \
    uniq -uf1
} | \
  sed '
    s,^-.*$,<font color="#FF0000">\0</font>,
    s,^+.*$,<font color="#00FF00">\0</font>,
    s/$/<br>/
    1 i <html><head><title>sanity of the buildmaster'"'"'s mysql database</title></head><body>
    $ a </body></html>
  ' | \
  sponge "${webserver_directory}/mysql-sanity.html"