class EditZone(QDialog): def __init__(self, parent=None): QDialog.__init__(self) self.editZone = Ui_editZone() self.editZone.setupUi(self) self.conn = None self.cursor = None self.db = DataBase() self.db.open('dakar.sqlite') self.createTable() self.connect(self.editZone.btnDeleteZone,SIGNAL('clicked()'),self.deleteZone) self.connect(self.editZone.btnAdd,SIGNAL('clicked()'),self.addZone) def deleteZone(self): self.editZone.lnNumZone.setText("1") self.db.deleteZone() self.createTable() def createTable(self): rows = self.db.getZone() self.editZone.tblZone.setRowCount(len(rows)) for i,table in enumerate(rows): for m,data in enumerate(table): if m != 0: self.editZone.tblZone.setItem(i,m - 1,QTableWidgetItem(str(data))) self.editZone.tblZone.resizeColumnsToContents() self.editZone.tblZone.resizeRowsToContents() pass def addZone(self): valueZone = self.editZone.lnZone.text() numZone = self.editZone.lnNumZone.text() tmpZone = int(numZone) + 1 self.db.insertZone(numZone,valueZone) self.editZone.lnNumZone.setText(str(tmpZone)) self.editZone.lnZone.setText("") self.createTable()