Mastering GUI Programming with Python

Building a form

Our coffee database has three tables: a list of coffee products, a list of roasts, and a table of reviews for the products. Our GUI will be designed as follows:

• It will have a list of coffee brands and products
• When we double-click an item in the list, it will open a form that will show all the information about the coffee and all the reviews associated with that product
• It will allow us to add new products and new reviews or edit any existing information

Let's start by copying your basic PyQt application template from Chapter 4, Building Applications with QMainWindow to a file called coffee_list1.py. Then, add an import for QtSQL like so:

from PyQt5 import QtSql as qts

Now we're going to create a form to display information ...