aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEugeniy E. Mikhailov <evgmik@gmail.com>2021-04-14 11:55:25 -0400
committerEugeniy E. Mikhailov <evgmik@gmail.com>2021-04-14 11:55:25 -0400
commit176c9f8057471749c4f3a0a7afc3e4f4bde110fc (patch)
treeae03c6afe638dc1ecd95c96b4d600971f9a32bed
parent93ee6cedbe725d87c1dda87c387350e43486ad90 (diff)
downloadGradeBook-176c9f8057471749c4f3a0a7afc3e4f4bde110fc.tar.gz
GradeBook-176c9f8057471749c4f3a0a7afc3e4f4bde110fc.zip
small script to convert csv gradescope to sqlite DB
-rwxr-xr-xregenGradescopeDB.sh7
1 files changed, 7 insertions, 0 deletions
diff --git a/regenGradescopeDB.sh b/regenGradescopeDB.sh
new file mode 100755
index 0000000..774f624
--- /dev/null
+++ b/regenGradescopeDB.sh
@@ -0,0 +1,7 @@
+#!/bin/bash
+
+rm -f 2021_Gradescope.db
+printf '.mode csv\n.import 2021_Gradescope.csv export_table' | \
+ sqlite3 2021_Gradescope.db
+
+