def get_rooms(sql: str, params: tuple) -> tuple:
cursor = get_cursor()
cursor.execute(sql, params)
rooms = []
for r in cursor:
rooms.append(r)
return tuple(rooms)
def get_room_availability(sql: str, params: tuple) -> dict:
cursor = get_cursor()
cursor.execute(sql, params)
avail_rooms_dict = {"rooms": []}
for r in cursor:
avail_rooms_dict["rooms"].append(r)
return avail_rooms_dict
def get_is_prereq_for(sql: str, params: tuple) -> list:
prereq_for: list = None
cursor = get_cursor()
cursor.execute(sql, params)
try:
prereq_for = [p for p in cursor]
return prereq_for
except IndexError:
return []
def get_single_course_joins(sql: str, params: tuple) -> list:
cursor = get_cursor()
cursor.execute(sql, params)
joined_courses = [c[0] for c in cursor]
if joined_courses:
return joined_courses
else:
return ["None"]
def get_course_prereqs(sql: str, params: tuple) -> list:
prereqs = None
cursor = get_cursor()
cursor.execute(sql, params)
try:
prereqs = [p for p in cursor]
return prereqs
except IndexError:
return []
def get_faculty_code(sql: str, search_parameters: tuple) -> dict:
cursor = get_cursor()
cursor.execute(sql, search_parameters)
data = [s for s in cursor][0]
fac_code_data = {
"fac_eid": data[0],
"fac_name": data[1],
"code_yr": data[2],
"code_qtr": data[3],
"fac_code": data[4],
}
return fac_code_data
def get_room_attrs(sql: str, params: tuple) -> dict:
cursor = get_cursor()
cursor.execute(sql, params)
room_dict = {
"bldg": params[0],
"room_no": params[1],
"capacity": 0,
"attributes": []
}
for r in cursor:
room_dict["capacity"] = r[2]
room_dict["attributes"].append((r[3].strip(), r[4]))
print(room_dict)
return (room_dict)
def get_joint_course_data(sql: str) -> dict:
course_joins_info = {}
cursor = get_cursor()
cursor.execute(sql)
joint_course_data = [c for c in cursor]
for row in joint_course_data:
course_no = row[1]
if course_no not in course_joins_info.keys():
course_joins_info[course_no] = {
"dept": row[0].strip(),
"joint_courses": [],
"resp_dept": row[4],
}
for row in joint_course_data:
course_no = row[1]
course_joins_info[course_no]["joint_courses"].append(
f"{row[2]} {row[3]}")
return course_joins_info
def get_student_data(sql: str, sid: str) -> dict:
cursor = get_cursor()
cursor.execute(sql, sid)
data = [s for s in cursor][0]
# parse data into student attributes
student_no = data[0]
split_name = data[1].split(sep=",")
last_name, first_name = split_name[0], split_name[1]
pref_first_name = data[2].strip()
qtrs_used = data[3]
uw_email = data[4]
alt_email = data[5]
campus = data[6]
major_abbr = data[7]
deg_pathway = data[8]
deg_level = data[9]
deg_type = data[10]
deg_status = data[11]
deg_earned_yr = data[12]
deg_earned_qtr = data[13]
if pref_first_name:
first_name = pref_first_name
# package data for injection into template
student_info = {
"sid": student_no,
"name": f"{first_name} {last_name}",
"qtrs_used": qtrs_used,
"uw_email": uw_email,
"other_email": alt_email,
"campus": campus,
"major": major_abbr,
"degree": f"{deg_pathway}-{deg_level}{deg_type}",
"degree_status": deg_status,
"degree_earned": f"{deg_earned_qtr}-{deg_earned_yr}",
}
return student_info
def get_single_course_info(sql: str, params: tuple) -> dict:
cursor = get_cursor()
cursor.execute(sql, params)
try:
data = [info for info in cursor][0]
base_info = {
"dept": data[0],
"crs_number": data[1],
"min_credits": data[2],
"max_credits": data[3],
"credit_ctrl": data[4],
"grade_sys": data[5],
"short_title": data[6],
"long_title": data[7],
"resp_crs": data[8],
"diversity": data[9],
"i_and_s": data[10],
"vis_lit_perf_arts": data[11],
"eng_comp": data[12],
"writing": data[13],
}
except IndexError:
return {}
return base_info
def get_rooms_by_capacity(sql: str, params: tuple) -> dict:
cursor = get_cursor()
cursor.execute(sql, params)
found_rooms = {'rooms': [r for r in cursor]}
return found_rooms
def get_student_transcript(sid: int) -> list:
sql = sql_scripts.student_transcript_query
cursor = get_cursor()
cursor.execute(sql, sid)
data = [course for course in cursor]
return data
def get_course_history(sql: str, search_parameters: tuple) -> dict:
cursor = get_cursor()
cursor.execute(sql, search_parameters)
data = [s for s in cursor]
return {"course_data": data}
def get_fac_crs_info(sql: str, search_parameters: tuple) -> dict:
cursor = get_cursor()
cursor.execute(sql, search_parameters)
data = [s for s in cursor]
return {"fac_crs_history_data": data}
def get_faculty_list(sql: str, year: int) -> List[tuple]:
cursor = get_cursor()
cursor.execute(sql, year)
instructor_list_info = [i for i in cursor]
return instructor_list_info
def get_current_ee_undergrads_data(sql: str) -> List[tuple]:
cursor = get_cursor()
cursor.execute(sql)
student_data = [s for s in cursor]
return student_data
def find_new_room_for_sln(sql: str, params: tuple) -> dict:
cursor = get_cursor()
cursor.execute(sql, params)
found_rooms = {"rooms": [r for r in cursor]}
return found_rooms
def get_student_current_schedule(sid: int) -> list:
sql = sql_scripts.student_current_schedule_query
cursor = get_cursor()
cursor.execute(sql, sid)
data = [c for c in cursor]
return data
