From ed45f26f1c87ac9a27436288b67af66a8abb20ed Mon Sep 17 00:00:00 2001
From: Zach DeCook <zach.decook@bettercarpeople.com>
Date: Tue, 3 Sep 2024 11:22:56 -0400
Subject: csv2*: minor changes

---
 .local/bin/csv2INSERT.sh | 2 +-
 .local/bin/csv2sql.sh    | 4 ++++
 2 files changed, 5 insertions(+), 1 deletion(-)

(limited to '.local/bin')

diff --git a/.local/bin/csv2INSERT.sh b/.local/bin/csv2INSERT.sh
index 1e20a67..efeb31b 100755
--- a/.local/bin/csv2INSERT.sh
+++ b/.local/bin/csv2INSERT.sh
@@ -1,6 +1,6 @@
 #!/bin/sh
 
 read line
-echo "INSERT INTO $1 ($line) VALUES"
+echo "INSERT IGNORE INTO $1 ($line) VALUES"
 csv2sql.sh | head -c -2
 echo ";"
diff --git a/.local/bin/csv2sql.sh b/.local/bin/csv2sql.sh
index 7f4a8d5..f080f36 100755
--- a/.local/bin/csv2sql.sh
+++ b/.local/bin/csv2sql.sh
@@ -3,6 +3,10 @@
 tr , "\t" |
 sed 's/\t\([^"\t]\+\)/\t"\1"/g' |
 sed 's/\([^"\t]\+\)\t/"\1"\t/g' |
+# Switch CSV " escaping to SQL escaping
+sed 's/""/\\"/g' |
+#sed 's/\\r/\\\\r/g' |
+#sed 's/\\n/\\\\n/g' |
 # replace empty with null,
 sed 's/\t\t/\tnull\t/g' |
 sed 's/\t\t/\tnull\t/g' |
-- 
cgit 1.4.1