This is an open source backend Application based on REST APIs to track customer activity.
Features:
-
Adding Customer info in the database.
-
Fetching Customer Details
-
Updating Customer info in the database.
-
Deleteing Customer info in the database.
Instructions for downloading the project:
- Install MySql server on your system which will be used as your local server for project.
- Inside Mysql Server create a database name ebdb.
- Import Dump20211005.sql in Mysql under ebdb database.
- Download Postman in your system.
- After downloading create a new workspace in your postman
- Import exp.postman_collection.json file inside postman
- Download the zip file of the code and unzip on any of the drive.
- Open InteliJ and click on open project.
- Select the coffee application file and click ok.
- Go to Application.Properties file and change Mysql username and password with regards to your system .
- Click on build project and then click on Run StartCoffeeApplication.
- Go to postman and click on Add data and send request with orderid,name,foodname,amount of your choice and send request.
- Data will be added in MySql
- For retrieve data click Retrieve data and in the above url change the orderId with your orderid.
- For updating data click Update Data change the orderId with your orderid of your choice and then provide updated orderid,name,foodname,amount.
- For deleting data click Delete Data and provide orderId of the customer which you want to delete and data will be deleted.
SAMPLE IMAGES:
- MySql Database before data is added:
- Postman Post Mapping:
- MySql Database after data is added:
- Postman Get Mapping: