def login_handler(self, data):
id = data.split(";")[2].split(",")[0]
password = data.split(";")[2].split(",")[1]
courses = ''
if len(password) != 0:
try:
masterInfo = select_master_check(id)
idIndex = masterInfo.index
if check_password_hash(masterInfo.password, TripleDES.encrypt(str(password))) is False:
self.request.send('0'.encode('utf-8'))
return
except:
self.request.send('0'.encode('utf-8'))
return
try:
courseList = select_unfinished_test_course_for_master(idIndex)
for courseInfo in courseList:
userCount = select_user_count(courseInfo.index)
banList = select_ban_list_index(courseInfo.index)
allowList = select_allow_list_index(courseInfo.index)
banList = str(banList).strip('[]').replace(' ','').replace('(','').replace(',)','').replace(',','*')
allowList = str(allowList).strip('[]').replace(' ','').replace('(','').replace(',)','').replace(',','*')
courseData = courseInfo.testName + "," + str(courseInfo.startDate) + "," + str(courseInfo.endDate) + "," + banList + "," + allowList + "," + str(userCount)
courses = courses + '^' + courseData
except:
courses = ''
courses = courses.lstrip('^')
else:
try:
idIndex = select_user_index(id)
except:
self.request.send('0'.encode('utf-8'))
return
try:
courseList = select_unfinished_test_course_for_user(idIndex)
if len(courseList) is 0:
self.request.send('-1'.encode('utf-8'))
return
courses = str(courseList).strip('[]').replace(' ','').replace('(','').replace(',)','').replace("'", '')
except:
self.request.send('-1'.encode('utf-8'))
return
sendData = str(idIndex)+"^"+courses
self.request.send(sendData.encode('utf-8'))
def init_db():
from DCheat_Server.model.allowList import AllowList
from DCheat_Server.model.allowSite import AllowSite
from DCheat_Server.model.banList import BanList
from DCheat_Server.model.banProgram import BanProgram
from DCheat_Server.model.master import Master
from DCheat_Server.model.testInfo import TestInfo
from DCheat_Server.model.testingUser import TestingUser
from DCheat_Server.model.user import User
from DCheat_Server.model import Base
#metadata 연결
Base.metadata.create_all(bind = DBManager.__engine)
# Init Date Input
try:
from datetime import datetime
from werkzeug.security import generate_password_hash
from DCheat_Server.DCheat_py3des import TripleDES
TripleDES.init()
from DCheat_Server.utils.insertQuery import insert_allow_site,\
insert_ban_program,\
insert_master
dao.add(insert_allow_site("http://cyber2010.kookmin.ac.kr", "KMU CYBER CAMPUS"))
dao.add(insert_allow_site("https://algolab.kookmin.ac.kr", "KMU GRADE SERVER"))
dao.add(insert_ban_program("Internet Explorer", "iexplorer", "Internet Explorer", "0", 0))
dao.add(insert_ban_program("Chrome", "chrome", "Google", "Chrome", 0))
dao.add(insert_ban_program("Firefox", "firefox", "Mozilla Firefox", "0", 0))
dao.add(insert_ban_program("Swing", "swing", "'Swing", "0", 0))
dao.add(insert_ban_program("Edge", "edge", "Edge", "0", 0))
dao.add(insert_ban_program("KakaoTalk", "KakaoTalk", "Kakao", "KakaoTalk", 5223))
dao.add(insert_ban_program("LINE", "LINE", "LINE", "LINE", 443))
dao.add(insert_ban_program("NATEON", "NateOnMain", "SK Communications", "NATEON", 5004))
dao.add(insert_ban_program("Skype", "Skype", "Skype", "phone", 12350))
dao.add(insert_ban_program("Tictoc", "Tictoc", "Tictoc", "bin", 23018))
dao.add(insert_ban_program("Between", "couple", "Between", "0", 0))
dao.add(insert_master("algolab", generate_password_hash(TripleDES.encrypt(str('rhflwma5106!'))), '*****@*****.**'))
dao.commit()
except Exception as e:
print(e)
dao.rollback()
