| index : builder | |
| Archlinux32 build system | gitolite user |
| summaryrefslogtreecommitdiff |
| -rwxr-xr-x | bin/build-master-status-from-mysql | 102 |
diff --git a/bin/build-master-status-from-mysql b/bin/build-master-status-from-mysql index 0e66473..081baec 100755 --- a/bin/build-master-status-from-mysql +++ b/bin/build-master-status-from-mysql @@ -39,28 +39,6 @@ sort "${work_dir}/build-list" > \ # shellcheck disable=SC2016 { - printf 'SELECT DISTINCT ' - printf '`package_sources`.`%s`,' \ - 'pkgbase' 'git_revision' 'mod_git_revision' - printf '`upstream_repositories`.`name`' - printf ' FROM `build_slaves`' - mysql_join_build_slaves_build_assignments - mysql_join_build_assignments_package_sources - mysql_join_package_sources_upstream_repositories -} | \ - mysql_run_query | \ - tr '\t' ' ' | \ - sort > \ - "${tmp_dir}/locked.mysql" -find "${work_dir}/package-states" -mindepth 1 -maxdepth 1 -name '*.locked' -printf '%f\n' | \ - sed ' - s/\.\([^.]\+\)\.\([^.]\+\)\.\([^.]\+\)\.[^.]\+$/ \1 \2 \3/ - ' | \ - sort > \ - "${tmp_dir}/locked.file" - -# shellcheck disable=SC2016 -{ printf 'SELECT DISTINCT `package_sources`.`pkgbase`' printf ' FROM `package_sources`' mysql_join_package_sources_build_assignments @@ -75,79 +53,7 @@ find "${work_dir}/package-states" -mindepth 1 -maxdepth 1 -name '*.locked' -prin sort "${work_dir}/deletion-list" > \ "${tmp_dir}/deletion-list.file" -# shellcheck disable=SC2016 { - printf 'SELECT ' - printf '`binary_packages`.`%s`,' \ - 'pkgname' \ - 'epoch' \ - 'pkgver' \ - 'pkgrel' \ - 'sub_pkgrel' - printf '`architectures`.`name`' - printf ' FROM `binary_packages`' - mysql_join_binary_packages_repositories - mysql_join_binary_packages_architectures - mysql_join_repositories_repository_stabilities - printf ' WHERE `binary_packages`.`is_tested`' - printf ' AND NOT `binary_packages`.`has_issues`' - printf ' AND `repository_stabilities`.`name`="testing"' -} | \ - mysql_run_query | \ - sed ' - s/^\(\S\+\)\s\(\S\+\)\s\(\S\+\)\s\(\S\+\)\s\(\S\+\)\s\(\S\+\)$/\1-\2:\3-\4.\5-\6.pkg.tar.xz/ - ' | \ - sort -u > \ - "${tmp_dir}/tested.mysql" -find "${work_dir}/package-states" -mindepth 1 -maxdepth 1 \ - -name '*.tested' \ - -exec cat '{}' \; | \ - sed ' - s/-\([^-.]\+\)\(-[^-]\+\)$/-\1.0\2/ - s/-\([^-:]\+\)\(\(-[^-]\+\)\{2\}\)$/-0:\1\2/ - ' | \ - sort -u > \ - "${tmp_dir}/tested.file" - -# shellcheck disable=SC2016 -{ - printf 'SELECT ' - printf '`binary_packages`.`%s`,' \ - 'pkgname' \ - 'epoch' \ - 'pkgver' \ - 'pkgrel' \ - 'sub_pkgrel' - printf '`architectures`.`name`' - printf ' FROM `binary_packages`' - mysql_join_binary_packages_repositories - mysql_join_binary_packages_architectures - mysql_join_repositories_repository_stabilities - printf ' WHERE NOT `binary_packages`.`is_tested`' - printf ' AND NOT `binary_packages`.`has_issues`' - printf ' AND `repository_stabilities`.`name`="testing"' -} | \ - mysql_run_query | \ - sed ' - s/^\(\S\+\)\s\(\S\+\)\s\(\S\+\)\s\(\S\+\)\s\(\S\+\)\s\(\S\+\)$/\1-\2:\3-\4.\5-\6.pkg.tar.xz/ - ' | \ - sort -u > \ - "${tmp_dir}/testing.mysql" -find "${work_dir}/package-states" -mindepth 1 -maxdepth 1 \ - -name '*.testing' \ - -exec cat '{}' \; | \ - sed ' - s/-\([^-.]\+\)\(-[^-]\+\)$/-\1.0\2/ - s/-\([^-:]\+\)\(\(-[^-]\+\)\{2\}\)$/-0:\1\2/ - ' | \ - sort -u > \ - "${tmp_dir}/testing.file" - -{ - diff -u \ - "${tmp_dir}/locked.file" \ - "${tmp_dir}/locked.mysql" || \ - true mysql_sanity_check || true diff -u \ "${tmp_dir}/build-list.file" \ @@ -157,14 +63,6 @@ find "${work_dir}/package-states" -mindepth 1 -maxdepth 1 \ "${tmp_dir}/deletion-list.file" \ "${tmp_dir}/deletion-list.mysql" || \ true - diff -u \ - "${tmp_dir}/tested.file" \ - "${tmp_dir}/tested.mysql" || \ - true - diff -u \ - "${tmp_dir}/testing.file" \ - "${tmp_dir}/testing.mysql" || \ - true } | \ sed ' s,^-.*$,<font color="#FF0000">\0</font>, |