From cde3b3a8b64069210fdc5f74ba8facd2b8d56a3c Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Mon, 13 Jan 2020 11:07:14 +0100
Subject: bin/nit-picker: recheck upstream-unavailable packages in our database
 - maybe, they were corrected in the meantime

---
 bin/nit-picker | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)

diff --git a/bin/nit-picker b/bin/nit-picker
index 9cec5c8..ebb3973 100755
--- a/bin/nit-picker
+++ b/bin/nit-picker
@@ -626,6 +626,32 @@ while pgrep -x ii >/dev/null \
           )" ]; then
             continue
           fi
+          # shellcheck disable=SC2016
+          if {
+            printf 'SELECT'
+            printf ' COUNT(1)'
+            printf ' FROM `binary_packages`'
+            mysql_join_binary_packages_binary_packages_in_repositories
+            printf ' AND `binary_packages`.`pkgname`=from_base64("%s")' \
+              "$(
+                printf '%s\n' "${parameters}" \
+                | base64 -w0
+              )"
+            printf ' AND NOT `binary_packages_in_repositories`.`is_to_be_deleted`'
+            mysql_join_binary_packages_in_repositories_repositories
+            printf ' AND ('
+              printf '`repositories`.`is_on_master_mirror`'
+              printf ' OR `repositories`.`id`=%s' \
+                "${repository_ids__any_build_list}"
+            printf ')'
+            mysql_join_binary_packages_build_assignments
+            mysql_join_build_assignments_package_sources
+            printf ' AND `package_sources`.`uses_upstream`;\n'
+          } \
+          | mysql_run_query \
+          | grep -qxF 0; then
+            continue
+          fi
           printf 'Package %s is still in our repositories or on the build-list, but is not available upstream.\n' \
             "${parameters}" \
           | local_irc_say
-- 
cgit v1.2.3