Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2022-07-04 19:29:16 +0200
committerErich Eckner <git@eckner.net>2022-07-04 19:29:49 +0200
commite6ae58c81071cdc2f926b437d3f0ab1ac143ae83 (patch)
tree2a249fd6a55eaed5a552642d25d1ce007c74ac10
parent348ccba102bdcda923651ece405ccb29ae1af46f (diff)
lib/mysql-functions: mysql_sanity_check(): check for signature in db, too
-rwxr-xr-xlib/mysql-functions10
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 '