def createJournal(self): """ Create a new journal by entering text into the dialog """ Dialog_text = QtGui.QDialog() ui = Ui_Dialog_memo("") ui.setupUi(Dialog_text, "New journal") Dialog_text.exec_() newText = ui.getMemo() journalName = ui.getFilename() if journalName is None or journalName == "": QtGui.QMessageBox.warning(None, "Warning", "No journal name selected") return #check for non-unique filename if any(d['name'] == journalName for d in self.journals): QtGui.QMessageBox.warning(None, "Warning", str(journalName) + " is already in use") return # update database newJrnl = { 'name': journalName, 'journal': newText, 'owner': self.settings['codername'], 'date': datetime.datetime.now().strftime("%a %b %d %H:%M:%S %Y"), 'dateM': "", 'status': 1 } cur = self.settings['conn'].cursor() cur.execute( "insert into journal(name,journal,owner,date,dateM,status) values(?,?,?,?,?,?)", (newJrnl['name'], newJrnl['journal'], newJrnl['owner'], newJrnl['date'], newJrnl['dateM'], newJrnl['status'])) self.settings['conn'].commit() self.log += "Journal " + newJrnl['name'] + " created\n" # clear and refill table widget for r in self.journals: self.tableWidget_journals.removeRow(0) self.journals.append(newJrnl) for row, itm in enumerate(self.journals): self.tableWidget_journals.insertRow(row) item = QtGui.QTableWidgetItem(itm['name']) self.tableWidget_journals.setItem(row, self.NAME_COLUMN, item) item = QtGui.QTableWidgetItem(itm['date']) self.tableWidget_journals.setItem(row, self.DATE_COLUMN, item) self.tableWidget_journals.resizeColumnsToContents() self.tableWidget_journals.resizeRowsToContents()
def createFile(self): """ Create a new text file by entering text into the dialog """ Dialog_text = QtGui.QDialog() ui = Ui_Dialog_memo("") ui.setupUi(Dialog_text, "New file") Dialog_text.exec_() fileText = ui.getMemo() fileName = ui.getFilename() if fileName == None or fileName == "": QtGui.QMessageBox.warning(None, 'Warning',"No filename was selected", QtGui.QMessageBox.Ok) return #check for non-unique filename if any(d['name'] == fileName for d in self.sourcetext): QtGui.QMessageBox.warning(None, 'Warning',"Filename in use", QtGui.QMessageBox.Ok) return # increment fileId until a spare id is available fileId = 1 while any(d['id'] == fileId for d in self.sourcetext): fileId = fileId + 1 # update database newFile = {'name':fileName, 'id':fileId, 'file': fileText, 'memo':"", 'owner':self.settings['codername'], 'date':datetime.datetime.now().strftime("%a %b %d %H:%M:%S %Y"), 'dateM':"", 'status':1} cur = self.settings['conn'].cursor() cur.execute("insert into source(name,id,file,memo,owner,date,dateM,status) values(?,?,?,?,?,?,?,?)", (newFile['name'],newFile['id'],newFile['file'],newFile['memo'],newFile['owner'],newFile['date'],newFile['dateM'],newFile['status'])) self.settings['conn'].commit() self.log +=newFile['name'] + " added.\n" # clear and refill table widget for r in self.sourcetext: self.tableWidget_files.removeRow(0) self.sourcetext.append(newFile) for row, itm in enumerate(self.sourcetext): self.tableWidget_files.insertRow(row) item = QtGui.QTableWidgetItem(itm['name']) self.tableWidget_files.setItem(row,self.NAME_COLUMN, item) item = QtGui.QTableWidgetItem(itm['date']) self.tableWidget_files.setItem(row,self.DATE_COLUMN, item) if itm['memo'] != None and itm['memo'] != "": self.tableWidget_files.setItem(row, self.MEMO_COLUMN, QtGui.QTableWidgetItem("Yes")) item = QtGui.QTableWidgetItem(str(itm['id'])) self.tableWidget_files.setItem(row, self.ID_COLUMN, item) self.tableWidget_files.resizeColumnsToContents() self.tableWidget_files.resizeRowsToContents()
def createJournal(self): """ Create a new journal by entering text into the dialog """ Dialog_text = QtGui.QDialog() ui = Ui_Dialog_memo("") ui.setupUi(Dialog_text, "New journal") Dialog_text.exec_() newText = ui.getMemo() journalName = ui.getFilename() if journalName is None or journalName == "": QtGui.QMessageBox.warning(None, "Warning", "No journal name selected") return #check for non-unique filename if any(d['name'] == journalName for d in self.journals): QtGui.QMessageBox.warning(None, "Warning", str(journalName) + " is already in use") return # update database newJrnl = {'name':journalName, 'journal': newText, 'owner':self.settings['codername'], 'date':datetime.datetime.now().strftime("%a %b %d %H:%M:%S %Y"), 'dateM':"", 'status':1} cur = self.settings['conn'].cursor() cur.execute("insert into journal(name,journal,owner,date,dateM,status) values(?,?,?,?,?,?)", (newJrnl['name'],newJrnl['journal'],newJrnl['owner'],newJrnl['date'],newJrnl['dateM'],newJrnl['status'])) self.settings['conn'].commit() self.log += "Journal " + newJrnl['name'] + " created\n" # clear and refill table widget for r in self.journals: self.tableWidget_journals.removeRow(0) self.journals.append(newJrnl) for row, itm in enumerate(self.journals): self.tableWidget_journals.insertRow(row) item = QtGui.QTableWidgetItem(itm['name']) self.tableWidget_journals.setItem(row, self.NAME_COLUMN, item) item = QtGui.QTableWidgetItem(itm['date']) self.tableWidget_journals.setItem(row, self.DATE_COLUMN, item) self.tableWidget_journals.resizeColumnsToContents() self.tableWidget_journals.resizeRowsToContents()
def createFile(self): """ Create a new text file by entering text into the dialog """ Dialog_text = QtGui.QDialog() ui = Ui_Dialog_memo("") ui.setupUi(Dialog_text, "New file") Dialog_text.exec_() fileText = ui.getMemo() fileName = ui.getFilename() if fileName == None or fileName == "": QtGui.QMessageBox.warning(None, 'Warning', "No filename was selected", QtGui.QMessageBox.Ok) return #check for non-unique filename if any(d['name'] == fileName for d in self.sourcetext): QtGui.QMessageBox.warning(None, 'Warning', "Filename in use", QtGui.QMessageBox.Ok) return # increment fileId until a spare id is available fileId = 1 while any(d['id'] == fileId for d in self.sourcetext): fileId = fileId + 1 # update database newFile = { 'name': fileName, 'id': fileId, 'file': fileText, 'memo': "", 'owner': self.settings['codername'], 'date': datetime.datetime.now().strftime("%a %b %d %H:%M:%S %Y"), 'dateM': "", 'status': 1 } cur = self.settings['conn'].cursor() cur.execute( "insert into source(name,id,file,memo,owner,date,dateM,status) values(?,?,?,?,?,?,?,?)", (newFile['name'], newFile['id'], newFile['file'], newFile['memo'], newFile['owner'], newFile['date'], newFile['dateM'], newFile['status'])) self.settings['conn'].commit() self.log += newFile['name'] + " added.\n" # clear and refill table widget for r in self.sourcetext: self.tableWidget_files.removeRow(0) self.sourcetext.append(newFile) for row, itm in enumerate(self.sourcetext): self.tableWidget_files.insertRow(row) item = QtGui.QTableWidgetItem(itm['name']) self.tableWidget_files.setItem(row, self.NAME_COLUMN, item) item = QtGui.QTableWidgetItem(itm['date']) self.tableWidget_files.setItem(row, self.DATE_COLUMN, item) if itm['memo'] != None and itm['memo'] != "": self.tableWidget_files.setItem(row, self.MEMO_COLUMN, QtGui.QTableWidgetItem("Yes")) item = QtGui.QTableWidgetItem(str(itm['id'])) self.tableWidget_files.setItem(row, self.ID_COLUMN, item) self.tableWidget_files.resizeColumnsToContents() self.tableWidget_files.resizeRowsToContents()