From 6df5b189676fd9877ff2168e03779a667d59259c Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Tue, 4 Feb 2020 13:35:05 +0100
Subject: lib/mysql-functions: save permanent copies of *successful* mysql
 queries

---
 lib/mysql-functions | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

(limited to 'lib')

diff --git a/lib/mysql-functions b/lib/mysql-functions
index f84cb8b..4bd1164 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -53,11 +53,13 @@ mysql_run_query() {
     if [ -f "${query_stdout}" ]; then
       wait_some_time 10 10
     fi
-    ${mysql_command} -N --raw --batch "$@" \
+    if ${mysql_command} -N --raw --batch "$@" \
       < "${query_stdin}" \
       > "${query_stdout}" \
-      2>> "${query_stderr}" \
-      && rm "${query_stdin}" "${query_stderr}"
+      2>> "${query_stderr}"; then
+      mv "${query_stdin}" "${work_dir}/successful.${query_stdin##*/}"
+      rm "${query_stderr}"
+    fi
     if ! [ -f "${query_stdin}" ]; then
       # success!
       break
-- 
cgit v1.2.3