import pandas as pd import os import time from pandas.compat import StringIO import numpy as np from datetime import datetime import dateutil from dateutil.tz import tzutc from apscheduler.schedulers.blocking import BlockingScheduler from apscheduler.executors.pool import ThreadPoolExecutor import sys import canvasModels from canvasModels import * db = canvasModels.init_db(sqlCredentials) canvas = Canvas(canvasCredentials.API_URL, canvasCredentials.API_KEY) sys.stdout = open("logs.txt", "w") last_update = None def populateSectionsAndStudents(course_num): course = canvas.get_course(course_num) groups = list(course.get_sections()) for group in groups: try: section_number = int(group.name[-2] + group.name[-1]) except ValueError:
def refresh_connection(): global db db.close() db = canvasModels.init_db(sqlCredentials) db.connect()