PyQt Combobox with QtGui.QDataWidgetMapper not saving key to database



  • I have a MySQL database with two 2 tables. The one table (movie) containing a foreign key to the other table (category).

    I have setup the code and the record is inserted in the main table but with the foreign key field set to null. It does not insert the value from the combobox. A description is displayed from the category table and the category Id must be saved in the main table

    Below is my code. The dialog is set up in Qt Desginer. Can somebody maybe spot the problem?

    import sys
    from moviewindow import *
    from PyQt4 import QtSql, QtGui

    def createConnection():
    db = QtSql.QSqlDatabase.addDatabase('QMYSQL')
    db.setHostName('localhost')
    db.setDatabaseName('movies')
    db.setUserName('root')
    db.setPassword('mce')
    db.open()
    print (db.lastError().text())
    return True

    class MyForm(QtGui.QDialog):
    def init(self, parent=None):
    QtGui.QWidget.init(self, parent)
    self.ui = Ui_Dialog()
    self.ui.setupUi(self)
    self.model = QtSql.QSqlRelationalTableModel(self)
    self.model.setTable('movie')
    self.model.setRelation(self.model.fieldIndex("movie_category_id"),QtSql.QSqlRelation("movie_category","category_id","category_desc"))
    self.model.select();
    self.mapper = QtGui.QDataWidgetMapper(self)
    self.mapper.setSubmitPolicy(QtGui.QDataWidgetMapper.ManualSubmit)
    self.mapper.setModel(self.model)

        self.mapper.setItemDelegate(QtSql.QSqlRelationalDelegate(self))
    
        self.mapper.addMapping(self.ui.lineEdit_Movietitle,self.model.fieldIndex("movie_title"))
        self.mapper.addMapping(self.ui.spinBox_Year,self.model.fieldIndex("movie_year"))
        self.mapper.addMapping(self.ui.lineEdit_Location,self.model.fieldIndex("movie_location"))
        
        
        relationModel = self.model.relationModel(4)
        self.ui.comboBox_Category.setModel(relationModel)
        self.ui.comboBox_Category.setModelColumn(relationModel.fieldIndex("category_desc"))
        self.mapper.addMapping(self.ui.comboBox_Category,self.model.fieldIndex("movie_category_id"))
                
        self.mapper.toFirst()
    
        QtCore.QObject.connect(self.ui.pushButton_First, QtCore.SIGNAL('clicked()'), self.goto_First)
        QtCore.QObject.connect(self.ui.pushButton_Last, QtCore.SIGNAL('clicked()'), self.goto_Last)
        QtCore.QObject.connect(self.ui.pushButton_Prior, QtCore.SIGNAL('clicked()'), self.goto_Prior)
        QtCore.QObject.connect(self.ui.pushButton_Next, QtCore.SIGNAL('clicked()'), self.goto_Next)
        QtCore.QObject.connect(self.ui.pushButton_Quit, QtCore.SIGNAL('clicked()'), self.accept)
        QtCore.QObject.connect(self.ui.pushButton_Add, QtCore.SIGNAL('clicked()'), self.add_Record)
        QtCore.QObject.connect(self.ui.pushButton_Delete, QtCore.SIGNAL('clicked()'), self.delete_Record)
    
        QtCore.QObject.connect(self.ui.pushButton_Save, QtCore.SIGNAL('clicked()'), self.save_Record)
    
        self.ui.comboBox_Category.currentIndexChanged.connect(lambda: self.mapper.itemDelegate().commitData.emit(self.ui.comboBox_Category))
        
    def save_Record(self):
        self.mapper.submit()
        self.model.submitAll()
    
    def delete_Record(self):
        row = self.mapper.currentIndex()
        self.model.removeRow(row)
        self.model.submitAll()
        if row + 1 >= self.model.rowCount():
            row = self.model.rowCount()-1
        self.mapper.setCurrentIndex(row)
        
    def add_Record(self):
        row = self.model.rowCount()
        self.mapper.submit()
        self.model.submitAll()
        self.model.insertRow(row)
        self.mapper.setCurrentIndex(row)
    
        self.ui.comboBox_Category.setCurrentIndex(self.ui.comboBox_Category.findText("Unresolved"))
        
        self.ui.lineEdit_Movietitle.setFocus()
     
    def accept(self):
        self.mapper.submit()
        self.model.submitAll()
        QtGui.QDialog.accept(self)
        
    def goto_First(self):
        self.mapper.toFirst()
    
    def goto_Last(self):
        self.mapper.toLast()
    
    def goto_Prior(self):
        self.mapper.toPrevious()
    
    def goto_Next(self):
        self.mapper.toNext()
    

    if name == "main":
    app = QtGui.QApplication(sys.argv)
    if not createConnection():
    sys.exit(1)
    myapp = MyForm()
    myapp.show()
    sys.exit(app.exec_())



  • By default a QComboBox reads and saves its currentText property when being mapped to a data model column. I wonder if this is causing your problem?


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.