Qt5 Python GUI Programming Cookbook

How it works…

You can see in the script that the click event of the push button with the objectName property pushButtonSearch is connected to the SearchRows() method. This means that, whenever the push button is clicked, the SearchRows() method is invoked. In the SearchRows() method, the connect() method is invoked on the sqlite3 class to establish a connection with the ECommerce database. An SQL search statement is defined that fetches the EmailAddress and Password columns from the Users table whose email address matches the email address supplied. The search SQL statement is executed on the Users table. The fetchone() method is executed on the cursor to fetch one row from the executed SQL statement. If the fetched row is not None, that ...