csv2rawSqliteDB.sh


1
2
3
4
5
6
7
8
9
10
11
12
13
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 .