Python-MySql-CRUD-System

It is a program developed in Python and MySQL made with the aim of applying crud concepts.

Status: Developing ⚠️

Below I'll detail what each field of the Main Screen means:

Main title:

• Product Registration

⬜ Text entry:

• ⬜ Code
• ⬜ Product
• ⬜ Price

Title RadioButton: Category

🔘 RaddioButon Options:

• 🔘 Computers
• 🔘 Food
• 🔘 Electronic

🔲 Button: List(Listar)

List button: Makes a list of all registered components.

🔲 Button: Send(Enviar)

Send button: Save the information added to the database.

---

Below I'll detail what each field of the List screen means:

Main title: Product list screen

The fields ID, CODE, ITEM, PRICE, CATEGORY represent the columns registered in the database.

🔲 Button: DELETE

DELETE button: Deletes the selected line.

🔲 Button: PDF

PDF button: Generates a pdf file with the information that is saved in the database. Note: This file will be saved in the same folder as the project.

🔲 Button: EDIT

EDIT button: Allows you to edit the selected line.

---

Below I'll detail what each field of the Edit screen means:

The screen has fields that represent the column information.

🔲 Save button:

Updates the information that has been modified.

---

What is being developed:

a screen that allows you to search for an item by the letter or keyword.

---

Technologies used:

Python	MySql
3.9	8.0

Python libraries used:

PyQt5	reportlab.pdfgen	mysql.connector
5.15.6	3.6.3	2.2.9

• PyQt5: User Interface
• reportlab.pdfgen: Generate Pdf
• mysql.connector: Connect ing to the database

---

How to run the application:

1. Download the repository
2. Run the file controle.py in the main folder.
3. Have fun exploring the possibilities, you will be able to add, query, edit and delete information through the graphical interface.

Note: To run the application correctly, you will need to have the respective technologies in place in the machine.