lib/mysql-functions: mysql_package_name_query(): take compression suffix from database, default to "tar.xz" for now

1 files changed, 6 insertions, 0 deletions

diff --git a/bin/delete-packages b/bin/delete-packages
index 9b5c7cd..2ce04d7 100755
--- a/bin/delete-packages
+++ b/bin/delete-packages
@@ -170,6 +170,8 @@ export TMPDIR="${tmp_dir}"
     mysql_join_binary_packages_in_repositories_binary_packages
     mysql_join_binary_packages_in_repositories_repositories
     mysql_join_binary_packages_architectures
+    printf ' LEFT'
+    mysql_join_binary_packages_compressions
     mysql_join_repositories_architectures '' 'r_a'
     printf ' WHERE `repositories`.`name`="build-support"'
     printf ' AND CONCAT(`r_a`.`name`," ",'
@@ -282,6 +284,8 @@ export TMPDIR="${tmp_dir}"
   mysql_join_binary_packages_in_repositories_binary_packages
   mysql_join_binary_packages_in_repositories_repositories
   mysql_join_binary_packages_architectures
+  printf ' LEFT'
+  mysql_join_binary_packages_compressions
   mysql_join_repositories_architectures '' 'r_a'
   printf ';\n'
 
@@ -296,6 +300,8 @@ export TMPDIR="${tmp_dir}"
   printf ' JOIN `binary_packages`'
   printf ' ON `bp_to_delete`.`id`=`binary_packages`.`id`'
   mysql_join_binary_packages_architectures
+  printf ' LEFT'
+  mysql_join_binary_packages_compressions
   printf ';\n'
 
   # we do not need the ids of the to-be-deleted binary_packages, because