1 files changed, 137 insertions, 0 deletions
diff --git a/sources/pyside2/doc/tutorials/portingguide/chapter3/bookwindow.py b/sources/pyside2/doc/tutorials/portingguide/chapter3/bookwindow.py
new file mode 100644
index 000000000..4bc4cf48b
--- /dev/null
+++ b/sources/pyside2/doc/tutorials/portingguide/chapter3/bookwindow.py
@@ -0,0 +1,137 @@
+#############################################################################
+##
+## Copyright (C) 2019 The Qt Company Ltd.
+## Contact: http://www.qt.io/licensing/
+##
+## This file is part of the Qt for Python examples of the Qt Toolkit.
+##
+## $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 The Qt Company Ltd 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 __future__ import print_function, absolute_import
+
+from PySide2.QtWidgets import (QAction, QAbstractItemView, qApp, QDataWidgetMapper,
+    QHeaderView, QMainWindow, QMessageBox)
+from PySide2.QtGui import QKeySequence
+from PySide2.QtSql import (QSqlRelation, QSqlRelationalTableModel, QSqlTableModel,
+    QSqlError)
+from PySide2.QtCore import QAbstractItemModel, QObject, QSize, Qt, Slot
+import createdb
+from ui_bookwindow import Ui_BookWindow
+from bookdelegate import BookDelegate
+
+
+class BookWindow(QMainWindow, Ui_BookWindow):
+    # """A window to show the books available"""
+
+    def __init__(self):
+        QMainWindow.__init__(self)
+        self.setupUi(self)
+
+        #Initialize db
+        createdb.init_db()
+
+        model = QSqlRelationalTableModel(self.bookTable)
+        model.setEditStrategy(QSqlTableModel.OnManualSubmit)
+        model.setTable("books")
+
+        # Remember the indexes of the columns:
+        author_idx = model.fieldIndex("author")
+        genre_idx = model.fieldIndex("genre")
+
+        # Set the relations to the other database tables:
+        model.setRelation(author_idx, QSqlRelation("authors", "id", "name"))
+        model.setRelation(genre_idx, QSqlRelation("genres", "id", "name"))
+
+        # Set the localized header captions:
+        model.setHeaderData(author_idx, Qt.Horizontal, self.tr("Author Name"))
+        model.setHeaderData(genre_idx, Qt.Horizontal, self.tr("Genre"))
+        model.setHeaderData(model.fieldIndex("title"), Qt.Horizontal, self.tr("Title"))
+        model.setHeaderData(model.fieldIndex("year"), Qt.Horizontal, self.tr("Year"))
+        model.setHeaderData(model.fieldIndex("rating"), Qt.Horizontal, self.tr("Rating"))
+
+        if not model.select():
+            print(model.lastError())
+
+        # Set the model and hide the ID column:
+        self.bookTable.setModel(model)
+        self.bookTable.setItemDelegate(BookDelegate(self.bookTable))
+        self.bookTable.setColumnHidden(model.fieldIndex("id"), True)
+        self.bookTable.setSelectionMode(QAbstractItemView.SingleSelection)
+
+        # Initialize the Author combo box:
+        self.authorEdit.setModel(model.relationModel(author_idx))
+        self.authorEdit.setModelColumn(model.relationModel(author_idx).fieldIndex("name"))
+
+        self.genreEdit.setModel(model.relationModel(genre_idx))
+        self.genreEdit.setModelColumn(model.relationModel(genre_idx).fieldIndex("name"))
+
+        # Lock and prohibit resizing of the width of the rating column:
+        self.bookTable.horizontalHeader().setSectionResizeMode(model.fieldIndex("rating"),
+            QHeaderView.ResizeToContents)
+
+        mapper = QDataWidgetMapper(self)
+        mapper.setModel(model)
+        mapper.setItemDelegate(BookDelegate(self))
+        mapper.addMapping(self.titleEdit, model.fieldIndex("title"))
+        mapper.addMapping(self.yearEdit, model.fieldIndex("year"))
+        mapper.addMapping(self.authorEdit, author_idx)
+        mapper.addMapping(self.genreEdit, genre_idx)
+        mapper.addMapping(self.ratingEdit, model.fieldIndex("rating"))
+
+        selection_model = self.bookTable.selectionModel()
+        selection_model.currentRowChanged.connect(mapper.setCurrentModelIndex)
+
+        self.bookTable.setCurrentIndex(model.index(0, 0))
+        self.create_menubar()
+
+    def showError(err):
+        QMessageBox.critical(self, "Unable to initialize Database",
+                    "Error initializing database: " + err.text())
+
+    def create_menubar(self):
+        file_menu = self.menuBar().addMenu(self.tr("&File"))
+        quit_action = file_menu.addAction(self.tr("&Quit"))
+        quit_action.triggered.connect(qApp.quit)
+
+        help_menu = self.menuBar().addMenu(self.tr("&Help"))
+        about_action = help_menu.addAction(self.tr("&About"))
+        about_action.setShortcut(QKeySequence.HelpContents)
+        about_action.triggered.connect(self.about)
+        aboutQt_action = help_menu.addAction("&About Qt")
+        aboutQt_action.triggered.connect(qApp.aboutQt)
+
+    def about(self):
+        QMessageBox.about(self, self.tr("About Books"),
+            self.tr("<p>The <b>Books</b> example shows how to use Qt SQL classes "
+                "with a model/view framework."))