QML, SQL and PySide Integration Tutorial#

This tutorial is very similar to the Qt Chat Tutorial one but it focuses on explaining how to integrate a SQL database into a PySide6 application using QML for its UI.


We import the pertinent libraries to our program, define a global variable that hold the name of our table, and define the global function createTable() that creates a new table if it doesn’t already exist. The database contains a single line to mock the beginning of a conversation.

 2import datetime
 3import logging
 5from PySide6.QtCore import Qt, Slot
 6from PySide6.QtSql import QSqlDatabase, QSqlQuery, QSqlRecord, QSqlTableModel
 7from PySide6.QtQml import QmlElement
 9table_name = "Conversations"
10QML_IMPORT_NAME = "ChatModel"
14def createTable():
15    if table_name in QSqlDatabase.database().tables():
16        return
18    query = QSqlQuery()
19    if not query.exec_(
20        """
21        CREATE TABLE IF NOT EXISTS 'Conversations' (
22            'author' TEXT NOT NULL,
23            'recipient' TEXT NOT NULL,
24            'timestamp' TEXT NOT NULL,
25            'message' TEXT NOT NULL,
26        FOREIGN KEY('author') REFERENCES Contacts ( name ),
27        FOREIGN KEY('recipient') REFERENCES Contacts ( name )
28        )
29        """
30    ):
31        logging.error("Failed to query database")
33    # This adds the first message from the Bot
34    # and further development is required to make it interactive.
35    query.exec_(
36        """
37        INSERT INTO Conversations VALUES(
38            'machine', 'Me', '2019-01-07T14:36:06', 'Hello!'
39        )
40        """

The SqlConversationModel class offers the read-only data model required for the non-editable contacts list. It derives from the QSqlQueryModel class, which is the logical choice for this use case. Then, we proceed to create the table, set its name to the one defined previously with the setTable() method. We add the necessary attributes to the table, to have a program that reflects the idea of a chat application.

 3class SqlConversationModel(QSqlTableModel):
 4    def __init__(self, parent=None):
 5        super(SqlConversationModel, self).__init__(parent)
 7        createTable()
 8        self.setTable(table_name)
 9        self.setSort(2, Qt.DescendingOrder)
10        self.setEditStrategy(QSqlTableModel.OnManualSubmit)
11        self.recipient = ""
13        self.select()

In setRecipient(), you set a filter over the returned results from the database, and emit a signal every time the recipient of the message changes.

 2    def setRecipient(self, recipient):
 3        if recipient == self.recipient:
 4            pass
 6        self.recipient = recipient
 8        filter_str = (f"(recipient = '{self.recipient}' AND author = 'Me') OR "
 9                      f"(recipient = 'Me' AND author='{self.recipient}')")
10        self.setFilter(filter_str)

The data() function falls back to QSqlTableModel’s implementation if the role is not a custom user role. If you get a user role, we can subtract UserRole() from it to get the index of that field, and then use that index to find the value to be returned.

2    def data(self, index, role):
3        if role < Qt.UserRole:
4            return QSqlTableModel.data(self, index, role)
6        sql_record = QSqlRecord()
7        sql_record = self.record(index.row())

In roleNames(), we return a Python dictionary with our custom role and role names as key-values pairs, so we can use these roles in QML. Alternatively, it can be useful to declare an Enum to hold all of the role values. Note that names has to be a hash to be used as a dictionary key, and that’s why we’re using the hash function.

 2    def roleNames(self):
 3        """Converts dict to hash because that's the result expected
 4        by QSqlTableModel"""
 5        names = {}
 6        author = "author".encode()
 7        recipient = "recipient".encode()
 8        timestamp = "timestamp".encode()
 9        message = "message".encode()
11        names[hash(Qt.UserRole)] = author
12        names[hash(Qt.UserRole + 1)] = recipient
13        names[hash(Qt.UserRole + 2)] = timestamp
14        names[hash(Qt.UserRole + 3)] = message

The send_message() function uses the given recipient and message to insert a new record into the database. Using OnManualSubmit() requires you to also call submitAll(), since all the changes will be cached in the model until you do so.

 2    # This is a workaround because PySide doesn't provide Q_INVOKABLE
 3    # So we declare this as a Slot to be able to call it  from QML
 4    @Slot(str, str, str)
 5    def send_message(self, recipient, message, author):
 6        timestamp = datetime.datetime.now()
 8        new_record = self.record()
 9        new_record.setValue("author", author)
10        new_record.setValue("recipient", recipient)
11        new_record.setValue("timestamp", str(timestamp))
12        new_record.setValue("message", message)
14        logging.debug(f'Message: "{message}" \n Received by: "{recipient}"')
16        if not self.insertRecord(self.rowCount(), new_record):
17            logging.error("Failed to send message: {self.lastError().text()}")
18            return
20        self.submitAll()


Let’s look at the chat.qml file.

2import QtQuick
3import QtQuick.Layouts

First, import the Qt Quick module. This gives us access to graphical primitives such as Item, Rectangle, Text, and so on. For a full list of types, see the Qt Quick QML Types documentation. We then add QtQuick.Layouts import, which we’ll cover shortly.

Next, import the Qt Quick Controls module. Among other things, this provides access to ApplicationWindow, which replaces the existing root type, Window:

Let’s step through the chat.qml file.

2ApplicationWindow {
3    id: window
4    title: qsTr("Chat")
5    width: 640
6    height: 960

ApplicationWindow is a Window with some added convenience for creating a header and a footer. It also provides the foundation for popups and supports some basic styling, such as the background color.

There are three properties that are almost always set when using ApplicationWindow: width, height, and visible. Once we’ve set these, we have a properly sized, empty window ready to be filled with content.

Because we are exposing the SqlConversationModel class to QML, we will declare a component to access it:

2    SqlConversationModel {
3        id: chat_model

There are two ways of laying out items in QML: Item Positioners and Qt Quick Layouts.

  • Item positioners (Row, Column, and so on) are useful for situations where the size of items is known or fixed, and all that is required is to neatly position them in a certain formation.

  • The layouts in Qt Quick Layouts can both position and resize items, making them well suited for resizable user interfaces. Below, we use ColumnLayout to vertically lay out a ListView and a Pane.

    2    ColumnLayout {
    3        anchors.fill: window
    2        Pane {
    3            id: pane

Pane is basically a rectangle whose color comes from the application’s style. It’s similar to Frame, but it has no stroke around its border.

Items that are direct children of a layout have various attached properties available to them. We use Layout.fillWidth and Layout.fillHeight on the ListView to ensure that it takes as much space within the ColumnLayout as it can, and the same is done for the Pane. As ColumnLayout is a vertical layout, there aren’t any items to the left or right of each child, so this results in each item consuming the entire width of the layout.

On the other hand, the Layout.fillHeight statement in the ListView enables it to occupy the remaining space that is left after accommodating the Pane.

Let’s look at the Listview in detail:

 2        ListView {
 3            id: listView
 4            Layout.fillWidth: true
 5            Layout.fillHeight: true
 6            Layout.margins: pane.leftPadding + messageField.leftPadding
 7            displayMarginBeginning: 40
 8            displayMarginEnd: 40
 9            verticalLayoutDirection: ListView.BottomToTop
10            spacing: 12
11            model: chat_model
12            delegate: Column {
13                anchors.right: sentByMe ? listView.contentItem.right : undefined
14                spacing: 6
16                readonly property bool sentByMe: model.recipient !== "Me"
17                Row {
18                    id: messageRow
19                    spacing: 6
20                    anchors.right: sentByMe ? parent.right : undefined
22                    Rectangle {
23                        width: Math.min(messageText.implicitWidth + 24,
24                            listView.width - (!sentByMe ? messageRow.spacing : 0))
25                        height: messageText.implicitHeight + 24
26                        radius: 15
27                        color: sentByMe ? "lightgrey" : "steelblue"
29                        Label {
30                            id: messageText
31                            text: model.message
32                            color: sentByMe ? "black" : "white"
33                            anchors.fill: parent
34                            anchors.margins: 12
35                            wrapMode: Label.Wrap
36                        }
37                    }
38                }
40                Label {
41                    id: timestampText
42                    text: Qt.formatDateTime(model.timestamp, "d MMM hh:mm")
43                    color: "lightgrey"
44                    anchors.right: sentByMe ? parent.right : undefined
45                }
46            }
48            ScrollBar.vertical: ScrollBar {}

After filling the width and height of its parent, we also set some margins on the view.

Next, we set displayMarginBeginning and displayMarginEnd. These properties ensure that the delegates outside the view don’t disappear when you scroll at the edges of the view. To get a better understanding, consider commenting out the properties and then rerun your code. Now watch what happens when you scroll the view.

We then flip the vertical direction of the view, so that first items are at the bottom.

Additionally, messages sent by the contact should be distinguished from those sent by a contact. For now, when a message is sent by you, we set a sentByMe property, to alternate between different contacts. Using this property, we distinguish between different contacts in two ways:

  • Messages sent by the contact are aligned to the right side of the screen by setting anchors.right to parent.right.

  • We change the color of the rectangle depending on the contact. Since we don’t want to display dark text on a dark background, and vice versa, we also set the text color depending on who the contact is.

At the bottom of the screen, we place a TextArea item to allow multi-line text input, and a button to send the message. We use Pane to cover the area under these two items:

 2        Pane {
 3            id: pane
 4            Layout.fillWidth: true
 6            RowLayout {
 7                width: parent.width
 9                TextArea {
10                    id: messageField
11                    Layout.fillWidth: true
12                    placeholderText: qsTr("Compose message")
13                    wrapMode: TextArea.Wrap
14                }
16                Button {
17                    id: sendButton
18                    text: qsTr("Send")
19                    enabled: messageField.length > 0
20                    onClicked: {
21                        listView.model.send_message("machine", messageField.text, "Me");
22                        messageField.text = "";
23                    }
24                }
25            }

The TextArea should fill the available width of the screen. We assign some placeholder text to provide a visual cue to the contact as to where they should begin typing. The text within the input area is wrapped to ensure that it does not go outside of the screen.

Lastly, we have a button that allows us to call the send_message method we defined on sqlDialog.py, since we’re just having a mock up example here and there is only one possible recipient and one possible sender for this conversation we’re just using strings here.


We use logging instead of Python’s print(), because it provides a better way to control the messages levels that our application will generate (errors, warnings, and information messages).

 2import sys
 3import logging
 5from PySide6.QtCore import QDir, QFile, QUrl
 6from PySide6.QtGui import QGuiApplication
 7from PySide6.QtQml import QQmlApplicationEngine
 8from PySide6.QtSql import QSqlDatabase
10# We import the file just to trigger the QmlElement type registration.
11import sqlDialog
13logging.basicConfig(filename="chat.log", level=logging.DEBUG)

connectToDatabase() creates a connection with the SQLite database, creating the actual file if it doesn’t already exist.

 2def connectToDatabase():
 3    database = QSqlDatabase.database()
 4    if not database.isValid():
 5        database = QSqlDatabase.addDatabase("QSQLITE")
 6        if not database.isValid():
 7            logger.error("Cannot add database")
 9    write_dir = QDir("")
10    if not write_dir.mkpath("."):
11        logger.error("Failed to create writable directory")
13    # Ensure that we have a writable location on all devices.
14    abs_path = write_dir.absolutePath()
15    filename = f"{abs_path}/chat-database.sqlite3"
17    # When using the SQLite driver, open() will create the SQLite
18    # database if it doesn't exist.
19    database.setDatabaseName(filename)
20    if not database.open():
21        logger.error("Cannot open database")

A few interesting things happen in the main function:

  • Declaring a QGuiApplication. You should use a QGuiApplication instead of QApplication because we’re not using the QtWidgets module.

  • Connecting to the database,

  • Declaring a QQmlApplicationEngine. This allows you to access the QML Elements to connect Python and QML from the conversation model we built on sqlDialog.py.

  • Loading the .qml file that defines the UI.

Finally, the Qt application runs, and your program starts.

 2if __name__ == "__main__":
 3    app = QGuiApplication()
 4    connectToDatabase()
 6    engine = QQmlApplicationEngine()
 7    engine.load(QUrl("chat.qml"))
 9    if not engine.rootObjects():
10        sys.exit(-1)