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