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 decorated_function(*args, **kwargs):
try:
from GradeServer.utils.utils import access_authority_check,\
get_request_value
from GradeServer import page_not_found
# Get URL Parameters
problemLevel = get_request_value(kwargs,
'problemLevel')
memberIdIndex = get_request_value(kwargs,
'memberIdIndex')
submissionIndex = get_request_value(kwargs,
'submissionIndex')
problemIndex = get_request_value(kwargs,
'problemIndex')
submissionReplyIndex = get_request_value(kwargs,
'submissionReplyIndex')
articleIndex = get_request_value(kwargs,
'articleIndex')
boardReplyIndex = get_request_value(kwargs,
'boardReplyIndex')
# unusual URL Access Check
if not access_authority_check(problemLevel = (None if problemLevel == LanguageResources().const.All[1]
else problemLevel),
memberIdIndex = (None if memberIdIndex == None
else int(memberIdIndex)),
submissionIndex = (None if submissionIndex == None
else int(submissionIndex)),
problemIndex = (None if problemIndex == None
else int(problemIndex)),
submissionReplyIndex = (None if submissionReplyIndex == None
else int(submissionReplyIndex)),
articleIndex = (None if articleIndex == None
else int(articleIndex)),
boardReplyIndex = (None if boardReplyIndex == None
else int(boardReplyIndex)),
isAdministrator = 'manage' in request.endpoint,
isWrite = (True if 'write' in request.endpoint
else None),
isCode = (True if 'submission_code' in request.endpoint
else None)):
return page_not_found()
# URL direct access and manager case
if not request.referrer and 'manage' in request.endpoint:
return redirect(url_for(RouteResources().const.ID_CHECK,
select = request.endpoint.split('.')[-1]))
return f(*args, **kwargs)
except Exception as e:
return unknown_error (e)
def rank(sortCondition, pageNum, error =None):
# Not Accept URL Check
if sortCondition not in (LanguageResources().const.Rate[1],
LanguageResources().const.SolvedProblems[1]):
return page_not_found()
try:
#Searched MemberId
memberId = None
try:
# Auto Complete MemberIds
memberRecords = select_members().all()
except Exception:
memberRecords = []
# Last Submission Max Count
submissions = select_ranks(select_last_submissions().subquery()).subquery()
submissions = join_member_id(submissions,
subMemberIdIndex = submissions.c.memberIdIndex).subquery()
# records count
try:
count = select_count(submissions.c.memberIdIndex).first().\
count
except Exception:
count = 0
# Paging Pointed
pages = get_page_pointed(pageNum = pageNum,
count = count)
submissions = ranks_sorted(submissions,
sortCondition = sortCondition)
# Find MemberId 뷰 호출
if request.method == 'POST':
# Finding MemberId
memberId = get_request_value(form = request.form,
name = 'memberId')
try:
memberIdIndex = select_match_member_id(memberId).first().memberIdIndex
# 순차 탐색으로 찾아야 함
for i in range(1, pages['allPage'] + 1):
# memberId in Pages
ranks = get_page_record(submissions,
pageNum = i).subquery()
# finding MemberId in Pages
if select_match_member_sub(ranks,
memberIdIndex = memberIdIndex).first() != None:
# Finding move to page
pageNum = i
# searchLine Check
# RePaging Pointed
pages = get_page_pointed(pageNum = pageNum,
count = count)
break
except Exception:
error = LanguageResources().const.NotExist
# 랭크 정보
try:
rankMemberRecords = get_page_record(submissions,
pageNum = pageNum).all()
except Exception:
rankMemberRecords = []
return render_template(HTMLResources().const.RANK_HTML,
sortCondition = sortCondition,
memberRecords = memberRecords,
rankMemberRecords = rankMemberRecords,
pages = pages,
memberId = memberId,
error = error) # 페이지 정보
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 manage_user(filterCondition, keyWord, sortCondition, pageNum, error=None):
# Not Accept URL Check
if sortCondition not in (LanguageResources().const.ID[1],
LanguageResources().const.Name[1]):
return page_not_found()
try:
# Request Post
if request.method == 'POST':
# Search Event
# FilterCondition
if len(request.form) <= 2 and 'keyWord' in request.form:
for form in request.form:
if 'keyWord' != form:
filterCondition = form
keyWord = get_request_value(form=request.form,
name='keyWord')
pageNum = 1
break
elif is_authority(session[SessionResources().const.AUTHORITY])[0]:
if 'memberDeleted' in request.form:
for form in request.form:
if 'member' not in form and 'keyWord' not in form:
memberIdIndex = form
# Get Folder Path
member = select_member(
memberIdIndex=memberIdIndex).first()
try:
update_member_deleted(memberIdIndex)
dao.commit()
userPath = '{0}/Current/{1}_{2}'.format(
projectPath, member.memberId,
member.memberName)
# Delete Folder
if os.path.exists(userPath):
shutil.rmtree(userPath)
except Exception:
dao.rollback()
error = LanguageResources().const.DBFailed
else:
for form in request.form:
# Insert Indivisual
if 'memberInsert' in form:
insertCount = int(form[len('memberInsert'):]) + 1
for i in range(1, insertCount):
# Get Input Data
detailInformation = get_request_value(
form=request.form,
name='detailInformation{0}'.format(i))
memberId = get_request_value(
form=request.form,
name='memberId{0}'.format(i))
memberName = get_request_value(
form=request.form,
name='memberName{0}'.format(i))
if memberId\
and memberName:
try:
memberIdIndex = select_match_member_id(memberId).first().\
memberIdIndex
except Exception:
memberIdIndex = None
try:
error = insert_member_registration(
memberIdIndex=memberIdIndex,
memberId=memberId,
memberName=memberName,
password=generate_password_hash(
TripleDES.encrypt(
str(memberId))),
detailInformation=detailInformation
)
dao.commit()
# Get Folder Path
userPath = '{0}/Current/{1}_{2}'.format(
projectPath, memberId, memberName)
# make Folders
if not os.path.exists(userPath):
os.makedirs(userPath)
except Exception:
dao.rollback()
error = LanguageResources(
).const.DBFailed
else:
error = LanguageResources(
).const.FormValidation
else:
error = LanguageResources().const.GetOutHere
# Get Users
try:
members = select_members().subquery()
# Filter Case
if filterCondition\
and filterCondition != ' ':
if not keyWord:
keyWord = ' '
members = search_members(
members,
FilterFindParameter(filterCondition=filterCondition,
keyWord=(keyWord if keyWord != ' ' else
''))).subquery()
count = select_count(members.c.memberIdIndex).first().\
count
memberRecords = get_page_record(members_sorted(
members, sortCondition),
pageNum=pageNum)
except Exception:
count = 0
memberRecords = []
return render_template(
'/manage_user.html',
# 검색시 FilterCondition List
Filters=[
LanguageResources().const.All,
LanguageResources().const.ID,
LanguageResources().const.Name
],
sortCondition=sortCondition,
filterCondition=filterCondition,
keyWord=keyWord,
memberRecords=memberRecords,
pages=get_page_pointed(pageNum, count),
count=count,
error=error)
except Exception as e:
return unknown_error(e)
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 rank(sortCondition, pageNum, error=None):
# Not Accept URL Check
if sortCondition not in (LanguageResources().const.Rate[1],
LanguageResources().const.SolvedProblems[1]):
return page_not_found()
try:
#Searched MemberId
memberId = None
try:
# Auto Complete MemberIds
memberRecords = select_members().all()
except Exception:
memberRecords = []
# Last Submission Max Count
submissions = select_ranks(
select_last_submissions().subquery()).subquery()
submissions = join_member_id(
submissions,
subMemberIdIndex=submissions.c.memberIdIndex).subquery()
# records count
try:
count = select_count(submissions.c.memberIdIndex).first().\
count
except Exception:
count = 0
# Paging Pointed
pages = get_page_pointed(pageNum=pageNum, count=count)
submissions = ranks_sorted(submissions, sortCondition=sortCondition)
# Find MemberId 뷰 호출
if request.method == 'POST':
# Finding MemberId
memberId = get_request_value(form=request.form, name='memberId')
try:
memberIdIndex = select_match_member_id(
memberId).first().memberIdIndex
# 순차 탐색으로 찾아야 함
for i in range(1, pages['allPage'] + 1):
# memberId in Pages
ranks = get_page_record(submissions, pageNum=i).subquery()
# finding MemberId in Pages
if select_match_member_sub(
ranks,
memberIdIndex=memberIdIndex).first() != None:
# Finding move to page
pageNum = i
# searchLine Check
# RePaging Pointed
pages = get_page_pointed(pageNum=pageNum, count=count)
break
except Exception:
error = LanguageResources().const.NotExist
# 랭크 정보
try:
rankMemberRecords = get_page_record(submissions,
pageNum=pageNum).all()
except Exception:
rankMemberRecords = []
return render_template(HTMLResources().const.RANK_HTML,
sortCondition=sortCondition,
memberRecords=memberRecords,
rankMemberRecords=rankMemberRecords,
pages=pages,
memberId=memberId,
error=error) # 페이지 정보
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)
