From 06e26b5b0ca1128730a847a4b06a4489dce10ca6 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 6 Jun 2018 16:17:43 +0200 Subject: bin/delete-packages: -f|--force new --- bin/delete-packages | 84 +++++++++++++++++++++++++++++++---------------------- 1 file changed, 49 insertions(+), 35 deletions(-) (limited to 'bin/delete-packages') diff --git a/bin/delete-packages b/bin/delete-packages index 75fdc8e..a0e6596 100755 --- a/bin/delete-packages +++ b/bin/delete-packages @@ -25,6 +25,7 @@ usage() { >&2 echo ' delete obsolete binary packages.' >&2 echo '' >&2 echo 'possible options:' + >&2 echo ' -f|--force $id: Only delete the selected packages - but delete in any case.' >&2 echo ' -h|--help: Show this help and exit.' >&2 echo ' -n|--no-action: Only print what would be deleted.' >&2 echo ' -w|--wait: If necessary, wait for lock blocking.' @@ -32,7 +33,8 @@ usage() { } eval set -- "$( - getopt -o hnw \ + getopt -o f:hnw \ + --long force: \ --long help \ --long no-action \ --long wait \ @@ -41,11 +43,16 @@ eval set -- "$( )" block_flag='-n' +force_ids='' no_action=false while true do case "$1" in + -f|--force) + shift + force_ids="${force_ids} $1" + ;; -h|--help) usage 0 ;; @@ -107,41 +114,48 @@ export TMPDIR="${tmp_dir}" { printf 'CREATE TEMPORARY TABLE `to_deletes` (`id` BIGINT, UNIQUE KEY (`id`));\n' printf 'INSERT IGNORE INTO `to_deletes`' - printf ' SELECT DISTINCT `binary_packages`.`id`' - printf ' FROM `binary_packages`' - mysql_join_binary_packages_binary_packages_in_repositories - mysql_join_binary_packages_in_repositories_repositories - printf ' LEFT' # should not be necessary, but is formally more correct - mysql_join_binary_packages_install_target_providers - printf ' WHERE `binary_packages_in_repositories`.`is_to_be_deleted`' - printf ' AND `repositories`.`is_on_master_mirror`' - printf ' AND NOT EXISTS (' - # no packages depending on that one exist - printf 'SELECT 1 FROM `dependencies`' - mysql_join_dependencies_dependency_types - printf ' AND `dependency_types`.`relevant_for_binary_packages`' - mysql_join_dependencies_binary_packages '' 'd_bp' - mysql_join_binary_packages_binary_packages_in_repositories 'd_bp' 'd_bpir' - # deliberately break dependencies of deletion-list packages - printf ' AND NOT `d_bpir`.`is_to_be_deleted`' - mysql_join_binary_packages_in_repositories_repositories 'd_bpir' 'd_r' - mysql_join_repositories_repository_stabilities 'd_r' 'd_rs' - # this is deliberately less restrict than `d_r`.`is_on_master_mirror` - printf ' AND `d_rs`.`name` NOT IN ("forbidden","virtual")' - printf ' WHERE `install_target_providers`.`install_target`=`dependencies`.`depending_on`' + if [ -n "${force_ids}" ]; then + printf ' VALUES ' + # shellcheck disable=SC2086 + printf '(%s),' ${force_ids} | \ + sed 's/,$/;\n/' + else + printf ' SELECT DISTINCT `binary_packages`.`id`' + printf ' FROM `binary_packages`' + mysql_join_binary_packages_binary_packages_in_repositories + mysql_join_binary_packages_in_repositories_repositories + printf ' LEFT' # should not be necessary, but is formally more correct + mysql_join_binary_packages_install_target_providers + printf ' WHERE `binary_packages_in_repositories`.`is_to_be_deleted`' + printf ' AND `repositories`.`is_on_master_mirror`' printf ' AND NOT EXISTS (' - printf 'SELECT 1 FROM `binary_packages` AS `s_bp`' - mysql_join_binary_packages_binary_packages_in_repositories 's_bp' 's_bpir' - printf ' AND NOT `s_bpir`.`is_to_be_deleted`' - mysql_join_binary_packages_install_target_providers 's_bp' 's_itp' - mysql_join_binary_packages_in_repositories_repositories 's_bpir' 's_r' - printf ' AND `s_r`.`is_on_master_mirror`' - printf ' JOIN `repository_stability_relations`' - printf ' ON `repository_stability_relations`.`more_stable`=`s_r`.`stability`' - printf ' WHERE `s_itp`.`install_target`=`install_target_providers`.`install_target`' - printf ' AND `repository_stability_relations`.`less_stable`=`d_r`.`stability`' - printf ')' - printf ');\n' + # no packages depending on that one exist + printf 'SELECT 1 FROM `dependencies`' + mysql_join_dependencies_dependency_types + printf ' AND `dependency_types`.`relevant_for_binary_packages`' + mysql_join_dependencies_binary_packages '' 'd_bp' + mysql_join_binary_packages_binary_packages_in_repositories 'd_bp' 'd_bpir' + # deliberately break dependencies of deletion-list packages + printf ' AND NOT `d_bpir`.`is_to_be_deleted`' + mysql_join_binary_packages_in_repositories_repositories 'd_bpir' 'd_r' + mysql_join_repositories_repository_stabilities 'd_r' 'd_rs' + # this is deliberately less restrict than `d_r`.`is_on_master_mirror` + printf ' AND `d_rs`.`name` NOT IN ("forbidden","virtual")' + printf ' WHERE `install_target_providers`.`install_target`=`dependencies`.`depending_on`' + printf ' AND NOT EXISTS (' + printf 'SELECT 1 FROM `binary_packages` AS `s_bp`' + mysql_join_binary_packages_binary_packages_in_repositories 's_bp' 's_bpir' + printf ' AND NOT `s_bpir`.`is_to_be_deleted`' + mysql_join_binary_packages_install_target_providers 's_bp' 's_itp' + mysql_join_binary_packages_in_repositories_repositories 's_bpir' 's_r' + printf ' AND `s_r`.`is_on_master_mirror`' + printf ' JOIN `repository_stability_relations`' + printf ' ON `repository_stability_relations`.`more_stable`=`s_r`.`stability`' + printf ' WHERE `s_itp`.`install_target`=`install_target_providers`.`install_target`' + printf ' AND `repository_stability_relations`.`less_stable`=`d_r`.`stability`' + printf ')' + printf ');\n' + fi printf 'SELECT DISTINCT "repo",`repositories`.`name`' printf ' FROM `to_deletes`' -- cgit v1.2.3-70-g09d2