From 95aa99618adf4f55d1a61f8e9fab56c7960a84e4 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 17 Oct 2019 10:19:56 +0200 Subject: lib/mysql-functions: mysql_package_name_query(): take compression suffix from database, default to "tar.xz" for now --- bin/bootstrap-mysql | 2 ++ bin/create-build-support-package | 6 +++++- bin/db-update | 4 ++++ bin/delete-packages | 6 ++++++ bin/get-assignment | 2 ++ bin/nit-picker | 10 ++++++++++ bin/return-assignment | 4 ++++ bin/sanity-check | 2 ++ bin/seed-build-list | 2 ++ 9 files changed, 37 insertions(+), 1 deletion(-) (limited to 'bin') diff --git a/bin/bootstrap-mysql b/bin/bootstrap-mysql index 636ee60..38e6d8d 100755 --- a/bin/bootstrap-mysql +++ b/bin/bootstrap-mysql @@ -646,6 +646,8 @@ fi mysql_join_binary_packages_in_repositories_repositories mysql_join_repositories_architectures '' 'r_a' mysql_join_binary_packages_architectures + printf ' LEFT' + mysql_join_binary_packages_compressions printf ';\n' printf 'INSERT INTO `knot_names_copy`' diff --git a/bin/create-build-support-package b/bin/create-build-support-package index 1d4ec66..3e9dd8d 100755 --- a/bin/create-build-support-package +++ b/bin/create-build-support-package @@ -127,6 +127,8 @@ if [ -n "${source_package}" ]; then mysql_join_binary_packages_in_repositories_repositories mysql_join_repositories_architectures '' 'r_a' mysql_join_binary_packages_architectures + printf ' LEFT' + mysql_join_binary_packages_compressions printf ' WHERE `repositories`.`is_on_master_mirror`' printf ' AND `r_a`.`name`=from_base64("%s")' \ "$( @@ -136,7 +138,7 @@ if [ -n "${source_package}" ]; then printf ' AND ' mysql_package_name_query '' 'XX' \ | sed ' - s/,"-",`XX.*\.pkg\.tar\.xz"// + s/,"-",`XX.*\.`suffix`)// ' printf '=from_base64("%s")' \ "$( @@ -258,6 +260,8 @@ elif [ -n "${shim_package}" ]; then printf 'SELECT DISTINCT `binary_packages`.`id`' printf ' FROM `binary_packages`' mysql_join_binary_packages_architectures + printf ' LEFT' + mysql_join_binary_packages_compressions printf ' WHERE ' mysql_package_name_query \ | sed 's/pkgname`,"/\0-shim/' diff --git a/bin/db-update b/bin/db-update index fa87673..738f3d6 100755 --- a/bin/db-update +++ b/bin/db-update @@ -460,6 +460,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 ' JOIN `repositories` AS `new_repo`' printf ' ON `new_repo`.`id`=`moveable_bpir`.`to_repository`' @@ -478,6 +480,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' } | \ 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 diff --git a/bin/get-assignment b/bin/get-assignment index b7cdb8a..6eaa5d9 100755 --- a/bin/get-assignment +++ b/bin/get-assignment @@ -47,6 +47,8 @@ hand_out_assignment() { 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 printf ' WHERE `binary_packages`.`build_assignment`=%s' \ "$1" 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 diff --git a/bin/return-assignment b/bin/return-assignment index c8c6ecf..d9ba283 100755 --- a/bin/return-assignment +++ b/bin/return-assignment @@ -758,6 +758,8 @@ find . -maxdepth 1 -name '*.pkg.tar.xz' -printf '%f\n' > \ 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 printf ' WHERE `binary_packages`.`build_assignment`=from_base64("%s")' \ "$( @@ -820,6 +822,8 @@ fi printf ' AND `binary_packages_in_repositories`.`repository`=%s' \ "${repository_ids__any_build_list}" mysql_join_binary_packages_architectures + printf ' LEFT' + mysql_join_binary_packages_compressions mysql_join_build_assignments_package_sources mysql_join_package_sources_upstream_repositories mysql_join_upstream_repositories_repository_moves diff --git a/bin/sanity-check b/bin/sanity-check index 75a4206..74b084e 100755 --- a/bin/sanity-check +++ b/bin/sanity-check @@ -469,6 +469,8 @@ while [ $# -gt 0 ]; do mysql_join_binary_packages_in_repositories_repositories printf ' AND `repositories`.`is_on_master_mirror`' mysql_join_binary_packages_architectures + printf ' LEFT' + mysql_join_binary_packages_compressions mysql_join_repositories_architectures '' 'r_a' } | \ mysql_run_query | \ diff --git a/bin/seed-build-list b/bin/seed-build-list index 4a8f9b5..cb8e647 100755 --- a/bin/seed-build-list +++ b/bin/seed-build-list @@ -235,6 +235,8 @@ if [ -s "${tmp_dir}/mirrors" ]; then 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`' -- cgit v1.2.3-54-g00ecf