[PyQt] QSqlQueryModel write subclass
info at linos.es
Fri Oct 12 00:03:21 BST 2007
i am trying to subclass QSqlQueryModel to write with it, i need this because not qsqltablemodel or
qsqlrelationaltablemodel fills my needs, i would like to do joins and insert in multiple tables, i have
implemented "flags" and "setData" methods and it works ok now, i have made a "refresh" method to reload the
contents on update because tableView not reload them with datachanged signal and all works ok but now i am
trying to implement insertrow or insertrows without luck, this is the code i am using now:
this in model:
def insertRows(self, position, rows=1, index=QModelIndex()):
self.beginInsertRows(QModelIndex(), position, position + rows - 1)
setdataquery = QSqlQuery(self.cursor)
setdataquery.exec_(QString("INSERT INTO SCHEMA.FAKE (FAKE1, FAKE2, FAKE3) VALUES (4, 2, 'PEPITO')"))
self.dirty = True
this in qdialog:
row = self.querymodel.rowCount()
index = self.querymodel.index(row, 0)
After execute this method i can view the new row in table view but i get this in stdout.
edit: index was invalid
edit: editing failed
I have test the row number rowCount() assign and it is ok, i dont know how to fix this, anyone can help me please?
PD: I get original snippet and the idea about subclass QSqlQueryModel in the really excellent book "Rapid GUI
Development with Python-PyQT".
More information about the PyQt