from PySide6.QtWidgets import QWidget, QApplication, QFileDialog from Ui_题目内容直接编辑 import Ui_Form from database_tools_2 import * class MyWindow(QWidget,Ui_Form): def __init__(self): super().__init__() self.setupUi(self) self.bind() def bind(self): self.lineEdit_ID.textChanged.connect(self.getID) self.pushButton_content.clicked.connect(self.showcontent) self.pushButton_genre.clicked.connect(self.showgenre) self.pushButton_ans.clicked.connect(self.showans) self.pushButton_solution.clicked.connect(self.showsolution) self.pushButton_origin.clicked.connect(self.showorigin) self.pushButton_remarks.clicked.connect(self.showremarks) self.pushButton_exec.clicked.connect(self.exec) self.pushButton_tocommit.clicked.connect(self.tocommit) self.db = connect(hostname = db_host, port = db_port, username=db_user, pwd=db_pwd, db = db_database) self.cursor = self.db.cursor() self.changedids = [] def getID(self): self.ID = self.lineEdit_ID.text().zfill(6) def showcontent(self): self.field = "题目内容" self.label_2.setText(f"题号 {self.lineEdit_ID.text()} 的 {self.field} 字段") sql = "SELECT content FROM problems WHERE ID = (%s);" val = (self.lineEdit_ID.text().zfill(6),) self.cursor.execute(sql,val) ret = self.cursor.fetchall() if ret[0][0] is None: self.originalcontent = "" else: self.originalcontent = ret[0][0].strip() self.plainTextEdit_toedit.setPlainText(self.originalcontent) def showgenre(self): self.field = "类型" self.label_2.setText(f"题号 {self.lineEdit_ID.text()} 的 {self.field} 字段") sql = "SELECT genre FROM problems WHERE ID = (%s);" val = (self.lineEdit_ID.text().zfill(6),) self.cursor.execute(sql,val) ret = self.cursor.fetchall() if ret[0][0] is None: self.originalcontent = "" else: self.originalcontent = ret[0][0].strip() self.plainTextEdit_toedit.setPlainText(self.originalcontent) def showans(self): self.field = "答案" self.label_2.setText(f"题号 {self.lineEdit_ID.text()} 的 {self.field} 字段") sql = "SELECT ans FROM problems WHERE ID = (%s);" val = (self.lineEdit_ID.text().zfill(6),) self.cursor.execute(sql,val) ret = self.cursor.fetchall() if ret[0][0] is None: self.originalcontent = "" else: self.originalcontent = ret[0][0].strip() self.plainTextEdit_toedit.setPlainText(self.originalcontent) def showsolution(self): self.field = "解答" self.label_2.setText(f"题号 {self.lineEdit_ID.text()} 的 {self.field} 字段") sql = "SELECT solution FROM problems WHERE ID = (%s);" val = (self.lineEdit_ID.text().zfill(6),) self.cursor.execute(sql,val) ret = self.cursor.fetchall() if ret[0][0] is None: self.originalcontent = "" else: self.originalcontent = ret[0][0].strip() self.plainTextEdit_toedit.setPlainText(self.originalcontent) def showorigin(self): self.field = "来源" self.label_2.setText(f"题号 {self.lineEdit_ID.text()} 的 {self.field} 字段") sql = "SELECT origin FROM problems WHERE ID = (%s);" val = (self.lineEdit_ID.text().zfill(6),) self.cursor.execute(sql,val) ret = self.cursor.fetchall() if ret[0][0] is None: self.originalcontent = "" else: self.originalcontent = ret[0][0].strip() self.plainTextEdit_toedit.setPlainText(self.originalcontent) def showremarks(self): self.field = "备注" self.label_2.setText(f"题号 {self.lineEdit_ID.text()} 的 {self.field} 字段") sql = "SELECT date,remark_content FROM remarks WHERE ID = (%s);" val = (self.lineEdit_ID.text().zfill(6),) self.cursor.execute(sql,val) ret_list = self.cursor.fetchall() if len(ret_list) == 0: self.originalcontent = "" else: self.originalcontent = "\n\n----------\n\n".join([ret[0]+"\t"+ret[1] for ret in ret_list]) self.plainTextEdit_toedit.setPlainText(self.originalcontent) def exec(self): self.currentcontent = self.plainTextEdit_toedit.toPlainText().strip() if self.currentcontent == self.originalcontent: print("未改变, 不作处理.") elif self.field in ["题目内容","答案","解答","来源"]: corresp = {"题目内容":"content","答案":"ans","解答":"solution","来源":"origin"} sql = f"UPDATE problems SET {corresp[self.field]} = %s WHERE ID = %s;" val = (self.currentcontent,self.ID) self.cursor.execute(sql,val) sql = "INSERT INTO logs (DATE,TIME,username,action,id,db_content) VALUE (%s,%s,%s,%s,%s,%s);" val = (GetDate(),GetTime(),get_git_username(),f"修改{self.field}",self.ID,f"{self.originalcontent} -> {self.currentcontent}") self.cursor.execute(sql,val) if self.field == "题目内容": sql = f"INSERT INTO edit_history (ID,date,editor) VALUE (%s,%s,%s);" val = (self.ID,GetDate(),get_git_username()) self.cursor.execute(sql,val) print(f"{self.ID} {self.field} 修改已完成") self.changedids.append(self.ID) elif self.field == "类型": sql = "UPDATE problems SET genre = %s WHERE ID = %s;" val = (self.currentcontent,self.ID) if self.currentcontent == "解答题": self.cursor.execute("UPDATE problems SET space = %s WHERE ID = %s;",("4em",self.ID)) else: self.cursor.execute("UPDATE problems SET space = %s WHERE ID = %s;",("",self.ID)) self.cursor.execute(sql,val) sql = "INSERT INTO logs (DATE,TIME,username,action,id,db_content) VALUE (%s,%s,%s,%s,%s,%s);" val = (GetDate(),GetTime(),get_git_username(),f"修改类型",self.ID,f"{self.originalcontent} -> {self.currentcontent}") self.cursor.execute(sql,val) print(f"{self.ID} {self.field} 修改已完成") self.changedids.append(self.ID) elif self.field == "备注": self.original_list = [item.strip() for item in self.originalcontent.split("-"*10)] self.current_list = [item.strip() for item in self.currentcontent.split("-"*10)] if len(self.original_list) != len(self.current_list): print("有问题, 需保持备注的数量一致") else: for i in range(len(self.original_list)): if self.original_list[i] != self.current_list[i]: rm_date_origin,rm_content_origin = parseRemark(self.original_list[i]) rm_date_current,rm_content_current = parseRemark(self.current_list[i]) sql = "UPDATE remarks SET date = %s, remark_content = %s WHERE ID = %s AND date = %s AND remark_content = %s;" val = (rm_date_current,rm_content_current,self.ID,rm_date_origin,rm_content_origin) self.cursor.execute(sql,val) sql = "INSERT INTO logs (DATE,TIME,username,action,id,db_content) VALUE (%s,%s,%s,%s,%s,%s);" val = (GetDate(),GetTime(),get_git_username(),f"修改备注",self.ID,f"{self.original_list[i]} -> {self.current_list[i]}") self.cursor.execute(sql,val) print(f"{self.ID} {self.field} 修改已完成") self.changedids.append(self.ID) def tocommit(self): if len(self.changedids) > 0: configjson = BuildFullScheme latexbody = "\\begin{enumerate}\n\n" for id in sorted(list(set(self.changedids))): latexbody += generateLaTeXBodyContentfromMariaDB(self.cursor,id,configjson) + "\n\n" latexbody += "\\end{enumerate}" latex_raw = ReadTextFile("模板文件/讲义模板.txt") if configjson["教师版"] == True: latex_raw = latex_raw.replace(r"学号\blank{50} \ 姓名\blank{80}","上海市控江中学") if sys.platform != "win32": #非win系统用默认字体 latex_raw = re.sub(r"fontset[\s]*=[\s]*none","fontset = fandol",latex_raw) latex_raw = re.sub(r"\\setCJKmainfont",r"% \\setCJKmainfont",latex_raw) latex_data = StringSubstitute(r"<<[\s\S]*?待替换[\s\S]*?>>",latex_raw,("试编译",latexbody)) #替换标题和bodystring outputdir = os.path.join(os.getcwd(),"临时文件") outputfilepath = os.path.join(outputdir,"试编译.tex") SaveTextFile(latex_data,outputfilepath) if XeLaTeXCompile(outputdir,"试编译.tex",times=1): print("修改后检验成功, 已导入数据库.") self.db.commit() else: print("修改后检验失败, 已回滚.") self.db.rollback() self.changedids = [] else: print("未作修改.") if __name__ == '__main__': app = QApplication([]) windows = MyWindow() windows.show() app.exec()