bin/modify-package-state: accept "any" as architecture to operate on all architectures

1 files changed, 6 insertions, 2 deletions

diff --git a/bin/modify-package-state b/bin/modify-package-state
index 686a131..7a0c252 100755
--- a/bin/modify-package-state
+++ b/bin/modify-package-state
@@ -170,12 +170,16 @@ while read -r a b; do
       )
     ;;
     'block'|'unblock')
-      # we expect a package source identifier (pkgbase.git_revision.mod_git_revision.repository)
+      # we expect a package source identifier (pkgbase.git_revision.mod_git_revision.repository.architecture)
       # and we will only operate on packages in "unbuilt" repositories
       # shellcheck disable=SC2016
       combiner=$(
         printf '`build_assignments`'
-        mysql_join_build_assignments_architectures
+        printf ' JOIN `architecture_compatibilities`'
+        printf ' ON `architecture_compatibilities`.`runs_on`=`build_assignments`.`architecture`'
+        printf ' AND `architecture_compatibilities`.`fully_compatible`'
+        printf ' JOIN `architectures`'
+        printf ' ON `architecture_compatibilities`.`built_for`=`architectures`.`id`'
         mysql_join_build_assignments_package_sources
         mysql_join_package_sources_upstream_repositories
         mysql_join_build_assignments_binary_packages