1 files changed, 14 insertions, 0 deletions
diff --git a/csv2rawSqliteDB.sh b/csv2rawSqliteDB.sh
new file mode 100755
index 0000000..b49414d
--- /dev/null
+++ b/csv2rawSqliteDB.sh
@@ -0,0 +1,14 @@
+#!/bin/bash
+
+inputCSV="$1"
+rm -f csvExport.db
+printf ".mode csv\n.import $inputCSV applicants_raw" | \
+sqlite3 csvExport.db 
+
+#dbFile=2021_physics.db
+#tmpDir=/run/user/1000
+#tmpDB=$tmpDir/$dbFile
+#rm -f $tmpDB
+#./convert_raw2physics.tcl
+#mv $tmpDB .
+