do not remove deletion-marker for all scheduled pkgbases

* we should additionally match the target repository
* else, a moved package will be
** marked for deletion in the old repository
** scheduled to be built in the new repository
** unmarked for deletion in *both* repositories
** only the next run will mark it for deletion again

1 files changed, 7 insertions, 1 deletions

diff --git a/bin/get-package-updates b/bin/get-package-updates
index 7d1aff2..4d2a8f9 100755
--- a/bin/get-package-updates
+++ b/bin/get-package-updates
@@ -439,12 +439,18 @@ while read -r pkgbase repository git_revision mod_git_revision; do
     mysql_join_binary_packages_in_repositories_binary_packages
     mysql_join_binary_packages_build_assignments
     mysql_join_build_assignments_package_sources
+    mysql_join_package_sources_upstream_repositories
     printf ' SET `binary_packages_in_repositories`.`is_to_be_deleted`=0'
-    printf ' WHERE `package_sources`.`pkgbase`=from_base64("%s");\n' \
+    printf ' WHERE `package_sources`.`pkgbase`=from_base64("%s")' \
       "$(
         printf '%s' "${pkgbase}" \
         | base64 -w0
       )"
+    printf ' AND `upstream_repositories`.`name`=from_base64("%s");\n' \
+      "$(
+        printf '%s' "${repository}" \
+        | base64 -w0
+      )"
   } \
   | mysql_run_query
   # shellcheck disable=SC2154