In this book, you will create two MariaDB and PostgreSQL driven projects using PyQt. The step-by-step guide in this book is expected to help the reader's confidence to become a programmer who can solve database programming problems. A progressive project is provided to demonstrate how to apply the concepts of MariaDB and PostgreSQL using Python.In second chapter, you will learn PyQt that consists of a number of Python bindings for cross-platform applications that combine all the strengths of Qt and Python. By using PyQt, you can include all Qt libraries in Python code, so you can write GUI applications in Python. In other words, you can use PyQt to access all the features provided by Qt through Python code. Because PyQt depends on the Qt libraries at run time, you need to install PyQt.In third chapter, you will How to create the initial three tables project in the School Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. In fourth chapter, you will learn how Create a main form to connect all forms; Create a project will add three more tables to the school Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables. In this chapter, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. In chapter five, you will create dan configure PotgreSQL database. In this chapter, you will create Suspect table in crime database. This table has eleven suspect_id , suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table.In chapter six, you will create a table with the name Feature_Extraction, which has eight feature_id , suspect_id , feature1, feature2, feature3, feature4, feature5, and feature6. The six fields will have a VARCHAR data type . You will also create GUI to display, edit, insert, and delete for this table.In chapter seven, you will create two tables, Police and Investigator. The Police table has six police_id , province, city, address, telephone, and photo. The Investigator table has eight investigator_id , investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables.In chapter eight, you will create two tables, Victim and Case_File. The Victim table has nine victim_id , victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven case_file_id , suspect_id , police_id , investigator_id , victim_id , status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.
Language
English
Pages
533
Format
Paperback
Release
November 13, 2019
ISBN 13
9781707959181
MariaDB And PostgreSQL Crash Course: A Step by Step, Project-Based Introduction to Python GUI Programming
In this book, you will create two MariaDB and PostgreSQL driven projects using PyQt. The step-by-step guide in this book is expected to help the reader's confidence to become a programmer who can solve database programming problems. A progressive project is provided to demonstrate how to apply the concepts of MariaDB and PostgreSQL using Python.In second chapter, you will learn PyQt that consists of a number of Python bindings for cross-platform applications that combine all the strengths of Qt and Python. By using PyQt, you can include all Qt libraries in Python code, so you can write GUI applications in Python. In other words, you can use PyQt to access all the features provided by Qt through Python code. Because PyQt depends on the Qt libraries at run time, you need to install PyQt.In third chapter, you will How to create the initial three tables project in the School Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. In fourth chapter, you will learn how Create a main form to connect all forms; Create a project will add three more tables to the school Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables. In this chapter, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. In chapter five, you will create dan configure PotgreSQL database. In this chapter, you will create Suspect table in crime database. This table has eleven suspect_id , suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table.In chapter six, you will create a table with the name Feature_Extraction, which has eight feature_id , suspect_id , feature1, feature2, feature3, feature4, feature5, and feature6. The six fields will have a VARCHAR data type . You will also create GUI to display, edit, insert, and delete for this table.In chapter seven, you will create two tables, Police and Investigator. The Police table has six police_id , province, city, address, telephone, and photo. The Investigator table has eight investigator_id , investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables.In chapter eight, you will create two tables, Victim and Case_File. The Victim table has nine victim_id , victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven case_file_id , suspect_id , police_id , investigator_id , victim_id , status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.