def cellSelected(self): """ When cell selected in table widget, do something: change a code colour, change a code memo """ x = self.tableWidget_codes.currentRow() y = self.tableWidget_codes.currentColumn() if y == self.COLOR_COLUMN: #print(self.freecode[x]['color']) Dialog_colorselect = QtGui.QDialog() ui = Ui_Dialog_colorselect(self.freecode[x]['color']) ui.setupUi(Dialog_colorselect) ok = Dialog_colorselect.exec_() if ok: selectedColor = ui.getColor() if selectedColor is not None: item = QtGui.QTableWidgetItem( ) # an empty item, used to have color name item.setBackground( QtGui.QBrush(QtGui.QColor(selectedColor['hex']))) self.tableWidget_codes.setItem(x, self.COLOR_COLUMN, item) self.tableWidget_codes.clearSelection() #update freecode list, database and currently viewed file self.freecode[x]['color'] = selectedColor['colname'] cur = self.settings['conn'].cursor() cur.execute( "update freecode set color=? where id=?", (self.freecode[x]['color'], self.freecode[x]['id'])) self.settings['conn'].commit() self.unlight() self.highlight() if y == self.MEMO_COLUMN: Dialog_memo = QtGui.QDialog() ui = Ui_Dialog_memo(self.freecode[x]['memo']) ui.setupUi(Dialog_memo, "Code memo " + self.freecode[x]['name']) Dialog_memo.exec_() memo = ui.getMemo() if memo == "": self.tableWidget_codes.setItem(x, self.MEMO_COLUMN, QtGui.QTableWidgetItem()) else: self.tableWidget_codes.setItem(x, self.MEMO_COLUMN, QtGui.QTableWidgetItem("Yes")) #update freecode list and database self.freecode[x]['memo'] = str(memo) cur = self.settings['conn'].cursor() cur.execute("update freecode set memo=? where id=?", (self.freecode[x]['memo'], self.freecode[x]['id'])) self.settings['conn'].commit()
def codesCellSelected(self): """ When colour or memo cells are selected in the table widget, open a memo dialog or colour selector dialog """ x = self.tableWidget_codes.currentRow() y = self.tableWidget_codes.currentColumn() if y == self.CODE_COLOR_COLUMN: Dialog_colorselect = QtGui.QDialog() ui = Ui_Dialog_colorselect(self.freecode[x]['color']) ui.setupUi(Dialog_colorselect) ok = Dialog_colorselect.exec_() if ok: selectedColor = ui.getColor() if selectedColor != None: item = QtGui.QTableWidgetItem( ) # an empty item, used to have color name item.setBackground( QtGui.QBrush(QtGui.QColor(selectedColor['hex']))) self.tableWidget_codes.setItem(x, self.CODE_COLOR_COLUMN, item) self.tableWidget_codes.clearSelection() #update freecode list and database self.freecode[x]['color'] = selectedColor['colname'] cur = self.settings['conn'].cursor() cur.execute( "update freecode set color=? where id=?", (self.freecode[x]['color'], self.freecode[x]['id'])) self.settings['conn'].commit() if y == self.CODE_MEMO_COLUMN: Dialog_memo = QtGui.QDialog() ui = Ui_Dialog_memo(self.freecode[x]['memo']) ui.setupUi(Dialog_memo, "Code memo " + self.freecode[x]['name']) Dialog_memo.exec_() memo = ui.getMemo() if memo == "": self.tableWidget_codes.setItem(x, self.CODE_MEMO_COLUMN, QtGui.QTableWidgetItem()) else: self.tableWidget_codes.setItem(x, self.CODE_MEMO_COLUMN, QtGui.QTableWidgetItem("Yes")) #update freecode list and database self.freecode[x]['memo'] = str(memo) cur = self.settings['conn'].cursor() cur.execute("update freecode set memo=? where id=?", (self.freecode[x]['memo'], self.freecode[x]['id'])) self.settings['conn'].commit()
def cellSelected(self): """ When cell selected in table widget, do something: change a code colour, change a code memo """ x = self.tableWidget_codes.currentRow() y = self.tableWidget_codes.currentColumn() if y == self.COLOR_COLUMN: # print(self.freecode[x]['color']) Dialog_colorselect = QtGui.QDialog() ui = Ui_Dialog_colorselect(self.freecode[x]["color"]) ui.setupUi(Dialog_colorselect) ok = Dialog_colorselect.exec_() if ok: selectedColor = ui.getColor() if selectedColor is not None: item = QtGui.QTableWidgetItem() # an empty item, used to have color name item.setBackground(QtGui.QBrush(QtGui.QColor(selectedColor["hex"]))) self.tableWidget_codes.setItem(x, self.COLOR_COLUMN, item) self.tableWidget_codes.clearSelection() # update freecode list, database and currently viewed file self.freecode[x]["color"] = selectedColor["colname"] cur = self.settings["conn"].cursor() cur.execute( "update freecode set color=? where id=?", (self.freecode[x]["color"], self.freecode[x]["id"]) ) self.settings["conn"].commit() self.unlight() self.highlight() if y == self.MEMO_COLUMN: Dialog_memo = QtGui.QDialog() ui = Ui_Dialog_memo(self.freecode[x]["memo"]) ui.setupUi(Dialog_memo, "Code memo " + self.freecode[x]["name"]) Dialog_memo.exec_() memo = ui.getMemo() if memo == "": self.tableWidget_codes.setItem(x, self.MEMO_COLUMN, QtGui.QTableWidgetItem()) else: self.tableWidget_codes.setItem(x, self.MEMO_COLUMN, QtGui.QTableWidgetItem("Yes")) # update freecode list and database self.freecode[x]["memo"] = str(memo) cur = self.settings["conn"].cursor() cur.execute("update freecode set memo=? where id=?", (self.freecode[x]["memo"], self.freecode[x]["id"])) self.settings["conn"].commit()
def codesCellSelected(self): """ When colour or memo cells are selected in the table widget, open a memo dialog or colour selector dialog """ x = self.tableWidget_codes.currentRow() y = self.tableWidget_codes.currentColumn() if y == self.CODE_COLOR_COLUMN: Dialog_colorselect = QtGui.QDialog() ui = Ui_Dialog_colorselect(self.freecode[x]['color']) ui.setupUi(Dialog_colorselect) ok = Dialog_colorselect.exec_() if ok: selectedColor = ui.getColor() if selectedColor!=None: item = QtGui.QTableWidgetItem() # an empty item, used to have color name item.setBackground(QtGui.QBrush(QtGui.QColor(selectedColor['hex']))) self.tableWidget_codes.setItem(x, self.CODE_COLOR_COLUMN, item) self.tableWidget_codes.clearSelection() #update freecode list and database self.freecode[x]['color'] = selectedColor['colname'] cur = self.settings['conn'].cursor() cur.execute("update freecode set color=? where id=?", (self.freecode[x]['color'], self.freecode[x]['id'])) self.settings['conn'].commit() if y == self.CODE_MEMO_COLUMN: Dialog_memo = QtGui.QDialog() ui = Ui_Dialog_memo(self.freecode[x]['memo']) ui.setupUi(Dialog_memo, "Code memo " + self.freecode[x]['name']) Dialog_memo.exec_() memo = ui.getMemo() if memo == "": self.tableWidget_codes.setItem(x, self.CODE_MEMO_COLUMN, QtGui.QTableWidgetItem()) else: self.tableWidget_codes.setItem(x, self.CODE_MEMO_COLUMN, QtGui.QTableWidgetItem("Yes")) #update freecode list and database self.freecode[x]['memo'] = str(memo) cur = self.settings['conn'].cursor() cur.execute("update freecode set memo=? where id=?", (self.freecode[x]['memo'], self.freecode[x]['id'])) self.settings['conn'].commit()