lib/mysql-functions: mysql_sanity_check(): check for signature in db, too

1 files changed, 10 insertions, 0 deletions

diff --git a/lib/mysql-functions b/lib/mysql-functions
index af2c3ba..c27babc 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -702,6 +702,16 @@ mysql_sanity_check() {
     mysql_join_binary_packages_in_repositories_repositories
     printf ' WHERE `repositories`.`is_on_master_mirror`'
     printf ' AND `binary_packages`.`sha512sum` IS NULL;\n'
+    printf 'SELECT DISTINCT CONCAT("non-virtual binary-package without signature: ",'
+    mysql_package_name_query
+    printf ') FROM `binary_packages`'
+    mysql_join_binary_packages_architectures
+    printf ' LEFT'
+    mysql_join_binary_packages_compressions
+    mysql_join_binary_packages_binary_packages_in_repositories
+    mysql_join_binary_packages_in_repositories_repositories
+    printf ' WHERE `repositories`.`is_on_master_mirror`'
+    printf ' AND `binary_packages`.`signing_key` IS NULL;\n'
   } | \
     mysql_run_query | \
     sed '