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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65
|
class fenetre_hypothese(QtGui.QDialog, Ui_Hypthese):
def __init__(self, parent=None):
QtGui.QWidget.__init__(self, parent)
self.ui = Ui_Hypthese()
self.ui.setupUi(self)
QtCore.QObject.connect(self.ui.afficher_h,QtCore.SIGNAL("clicked(bool)"),self.afficher_hf_clicked)
QtCore.QObject.connect(self.ui.sauvegarder_h,QtCore.SIGNAL("clicked(bool)"),self.sauvgarder_hf_clicked)
#***insertion et affichage des hypothèses
def afficher_hf_clicked(self):
id_h = self.ui.lineEdit_HFZ_ID.text()
zone = self.ui.lineEdit_HFZ.text()
fd = self.ui.lineEdit_HFF.text()
opex = self.ui.lineEdit_HFO.text()
milieu = self.ui.lineEdit_HFM.text()
capex = self.ui.lineEdit_HFC.text()
self.ui.tableWidget.setRowCount(6)
self.ui.tableWidget.setColumnCount(6)
self.ui.tableWidget.setHorizontalHeaderLabels(("ID_H;ZONE;FD;OPEX;MILIEU;CAPEX").split(";"))
item0 = QtGui.QTableWidgetItem(id_h)
self.ui.tableWidget.setItem(0,0, item0)
item1 = QtGui.QTableWidgetItem(zone)
self.ui.tableWidget.setItem(0,1, item1)
item2 =QtGui.QTableWidgetItem(fd)
self.ui.tableWidget.setItem(0,2, item2)
item3 =QtGui.QTableWidgetItem(opex)
self.ui.tableWidget.setItem(0,3, item3)
item4 =QtGui.QTableWidgetItem(milieu)
self.ui.tableWidget.setItem(0,4, item4)
item5 =QtGui.QTableWidgetItem(capex)
self.ui.tableWidget.setItem(0,5, item5)
#***sauvegarde des hypothese dans la BD
def sauvgarder_hf_clicked(self):
cnx = mysql.connector.connect(user='root', password='',
host='localhost',
database='testdb')
cursor = cnx.cursor()
rows =self.ui.tableWidget.rowCount()
columns = self.ui.tableWidget.columnCount()
hypothese = list()
for i in range(rows):
id_hypoth =(self.ui.tableWidget.item(i,0)).text()
zone =(self.ui.tableWidget.item(i,1)).text()
fd =(self.ui.tableWidget.item(i,2)).text()
opex =(self.ui.tableWidget.item(i,3)).text()
milieu =(self.ui.tableWidget.item(i,4)).text()
capex =(self.ui.tableWidget.item(i,5)).text()
#for
insert_hyp= ("INSERT INTO hypothese "
"(ID_HYP, ZONE, FD, OPEX, MILIEU, CAPEX)"
"VALUES (%s, %s, %s, %s, %s, %s)")
data_hyp = (id_hypoth, zone, fd, opex, milieu, capex)
cursor.execute(insert_hyp, data_hyp)
cnx.commit()
cursor.close()
cnx.close() |
Partager