def setupModel(self):
u"""Définit et configure le modèle sous-jacent à la table"""
self._modele = QSqlTableModel(self)
self._modele.setTable("intervenant")
self._modele.setHeaderData(1, Qt.Horizontal, "Nom")
self._modele.setHeaderData(2, Qt.Horizontal, u"Téléphone")
self._modele.setHeaderData(3, Qt.Horizontal, "Email")
self._modele.setEditStrategy(QSqlTableModel.OnFieldChange)
self._modele.select()
self._ui.tv.setModel(self._modele)
def __init__(self, parent=None):
super(MainWindow, self).__init__(parent)
database = QSqlDatabase.addDatabase('QSQLITE')
database.setDatabaseName(
'astatsscraper.db') # Better lookup logic needed
if not database.open():
print('Error opening database!')
model = QSqlTableModel(db=database)
model.setTable('steam_apps')
table = QTableView()
table.setEditTriggers(QAbstractItemView.NoEditTriggers)
table.setModel(model)
self.setCentralWidget(table)
table.show()
def InitTable(self):
"""Funzione che accede al database ed imposta il data model"""
db = QSqlDatabase.addDatabase("QSQLITE")
db.setDatabaseName(self.myWidget.txtPercorso.text())
db.open()
model = QSqlTableModel()
model.setTable("contatti")
model.setEditStrategy(QSqlTableModel.OnManualSubmit)
model.select()
model.setHeaderData(0, QtCore.Qt.Horizontal, "Nome")
model.setHeaderData(1, QtCore.Qt.Horizontal, "Cognome")
model.setHeaderData(2, QtCore.Qt.Horizontal, "Telefono")
self.tableModel = model
self.myWidget.lstRubrica.setModel(model)
