diff options
| author | Eugeniy E. Mikhailov <evgmik@gmail.com> | 2021-03-10 13:37:08 -0500 |
|---|---|---|
| committer | Eugeniy E. Mikhailov <evgmik@gmail.com> | 2021-03-10 13:37:08 -0500 |
| commit | 46155492783bc3f86504912dabca7676d9f88b1b (patch) | |
| tree | c55df1aa3bb1fca392dca1dca7894465526ccf1f /csv2rawSqliteDB.sh | |
| parent | 95203afeb2de976d304839d5b3140a7de709d936 (diff) | |
| download | GradeBook-46155492783bc3f86504912dabca7676d9f88b1b.tar.gz GradeBook-46155492783bc3f86504912dabca7676d9f88b1b.zip | |
added csv2rawSqliteDB for general csv files
Diffstat (limited to 'csv2rawSqliteDB.sh')
| -rwxr-xr-x | csv2rawSqliteDB.sh | 14 |
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 . + |