1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| try:
insert_breakdown=[None]*10
insert_breakdown[0]=self.toolQRcode.text()
insert_breakdown[1]=self.dateTimeEdit.text()
insert_breakdown[2]=self.ComboLine.currentText()
insert_breakdown[3]=self.ComboCell.currentText()
insert_breakdown[4]=self.ComboToollocation.currentText()
insert_breakdown[5]=self.ComboIntervenant.currentText()
insert_breakdown[6]=self.commentaire.toPlainText()
insert_breakdown[7]=BreakDownState
insert_breakdown[8]=''
insert_breakdown[9]=self.ComboToolIn.currentText()
print(insert_breakdown)
self.cursor.execute('INSERT INTO breakdown (ID_TOOL, sDATE, ID_LINE, ID_CELL, POSITION, ID_INTERVENANT, COMMENT, BREAKDOWN_STATE, ID_TOOL_NEW, ID_TOOL_NEW_NAME) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)', insert_breakdown)
except sqlite3.Error:
self.logger.log(logging.WARNING, "Error during saving datas into db") |
Partager