def init_ui(self): model = QStandardItemModel() model.insertColumns(0, 4) model.setHeaderData(0, 1, 'ID', 0) model.setHeaderData(1, 1, 'Sigle', 0) model.setHeaderData(2, 1, 'Parameter', 0) model.setHeaderData(3, 1, 'Value', 0) sql = "SELECT id, sigle, text, value FROM {0}.tracer_physic WHERE type = '{1}' ORDER BY id".format( self.mdb.SCHEMA, self.cur_wq_mod) rows = self.mdb.run_query(sql, fetch=True) model.insertRows(0, len(rows)) for r, row in enumerate(rows): for c, val in enumerate(row): itm = QStandardItem() itm.setData(val, 0) if c == 3: itm.setData(data_to_float(val), 0) itm.setFlags(Qt.ItemIsSelectable | Qt.ItemIsEnabled | Qt.ItemIsEditable) itm.setTextAlignment(Qt.AlignRight | Qt.AlignVCenter) else: itm.setData(val, 0) itm.setFlags(Qt.ItemIsEnabled) model.setItem(r, c, itm) self.ui.tab_param.setModel(model) self.ui.tab_param.hide() self.ui.tab_param.resizeColumnsToContents() self.ui.tab_param.resizeRowsToContents() self.ui.tab_param.setColumnHidden(0, True) self.ui.ui.tab_param.show()
def create_tab_model(self, cur_var): """ create model table""" model = QStandardItemModel() model.insertColumns(0, 3) model.setHeaderData(0, 1, 'Date', 0) model.setHeaderData(1, 1, cur_var, 0) model.setHeaderData(2, 1, 'Comment', 0) model.itemChanged.connect(self.on_tab_data_change) return model
def create_tab_model(self): """ create table""" self.list_var = [] model = QStandardItemModel() model.insertColumns(0, 11) for c in range(5): model.setHeaderData(c, 1, 'time', 0) for c in range(5, 11): model.setHeaderData(c, 1, self.dico_var[c - 5]["name"], 0) self.list_var.append( [self.dico_var[c - 5]["id"], self.dico_var[c - 5]["name"]]) model.itemChanged.connect(self.on_tab_data_change) return model
def create_tab_model(self): self.list_trac = [] model = QStandardItemModel() model.insertColumns(0, 4) for c in range(4): model.setHeaderData(c, 1, 'time', 0) sql = "SELECT id, sigle FROM {0}.tracer_name WHERE type = '{1}' ORDER BY id".format( self.mdb.SCHEMA, self.tbwq.dico_wq_mod[self.cur_wq_mod]) rows = self.mdb.run_query(sql, fetch=True) model.insertColumns(4, len(rows)) for r, row in enumerate(rows): model.setHeaderData(r + 4, 1, row[1], 0) self.list_trac.append([row[0], row[1]]) model.itemChanged.connect(self.on_tab_data_change) return model
def create_tab_model(self): """ Create table of initial concentrations""" self.list_trac = [] model = QStandardItemModel() model.insertColumns(0, 2) model.setHeaderData(0, 1, 'Bief', 0) model.setHeaderData(1, 1, 'Abscissa', 0) sql = "SELECT id, sigle FROM {0}.tracer_name WHERE type = '{1}' ORDER BY id".format( self.mdb.SCHEMA, self.tbwq.dico_wq_mod[self.cur_wq_mod]) rows = self.mdb.run_query(sql, fetch=True) model.insertColumns(2, len(rows)) for r, row in enumerate(rows): model.setHeaderData(r + 2, 1, row[1], 0) self.list_trac.append([row[0], row[1]]) model.itemChanged.connect(self.on_tab_data_change) return model