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