def close_db_session(exception = None):
"""요청이 완료된 후에 db연결에 사용된 세션을 종료함"""
try:
dao.remove()
except Exception as e:
from GradeServer.GradeServer_logger import Log
Log.error(str(e))
def to_process_written_code(pageNum, problemIndex):
memberId = session[SessionResources().const.MEMBER_ID]
memberIdIndex = session[SessionResources().const.MEMBER_ID_INDEX]
problemName = remove_space_in_problemName(problemIndex)
filePath, tempPath = make_path(PATH, memberIdIndex, memberId, problemName)
try:
os.mkdir(tempPath)
usedLanguageName, usedLanguageVersion, fileName = write_code_in_file(
tempPath)
fileSize = os.stat(os.path.join(tempPath, fileName)).st_size
fileIndex = 1
submissionIndex = get_submission_index(memberIdIndex, problemIndex)
delete_submitted_files_data(submissionIndex)
insert_submitted_files(submissionIndex, fileIndex, fileName, filePath,
fileSize)
send_to_celery(memberIdIndex, problemIndex, submissionIndex,
usedLanguageName, usedLanguageVersion, fileSize,
problemName, filePath, tempPath)
Log.info(OtherResources().const.WRITED_CODE_SUBMITTED)
except OSError as e:
Log.error(str(e))
submit_error(tempPath, pageNum, OtherResources().const.FILE_ERROR)
except Exception as e:
dao.rollback()
Log.error(str(e))
print e
submit_error(tempPath, pageNum, OtherResources().const.DB_ERROR)
time.sleep(0.4)
return page_move(pageNum)
def to_process_written_code(pageNum, problemIndex):
memberId = session[SessionResources().const.MEMBER_ID]
memberIdIndex = session[SessionResources().const.MEMBER_ID_INDEX]
problemName = remove_space_in_problemName(problemIndex)
filePath, tempPath = make_path(PATH, memberIdIndex, memberId, problemName)
try:
os.mkdir(tempPath)
usedLanguageName, usedLanguageVersion, fileName = write_code_in_file(tempPath)
fileSize = os.stat(os.path.join(tempPath, fileName)).st_size
fileIndex = 1
submissionIndex = get_submission_index(memberIdIndex, problemIndex)
delete_submitted_files_data(submissionIndex)
insert_submitted_files(submissionIndex, fileIndex, fileName, filePath, fileSize)
send_to_celery(memberIdIndex, problemIndex, submissionIndex, usedLanguageName, usedLanguageVersion, fileSize, problemName, filePath, tempPath)
Log.info(OtherResources().const.WRITED_CODE_SUBMITTED)
except OSError as e:
Log.error(str(e))
submit_error(tempPath, pageNum, OtherResources().const.FILE_ERROR)
except Exception as e:
dao.rollback()
Log.error(str(e))
print e
submit_error(tempPath, pageNum, OtherResources().const.DB_ERROR)
time.sleep(0.4)
return page_move(pageNum)
def to_process_uploaded_files(problemIndex, pageNum, browserName, browserVersion):
memberId = session[SessionResources().const.MEMBER_ID]
memberIdIndex = session[SessionResources().const.MEMBER_ID_INDEX]
problemName = remove_space_in_problemName(problemIndex)
filePath, tempPath = make_path(PATH, memberIdIndex, memberId, problemName)
try:
os.mkdir(tempPath)
uploadFiles = request.files.getlist(OtherResources().const.GET_FILES)
usedLanguageName = request.form[OtherResources().const.USED_LANGUAGE_NAME]
usedLanguageVersion = request.form[OtherResources().const.USED_LANGUAGE_VERSION]
submissionIndex = get_submission_index(memberIdIndex, problemIndex)
sumOfSubmittedFileSize = file_save(submissionIndex, uploadFiles, tempPath, filePath)
send_to_celery(memberIdIndex, problemIndex, submissionIndex, usedLanguageName, usedLanguageVersion, sumOfSubmittedFileSize, problemName, filePath, tempPath)
Log.info(OtherResources().const.FILE_SUBMITTED)
except OSError as e:
Log.error(str(e))
submit_error(tempPath, pageNum, OtherResources().const.FILE_ERROR, browserName, browserVersion)
except Exception as e:
dao.rollback()
Log.error(str(e))
print e
submit_error(tempPath, pageNum, OtherResources().const.DB_ERROR, browserName, browserVersion)
time.sleep(0.4)
return page_move(pageNum, browserName, browserVersion)
def id_check(select, error = None):
if request.method == 'POST':
# 암호를 입력 안했을 때
if not request.form['password']:
error ='Password' + get_message('fillData')
else:
try:
memberId = session[SessionResources().const.MEMBER_ID]
password = request.form['password']
check = select_match_member(memberCourseProblemParameter = MemberCourseProblemParameter(memberId = memberId)).first()
# 암호가 일치 할 때
#Checking Success
if check_password_hash (check.password,
TripleDES.encrypt(str(password))):
# for all user
if select == 'account':
return redirect(url_for(RouteResources().const.EDIT_PERSONAL))
# server manager
elif SETResources().const.SERVER_ADMINISTRATOR in session[SessionResources().const.AUTHORITY][0]:
if select == 'server_manage_collegedepartment':
return redirect(url_for('.server_manage_collegedepartment',
collegePageNum = int(1),
departmentPageNum = int(1)))
elif select == 'server_manage_class':
return redirect(url_for('.server_manage_class',
pageNum = int(1)))
elif select == 'server_manage_problem':
return redirect(url_for('.server_manage_problem',
activeTabId = OtherResources().const.ALL,
pageNum = int(1)))
elif select == 'server_manage_user':
return redirect(url_for('.server_manage_user',
activeTabId = OtherResources().const.ALL,
pageNum = int(1)))
elif select == 'server_manage_service':
return redirect(url_for('.server_manage_service'))
# class manager
elif SETResources().const.COURSE_ADMINISTRATOR in session[SessionResources().const.AUTHORITY][0]:
if select == 'user_submit':
return redirect(url_for('.class_user_submit'))
elif select == 'cm_manage_problem':
return redirect(url_for('.class_manage_problem'))
elif select == 'cm_manage_user':
return redirect(url_for('.class_manage_user'))
elif select == 'cm_manage_service':
return redirect(url_for('.class_manage_service'))
else:
return unknown_error()
# 암호가 일치 하지 않을 때
else:
error = get_message('wrongPassword')
except Exception as e:
Log.error(str(e))
raise e
return render_template(HTMLResources().const.ID_CHECK_HTML,
error = error)
def to_process_uploaded_files(courseId, problemId, pageNum, browserName, browserVersion):
memberId = session[SessionResources.const.MEMBER_ID]
problemName = remove_space_in_problemName(problemId)
filePath, tempPath = make_path(PATH, memberId, courseId, problemId, problemName)
try:
os.mkdir(tempPath)
uploadFiles = request.files.getlist(OtherResources.const.GET_FILES)
usedLanguageName = request.form[OtherResources.const.USED_LANGUAGE_NAME]
sumOfSubmittedFileSize = file_save(memberId, courseId, problemId, uploadFiles, tempPath, filePath)
send_to_celery(memberId, courseId, problemId, usedLanguageName, sumOfSubmittedFileSize, problemName, filePath, tempPath)
Log.info("file submitted")
except OSError as e:
Log.error(str(e))
submit_error(tempPath, courseId, pageNum, 'fileError', browserName, browserVersion)
except Exception as e:
dao.rollback()
Log.error(str(e))
submit_error(tempPath, courseId, pageNum, 'dbError', browserName, browserVersion)
time.sleep(0.4)
return page_move(courseId, pageNum, browserName, browserVersion)
def to_process_uploaded_files(problemIndex, pageNum, browserName,
browserVersion):
memberId = session[SessionResources().const.MEMBER_ID]
memberIdIndex = session[SessionResources().const.MEMBER_ID_INDEX]
problemName = remove_space_in_problemName(problemIndex)
filePath, tempPath = make_path(PATH, memberIdIndex, memberId, problemName)
try:
os.mkdir(tempPath)
uploadFiles = request.files.getlist(OtherResources().const.GET_FILES)
usedLanguageName = request.form[
OtherResources().const.USED_LANGUAGE_NAME]
usedLanguageVersion = request.form[
OtherResources().const.USED_LANGUAGE_VERSION]
submissionIndex = get_submission_index(memberIdIndex, problemIndex)
sumOfSubmittedFileSize = file_save(submissionIndex, uploadFiles,
tempPath, filePath)
send_to_celery(memberIdIndex, problemIndex, submissionIndex,
usedLanguageName, usedLanguageVersion,
sumOfSubmittedFileSize, problemName, filePath, tempPath)
Log.info(OtherResources().const.FILE_SUBMITTED)
except OSError as e:
Log.error(str(e))
submit_error(tempPath, pageNum,
OtherResources().const.FILE_ERROR, browserName,
browserVersion)
except Exception as e:
dao.rollback()
Log.error(str(e))
print e
submit_error(tempPath, pageNum,
OtherResources().const.DB_ERROR, browserName,
browserVersion)
time.sleep(0.4)
return page_move(pageNum, browserName, browserVersion)
def to_process_written_code(courseId, pageNum, problemId):
memberId = session[SessionResources.const.MEMBER_ID]
problemName = remove_space_in_problemName(problemId)
filePath, tempPath = make_path(PATH, memberId, courseId, problemId, problemName)
try:
os.mkdir(tempPath)
usedLanguageName, fileName = write_code_in_file(tempPath)
fileSize = os.stat(os.path.join(tempPath, fileName)).st_size
fileIndex = 1
delete_submitted_files_data(memberId, problemId, courseId)
insert_submitted_files(memberId, courseId, problemId, fileIndex, fileName, filePath, fileSize)
send_to_celery(memberId, courseId, problemId, usedLanguageName, fileSize, problemName, filePath, tempPath)
Log.info("writed code is submitted")
except OSError as e:
Log.error(str(e))
submit_error(tempPath, courseId, pageNum, 'fileError')
except Exception as e:
dao.rollback()
Log.error(str(e))
submit_error(tempPath, courseId, pageNum, 'dbError')
time.sleep(0.4)
return page_move(courseId, pageNum)
def close_db_session(exception = None):
"""요청이 완료된 후에 db연결에 사용된 세션을 종료함"""
try:
dao.remove()
except Exception as e:
Log.error(str(e))
def close_db_session(exception=None):
'''요청이 완료된 후에 db연결에 사용된 세션을 종료함'''
try:
dao.remove()
except Exception as e:
Log.error(str(e))
def access_authority_check(problemLevel=None,
memberIdIndex=None,
submissionIndex=None,
problemIndex=None,
submissionReplyIndex=None,
articleIndex=None,
boardReplyIndex=None,
isAdministrator=None,
isWrite=None,
isCode=None):
try:
# Zero Index Check
if memberIdIndex == 0\
or problemIndex == 0\
or submissionReplyIndex == 0\
or (articleIndex == 0 and not isWrite)\
or boardReplyIndex == 0:
return False
# Get Authority type Turple
authority = is_authority(session[SessionResources().const.AUTHORITY])
# Get my Index
thisMemberIdIndex = session[SessionResources().const.MEMBER_ID_INDEX]
# Authority check authority is turple, size 3
if isAdministrator and authority[0]:
if problemLevel\
and problemLevel not in (LanguageResources().const.GoldLevel[1],
LanguageResources().const.SilverLevel[1],
LanguageResources().const.BronzeLevel[1]):
return False
return True
elif isAdministrator and not authority[0]:
return False
else:
# Division Index
if submissionIndex:
submissionIndex = select_data_of_submission_board(
submissionIndex).first()
memberIdIndex = submissionIndex.memberIdIndex
problemIndex = submissionIndex.problemIndex
# MemberIdIndex Check
if memberIdIndex\
and not select_member(memberIdIndex).first():
return False
if problemIndex\
and not course_problem_check(isAdministrator,
authority,
memberIdIndex,
problemIndex,
thisMemberIdIndex,
isCode):
return False
# Submission Reply Index check
if submissionReplyIndex:
replySubmissionIndex = select_replies_on_code(
submissionIndex=None,
submissionReplyIndex=submissionReplyIndex).first()
replySubmissionIndex = select_data_of_submission_board(
replySubmissionIndex.submissionIndex).first()
if not course_problem_check(isAdministrator, authority,
replySubmissionIndex.memberIdIndex,
replySubmissionIndex.problemIndex,
thisMemberIdIndex, isCode):
return False
# Board Check
if articleIndex:
article = select_article(articleIndex).first()
if isWrite\
and article.writerIdIndex != thisMemberIdIndex:
return False
# All Pass Authority
return True
except Exception as e:
Log.error(str(e))
return False
def access_authority_check(problemLevel = None, memberIdIndex = None,
submissionIndex = None, problemIndex = None, submissionReplyIndex = None,
articleIndex = None, boardReplyIndex = None,
isAdministrator = None, isWrite = None, isCode = None):
try:
# Zero Index Check
if memberIdIndex == 0\
or problemIndex == 0\
or submissionReplyIndex == 0\
or (articleIndex == 0 and not isWrite)\
or boardReplyIndex == 0:
return False
# Get Authority type Turple
authority = is_authority(session[SessionResources().const.AUTHORITY])
# Get my Index
thisMemberIdIndex = session[SessionResources().const.MEMBER_ID_INDEX]
# Authority check authority is turple, size 3
if isAdministrator and authority[0]:
if problemLevel\
and problemLevel not in (LanguageResources().const.GoldLevel[1],
LanguageResources().const.SilverLevel[1],
LanguageResources().const.BronzeLevel[1]):
return False
return True
elif isAdministrator and not authority[0]:
return False
else:
# Division Index
if submissionIndex:
submissionIndex = select_data_of_submission_board(submissionIndex).first()
memberIdIndex = submissionIndex.memberIdIndex
problemIndex = submissionIndex.problemIndex
# MemberIdIndex Check
if memberIdIndex\
and not select_member(memberIdIndex).first():
return False
if problemIndex\
and not course_problem_check(isAdministrator,
authority,
memberIdIndex,
problemIndex,
thisMemberIdIndex,
isCode):
return False
# Submission Reply Index check
if submissionReplyIndex:
replySubmissionIndex = select_replies_on_code(submissionIndex = None,
submissionReplyIndex = submissionReplyIndex).first()
replySubmissionIndex = select_data_of_submission_board(replySubmissionIndex.submissionIndex).first()
if not course_problem_check(isAdministrator,
authority,
replySubmissionIndex.memberIdIndex,
replySubmissionIndex.problemIndex,
thisMemberIdIndex,
isCode):
return False
# Board Check
if articleIndex:
article = select_article(articleIndex).first()
if isWrite\
and article.writerIdIndex != thisMemberIdIndex:
return False
# All Pass Authority
return True
except Exception as e:
Log.error(str(e))
return False
