From bef368a6363dadb025515a6a6d989d6cb7a3574f Mon Sep 17 00:00:00 2001
From: Zach DeCook <zach.decook@bettercarpeople.com>
Date: Mon, 17 Oct 2022 11:57:51 -0400
Subject: work: initial commit

---
 .local/bin/csv2sql.sh | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100755 .local/bin/csv2sql.sh

(limited to '.local/bin/csv2sql.sh')

diff --git a/.local/bin/csv2sql.sh b/.local/bin/csv2sql.sh
new file mode 100755
index 0000000..7f4a8d5
--- /dev/null
+++ b/.local/bin/csv2sql.sh
@@ -0,0 +1,13 @@
+#!/bin/sh
+# Quote everything,
+tr , "\t" |
+sed 's/\t\([^"\t]\+\)/\t"\1"/g' |
+sed 's/\([^"\t]\+\)\t/"\1"\t/g' |
+# replace empty with null,
+sed 's/\t\t/\tnull\t/g' |
+sed 's/\t\t/\tnull\t/g' |
+sed 's/\t$/\tnull/g' |
+sed 's/^\t/null\t/g' |
+tr "\t" , |
+# and add parens around each line
+sed 's/^/(/g' | sed 's/$/),/g'
-- 
cgit 1.4.1