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

1 files changed, 10 insertions, 0 deletions

diff --git a/bin/nit-picker b/bin/nit-picker
index 7a2f785..7312348 100755
--- a/bin/nit-picker
+++ b/bin/nit-picker
@@ -128,6 +128,8 @@ while pgrep -x ii >/dev/null \
         mysql_package_name_query
         printf ' FROM `binary_packages`'
         mysql_join_binary_packages_architectures
+        printf ' LEFT'
+        mysql_join_binary_packages_compressions
         mysql_join_binary_packages_binary_packages_in_repositories
         mysql_join_binary_packages_in_repositories_repositories
         printf ' WHERE `repositories`.`is_on_master_mirror`'
@@ -147,6 +149,8 @@ while pgrep -x ii >/dev/null \
       mysql_package_name_query
       printf ' FROM `binary_packages`'
       mysql_join_binary_packages_architectures
+      printf ' LEFT'
+      mysql_join_binary_packages_compressions
       mysql_join_binary_packages_binary_packages_in_repositories
       mysql_join_binary_packages_in_repositories_repositories
       printf ' WHERE `repositories`.`is_on_master_mirror`'
@@ -246,6 +250,8 @@ while pgrep -x ii >/dev/null \
             printf ' FROM `binary_packages`'
             mysql_join_binary_packages_dependencies
             mysql_join_binary_packages_architectures
+            printf ' LEFT'
+            mysql_join_binary_packages_compressions
             mysql_join_dependencies_dependency_types
             mysql_join_dependencies_versions
             mysql_join_dependencies_install_targets
@@ -458,6 +464,8 @@ done
         "${tmp_dir}/remove-those-dependencies"
       printf 'SELECT `d`.`id` FROM `binary_packages`'
       mysql_join_binary_packages_architectures
+      printf ' LEFT'
+      mysql_join_binary_packages_compressions
       printf ' JOIN `rd`'
       printf ' ON `rd`.`pf`='
       mysql_package_name_query
@@ -529,6 +537,8 @@ done
     printf '`ad`.`vr`'
     printf ' FROM `binary_packages`'
     mysql_join_binary_packages_architectures
+    printf ' LEFT'
+    mysql_join_binary_packages_compressions
     printf ' JOIN `ad`'
     printf ' ON `ad`.`pf`='
     mysql_package_name_query