A Guide to PyQt6 for Beginners/

...

/

Example Queries Using QSqlQuery

Example Queries Using QSqlQuery

Understand how we use QSqlQuery by using examples.

We'll cover the following...

Creating the GUI

More examples of how to add, update, and delete records using SQL in a PyQt application are provided in the following code.

First of all, we start by importing the required modules.

Python 3.8
import sys
from PyQt6.QtSql import QSqlDatabase, QSqlQuery

Then we create the QueryExamples class and the createConnection function which enabled us to connect to the database.

Python 3.8
class QueryExamples:
    def __init__(self):
        super().__init__()
        self.createConnection()
        self.exampleQueries()
    def createConnection(self):
        """
        Create connection to the database.
        """
        database = QSqlDatabase.addDatabase("QSQLITE")
        database.setDatabaseName("files/accounts.db")
        if not database.open():
            print("Unable to open data source file.")
            sys.exit(1) # Error code 1 - signifies error

We then create the exampleQueries function to ...