diff options
| author | Eugeniy E. Mikhailov <evgmik@gmail.com> | 2023-05-12 12:55:09 -0400 |
|---|---|---|
| committer | Eugeniy E. Mikhailov <evgmik@gmail.com> | 2023-05-12 12:55:09 -0400 |
| commit | 8739f1acab8366dceb4b5ae624c4181b585f134a (patch) | |
| tree | a2b2163462be6f26163646290a00ed1452217e71 | |
| parent | 65920f8452917dbbd2507d58df50d591d6679836 (diff) | |
| download | GradeBook-8739f1acab8366dceb4b5ae624c4181b585f134a.tar.gz GradeBook-8739f1acab8366dceb4b5ae624c4181b585f134a.zip | |
more general converters for grades csv files
| -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" |