CRUD_Python

This algorithm is a CRUD made in python that has the purpose of the four basic operations (creation, consultation, updating and destruction of data) used in relational databases (RDBMS).

Apoie esse projeto! 💵💵

Olá! Você pode realizar doações de qualquer banco para minha chave Pix Itaú: 865875c7-c1cc-4254-8585-7c1616dfbc59

Requirements

pip install -r requirements.txt

You will need to instal MySQL and XAMPP also:

• MySQL installation tutorial: https://www.youtube.com/watch?v=5JbAOWJbgIA&list=PLHz_AreHm4dkBs-795Dsgvau_ekxg8g1r&index=2&ab_channel=CursoemV%C3%ADdeo

• XAMPP installation tutorial: https://www.youtube.com/watch?v=R2HrwSQ6EPM&list=PLHz_AreHm4dkBs-795Dsgvau_ekxg8g1r&index=3&ab_channel=CursoemV%C3%ADdeo

Operation

Home screen

When initializing the code, the first screen that is presented is the selection menu screen below:

On this screen we can execute the 4 basic commands of a CRUD (Create, Read, Update and Delete).

Option 1

Selecting option 1, we can insert a new record in our database, as described in the image below:

Option 2

Selecting option 2, we can perform a search and read all parameters of a record or of the complete base, as shown in the images below:

• Reading of data searching for Name:

• Reading of data searching for CPF:

• Presentation of the complete database:

Option 3

Selecting option 3, we can update our base records, as shown in the images below:

• Name Update:

• CPF update:

Option 4:

Selecting option 4, we can delete a record in our database, or delete the entire database, as shown in the images below:

• Deletion of registration by Name:

• Deletion of registration by CPF:

• Complete deletion of the base: