Hi all,
Is it possible to get the insert &/or update query statement from a
QSqlRelationalTableModel's submitAll() operation?
I'm looking for a way to get the query string from a table model's
submitAll() method when a user invokes it to save data back to the
database. I've found QSqlQuery.lastQuery() returns a select
statement, even when the last apparent operation was writing data back
to the database. eg:
modelErr = self.theModel.submitAll()
theQuery = self.theModel.query()
print "query: ", theQuery.lastQuery()
This yields:
SELECT "color_id", "name", "description" FROM "color" ORDER BY
"color"."name" ASC
rather than the data write statement I'm looking for, eg:
UPDATE color SET name = 'foo'
See the attached sample program for an example, especially line 121 in
the saveRecord() method.
Thanks in advance for any suggestions,
Scott
#!/usr/bin/env python
def createData():
print "createData() ..."
query = QtSql.QSqlQuery()
query.exec_("DROP TABLE color")
query.exec_("""CREATE TABLE color (
color_id PRIMARY KEY,
name VARCHAR(32) UNIQUE NOT NULL,
description TEXT NOT NULL)""")
query.exec_("INSERT INTO color (name, description) "
"VALUES ('red', 'this is red')")
query.exec_("INSERT INTO color (name, description) "
"VALUES ('green', 'this is green')")
query.exec_("INSERT INTO color (name, description) "
"VALUES ('blue', 'this is blue')")
import sys
from PyQt4 import QtCore, QtGui, QtSql
MAC = "qt_mac_set_native_menubar" in dir()
ID, NAME, DESC = range(3)
class DataWidgetMapperTest(QtGui.QDialog):
def __init__(self, parent=None):
QtGui.QDialog.__init__(self)
self.theFrame = QtGui.QFrame()
self.theFrame.setFrameStyle(QtGui.QFrame.StyledPanel|QtGui.QFrame.Sunken)
self.nameGroup = QtGui.QGroupBox()
self.nameLabel = QtGui.QLabel(self.tr("Name"))
self.nameEdit = QtGui.QLineEdit()
self.descLabel = QtGui.QLabel(self.tr("Description"))
self.descEdit = QtGui.QLineEdit()
self.nameLayout = QtGui.QGridLayout()
self.nameLayout.addWidget(self.nameLabel, 0, 0)
self.nameLayout.addWidget(self.nameEdit, 0, 1)
self.nameLayout.addWidget(self.descLabel, 1, 0)
self.nameLayout.addWidget(self.descEdit, 1, 1)
self.nameGroup.setLayout(self.nameLayout)
# data model
self.theModel = QtSql.QSqlTableModel(self)
self.theModel.setTable("color")
self.theModel.setSort(NAME, QtCore.Qt.AscendingOrder)
self.theModel.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit)
self.theModel.setHeaderData(ID, QtCore.Qt.Horizontal, QtCore.QVariant("ID"))
self.theModel.setHeaderData(NAME, QtCore.Qt.Horizontal, QtCore.QVariant("NAME"))
self.theModel.setHeaderData(DESC, QtCore.Qt.Horizontal, QtCore.QVariant("DESC"))
select = self.theModel.select()
# data widget mapper
self.mapper = QtGui.QDataWidgetMapper(self)
self.mapper.setSubmitPolicy(QtGui.QDataWidgetMapper.ManualSubmit)
self.mapper.setModel(self.theModel)
self.mapper.addMapping(self.nameEdit, NAME)
self.mapper.addMapping(self.descEdit, DESC)
self.mapper.toFirst()
# buttons
self.newButton = QtGui.QPushButton("New")
self.delButton = QtGui.QPushButton("Delete")
self.delButton.setEnabled(False)
self.commitButton = QtGui.QPushButton("Commit")
if not MAC:
self.newButton.setFocusPolicy(QtCore.Qt.NoFocus)
self.delButton.setFocusPolicy(QtCore.Qt.NoFocus)
self.commitButton.setFocusPolicy(QtCore.Qt.NoFocus)
self.buttonGroup = QtGui.QGroupBox()
self.buttonLayout = QtGui.QHBoxLayout()
self.buttonLayout.addStretch()
self.buttonLayout.addWidget(self.newButton)
self.buttonLayout.addWidget(self.delButton)
self.buttonLayout.addWidget(self.commitButton)
self.buttonLayout.addStretch()
self.buttonGroup.setLayout(self.buttonLayout)
# main layout
self.widgetLayout = QtGui.QVBoxLayout()
self.widgetLayout.addWidget(self.nameGroup)
self.widgetLayout.addWidget(self.buttonGroup)
self.widgetLayout.addStretch()
self.formLayout = QtGui.QHBoxLayout()
self.formLayout.addLayout(self.widgetLayout)
self.theFrame.setLayout(self.formLayout)
self.theLayout = QtGui.QVBoxLayout()
self.theLayout.addWidget(self.theFrame)
self.setLayout(self.theLayout)
# signals/slots
self.connect(self.newButton, QtCore.SIGNAL("clicked()"), self.newRecord)
self.connect(self.commitButton, QtCore.SIGNAL("clicked()"), self.saveRecord)
# methods
def saveRecord(self):
row = self.mapper.currentIndex()
submit = self.mapper.submit()
self.mapper.setCurrentIndex(row)
modelErr = self.theModel.submitAll()
# get query string from the model
theQuery = self.theModel.query()
print "query: ", theQuery.lastQuery()
def newRecord(self):
row = self.theModel.rowCount()
submit = self.mapper.submit()
self.theModel.insertRow(row)
self.mapper.setCurrentIndex(row)
self.nameEdit.setFocus()
# main
if __name__ == "__main__":
app = QtGui.QApplication(sys.argv)
db = QtSql.QSqlDatabase.addDatabase("QSQLITE")
db.setDatabaseName(":memory:")
if not db.open():
QtGui.QMessageBox.warning(None, "Foo",
QtCore.QString("Database Error: %1").arg(db.lastError().text()))
sys.exit(1)
ok = db.open()
# print "db connection: ", ok
createData()
form = DataWidgetMapperTest()
form.setWindowTitle("Data Widget Mapper Test")
form.show()
sys.exit(app.exec_())
_______________________________________________
PyQt mailing list PyQt@riverbankcomputing.com
http://www.riverbankcomputing.com/mailman/listinfo/pyqt
