bin/find-obsolete-packages: ignore _all_ packages w/o upstream sources in our database - they're intentionally additional

1 files changed, 3 insertions, 4 deletions

diff --git a/bin/find-obsolete-packages b/bin/find-obsolete-packages
index 1a35ec1..096411e 100755
--- a/bin/find-obsolete-packages
+++ b/bin/find-obsolete-packages
@@ -102,18 +102,17 @@ fi
       p
       p
     '
-  printf '%s\n' \
-    'archlinux32-keyring' \
-    'archlinux32-keyring-transition' | \
-    sed 'p'
   # shellcheck disable=SC2016
   {
     printf 'SELECT DISTINCT `binary_packages`.`pkgname`'
     printf ' FROM `binary_packages`'
     mysql_join_binary_packages_binary_packages_in_repositories
     mysql_join_binary_packages_in_repositories_repositories
+    mysql_join_binary_packages_build_assignments
+    mysql_join_build_assignments_package_sources
     printf ' WHERE `repositories`.`is_on_master_mirror`'
     printf ' AND NOT `binary_packages_in_repositories`.`is_to_be_deleted`'
+    printf ' AND `package_sources`.`uses_upstream`'
   } | \
     mysql_run_query
 } | \