Flask-E-Commerce-API with MySQL

Files navigation

controllers folder has product_cartitem_controller file this consists of API endpoints.

models folder has cart_item_model and product_model and the respective queries/ functions/ CRUD operations related code is in these files

Download setup

Step-1: Creating & activating venv Windows:

python -m venv venv ./venv/Scripts/activate

Step-2: Installing Dependencies

pip install -r requirements.txt

Step-3: Running application Windows:

$env:PYTHONDONTWRITEBYTECODE=1;$env:FLASK_APP="app";$env:FLASK_ENV = "development"

Step-4: Connect MySQL with the code editor and create database=flask_ecommerce and tables= product and cart_item

Step-5:

flask run

Step-6:

open postman application and paste the link with respective endpoints

Output

product table in mysql

cart_item table in mysql

flask run in VS code

GET /products: Returns a list of all products.

GET /products/: Returns details of a specific product.

POST /cart: Adds a product to the cart.

in mysql its added

GET /cart: Retrieves the cart items.

DELETE /cart/: Removes a specific item from the cart.

in mysql id=2 is deleted

Additional end points

get specific cart item by id

adds a product to the table

in mysql its added

update the product

in mysql id=1 is updated

delete a product by id

in mysql id=4 is deleted

get specific cart item by id

update cart item