Book Image

Qt5 Python GUI Programming Cookbook

By : B. M. Harwani
Book Image

Qt5 Python GUI Programming Cookbook

By: B. M. Harwani

Overview of this book

PyQt is one of the best cross-platform interface toolkits currently available; it's stable, mature, and completely native. If you want control over all aspects of UI elements, PyQt is what you need. This book will guide you through every concept necessary to create fully functional GUI applications using PyQt, with only a few lines of code. As you expand your GUI using more widgets, you will cover networks, databases, and graphical libraries that greatly enhance its functionality. Next, the book guides you in using Qt Designer to design user interfaces and implementing and testing dialogs, events, the clipboard, and drag and drop functionality to customize your GUI. You will learn a variety of topics, such as look and feel customization, GUI animation, graphics rendering, implementing Google Maps, and more. Lastly, the book takes you through how Qt5 can help you to create cross-platform apps that are compatible with Android and iOS. You will be able to develop functional and appealing software using PyQt through interesting and fun recipes that will expand your knowledge of GUIs
Table of Contents (20 chapters)
Title Page
Dedication
Packt Upsell
Contributors
Preface
Index

Inserting rows in the specified database table


In this recipe, we will be learning to insert rows into a table. We assume a table called Users consisting of two columns, EmailAddress and Password, already exists in a database called ECommerce.

After entering the email address and password in the respective Line Edit widgets, when the user clicks the Insert Row button, the row will be inserted into the specified database table.

How to do it…

Here are the steps to insert rows into a database table that exists in SQLite:

  1. Let's create an application based on the Dialog without Buttons template.
  2. Add five QLabel widgets, four QLineEdit widgets, and one QPushButton widgets to the form by dragging and dropping five Label widgets, four Line Edit widgtes, and one Push Button widget on the form.
  3. Set the text property of the first four Label widgets to Enter database name, Enter table name, Email Address, and Password.
  4. Delete the text property of the fifth Label widget this is established through code.
  5. Set...