1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| class Table:
def __init__(self):
self.createConnection()
self.model=QtSql.QSqlTableModel()
self.initialiseModel(self.model)
def initialiseModel(self,model):
# pour afficher une table
self.model.setTable("com")
self.model.setEditStrategy(QtSql.QSqlTableModel.OnRowChange)
self.model.setSort(0,QtCore.Qt.SortOrder(0))
self.model.select()
return self.model
def createConnection(self):
self.con1 = psycopg.connect('host=localhost port=5432 dbname=stat user=postgres password=admin')
return self.con1
tableView = QtGui.QTableView()
table=Table()
tableView.setModel(table.model)
tableView.show() |
Partager