[PyQt] OnManualSubmit + insertRows: EditRole and DisplayRole = QVariant.Invalid?

[sbremal at hotmail.com]

Thanks for the quick reply. Here is a small rewrite (extension) of "connection.py". If you comment out the line "m.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit)" then it is all fine, otherwise the custom editor widget for "int" is not picked by the Q table.
 
Any idea?
 
 
Cheers,
B.
 
---
 
connection.py
 
#!/bin/env python
import os
import sys
############################################################################
##
## Copyright (C) 2004-2005 Trolltech AS. All rights reserved.
##
## This file is part of the example classes of the Qt Toolkit.
##
## This file may be used under the terms of the GNU General Public
## License version 2.0 as published by the Free Software Foundation
## and appearing in the file LICENSE.GPL included in the packaging of
## this file.  Please review the following information to ensure GNU
## General Public Licensing requirements will be met:
## http://www.trolltech.com/products/qt/opensource.html
##
## If you are unsure which license is appropriate for your use, please
## review the following information:
## http://www.trolltech.com/products/qt/licensing.html or contact the
## sales department at sales at trolltech.com.
##
## This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE
## WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
##
############################################################################
from PyQt4 import QtSql, QtGui, QtCore

def createConnection():
    db = QtSql.QSqlDatabase.addDatabase("QSQLITE")
    db.setDatabaseName(":memory:")
    if not db.open():
        QtGui.QMessageBox.critical(None, QtGui.qApp.tr("Cannot open database"),
                QtGui.qApp.tr("Unable to establish a database connection.\n"
                              "This example needs SQLite support. Please read "
                              "the Qt SQL driver documentation for information "
                              "how to build it.\n\n"
                              "Click Cancel to exit."),
                QtGui.QMessageBox.Cancel)
        return False
    
    query = QtSql.QSqlQuery()
    query.exec_("create table person(id int primary key, "
                "firstname varchar(20), lastname varchar(20))")
    query.exec_("insert into person values(101, 'Danny', 'Young')")
    query.exec_("insert into person values(102, 'Christine', 'Holand')")
    query.exec_("insert into person values(103, 'Lars', 'Gordon')")
    query.exec_("insert into person values(104, 'Roberto', 'Robitaille')")
    query.exec_("insert into person values(105, 'Maria', 'Papadopoulos')")
    query.exec_("create table offices (id int primary key,"
                                             "imagefile int,"
                                             "location varchar(20),"
                                             "country varchar(20),"
                                             "description varchar(100))");
    query.exec_("insert into offices "
               "values(0, 0, 'Oslo', 'Norway',"
               "'Oslo is home to more than 500 000 citizens and has a "
               "lot to offer.It has been called \"The city with the big "
               "heart\" and this is a nickname we are happy to live up to.')")
    query.exec_("insert into offices "
               "values(1, 1, 'Brisbane', 'Australia',"
               "'Brisbane is the capital of Queensland, the Sunshine State, "
               "where it is beautiful one day, perfect the next.  "
               "Brisbane is Australia''s 3rd largest city, being home "
               "to almost 2 million people.')")
    query.exec_("insert into offices "
               "values(2, 2, 'Redwood City', 'US',"
               "'You find Redwood City in the heart of the Bay Area "
               "just north of Silicon Valley. The largest nearby city is "
               "San Jose which is the third largest city in California "
               "and the 10th largest in the US.')")
    query.exec_("insert into offices "
               "values(3, 3, 'Berlin', 'Germany',"
               "'Berlin, the capital of Germany is dynamic, cosmopolitan "
               "and creative, allowing for every kind of lifestyle. "
               "East meets West in the metropolis at the heart of a "
               "changing Europe.')")
    query.exec_("insert into offices "
               "values(4, 4, 'Munich', 'Germany',"
               "'Several technology companies are represented in Munich, "
               "and the city is often called the \"Bavarian Silicon Valley\". "
               "The exciting city is also filled with culture, "
               "art and music. ')")
    query.exec_("insert into offices "
               "values(5, 5, 'Beijing', 'China',"
               "'Beijing as a capital city has more than 3000 years of "
               "history. Today the city counts 12 million citizens, and "
               "is the political, economic and cultural centre of China.')")
    query.exec_("create table images (locationid int, file varchar(20))")
    query.exec_("insert into images values(0, 'images/oslo.png')")
    query.exec_("insert into images values(1, 'images/brisbane.png')")
    query.exec_("insert into images values(2, 'images/redwood.png')")
    query.exec_("insert into images values(3, 'images/berlin.png')")
    query.exec_("insert into images values(4, 'images/munich.png')")
    query.exec_("insert into images values(5, 'images/beijing.png')")
    return True
class Line_editor_creator(QtGui.QItemEditorCreatorBase):
 def createWidget(self, parent):
  return QtGui.QLineEdit(parent)
class X(QtGui.QMainWindow):
 def __init__(self, parent = None):
  QtGui.QMainWindow.__init__(self, parent)
  line_editor_creator = Line_editor_creator()
  item_editor_factory = QtGui.QItemEditorFactory()
  item_editor_factory.registerEditor(QtCore.QVariant.Int, line_editor_creator)
  QtGui.QItemEditorFactory.setDefaultFactory(item_editor_factory)
  m = QtSql.QSqlTableModel()
  #
  # With "OnManualSubmit" the below "prints" show:
  #   qlonglong
  #   qlonglong
  #   None
  #   None  
  #
  # With default "OnRowChange":
  #    qlonglong
  #    qlonglong
  #    int
  #    int
  #
  m.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit)
  m.setTable('offices')
  v = QtGui.QTableView()
  v.setModel(m)
  r = QtSql.QSqlRelationalDelegate(v)
  v.setItemDelegate(r)
  m.select()
  self.setCentralWidget(v)
  i = m.rowCount()
  m.insertRow(i)
  print(m.data(m.index(i - 1, 0), QtCore.Qt.DisplayRole).typeName())
  print(m.data(m.index(i - 1, 0), QtCore.Qt.EditRole).typeName())
  print(m.data(m.index(i, 0), QtCore.Qt.DisplayRole).typeName())
  print(m.data(m.index(i, 0), QtCore.Qt.EditRole).typeName())
if __name__ == "__main__":
 a = QtGui.QApplication(sys.argv)
 createConnection()
 x = X()
 x.showMaximized()
 sys.exit(a.exec_())

----------------------------------------
> From: hpj at urpla.net
> To: pyqt at riverbankcomputing.com
> Date: Thu, 25 Nov 2010 21:08:36 +0100
> Subject: Re: [PyQt] OnManualSubmit + insertRows: EditRole and DisplayRole = QVariant.Invalid?
>
> On Thursday 25 November 2010, 17:57:09 sbremal at hotmail.com wrote:
> > Hello,
> >
> > With OnManualSubmit on QSqlTableModel using the insertRows function
> > the cell roles for EditRole and DisplayRole is not set properly.
> > Actually they seem to remain uninitialized and have the value
> > QVariant.Invalid. This causes my table editors to behave stange (but
> > only for new rows).
> >
> > With OnRowChange it is all fine.
>
> The usual "please provide a minimum runnable example" applies here too..
>
> You may base it on examples/connection.py for database setup.
>
> Pete
> _______________________________________________
> PyQt mailing list PyQt at riverbankcomputing.com
> http://www.riverbankcomputing.com/mailman/listinfo/pyqt