From 8dde526290718371b6da178c65955d431910fd97 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Thu, 31 May 2018 13:27:18 +0200
Subject: fill new columns in `binary_packages_in_repositories`, too

---
 bin/get-package-updates | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

(limited to 'bin/get-package-updates')

diff --git a/bin/get-package-updates b/bin/get-package-updates
index 34e9753..6c4c5f9 100755
--- a/bin/get-package-updates
+++ b/bin/get-package-updates
@@ -128,9 +128,13 @@ delete_package() {
       mysql_join_binary_packages_build_assignments
       mysql_join_build_assignments_package_sources
       mysql_join_binary_packages_binary_packages_in_repositories
+      printf ' SET '
       # shellcheck disable=SC2154
-      printf ' SET `binary_packages_in_repositories`.`repository`=%s' \
-        "${repository_ids__any_deletion_list}"
+      printf '`binary_packages_in_repositories`.`%s`=%s,' \
+        'repository' "${repository_ids__any_deletion_list}" \
+        'is_to_be_deleted' '1' \
+        'last_moved' 'NOW()' | \
+        sed 's/,$//'
       # shellcheck disable=SC2154
       printf ' WHERE `binary_packages_in_repositories`.`repository` in (%s,%s)' \
         "${repository_ids__any_build_list}" \
-- 
cgit v1.2.3