From 1bee9d0041a1772d1066481d49bb349fa4adc28d Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Mon, 12 Feb 2018 13:46:07 +0100 Subject: bin/mysql-functions: add check if a single build assignment having packages on the build-list, deletion-list or to-beconsidered also has packages in a second "repository" --- bin/mysql-functions | 18 +++++++++++++++++- 1 file changed, 17 insertions(+), 1 deletion(-) diff --git a/bin/mysql-functions b/bin/mysql-functions index 262112e..ca78846 100755 --- a/bin/mysql-functions +++ b/bin/mysql-functions @@ -644,9 +644,25 @@ mysql_sanity_check() { printf ' JOIN `repositories` AS `arep` ON `a`.`repository`=`arep`.`id`' printf ' JOIN `repositories` AS `brep` ON `b`.`repository`=`brep`.`id`' printf ' WHERE `a`.`sub_pkgrel`!=`b`.`sub_pkgrel`' - printf ' AND `%srep`.`name` = "build-list"' \ + printf ' AND `%srep`.`name`="build-list"' \ 'a' 'b' printf ';\n' + printf 'SELECT DISTINCT CONCAT("package source ",' + printf '`package_sources`.`%s`,".",' \ + 'pkgbase' 'git_revision' 'mod_git_revision' + printf '`upstream_repositories`.`name`," has parts in ",' + printf '`repo_a`.`name`," and ",' + printf '`repo_b`.`name`," - which should not be the case!")' + printf ' FROM `upstream_repositories`' + printf ' JOIN `%s` ON `%s`.`%s`=`%s`.`id`' \ + 'package_sources' 'package_sources' 'upstream_package_repository' 'upstream_repositories' \ + 'build_assignments' 'build_assignments' 'package_source' 'package_sources' \ + 'binary_packages` AS `bin_a' 'bin_a' 'build_assignment' 'build_assignments' \ + 'binary_packages` AS `bin_b' 'bin_b' 'build_assignment' 'build_assignments' \ + 'repositories` AS `repo_a' 'bin_a' 'repository' 'repo_a' \ + 'repositories` AS `repo_b' 'bin_b' 'repository' 'repo_b' + printf ' WHERE `repo_a`.`name` IN ("build-list","deletion-list","to-be-decided")' + printf ' AND `bin_a`.`repository`!=`bin_b`.`repository`;\n' } | \ ${mysql_command} --raw --batch | \ sed ' -- cgit v1.2.3-54-g00ecf