def __init__(self, parent=None): UFT_UiForm.__init__(self) self.dut_image = None # sync config db from config xml sync_config("sqlite:///" + CONFIG_DB, CONFIG_FILE, direction="in") # # setup config db, view and model self.config_db = QtSql.QSqlDatabase.addDatabase("QSQLITE", "config") self.config_db.setDatabaseName(CONFIG_DB) result = self.config_db.open() if (not result): msgbox = QtGui.QMessageBox() msg = self.config_db.lastError().text() msgbox.critical(msgbox, "error", msg + " db=" + CONFIG_DB) self.config_tableView = QtGui.QTableView() # self.test_item_tableView already created in UI. self.config_model = QtSql.QSqlTableModel(db=self.config_db) self.test_item_model = QtSql.QSqlRelationalTableModel( db=self.config_db) self.test_item_model.setEditStrategy( QtSql.QSqlTableModel.OnManualSubmit) # setup log db, view and model self.log_db = QtSql.QSqlDatabase.addDatabase("QSQLITE", "log") self.log_db.setDatabaseName(RESULT_DB) result = self.log_db.open() if (not result): msgbox = QtGui.QMessageBox() msg = self.config_db.lastError().text() msgbox.critical(msgbox, "error", msg + " db=" + RESULT_DB) # self.log_tableView self.log_model = QtSql.QSqlTableModel(db=self.log_db) self.cycle_model = QtSql.QSqlRelationalTableModel(db=self.log_db)
def __init__(self): super(MainWindow, self).__init__() self.controlador = Controller(self) db = QtSql.QSqlDatabase.addDatabase('QSQLITE') db.setDatabaseName('fichadas.db') self.model = QtSql.QSqlTableModel() self.modelFichada = QtSql.QSqlTableModel() self.init_ui()
def refresh_table(self, Dialog): if (self.db.open()): roommodel = QtSql.QSqlTableModel() roommodel.setTable(self.roomip) roommodel.select() self.tableView.setModel(roommodel) usermodel = QtSql.QSqlTableModel() usermodel.setTable('user_info') usermodel.select() self.tableView_2.setModel(usermodel) self.db.close() else: print("Failed to connect to mysql") print(self.db.lastError().text())
def __init__(self): super(Dialogo_Editar_Ministerios, self).__init__() self.msgBox = QtGui.QMessageBox() self.msgBox.setModal(True) self.dialogo = QtGui.QDialog() self.dialogo.setAttribute(QtCore.Qt.WA_DeleteOnClose) self.ui = Ui_Dialogo_Editar_Ministerios(self.dialogo) self.modeloBaseDatos = QtSql.QSqlTableModel(self, db) self.modeloBaseDatos.setTable("ministerios") self.modeloBaseDatos.select() self.modeloBaseDatos.setHeaderData(0, QtCore.Qt.Horizontal, "Ministerios") self.filtro = QtGui.QSortFilterProxyModel() self.filtro.setSourceModel(self.modeloBaseDatos) self.filtro.setFilterKeyColumn(1) self.ui.tableView.setModel(self.filtro) self.ui.tableView.hideColumn(0) self.ui.tableView.show() self.ui.pushButton.clicked.connect(self.eliminarMinisterios) self.ui.pushButton_2.clicked.connect(self.agregarMinisterio) self.ui.lineEdit.textChanged.connect(self.filtro.setFilterRegExp) self.modeloBaseDatos.beforeInsert.connect(self.verificarData) self.modeloBaseDatos.beforeUpdate.connect(self.verificarData)
def __init__(self, parent=None): QtGui.QDialog.__init__(self, parent) self.setWindowTitle(u'假期设置') self.setWindowIcon(QtGui.QIcon('guis/icons/tent.png')) self.setMaximumWidth(200) layout = QtGui.QVBoxLayout() self.holData = QtSql.QSqlTableModel() self.holData.setTable('holidays') self.holData.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) self.holData.select() self.holData.setHeaderData(0, QtCore.Qt.Horizontal, u'日期') self.holData.setHeaderData(1, QtCore.Qt.Horizontal, u'假期') self.holData.setHeaderData(2, QtCore.Qt.Horizontal, u'状态') self.holView = QtGui.QTableView() self.holView.setModel(self.holData) self.holView.resizeColumnsToContents() self.holView.resizeRowsToContents() self.holView.verticalHeader().hide() buttonLayout = QtGui.QHBoxLayout() self.btAdd = QtGui.QPushButton(u'添加假期') self.btAdd.clicked.connect(self.newHol) self.btConf = QtGui.QPushButton(u'确认修改') self.btConf.clicked.connect(self.submit) self.btCancel = QtGui.QPushButton(u'取消') self.btCancel.clicked.connect(self.close) buttonLayout.addWidget(self.btAdd) buttonLayout.addWidget(self.btConf) buttonLayout.addWidget(self.btCancel) layout.addLayout(buttonLayout) layout.addWidget(self.holView) self.setLayout(layout)
def geoODKConfig(self): dbName = QtGui.QFileDialog.getOpenFileName(self.iface.parent(), 'Select mbTiles database', '.', '*.mbtiles') if os.path.exists(dbName): db = QtSql.QSqlDatabase.addDatabase('QSQLITE') db.setDatabaseName(dbName) db.open() model = QtSql.QSqlTableModel() model.setTable('images') if not model.select(): query = QtSql.QSqlQuery() try: query.exec_("CREATE TABLE images (tile_data blob, tile_id text);") db.close() messageText = "Required table created in %s." % dbName response = QtGui.QMessageBox.information(self.iface.parent(), 'Success', messageText, QtGui.QMessageBox.Ok) except: messageText = "Unable to create required table in %s." % dbName response = QtGui.QMessageBox.warning(self.iface.parent(), 'Warning', messageText, QtGui.QMessageBox.Ok) else: messageText = "Required table already exists in %s." % dbName response = QtGui.QMessageBox.information(self.iface.parent(), 'Information', messageText, QtGui.QMessageBox.Ok)
def showTableFuntionTab2(self): self.tableModelTab2 = QtSql.QSqlTableModel(self) self.tableModelTab2.setTable("INVENTARIO") self.tableModelTab2.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) self.tableModelTab2.select() self.uiMain.tableViewTab2.setModel(self.tableModelTab2) self.uiMain.tableViewTab2.show()
def __init__(self, parent=None): QtCore.QThread.__init__(self) self.parent = parent # Connect to sqlite DB self.db = QtSql.QSqlDatabase.addDatabase("QSQLITE") self.db.setDatabaseName("log.db") self.db.open() self.q = QtSql.QSqlQuery() # Reset table (from last gui execution) self.q.exec_("DROP TABLE IF EXISTS messages") self.q.exec_( "CREATE TABLE messages (timestamp TEXT PRIMARY KEY, component TEXT, verbosity TEXT, message TEXT)" ) self.model = QtSql.QSqlTableModel(None, self.db) self.model.setTable('messages') self.model.setEditStrategy(self.model.OnManualSubmit) self.model.select() # Signal from recordCreator that new record is ready to be inserted self.insertRecordSignal.connect(self.insert_record) # Signal from logWidget that the filter has changed #self.filterChangedSignal.connect(self.filterChanged) '''
def __init__(self,tabela): QtGui.QWidget.__init__(self) self.ui = Cria_janela_cargas() self.ui.setupUi12(self) self.model = QtSql.QSqlTableModel(self) self.model.setTable("%s"%tabela) self.model.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) self.model.select() QtGui.QWidget.setWindowTitle(self, "Easy Energy - Residencial/Comercial - %s"%(tabela)) self.ui.tableView.setModel(self.model) self.lista_classes_tarifarias() #TRIGGERS QtCore.QObject.connect(self.ui.UpdateButton, QtCore.SIGNAL('clicked()'), self.UpdateRecords) QtCore.QObject.connect(self.ui.CancelButton, QtCore.SIGNAL('clicked()'), self.CancelChanges) QtCore.QObject.connect(self.ui.InsertButton, QtCore.SIGNAL('clicked()'), self.InsertRecords) QtCore.QObject.connect(self.ui.DeleteButton, QtCore.SIGNAL('clicked()'), self.DeleteRecords) QtCore.QObject.connect(self.ui.FilterButton, QtCore.SIGNAL('clicked()'), self.Filtrar) QtCore.QObject.connect(self.ui.DeleteButton_3, QtCore.SIGNAL('clicked()'),self.novo_item) QtCore.QObject.connect(self.ui.DeleteButton_2, QtCore.SIGNAL('clicked()'),self.DeleteAll) QtCore.QObject.connect(self.ui.pushButton_selecionar, QtCore.SIGNAL('clicked()'),self.configura_globais_tarifação) QtCore.QObject.connect(self.ui.FilterButton_2, QtCore.SIGNAL('clicked()'),self.atualizar_informações_consultoria) #ATALHOS global tab tab = tabela self.ui.radioButton.setChecked(1)
def __init__(self, tableName, parent=None): super(TableEditor, self).__init__(parent) self.model = QtSql.QSqlTableModel(self) self.model.setTable(tableName) self.model.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) self.model.select() self.model.setHeaderData(0, QtCore.Qt.Horizontal, "ID") self.model.setHeaderData(1, QtCore.Qt.Horizontal, "First name") self.model.setHeaderData(2, QtCore.Qt.Horizontal, "Last name") view = QtGui.QTableView() view.setModel(self.model) submitButton = QtGui.QPushButton("Submit") submitButton.setDefault(True) revertButton = QtGui.QPushButton("&Revert") quitButton = QtGui.QPushButton("Quit") buttonBox = QtGui.QDialogButtonBox(QtCore.Qt.Vertical) buttonBox.addButton(submitButton, QtGui.QDialogButtonBox.ActionRole) buttonBox.addButton(revertButton, QtGui.QDialogButtonBox.ActionRole) buttonBox.addButton(quitButton, QtGui.QDialogButtonBox.RejectRole) submitButton.clicked.connect(self.submit) revertButton.clicked.connect(self.model.revertAll) quitButton.clicked.connect(self.close) mainLayout = QtGui.QHBoxLayout() mainLayout.addWidget(view) mainLayout.addWidget(buttonBox) self.setLayout(mainLayout) self.setWindowTitle("Cached Table")
def __init__(self, parent=None): QtCore.QThread.__init__(self) self.parent = parent self.recordQueue = deque() # Connect to sqlite DB self.db = QtSql.QSqlDatabase.addDatabase("QSQLITE") self.db.setDatabaseName("log.db") self.db.open() self.q = QtSql.QSqlQuery() # Reset table (from last gui execution) self.q.exec_("DROP TABLE IF EXISTS messages") self.q.exec_( "CREATE TABLE messages (timestamp TEXT, component TEXT, verbosity TEXT, message TEXT)" ) # WAS: #self.q.exec_("CREATE TABLE messages (timestamp TEXT PRIMARY KEY, component TEXT, verbosity TEXT, message TEXT)") # But this lead to error inserting batch of Records that have the same # timestamp (logs arriving almost at the same time) self.model = QtSql.QSqlTableModel(None, self.db) self.model.setTable('messages') self.model.setEditStrategy(self.model.OnManualSubmit) self.model.select()
def _loadDatabase(self, fileName): # TODO: probe database for existence and correctness self.database = None self.database = QtSql.QSqlDatabase.addDatabase("QSQLITE") self.database.setHostName("") self.database.setDatabaseName(fileName) self.database.open() self.testrunModel = _oatr_testrun.cTestrunModel(None, self.database) self.testrunModel.setTable('testruns') self.testrunModel.setEditStrategy(QtSql.QSqlTableModel.OnFieldChange) self.testsuiteModel = QtSql.QSqlTableModel(None, self.database) self.testsuiteModel.setTable('testsuites') self.testsuiteModel.select() self.testruninfoModel = QtSql.QSqlTableModel(None, self.database) self.testruninfoModel.setTable('testruninfo') self.testruninfoModel.select() for i in range(self.mainView.count()): self.mainView.widget(i).close() self.testrunDetailView = _oatr_testrun.cTestrunDetailsView( self.mainView, self.testrunModel) self.testsuiteDetailView = _oatr_testsuite.cTestsuiteView( self.mainView, self.testsuiteModel) self.testsuiteDetailView.mapper.toFirst() self.testruninfoDetailView = _oatr_testrun.cTestrunInfoView( self.mainView, self.testruninfoModel) self.testruninfoDetailView.mapper.toFirst() self.tableView = _oatr_tableview.cTestrunTableView( self.mainView, self.testrunModel, self.testrunTableViewSelectionHandler) self.tableView.activated.connect(self.execTestcase) self.tabView = QtGui.QTabWidget(self.mainView) self.tabView.addTab(self.testrunDetailView, self.tr("Testcase")) self.tabView.addTab(self.testsuiteDetailView, self.tr("Testsuite")) self.tabView.addTab(self.testruninfoDetailView, self.tr("Test Run Info")) self.actionsRequiringDatabase.setEnabled(True) self.setWindowTitle( QtCore.QFileInfo(fileName).baseName() + ' - ' + WINTITLE) self.updateStatusBar()
class table(object): def initializeModel(model): model.setTable('People') model.setEditStrategy(QtSql.QSqlTableModel.OnFieldChange) model.select() model.setHeaderData(0, QtCore.Qt.Horizontal, "ID") model.setHeaderData(1, QtCore.Qt.Horizontal, "First name") model.setHeaderData(2, QtCore.Qt.Horizontal, "Last name") model.setHeaderData(2, QtCore.Qt.Horizontal, "Last name") model.setHeaderData(2, QtCore.Qt.Horizontal, "Last name") def createView(title, model): view = QtGui.QTableView() view.setModel(model) view.setWindowTitle(title) return view def addrow(): print model.rowCount() ret = model.insertRows(model.rowCount(), 1) print ret def findrow(i): delrow = i.row() if __name__ == '__main__': app = QtGui.QApplication(sys.argv) db = QtSql.QSqlDatabase.addDatabase('QSQLITE') db.setDatabaseName('Photogeniks.db') model = QtSql.QSqlTableModel() delrow = -1 initializeModel(model) view1 = createView("Table Model (View 1)", model) view1.clicked.connect(findrow) dlg = QtGui.QDialog() layout = QtGui.QVBoxLayout() layout.addWidget(view1) button = QtGui.QPushButton("Add a row") button.clicked.connect(addrow) layout.addWidget(button) btn1 = QtGui.QPushButton("del a row") btn1.clicked.connect( lambda: model.removeRow(view1.currentIndex().row())) layout.addWidget(btn1) btn1 = QtGui.QPushButton("Export to excel") btn1.clicked.connect( lambda: model.removeRow(view1.currentIndex().row())) layout.addWidget(btn1) dlg.setLayout(layout) dlg.setWindowTitle("Database view/update") dlg.show() sys.exit(app.exec_())
def get_presentations_model(self): """Gets the Presentation Table Model. Useful for Qt GUI based Frontends to load the Model in Table Views""" if self.presentationsModel is None: self.presentationsModel = QtSql.QSqlTableModel() self.presentationsModel.setTable("presentations") self.presentationsModel.setEditStrategy(QtSql.QSqlTableModel.OnFieldChange) self.presentationsModel.select() return self.presentationsModel
def read_clicked(self): self.model = QtSql.QSqlTableModel(self, self.db) self.model.setTable("names") self.model.select() self.comboBox_tabel.setModel(self.model) self.comboBox_tabel.setModelColumn(self.model.fieldIndex("name")) self.tableView_db.setModel(self.model) self.tableView_db.show()
def get_failures_model(self): """Gets the Failure reports table Model. Useful for QT GUI based Frontends to load the Model in Table Views""" if self.failuresModel is None: self.failuresModel = QtSql.QSqlTableModel() self.failuresModel.setTable("failures") self.failuresModel.setEditStrategy(QtSql.QSqlTableModel.OnFieldChange) self.failuresModel.select() return self.failuresModel
def get_recentconn_model(self): """Gets the Recent Connections table Model Useful for QT GUI based Frontends to load the Model in Table Views""" self.recentconnModel = QtSql.QSqlTableModel() self.recentconnModel.setTable("recentconn") self.recentconnModel.setEditStrategy(QtSql.QSqlTableModel.OnFieldChange) self.recentconnModel.select() return self.recentconnModel
def __init__(self, parent=None): QObject.__init__(self, parent) self.model = QtSql.QSqlTableModel(self) self.model.setTable("distinctpackets") self.model.sort(0, Qt.DescendingOrder) self.proxy = QtGui.QSortFilterProxyModel() self.proxy.setSourceModel(self.model) self.proxy.setFilterKeyColumn(3) self.proxy.setDynamicSortFilter(True)
def get_data(self): mat_mod = QtSql.QSqlTableModel() mat_mod.setTable('`material`') mat_mod.setEditStrategy(0) if mat_mod.select(): self.material_table.setModel(mat_mod) self.material_table.resizeColumnToContents(1) else: db_err(mat_mod)
def cargarviewadhcofo(self): self.modeladhcofo = QtSql.QSqlTableModel(self) self.modeladhcofo.setTable("adhesivo_coldfoil") listaref = self.cadenadereferencias( DAO.AdhCoFoFicha().leerAdhCoFoEnFicha(self.edicion)) self.modeladhcofo.setFilter("idAdhColdFoil in {0}".format(listaref)) self.modeladhcofo.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) self.modeladhcofo.select() self.ui.viewAdhCofo.setModel(self.modeladhcofo) self.ui.viewAdhCofo.hideColumn(0)
def setupSourceModels(self): self.model = QtSql.QSqlTableModel(self) self.model.setTable("distinctpackets") self.model.sort(0, Qt.DescendingOrder) self.sessionmodel = QtSql.QSqlRelationalTableModel(self) self.sessionmodel.setTable("session") self.sessionmodel.setRelation( 1, QtSql.QSqlRelation("distinctpackets", "ID", "Class")) self.sessionmodel.sort(0, Qt.DescendingOrder)
def cargarviewcoldfoil(self): self.modelcoldfoil = QtSql.QSqlTableModel(self) self.modelcoldfoil.setTable("cold_foil") listaref = self.cadenadereferencias( DAO.ColdFoilFicha().leerColdFoilEnFicha(self.edicion)) self.modelcoldfoil.setFilter("idColdFoil in {0}".format(listaref)) self.modelcoldfoil.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) self.modelcoldfoil.select() self.ui.viewColdFoil.setModel(self.modelcoldfoil) self.ui.viewColdFoil.hideColumn(0) pass
def __init__(self, parent = None): super(CEQueueTypeOrgStructureWidget, self).__init__(parent) self.setupUi(self) self._queueTypeModel = QtSql.QSqlTableModel(self, QtSql.QSqlDatabase.database(generalConnectionName(), open = True)) self._queueTypeModel.setTable(u'rbEQueueType') self._queueTypeModel.select() self._baseOrgStructureId = None self._orgStructureModel = QtSql.QSqlTableModel(self, QtSql.QSqlDatabase.database(generalConnectionName(), open = True)) self._orgStructureModel.setTable(u'OrgStructure') self._orgStructureModel.select() self.cmbQueue.setModel(self._queueTypeModel) self.cmbQueue.setModelColumn(self._queueTypeModel.fieldIndex('name')) self.on_cmbQueue_currentChanged(self.cmbQueue.currentIndex()) self.cmbOrgStructure.setModel(self._orgStructureModel) self.cmbOrgStructure.setModelColumn(self._orgStructureModel.fieldIndex('name'))
def cargarviewtintas(self): self.modelTinta = QtSql.QSqlTableModel(self) self.modelTinta.setTable("tinta") listaref = self.cadenadereferencias(DAO.TintaFicha().leerTintaEnFicha( self.edicion)) self.modelTinta.setFilter("idTinta in {0}".format(listaref)) self.modelTinta.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) self.modelTinta.select() self.ui.viewTintas.setModel(self.modelTinta) self.ui.viewTintas.hideColumn(0) pass
def cargarviewadhlam(self): self.modeladhlam = QtSql.QSqlTableModel(self) self.modeladhlam.setTable("adhesivo_laminacion") listaref = self.cadenadereferencias(DAO.AdhLamFicha().leerAdhLamFicha( self.edicion)) self.modeladhlam.setFilter("idAdhLam in {0}".format(listaref)) self.modeladhlam.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) self.modeladhlam.select() self.ui.viewAdhLam.setModel(self.modeladhlam) self.ui.viewAdhLam.hideColumn(0) pass
def refresh_table(self, Dialog): if (self.db.open()): roommodel = QtSql.QSqlTableModel() roommodel.setTable('room_info') roommodel.select() self.tableView.setModel(roommodel) self.tableView.resizeRowsToContents() self.db.close() else: print("Failed to connect to mysql") print(self.db.lastError().text())
def cargarviewfilmmi(self): self.modelfilmi = QtSql.QSqlTableModel(self) self.modelfilmi.setTable("film_micronaje") listaref = self.cadenadereferencias( DAO.FilmMiFicha().leerFilmMiEnFicha(self.edicion)) self.modelfilmi.setFilter("idFilmMi in {0}".format(listaref)) self.modelfilmi.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) self.modelfilmi.select() self.ui.viewFilmmi.setModel(self.modelfilmi) self.ui.viewFilmmi.hideColumn(0) pass
def cargarviewtbarniz(self): self.modeltbarniz = QtSql.QSqlTableModel(self) self.modeltbarniz.setTable("tipo_barniz") listaref = self.cadenadereferencias( DAO.TBarnizFicha().leerTBarnizEnFicha(self.edicion)) self.modeltbarniz.setFilter("idTBarniz in {0}".format(listaref)) self.modeltbarniz.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) self.modeltbarniz.select() self.ui.viewTipoBarniz.setModel(self.modeltbarniz) self.ui.viewTipoBarniz.hideColumn(0) pass
def cargarviewtroquel(self): self.modeltroquel = QtSql.QSqlTableModel(self) self.modeltroquel.setTable("troquel") listaref = self.cadenadereferencias( DAO.TroquelFicha().leerTroquelEnFicha(self.edicion)) self.modeltroquel.setFilter("idTroquel in {0}".format(listaref)) self.modeltroquel.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) self.modeltroquel.select() self.ui.viewTroquel.setModel(self.modeltroquel) self.ui.viewTroquel.hideColumn(0) pass
def panel(self): self.ui = Ui_MainWindow() self.ui.setupUi(self.MainWindow) self.ui.labelErrorPermitidos.setVisible(False) self.ui.labelErrorDenegados.setVisible(False) self.ui.botonCancelar.clicked.connect(self.salir) self.ui.pushButtonPermitir.clicked.connect(self.agregarPermitido) self.ui.pushButtonDenegar.clicked.connect(self.agregarDenegado) self.ui.botonEliminarPermitido.clicked.connect(self.eliminarPermitido) self.ui.botonEliminarDenegado.clicked.connect(self.eliminarDenegado) self.ui.botonGuardar.clicked.connect(self.refrezcarDominios) self.db = QtSql.QSqlDatabase.addDatabase('QSQLITE') self.db.setDatabaseName(config.PATH_COMMON + '/kerberus.db') self.db.open() # Listo los dominios denegados self.modelPermitidos = QtSql.QSqlTableModel(None, self.db) self.modelPermitidos.setTable("dominios_usuario") # requiere de un submit para que se apliquen los cambios self.modelPermitidos.setEditStrategy(2) self.modelPermitidos.setFilter('estado=1') self.modelPermitidos.select() self.modelPermitidos.setHeaderData(0, 1, "Dominios permitidos") self.ui.tableViewPermitidos.setModel(self.modelPermitidos) self.ui.tableViewPermitidos.hideColumn(1) self.ui.tableViewPermitidos.hideColumn(2) self.ui.tableViewPermitidos.resizeRowsToContents() self.ui.tableViewPermitidos.show() # Listo los dominios denegados self.modelDenegados = QtSql.QSqlTableModel(None, self.db) self.modelDenegados.setTable("dominios_usuario") # requiere de un submit para que se apliquen los cambios self.modelDenegados.setEditStrategy(2) self.modelDenegados.setFilter('estado=2') self.modelDenegados.select() self.modelDenegados.setHeaderData(0, 1, "Dominios permitidos") self.ui.tableViewDenegados.setModel(self.modelDenegados) self.ui.tableViewDenegados.hideColumn(1) self.ui.tableViewDenegados.hideColumn(2) self.ui.tableViewDenegados.resizeRowsToContents() self.ui.tableViewDenegados.show() self.MainWindow.show()