def buildStudentDB(): studentNoList = [] # insert student info using 출석부 file ==> student no, name for no, name in readExcelStudentInfo(excelFilePath): LectureDB.insertStudentInfo(no, name, None) # katalk ID = None, not yet assigned studentNoList.append(no) # read katalk chat, extract matching katalk ID, name, no, update student info DB for katalkID, name, no in readKatalkUserInfo(chatFilePath): if LectureDB.findStudentInfo(no=no) is None: print('Error:', katalkID + '의 .user 정보작성에 오류가 있음. - 출석부에 학번', no, ' 존재하지 않음.') continue if LectureDB.findStudentInfo(name=name) is None: print('Error:', katalkID + '의 .user 정보작성에 오류가 있음. - 출석부에 이름', name, ' 존재하지 않음.') continue LectureDB.updateStudentInfo(no, name, katalkID) # print(no, name, katalkID) # check integrity of student info DB for no in studentNoList: info = LectureDB.findStudentInfo(no=no) # print(info) if info['katalkID'] is None: print('Error: ' , info['name']+'의 .user 정보작성에 오류가 있음.')