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