bin/db-update: -f moves all parts of a split package simultanously, now

1 files changed, 6 insertions, 3 deletions

diff --git a/bin/db-update b/bin/db-update
index fe8f167..401ef88 100755
--- a/bin/db-update
+++ b/bin/db-update
@@ -9,8 +9,6 @@
 
 # TODO: make (all) locking less restrictive
 
-# TODO: -f should move *all* parts of the mentioned split package
-
 # shellcheck disable=SC2039,SC2119,SC2120
 
 # shellcheck source=../lib/load-configuration
@@ -277,12 +275,17 @@ export TMPDIR="${tmp_dir}"
         printf '`binary_packages_in_repositories`.`id`,NULL'
         printf ' FROM `binary_packages_in_repositories`'
         mysql_join_binary_packages_in_repositories_repositories
+        printf ' AND `repositories`.`is_on_master_mirror`'
         mysql_join_repositories_architectures
         mysql_join_binary_packages_in_repositories_binary_packages
+        printf ' JOIN `binary_packages` AS `f_bp`'
+        printf ' ON `binary_packages`.`build_assignment`=`f_bp`.`build_assignment`'
+        mysql_join_binary_packages_binary_packages_in_repositories 'f_bp' 'f_bpir'
+        printf ' AND `f_bpir`.`repository`=`repositories`.`id`'
         printf ' WHERE CONCAT('
           printf '`architectures`.`name`,"/",'
           printf '`repositories`.`name`,"/",'
-          printf '`binary_packages`.`pkgname`'
+          printf '`f_bp`.`pkgname`'
         printf ') IN ('
         # shellcheck disable=SC2086
         printf 'from_base64("%s"),' \