- tkinter
- tkinter.messagebox
- pyodbc
This is an integration project that creates a user-friendly User Interface with Tkinter enabling SQL database manipulation. In this project's scenario we're creating an Inventory Control System capable of adding new inventory items, searching for existing items, updating an item's quantity and deleting an existing item.
The following interface was created using Proxlight Designer and Figma. Proxlight imports Figma's project and transform it into a Python Script using Tkinter.
This project utilizes pyodbc package, allowing python scripts to execute SQL commands on the database. In this case we're creating the CRUD Operations (Create, Read, Update and Delete).
Create
Lines 62 to 80 in 0fe1bfd
Read
Lines 13 to 28 in 0fe1bfd
Update
Lines 45 to 60 in 0fe1bfd
Delete
Lines 30 to 43 in 0fe1bfd