From c02adc5857c4e34cb0920482d5093bdf5b13ddb7 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Thu, 16 Aug 2018 17:53:50 +0200
Subject: bin/find-obsolete-packages: ignore _all_ packages w/o upstream
 sources in our database - they're intentionally additional

---
 bin/find-obsolete-packages | 7 +++----
 1 file 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
 } | \
-- 
cgit v1.2.3-70-g09d2