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()