def submission_record(memberIdIndex, sortCondition, pageNum):
# Not Accept URL Check
if sortCondition not in (LanguageResources().const.SubmissionDate[1],
LanguageResources().const.Memory[1],
LanguageResources().const.FileSize[1],
LanguageResources().const.Runtime[1]):
return page_not_found()
try:
# Get MemberId
try:
member = select_member(memberIdIndex).first()
except Exception:
member = []
# 모든 제출 정보
submissions = select_all_submissions(memberIdIndex).subquery()
try:
# 차트 정보
chartSubmissionRecords = select_member_chart_submissions(submissions).first()
except Exception:
#None Type Exception
chartSubmissionRecords = []
# Viiew Value Text
chartSubmissionDescriptions = [LanguageResources().const.SolvedProblems,
LanguageResources().const.Count,
LanguageResources().const.Solved,
LanguageResources().const.WrongAnswer,
LanguageResources().const.TimeOver,
LanguageResources().const.MemoryOverflow,
LanguageResources().const.CompileError,
LanguageResources().const.RuntimeError]
try:
# 모든 제출 정보
count = select_count(submissions.c.memberId).first().\
count
# Sorted
submissionRecords = get_page_record(submissions_sorted(submissions,
sortCondition = sortCondition,
DESC = True),
pageNum = pageNum).all()
except Exception:
count = 0
submissionRecords = []
return render_template(HTMLResources().const.SUBMISSION_RECORD_HTML,
memberIdIndex = memberIdIndex,
sortCondition = sortCondition,
member = member,
submissionRecords = submissionRecords,
chartSubmissionDescriptions = chartSubmissionDescriptions,
chartSubmissionRecords = chartSubmissionRecords,
pages = get_page_pointed(pageNum = pageNum,
count = count))
except Exception as e:
# Unknow Error
return unknown_error(e)
def submission_record(memberId, sortCondition, pageNum):
try:
# 모든 제출 정보
submissions = select_all_submissions(lastSubmission = None,
memberCourseProblemParameter = MemberCourseProblemParameter(memberId = memberId)).subquery()
# List Count
try:
count = select_count(submissions.c.memberId).first().\
count
except Exception:
count = 0
try:
# 차트 정보
chartSubmissionRecords = select_member_chart_submissions(submissions).first()
except Exception:
#None Type Exception
chartSubmissionRecords = []
# Viiew Value Text
chartSubmissionDescriptions = ['Solved Problems',
'Total Submissions',
'Solved',
'Wrong answer',
'Timeover',
'Compile error',
'Runtime error',
'Server error']
try:
# 모든 제출 정보
# Sorted
submissionRecords = get_page_record(submissions_sorted(submissions,
sortCondition = sortCondition),
pageNum = pageNum).all()
except Exception:
#None Type Exception
submissionRecords = []
return render_template(HTMLResources().const.SUBMISSION_RECORD_HTML,
memberId = memberId,
sortCondition = sortCondition,
submissionRecords = submissionRecords,
chartSubmissionDescriptions = chartSubmissionDescriptions,
chartSubmissionRecords = chartSubmissionRecords,
pages = get_page_pointed(pageNum = pageNum,
count = count))
except Exception:
# Unknow Error
return unknown_error()
def submission_code(memberIdIndex, status, problemIndex, error=None):
try:
# Get endDateOfSubmission of Problem
# are Not Access. conditions is an Administrator and endOfSubmission ago
if SETResources().const.ADMINISTRATOR in session[SessionResources().const.AUTHORITY]\
or memberIdIndex == session[SessionResources().const.MEMBER_ID_INDEX]:
# Get SubmissionIndex
dataOfSubmissionBoard = select_data_of_submission_board(
None, memberIdIndex, problemIndex)
if dataOfSubmissionBoard.first():
submissionIndex = dataOfSubmissionBoard.first().submissionIndex
# 내가 Code에 누른 좋아요 정보
try:
isLikeCancelled = select_code_is_like(submissionIndex,
memberIdIndex = session[SessionResources().const.MEMBER_ID_INDEX]).first().\
isLikeCancelled
except Exception:
# Non-Exist Case
isLikeCancelled = None
if request.method == 'POST':
authorityCheck = is_authority(
session[SessionResources().const.AUTHORITY])
for form in request.form:
# 댓글 달기
if form == 'writeCodeReply':
# 새로운 댓글 정보articleParameter
codeReplyContent = get_request_value(
form=request.form, name='writeCodeReply')
if codeReplyContent:
dao.add(
insert_replies_on_code(
submissionIndex,
memberIdIndex=session[SessionResources(
).const.MEMBER_ID_INDEX],
articleParameter=ArticleParameter(
title=None,
content=codeReplyContent,
updateIp=socket.gethostbyname(
socket.gethostname()),
updateDate=datetime.now())))
# remove duplicated read count
update_code_view_reply_counting(
submissionIndex,
VIEW_INCREASE=-1,
REPLY_INCREASE=1)
break
# 댓글 삭제
elif 'deleteCodeReply' in form:
# Get Reply Index
replyIndex = len('deleteCodeReply')
submissionReplyIndex = int(form[replyIndex:])
try:
writerIndex = select_replies_on_code(
submissionIndex=None,
submissionReplyIndex=submissionReplyIndex
).first()
except Exception:
writerIndex = None
if (authorityCheck[0] or authorityCheck[1])\
or writerIndex.codeReplierIdIndex == session['memberIdIndex']:
update_replies_on_code_delete(
submissionReplyIndex,
isDeleted=ENUMResources().const.TRUE)
# remove duplicated read count
update_code_view_reply_counting(
submissionIndex,
VIEW_INCREASE=-1,
REPLY_INCREASE=-1)
else:
error = LanguageResources().const.GetOutHere
break
# Commit Modify
elif 'modifyCodeReplyContent' in form:
replyIndex = len('modifyCodeReplyContent')
submissionReplyIndex = int(form[replyIndex:])
try:
writerIndex = select_replies_on_code(
submissionIndex=None,
submissionReplyIndex=submissionReplyIndex
).first()
except Exception:
writerIndex = None
if writerIndex.codeReplierIdIndex == session[
'memberIdIndex']:
submissionReplyContent = get_request_value(
form=request.form,
name='modifyCodeReplyContent{0}'.format(
form[replyIndex:]))
if submissionReplyContent:
#update comment
update_replies_on_code_modify(
submissionReplyIndex,
ArticleParameter(
title=None,
content=submissionReplyContent,
updateIp=socket.gethostbyname(
socket.gethostname()),
updateDate=datetime.now()))
# remove duplicated read count
update_code_view_reply_counting(
submissionIndex, VIEW_INCREASE=-1)
else:
error = LanguageResources().const.GetOutHere
break
# end Loop
# Commit Exception
try:
dao.commit()
except Exception:
dao.rollback()
error = LanguageResources().const.DBFailed
try:
# replies 정보
repliesOnSubmissionRecords = select_replies_on_code(
submissionIndex).subquery()
repliesOnSubmissionRecords = join_member_id(
repliesOnSubmissionRecords,
repliesOnSubmissionRecords.c.codeReplierIdIndex)
# 내가 게시글 리플에 누른 좋아요 정보
repliesOnSubmissionIsLikeRecords = select_replies_on_code_like(
repliesOnSubmissionRecords.subquery(), session[
SessionResources().const.MEMBER_ID_INDEX]).all()
repliesOnSubmissionRecords = repliesOnSubmissionRecords.all(
)
except Exception:
repliesOnSubmissionIsLikeRecords = []
repliesOnSubmissionRecords = []
# 읽은 횟수 카운팅
update_code_view_reply_counting(submissionIndex,
VIEW_INCREASE=1)
# Commit Exception
try:
dao.commit()
except Exception:
dao.rollback()
# Problem Information (LimitedTime, LimitedMemory
try:
problemName = select_problem(problemIndex = problemIndex).first().\
problemName
except Exception:
problemName = None
# Problem Solved Users
try:
# last Submissions Info
lastSubmission = select_last_submissions(
memberIdIndex=memberIdIndex,
problemIndex=problemIndex).subquery()
problemSolvedMemberRecords = select_all_submissions(
memberIdIndex=memberIdIndex,
problemIndex=problemIndex,
lastSubmission=lastSubmission).first()
except Exception:
problemSolvedMemberRecords = []
# Submitted Files Information
import codecs
try:
submittedFileRecords = select_submitted_files(
dataOfSubmissionBoard.subquery()).all()
fileData = []
for raw in submittedFileRecords:
# Open
filePath = '{0}/{1}'.format(raw.filePath, raw.fileName)
# EUC_KR type
try:
with codecs.open(filePath, 'r',
encoding='cp949') as f:
# Read
data = f.read()
fileData.append(data)
# UTF-8 Type
except Exception:
with codecs.open(filePath, 'r',
encoding='utf8') as f:
# Read
data = f.read()
fileData.append(data)
except Exception:
submittedFileRecords = []
fileData = []
return render_template(HTMLResources().const.SUBMISSION_CODE_HTML,
memberIdIndex = memberIdIndex,
submissionIndex = submissionIndex,
submittedFileRecords = submittedFileRecords,
fileData = fileData,
problemName = problemName,
problemSolvedMemberRecords = problemSolvedMemberRecords,
isLikeCancelled = isLikeCancelled,
sumOfLikeCount = dataOfSubmissionBoard.first().\
sumOfLikeCount,
repliesOnSubmissionIsLikeRecords = repliesOnSubmissionIsLikeRecords,
repliesOnSubmissionRecords = repliesOnSubmissionRecords,
browserName = request.user_agent.browser,
browserVersion = request.user_agent.version,
error = error)
#Access Rejection
else:
return redirect(
url_for(
RouteResources().const.PROBLEM_RECORD,
status=status,
problemIndex=problemIndex,
sortCondition=LanguageResources().const.SubmissionDate[1]))
except Exception as e:
return unknown_error(e)
def problem_record(status, problemIndex, sortCondition, error=None):
# Not Accept URL Check
if sortCondition not in (LanguageResources().const.SubmissionDate[1],
LanguageResources().const.Memory[1],
LanguageResources().const.FileSize[1],
LanguageResources().const.Runtime[1]):
return page_not_found()
try:
memberId = None
# Request Post
if request.method == 'POST':
# Search Event
if 'memberId' in request.form:
memberId = get_request_value(form=request.form,
name='memberId')
# Chart View Value Text
chartSubmissionDescriptions = [
LanguageResources().const.TriedPeople,
LanguageResources().const.SolvedPeople,
LanguageResources().const.Count,
LanguageResources().const.Solved,
LanguageResources().const.WrongAnswer,
LanguageResources().const.TimeOver,
LanguageResources().const.MemoryOverflow,
LanguageResources().const.CompileError,
LanguageResources().const.RuntimeError
]
# last Submissions of Problem Info
lastSubmission = select_last_submissions(
problemIndex=problemIndex).subquery()
submissions = select_all_submissions(
problemIndex=problemIndex,
lastSubmission=lastSubmission).subquery()
try:
# Submitted Members Count
sumOfSubmissionPeopleCount = select_submissions_peoples_counts(
submissions).subquery()
# Solved Members Count
sumOfSolvedPeopleCount = select_solved_peoples_counts(
submissions).subquery()
# Problem Record
problemSubmittedRecords = select_submitted_records_of_problem(
problemIndex=problemIndex).subquery()
# Chart SubmissionRecords
chartSubmissionRecords = select_problem_chart_submissions(
sumOfSubmissionPeopleCount, sumOfSolvedPeopleCount,
problemSubmittedRecords).first()
except Exception:
chartSubmissionRecords = []
# Problem Information (LimitedTime, LimitedMemory
try:
problemInformation = select_problem(
problemIndex=problemIndex).first()
except Exception:
problemInformation = []
# Problem Solved Users
try:
# Problem Solved Member
problemSolvedMemberRecords = submissions_sorted(
select_solved_submissions(submissions).subquery(),
sortCondition=sortCondition).all()
except Exception:
problemSolvedMemberRecords = []
# Search Failed Problem
if status != ENUMResources().const.SOLVED\
and status != ENUMResources().const.JUDGING\
and status != ENUMResources().const.SERVER_ERROR:
try:
# last Submissions of Problem Info
lastSubmission = select_last_submissions(
memberIdIndex=session[
SessionResources().const.MEMBER_ID_INDEX],
problemIndex=problemIndex).subquery()
submissions = select_all_submissions(
memberIdIndex=session[
SessionResources().const.MEMBER_ID_INDEX],
problemIndex=problemIndex,
lastSubmission=lastSubmission).subquery()
# Current Failed Problem
failedProblem = select_failed_problems(submissions).first()
except Exception:
failedProblem = []
else:
failedProblem = []
return render_template(
HTMLResources().const.PROBLEM_RECORD_HTML,
memberId=memberId,
status=status,
problemSolvedMemberRecords=problemSolvedMemberRecords,
problemInformation=problemInformation,
chartSubmissionDescriptions=chartSubmissionDescriptions,
chartSubmissionRecords=chartSubmissionRecords,
failedProblem=failedProblem,
error=error)
except Exception as e:
return unknown_error(e)
def submission_code(memberId, courseId, problemId, error = None):
try:
# Get endDateOfSubmission of Problem
try:
endDateOfSubmission = select_problems_of_course(memberCourseProblemParameter = MemberCourseProblemParameter(memberId = None,
courseId = courseId,
problemId = problemId)).first().\
endDateOfSubmission
except Exception:
endDateOfSubmission = None
# are Not Access. conditions is an Administrator and endOfSubmission ago
if SETResources().const.SERVER_ADMINISTRATOR in session[SessionResources().const.AUTHORITY]\
or SETResources().const.COURSE_ADMINISTRATOR in session[SessionResources().const.AUTHORITY]\
or endDateOfSubmission <= datetime.now():
# last Submissions Info
lastSubmission = select_last_submissions(memberCourseProblemParameter = MemberCourseProblemParameter(memberId = memberId,
courseId = courseId,
problemId = problemId)).subquery()
# Code View Count Up
update_submission_code_view_count(lastSubmission,
memberCourseProblemParameter = MemberCourseProblemParameter(memberId = memberId,
courseId = courseId,
problemId = problemId))
# Commit Exception
try:
dao.commit()
except Exception:
dao.rollback()
error = get_message('updateFailed')
# Problem Information (LimitedTime, LimitedMemory
try:
problemName = select_problem_informations(memberCourseProblemParameter = MemberCourseProblemParameter(memberId = None,
courseId = None,
problemId = problemId)).first().\
problemName
except Exception:
problemName = None
# Problem Solved Users
try:
# last Submissions Info
submissions = select_all_submissions(lastSubmission,
memberCourseProblemParameter = MemberCourseProblemParameter(memberId = memberId,
courseId = courseId,
problemId = problemId)).subquery()
problemSolvedMemberRecords = select_solved_submissions(submissions).first()
except Exception:
problemSolvedMemberRecords = []
# Submitted Files Information
try:
submittedFileRecords = select_submitted_files(memberCourseProblemParameter = MemberCourseProblemParameter(memberId = memberId,
courseId = courseId,
problemId = problemId)).all()
fileData = []
for raw in submittedFileRecords:
# Open
filePath = raw.filePath + '/' +raw.fileName
file = open(filePath)
# Read
data = file.read()
# Close
file.close()
fileData.append(data)
except Exception:
submittedFileRecords = []
fileData = []
return render_template(HTMLResources().const.SUBMISSION_CODE_HTML,
SETResources = SETResources,
SessionResources = SessionResources,
LanguageResources = LanguageResources,
submittedFileRecords = submittedFileRecords,
fileData = fileData,
problemName = problemName,
problemSolvedMemberRecords = problemSolvedMemberRecords,
error = error)
#Access Rejection
else:
flash('코드를 볼 권한이 없습니다!!!')
return redirect(url_for(RouteResources().const.PROBLEM_RECORD,
courseId = courseId,
problemId = problemId,
sortCondition = OtherResources().const.RUN_TIME))
except Exception:
return unknown_error()
def problem_record(courseId, problemId, sortCondition = OtherResources().const.RUN_TIME):
"""
navbar - class - Record of problem
"""
try:
# Chart View Value Text
chartSubmissionDescriptions = ['Tried People',
'Solved People',
'Submission Count',
'Solved',
'Wrong Answer',
'Time Over',
'Compile Error',
'Runtime Error']
# last Submissions Info
submissions = select_all_submissions(lastSubmission = select_last_submissions(memberCourseProblemParameter = MemberCourseProblemParameter(memberId = None,
courseId = courseId,
problemId = problemId)).subquery(),
memberCourseProblemParameter = MemberCourseProblemParameter(memberId = None,
courseId = courseId,
problemId = problemId)).subquery()
try:
# Submitted Members Count
sumOfSubmissionPeopleCount = select_submissions_peoples_counts(submissions).subquery()
# Solved Members Count
sumOfSolvedPeopleCount = select_solved_peoples_counts(submissions).subquery()
# Problem Rrecord
problemSubmittedRecords = select_submitted_records_of_problem(memberCourseProblemParameter = MemberCourseProblemParameter(memberId = None,
courseId = courseId,
problemId = problemId)).subquery()
# Chart SubmissionRecords
chartSubmissionRecords = select_problem_chart_submissions(sumOfSubmissionPeopleCount,
sumOfSolvedPeopleCount,
problemSubmittedRecords).first()
except:
print 'SubmittedRecordsOfProblems table is empty'
chartSubmissionRecords = []
# Problem Information (LimitedTime, LimitedMemory
try:
problemInformationRecords = select_problem_informations(memberCourseProblemParameter = MemberCourseProblemParameter(memberId = None,
courseId = None,
problemId = problemId)).first()
except Exception:
problemInformationRecords = []
# Problem Solved Users
try:
# Problem Solved Member
problemSolvedMemberRecords = submissions_sorted(select_solved_submissions(submissions).subquery(),
sortCondition = sortCondition).all()
except Exception:
problemSolvedMemberRecords = []
return render_template(HTMLResources().const.PROBLEM_RECORD_HTML,
SETResources = SETResources,
SessionResources = SessionResources,
LanguageResources = LanguageResources,
courseId = courseId,
problemSolvedMemberRecords = problemSolvedMemberRecords,
problemInformationRecords = problemInformationRecords,
chartSubmissionDescriptions = chartSubmissionDescriptions,
chartSubmissionRecords = chartSubmissionRecords)
except Exception:
return unknown_error()
def submission_record(memberIdIndex, sortCondition, pageNum):
# Not Accept URL Check
if sortCondition not in (LanguageResources().const.SubmissionDate[1],
LanguageResources().const.Memory[1],
LanguageResources().const.FileSize[1],
LanguageResources().const.Runtime[1]):
return page_not_found()
try:
# Get MemberId
try:
member = select_member(memberIdIndex).first()
except Exception:
member = []
# 모든 제출 정보
submissions = select_all_submissions(memberIdIndex).subquery()
try:
# 차트 정보
chartSubmissionRecords = select_member_chart_submissions(
submissions).first()
except Exception:
#None Type Exception
chartSubmissionRecords = []
# Viiew Value Text
chartSubmissionDescriptions = [
LanguageResources().const.SolvedProblems,
LanguageResources().const.Count,
LanguageResources().const.Solved,
LanguageResources().const.WrongAnswer,
LanguageResources().const.TimeOver,
LanguageResources().const.MemoryOverflow,
LanguageResources().const.CompileError,
LanguageResources().const.RuntimeError
]
try:
# 모든 제출 정보
count = select_count(submissions.c.memberId).first().\
count
# Sorted
submissionRecords = get_page_record(submissions_sorted(
submissions, sortCondition=sortCondition, DESC=True),
pageNum=pageNum).all()
except Exception:
count = 0
submissionRecords = []
return render_template(
HTMLResources().const.SUBMISSION_RECORD_HTML,
memberIdIndex=memberIdIndex,
sortCondition=sortCondition,
member=member,
submissionRecords=submissionRecords,
chartSubmissionDescriptions=chartSubmissionDescriptions,
chartSubmissionRecords=chartSubmissionRecords,
pages=get_page_pointed(pageNum=pageNum, count=count))
except Exception as e:
# Unknow Error
return unknown_error(e)
def submission_code(memberIdIndex, status, problemIndex, error = None):
try:
# Get endDateOfSubmission of Problem
# are Not Access. conditions is an Administrator and endOfSubmission ago
if SETResources().const.ADMINISTRATOR in session[SessionResources().const.AUTHORITY]\
or memberIdIndex == session[SessionResources().const.MEMBER_ID_INDEX]:
# Get SubmissionIndex
dataOfSubmissionBoard = select_data_of_submission_board(None,
memberIdIndex,
problemIndex)
if dataOfSubmissionBoard.first():
submissionIndex = dataOfSubmissionBoard.first().submissionIndex
# 내가 Code에 누른 좋아요 정보
try:
isLikeCancelled = select_code_is_like(submissionIndex,
memberIdIndex = session[SessionResources().const.MEMBER_ID_INDEX]).first().\
isLikeCancelled
except Exception:
# Non-Exist Case
isLikeCancelled = None
if request.method == 'POST':
authorityCheck = is_authority(session[SessionResources().const.AUTHORITY])
for form in request.form:
# 댓글 달기
if form == 'writeCodeReply':
# 새로운 댓글 정보articleParameter
codeReplyContent = get_request_value(form = request.form,
name = 'writeCodeReply')
if codeReplyContent:
dao.add(insert_replies_on_code(submissionIndex,
memberIdIndex = session[SessionResources().const.MEMBER_ID_INDEX],
articleParameter = ArticleParameter(title = None,
content = codeReplyContent,
updateIp = socket.gethostbyname(socket.gethostname()),
updateDate = datetime.now())))
# remove duplicated read count
update_code_view_reply_counting(submissionIndex,
VIEW_INCREASE = -1,
REPLY_INCREASE = 1)
break
# 댓글 삭제
elif 'deleteCodeReply' in form:
# Get Reply Index
replyIndex = len('deleteCodeReply')
submissionReplyIndex = int(form[replyIndex:])
try:
writerIndex = select_replies_on_code(submissionIndex = None,
submissionReplyIndex = submissionReplyIndex).first()
except Exception:
writerIndex = None
if (authorityCheck[0] or authorityCheck[1])\
or writerIndex.codeReplierIdIndex == session['memberIdIndex']:
update_replies_on_code_delete(submissionReplyIndex,
isDeleted = ENUMResources().const.TRUE)
# remove duplicated read count
update_code_view_reply_counting(submissionIndex,
VIEW_INCREASE = -1,
REPLY_INCREASE = -1)
else:
error = LanguageResources().const.GetOutHere
break
# Commit Modify
elif 'modifyCodeReplyContent' in form:
replyIndex = len('modifyCodeReplyContent')
submissionReplyIndex = int(form[replyIndex:])
try:
writerIndex = select_replies_on_code(submissionIndex = None,
submissionReplyIndex = submissionReplyIndex).first()
except Exception:
writerIndex = None
if writerIndex.codeReplierIdIndex == session['memberIdIndex']:
submissionReplyContent = get_request_value(form = request.form,
name = 'modifyCodeReplyContent{0}'.format(form[replyIndex:]))
if submissionReplyContent:
#update comment
update_replies_on_code_modify(submissionReplyIndex,
ArticleParameter(title = None,
content = submissionReplyContent,
updateIp = socket.gethostbyname(socket.gethostname()),
updateDate = datetime.now()))
# remove duplicated read count
update_code_view_reply_counting(submissionIndex,
VIEW_INCREASE = -1)
else:
error = LanguageResources().const.GetOutHere
break
# end Loop
# Commit Exception
try:
dao.commit()
except Exception:
dao.rollback()
error = LanguageResources().const.DBFailed
try:
# replies 정보
repliesOnSubmissionRecords = select_replies_on_code(submissionIndex).subquery()
repliesOnSubmissionRecords = join_member_id(repliesOnSubmissionRecords,
repliesOnSubmissionRecords.c.codeReplierIdIndex)
# 내가 게시글 리플에 누른 좋아요 정보
repliesOnSubmissionIsLikeRecords = select_replies_on_code_like(repliesOnSubmissionRecords.subquery(),
session[SessionResources().const.MEMBER_ID_INDEX]).all()
repliesOnSubmissionRecords = repliesOnSubmissionRecords.all()
except Exception:
repliesOnSubmissionIsLikeRecords = []
repliesOnSubmissionRecords = []
# 읽은 횟수 카운팅
update_code_view_reply_counting(submissionIndex,
VIEW_INCREASE = 1)
# Commit Exception
try:
dao.commit()
except Exception:
dao.rollback()
# Problem Information (LimitedTime, LimitedMemory
try:
problemName = select_problem(problemIndex = problemIndex).first().\
problemName
except Exception:
problemName = None
# Problem Solved Users
try:
# last Submissions Info
lastSubmission = select_last_submissions(memberIdIndex = memberIdIndex,
problemIndex = problemIndex).subquery()
problemSolvedMemberRecords = select_all_submissions(memberIdIndex = memberIdIndex,
problemIndex = problemIndex,
lastSubmission = lastSubmission).first()
except Exception:
problemSolvedMemberRecords = []
# Submitted Files Information
import codecs
try:
submittedFileRecords = select_submitted_files(dataOfSubmissionBoard.subquery()).all()
fileData = []
for raw in submittedFileRecords:
# Open
filePath = '{0}/{1}'.format(raw.filePath,
raw.fileName)
# EUC_KR type
try:
with codecs.open(filePath,
'r',
encoding = 'cp949') as f:
# Read
data = f.read()
fileData.append(data)
# UTF-8 Type
except Exception:
with codecs.open(filePath,
'r',
encoding = 'utf8') as f:
# Read
data = f.read()
fileData.append(data)
except Exception:
submittedFileRecords = []
fileData = []
return render_template(HTMLResources().const.SUBMISSION_CODE_HTML,
memberIdIndex = memberIdIndex,
submissionIndex = submissionIndex,
submittedFileRecords = submittedFileRecords,
fileData = fileData,
problemName = problemName,
problemSolvedMemberRecords = problemSolvedMemberRecords,
isLikeCancelled = isLikeCancelled,
sumOfLikeCount = dataOfSubmissionBoard.first().\
sumOfLikeCount,
repliesOnSubmissionIsLikeRecords = repliesOnSubmissionIsLikeRecords,
repliesOnSubmissionRecords = repliesOnSubmissionRecords,
browserName = request.user_agent.browser,
browserVersion = request.user_agent.version,
error = error)
#Access Rejection
else:
return redirect(url_for(RouteResources().const.PROBLEM_RECORD,
status = status,
problemIndex = problemIndex,
sortCondition = LanguageResources().const.SubmissionDate[1]))
except Exception as e:
return unknown_error(e)
def problem_record(status, problemIndex, sortCondition, error = None):
# Not Accept URL Check
if sortCondition not in (LanguageResources().const.SubmissionDate[1],
LanguageResources().const.Memory[1],
LanguageResources().const.FileSize[1],
LanguageResources().const.Runtime[1]):
return page_not_found()
try:
memberId = None
# Request Post
if request.method == 'POST':
# Search Event
if 'memberId' in request.form:
memberId = get_request_value(form = request.form,
name = 'memberId')
# Chart View Value Text
chartSubmissionDescriptions = [LanguageResources().const.TriedPeople,
LanguageResources().const.SolvedPeople,
LanguageResources().const.Count,
LanguageResources().const.Solved,
LanguageResources().const.WrongAnswer,
LanguageResources().const.TimeOver,
LanguageResources().const.MemoryOverflow,
LanguageResources().const.CompileError,
LanguageResources().const.RuntimeError]
# last Submissions of Problem Info
lastSubmission = select_last_submissions(problemIndex = problemIndex).subquery()
submissions = select_all_submissions(problemIndex = problemIndex,
lastSubmission = lastSubmission).subquery()
try:
# Submitted Members Count
sumOfSubmissionPeopleCount = select_submissions_peoples_counts(submissions).subquery()
# Solved Members Count
sumOfSolvedPeopleCount = select_solved_peoples_counts(submissions).subquery()
# Problem Record
problemSubmittedRecords = select_submitted_records_of_problem(problemIndex = problemIndex).subquery()
# Chart SubmissionRecords
chartSubmissionRecords = select_problem_chart_submissions(sumOfSubmissionPeopleCount,
sumOfSolvedPeopleCount,
problemSubmittedRecords).first()
except Exception:
chartSubmissionRecords = []
# Problem Information (LimitedTime, LimitedMemory
try:
problemInformation = select_problem(problemIndex = problemIndex).first()
except Exception:
problemInformation = []
# Problem Solved Users
try:
# Problem Solved Member
problemSolvedMemberRecords = submissions_sorted(select_solved_submissions(submissions).subquery(),
sortCondition = sortCondition).all()
except Exception:
problemSolvedMemberRecords = []
# Search Failed Problem
if status != ENUMResources().const.SOLVED\
and status != ENUMResources().const.JUDGING\
and status != ENUMResources().const.SERVER_ERROR:
try:
# last Submissions of Problem Info
lastSubmission = select_last_submissions(memberIdIndex = session[SessionResources().const.MEMBER_ID_INDEX],
problemIndex = problemIndex).subquery()
submissions = select_all_submissions(memberIdIndex = session[SessionResources().const.MEMBER_ID_INDEX],
problemIndex = problemIndex,
lastSubmission = lastSubmission).subquery()
# Current Failed Problem
failedProblem = select_failed_problems(submissions).first()
except Exception:
failedProblem = []
else:
failedProblem = []
return render_template(HTMLResources().const.PROBLEM_RECORD_HTML,
memberId = memberId,
status = status,
problemSolvedMemberRecords = problemSolvedMemberRecords,
problemInformation = problemInformation,
chartSubmissionDescriptions = chartSubmissionDescriptions,
chartSubmissionRecords = chartSubmissionRecords,
failedProblem = failedProblem,
error = error)
except Exception as e:
return unknown_error(e)
