From 7076434dfbf8e1c11db92bf44695cbc2b5c2564b Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Tue, 12 Jun 2018 14:30:02 +0200
Subject: bin/db-update: do not remove db entries with "-n"

---
 bin/db-update | 41 ++++++++++++++++++++++-------------------
 1 file changed, 22 insertions(+), 19 deletions(-)

diff --git a/bin/db-update b/bin/db-update
index 1b72805..7d5af50 100755
--- a/bin/db-update
+++ b/bin/db-update
@@ -370,25 +370,28 @@ for source_stability in \
     s,^\(\S\+\) \(\S\+\) \(\S\+\)$,\2/\3/\1,
   ' "${tmp_dir}/rm"
 
-  # shellcheck disable=SC2016
-  {
-    printf 'CREATE TEMPORARY TABLE `replaced_bpir` (`id` BIGINT, UNIQUE KEY (`id`));\n'
-    printf 'CREATE TEMPORARY TABLE `moved_bpir` (`id` BIGINT, `new_repository` MEDIUMINT, UNIQUE KEY (`id`));\n'
-    printf 'LOAD DATA LOCAL INFILE "%s" INTO TABLE `%s` COLUMNS TERMINATED BY " ";\n' \
-      "${tmp_dir}/mv.id" 'moved_bpir' \
-      "${tmp_dir}/rm.id" 'replaced_bpir'
-    printf 'DELETE `binary_packages_in_repositories` FROM `binary_packages_in_repositories`'
-    printf ' JOIN `replaced_bpir` ON `binary_packages_in_repositories`.`id`=`replaced_bpir`.`id`;\n'
-    mysql_query_and_delete_unneeded_binary_packages
-    printf 'UPDATE `binary_packages_in_repositories`'
-    printf ' JOIN `moved_bpir` ON `binary_packages_in_repositories`.`id`=`moved_bpir`.`id`'
-    printf ' SET `binary_packages_in_repositories`.`repository`=`moved_bpir`.`new_repository`,'
-    printf '`binary_packages_in_repositories`.`last_moved`=NOW()'
-    printf ' WHERE `binary_packages_in_repositories`.`repository`!=`moved_bpir`.`new_repository`;\n'
-  } | \
-    mysql_run_query | \
-    sort -u >> \
-    "${tmp_dir}/rm"
+  # somewhat inaccurate
+  if ! ${no_action}; then
+    # shellcheck disable=SC2016
+    {
+      printf 'CREATE TEMPORARY TABLE `replaced_bpir` (`id` BIGINT, UNIQUE KEY (`id`));\n'
+      printf 'CREATE TEMPORARY TABLE `moved_bpir` (`id` BIGINT, `new_repository` MEDIUMINT, UNIQUE KEY (`id`));\n'
+      printf 'LOAD DATA LOCAL INFILE "%s" INTO TABLE `%s` COLUMNS TERMINATED BY " ";\n' \
+        "${tmp_dir}/mv.id" 'moved_bpir' \
+        "${tmp_dir}/rm.id" 'replaced_bpir'
+      printf 'DELETE `binary_packages_in_repositories` FROM `binary_packages_in_repositories`'
+      printf ' JOIN `replaced_bpir` ON `binary_packages_in_repositories`.`id`=`replaced_bpir`.`id`;\n'
+      mysql_query_and_delete_unneeded_binary_packages
+      printf 'UPDATE `binary_packages_in_repositories`'
+      printf ' JOIN `moved_bpir` ON `binary_packages_in_repositories`.`id`=`moved_bpir`.`id`'
+      printf ' SET `binary_packages_in_repositories`.`repository`=`moved_bpir`.`new_repository`,'
+      printf '`binary_packages_in_repositories`.`last_moved`=NOW()'
+      printf ' WHERE `binary_packages_in_repositories`.`repository`!=`moved_bpir`.`new_repository`;\n'
+    } | \
+      mysql_run_query | \
+      sort -u >> \
+      "${tmp_dir}/rm"
+  fi
 
   # move the packages remotely via sftp
   {
-- 
cgit v1.2.3