From 3c9c64edc856e6c8656614b5106b1f3f67704621 Mon Sep 17 00:00:00 2001 From: Benjamin Mako Hill Date: Sat, 28 Sep 2024 16:01:05 -0700 Subject: [PATCH] initial version of commit updating coldcall.py --- coldcall.py | 35 +++++++++++++++++------------------ data/download_data.sh | 4 ---- download_student_info.py | 15 +++++++++++++++ 3 files changed, 32 insertions(+), 22 deletions(-) delete mode 100755 data/download_data.sh create mode 100755 download_student_info.py diff --git a/coldcall.py b/coldcall.py index 1ba96a5..2250fac 100644 --- a/coldcall.py +++ b/coldcall.py @@ -8,18 +8,25 @@ from csv import DictReader import os.path import re +import json class ColdCall(): def __init__ (self, record_attendance=True): + with open("configuration.json") as config_file: + config = json.loads(config_file.read()) + self.today = str(datetime.date(datetime.now())) # how much less likely should it be that a student is called upon? self.weight = 2 self.record_attendance = record_attendance # filenames - self.__fn_studentinfo = "data/student_information.tsv" - self.__fn_daily_calllist = f"data/call_list-{self.today}.tsv" - self.__fn_daily_attendance = f"data/attendance-{self.today}.tsv" + self.__fn_studentinfo = config["student_info_file"] + self.__fn_daily_calllist = config["daily_calllist_file"].format(date=self.today) + self.__fn_daily_attendance = config["daily_attendance"].format(date=self.today) + + self.unique_row = config["unique_name_rowname"] + self.preferred_row = config["preferred_name_rowname"] self.preferred_names = self.__get_preferred_names() @@ -31,7 +38,7 @@ class ColdCall(): with open(f"./data/{fn}", 'r') as f: for row in DictReader(f, delimiter="\t"): if not row["answered"] == "FALSE": - previous_questions[row["unique_name"]] += 1 + previous_questions[row[self.unique_row]] += 1 return previous_questions @@ -42,7 +49,7 @@ class ColdCall(): preferred_names = {} with open(self.__fn_studentinfo, 'r') as f: for row in DictReader(f, delimiter="\t"): - preferred_names[row["Your username on the class Teams server"]] = row["Name you'd like to go by in class"] + preferred_names[row[self.unique_row]] = row[self.preferred_row] return(preferred_names) @@ -83,12 +90,14 @@ class ColdCall(): # if it's the first one of the day, write it out if not os.path.exists(self.__fn_daily_calllist): with open(self.__fn_daily_calllist, "w") as f: - print("\t".join(["unique_name", "timestamp", "answered", "assessment"]), file=f) + print("\t".join([self.unique_row, self.preferred_row, "answered", "assessment", "timestamp"]), file=f) + + preferred_name = self.__get_preferred_name(selected_student) # open for appending the student with open(self.__fn_daily_calllist, "a") as f: - print("\t".join([selected_student, str(datetime.now()), - "MISSING", "MISSING"]), file=f) + print("\t".join([selected_student, preferred_name, + "MISSING", "MISSING", str(datetime.now())]), file=f) def coldcall(self, students_present): selected_student = self.__select_student_from_list(students_present) @@ -105,13 +114,3 @@ class ColdCall(): coldcall_message = f"@{selected_student}, you're up!" return coldcall_message -# cc = ColdCall() - -# test_student_list = ["jordan", "Kristen Larrick", "Madison Heisterman", "Maria.Au20", "Laura (Alia) Levi", "Leona Aklipi", "anne", "emmaaitelli", "ashleylee", "allie_partridge", "Tiana_Cole", "Hamin", "Ella Qu", "Shizuka", "Ben Baird", "Kim Do", "Isaacm24", "Sam Bell", "Courtneylg"] -# print(cc.coldcall(test_student_list)) - -# test_student_list = ["jordan", "Kristen Larrick", "Mako"] -# print(cc.coldcall(test_student_list)) - -# test_student_list = ["jordan", "Kristen Larrick"] -# print(cc.coldcall(test_student_list)) diff --git a/data/download_data.sh b/data/download_data.sh deleted file mode 100755 index 8687509..0000000 --- a/data/download_data.sh +++ /dev/null @@ -1,4 +0,0 @@ -#!/bin/bash - -wget 'https://docs.google.com/spreadsheets/d/FIXME/export?gid=FIXME&format=tsv' -O 'student_information.tsv' - diff --git a/download_student_info.py b/download_student_info.py new file mode 100755 index 0000000..0b6a98f --- /dev/null +++ b/download_student_info.py @@ -0,0 +1,15 @@ +#!/usr/bin/env python3 + +import json +import subprocess + +with open("configuration.json", 'r') as config_file: + config = json.loads(config_file.read()) + +base_url = 'https://docs.google.com/spreadsheets/d/{id}/export?gid={gid}&format=tsv' + +student_info_url = base_url.format(id=config["student_info_gsheet_id"], gid=config["student_info_gsheet_gid"]) +subprocess.run(["wget", url, "-O", config["student_info_file"]], check=True) + +optout_url = base_url.format(id=config["optout_info_gsheet_id"], gid=config["output_info_gsheet_gid"]) +subprocess.run(["wget", optout_url, "-O", config["optout_file"]], check=True) -- 2.39.5