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