diff options
Diffstat (limited to 'regenGradescopeDB.sh')
| -rwxr-xr-x | regenGradescopeDB.sh | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/regenGradescopeDB.sh b/regenGradescopeDB.sh index 774f624..e7273ea 100755 --- a/regenGradescopeDB.sh +++ b/regenGradescopeDB.sh @@ -1,7 +1,10 @@ #!/bin/bash -rm -f 2021_Gradescope.db -printf '.mode csv\n.import 2021_Gradescope.csv export_table' | \ - sqlite3 2021_Gradescope.db +CSVFILE="$1" +dbfile=Gradescope.db +rm -f "$dbfile" + +printf ".mode csv\n.import \"$CSVFILE\" export_table" | \ + sqlite3 "$dbfile" |