This project is a simple web application that allows users to manage orders and customers using a MySQL database. The application is built using FastAPI on the backend and React on the frontend.
Data retrived from XML :
User can amend/update orders :
DB design :
- Install Node.js, Python
- To run this project, you will need to install its dependencies.
pip install -r requirements.txt
-
Command will install all the required packages listed in the
requirements.txtfile. -
Clone the repository to your local machine.
-
Install the necessary dependencies.
-
Set up a MySQL database and configure the connection details in mysql_config.py.
-
Run the backend using :
uvicorn main:app --reload -
Run the frontend using :
npm start
Once the application is running, you can access it in your browser by navigating to http://localhost:3000. The home page displays a list of orders. You can also add a new order or edit an existing one by clicking the corresponding buttons.
The following API endpoints are available:
- GET /get_order_data: Returns a list of all orders in the database.
- PUT /order_update/: Updates an existing order with the specified ID.