From 99ab64ce137a4c139a399bf4286e7dc6ddf5e824 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 9 May 2018 15:29:19 +0200 Subject: bin/get-package-updates: keep binary_packages_in_repositories up to date --- bin/get-package-updates | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/bin/get-package-updates b/bin/get-package-updates index cf0e608..f20ee27 100755 --- a/bin/get-package-updates +++ b/bin/get-package-updates @@ -129,6 +129,17 @@ delete_package() { printf ' WHERE `repositories`.`name` in ("build-list","to-be-decided")' printf ' AND `package_sources`.`pkgbase`=from_base64("%s");\n' \ "$(printf '%s' "$1" | base64 -w0)" + printf 'COMMIT;\n' + printf 'UPDATE `binary_packages_in_repositories`' + mysql_join_binary_packages_in_repositories_binary_packages + mysql_join_binary_packages_repositories + mysql_join_binary_packages_build_assignments + mysql_join_build_assignments_package_sources + printf ' SET `binary_packages`.`repository`=(SELECT `repositories`.`id` FROM `repositories` WHERE `repositories`.`name`="deletion-list")' + printf ' WHERE `repositories`.`name` in ("build-list","to-be-decided")' + printf ' AND `package_sources`.`pkgbase`=from_base64("%s");\n' \ + "$(printf '%s' "$1" | base64 -w0)" + printf 'COMMIT;\n' # other packages are marked as `is_to_be_deleted` printf 'UPDATE `binary_packages`' mysql_join_binary_packages_repositories -- cgit v1.2.3-70-g09d2