def get_course_name(courseId): try: courseName = select_course_information(courseId).first().\ courseName return courseName except Exception as e: return unknown_error(get_message('dbError'))
def problem_list(courseId, pageNum): """ problem submitting page """ try: ''' too long ''' # Get Last Submitted History lastSubmission = select_last_submissions(memberCourseProblemParameter = MemberCourseProblemParameter(memberId = session[SessionResources().const.MEMBER_ID], courseId = courseId)).subquery() # Current Submission submissions = select_current_submissions(lastSubmission).subquery() # Get Problem Informations problems = join_problems_names(select_problems_of_course(memberCourseProblemParameter = MemberCourseProblemParameter(memberId = None, courseId = courseId)).subquery()).subquery() # Get ProblemList Count try: count = select_count(problems.c.problemId).first().\ count except Exception: count = 0 # Get ProblemListRecords OuterJoin try: problemListRecords = get_page_record(join_problem_lists_submissions(problems, submissions), pageNum = pageNum).all() except Exception: problemListRecords = [] # Get Course Information try: courseRecords = select_course_information(courseId).first() except: courseRecords = [] return render_template(HTMLResources().const.PROBLEM_LIST_HTML, courseRecords = courseRecords, problemListRecords = problemListRecords, pages = get_page_pointed(pageNum = pageNum, count = count)) except Exception: return unknown_error()