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