text: #!/usr/bin/env python
  
  
  #############################################################################
  ##
  ## Copyright (C) 2010 Riverbank Computing Limited.
  ## Copyright (C) 2010 Nokia Corporation and/or its subsidiary(-ies).
  ## All rights reserved.
  ##
  ## This file is part of the examples of PyQt.
  ##
  ## $QT_BEGIN_LICENSE:BSD$
  ## You may use this file under the terms of the BSD license as follows:
  ##
  ## "Redistribution and use in source and binary forms, with or without
  ## modification, are permitted provided that the following conditions are
  ## met:
  ##   * Redistributions of source code must retain the above copyright
  ##     notice, this list of conditions and the following disclaimer.
  ##   * Redistributions in binary form must reproduce the above copyright
  ##     notice, this list of conditions and the following disclaimer in
  ##     the documentation and/or other materials provided with the
  ##     distribution.
  ##   * Neither the name of Nokia Corporation and its Subsidiary(-ies) nor
  ##     the names of its contributors may be used to endorse or promote
  ##     products derived from this software without specific prior written
  ##     permission.
  ##
  ## THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
  ## "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
  ## LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
  ## A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
  ## OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
  ## SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
  ## LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
  ## DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
  ## THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  ## (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
  ## OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE."
  ## $QT_END_LICENSE$
  ##
  #############################################################################
  
  
  from PyQt4 import QtCore, QtGui, QtSql
  
  import connection
  
  
  def initializeModel(model):
      model.setTable('person')
  
      model.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit)
      model.select()
  
      model.setHeaderData(0, QtCore.Qt.Horizontal, "ID")
      model.setHeaderData(1, QtCore.Qt.Horizontal, "First name")
      model.setHeaderData(2, QtCore.Qt.Horizontal, "Last name")
  
  
  def createView(title, model):
      view = QtGui.QTableView()
      view.setModel(model)
      view.setWindowTitle(title)
      return view
  
  
  if __name__ == '__main__':
  
      import sys
  
      app = QtGui.QApplication(sys.argv)
      if not connection.createConnection():
          sys.exit(1)
  
      model = QtSql.QSqlTableModel()
  
      initializeModel(model)
  
      view1 = createView("Table Model (View 1)", model)
      view2 = createView("Table Model (View 2)", model)
  
      view1.show()
      view2.move(view1.x() + view1.width() + 20, view1.y())
      view2.show()
  
      sys.exit(app.exec_())
  