diff options
| -rwxr-xr-x | regenBlackboardDB.sh | 6 | ||||
| -rwxr-xr-x | regenGradescopeDB.sh | 9 |
2 files changed, 9 insertions, 6 deletions
diff --git a/regenBlackboardDB.sh b/regenBlackboardDB.sh index 4231683..08c021b 100755 --- a/regenBlackboardDB.sh +++ b/regenBlackboardDB.sh @@ -1,10 +1,10 @@ #!/bin/bash CSVFILE="$1" -bbfile=Blackboard.db -rm -f "$bbfile" +dbfile=Blackboard.db +rm -f "$dbfile" printf ".mode csv\n.import \"$CSVFILE\" export_table" | \ - sqlite3 "$bbfile" + sqlite3 "$dbfile" 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" |