From 820afab73ec7bb4652834525fbb360803ecea50a Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc" <kop@karlpinc.com>
Date: Thu, 9 Nov 2023 10:31:58 -0600
Subject: [PATCH] Separate file for db speed settings

---
 conversion/Makefile     |  3 ++-
 conversion/mung_dump.sh |  4 ----
 conversion/speedups.sh  | 32 ++++++++++++++++++++++++++++++++
 3 files changed, 34 insertions(+), 5 deletions(-)
 create mode 100644 conversion/speedups.sh

diff --git a/conversion/Makefile b/conversion/Makefile
index dd9ea7c..3bf732c 100644
--- a/conversion/Makefile
+++ b/conversion/Makefile
@@ -109,7 +109,8 @@ restore: $(PSQL_DEPENDS)
            || { printf 'The DATA_FILE variable must be set\n' >&2 ; \
                 exit 1 ; }
 	( $(PSQL_SETUP) \
-          ./mung_dump.sh $(DATA_FILE) ; ) \
+	  ./speedups.sh ; \
+	./mung_dump.sh $(DATA_FILE) ; ) \
 	| psql $(PSQL_ARGS)
 #	| psql $(PSQL_ARGS) $(PSQL_SINGLE_TRANS) --set=ON_ERROR_STOP=y
 
diff --git a/conversion/mung_dump.sh b/conversion/mung_dump.sh
index 2d57d5d..76cbe31 100755
--- a/conversion/mung_dump.sh
+++ b/conversion/mung_dump.sh
@@ -29,10 +29,6 @@
 
 DATA_FILE="$1"
 
-# Settings to speed the restore.
-printf 'SET default_transaction_isolation TO "read uncommitted";\n'
-printf 'SET synchronous_commit TO "off";\n'
-
 # Output the munged data dump as SQL
 bunzip2 -c "${DATA_FILE}" \
   | awk '
diff --git a/conversion/speedups.sh b/conversion/speedups.sh
new file mode 100644
index 0000000..de336b3
--- /dev/null
+++ b/conversion/speedups.sh
@@ -0,0 +1,32 @@
+#!/bin/sh
+# Copyright (C) 2023 The Meme Factory, Inc. http://www.karlpinc.com/
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as published by
+# the Free Software Foundation, either version 3 of the License, or
+# (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU Affero General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <https://www.gnu.org/licenses/>.
+#
+#  Ouput SQL on stdout of a modifed dump, applying settings to speed
+#  up the restore and altering the dump so that it will load.
+#
+# Syntax: mung_dump.sh DATA_FILE
+#
+# DATA_FILE  The file containing the bzip2 compressed data dump
+#
+#
+# Karl O. Pinc <kop@karlpinc.com>
+#
+# Note: The DATA_FILE seems to use crlf (MS Windows format) for EOL.
+#
+
+# Settings to speed the restore.
+printf 'SET default_transaction_isolation TO "read uncommitted";\n'
+printf 'SET synchronous_commit TO "off";\n'
-- 
2.34.1