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