Its a small simple project of CRUD operations using flask framework of python First we had created a virtual environment using python package 'virtualenv' to avoid installing packages globally which can break system tools or cause problem for other projects due to version difference. We have mysql workbench to see the database and mysql-connector-python package for connection of python code with database, so to be able to execute sql query from python. The database contains 3 tables

For frontend/UI we use HTML,CSS,JavaScript,BootStrap For backend we use Python,Flask For database we use MySQL server - Flask server

In the project we have 2 modules Products & Orders

The project features : inserting,deleting,modifying,viewing of products placing an order, deleting an order view all orders view details of a specific order

• IDE (for python3)
• Mysql Database
• JavaScript/jQuery
• HTML5/CSS (Bootstrap 4)
• CRUD Functionality (Create, Read, Update, Delete)

Project Dependencies

• MySQL Driver
• Python modules (Flask, sql_connection)

Add Product

All Products

Edit Product (info autopopulating of that product before edit)

Delete Product

Add an Order (Column Price autopopulating based on product id) (Column Total autopopulating based on price * quantity)

All Orders

View a specific Order

Delete an Order