TickerDataDashboard

About

1. Data is listed below for one ticker symbol. Create a table in a database (Postgres or MySQL). Use Python to insert data into the database.
2. Build a simple app with React frontend and FastAPI backend. The user has two options:

a. Upload Data: By clicking this button, the user should upload the CSV data and with the help of Rest APIs, the FastAPI backend should insert the data in the DB. b. Get data: On clicking this button, the API should fetch data from the DB and display it on the React frontend as a table.

OUTPUTS

1)The Output

2)Selecting and Uploading File

3)Uploaded File

4)Clicking Upload Data

5)MySQL Table Created and Data Inserted

6)Clicking Get Data

HOW TO RUN IT?

1)env file

Make a .env file in api folder of backend and fill DATABASE_NAME,MYSQL_USER,MYSQL_PASSWORD

2)Backend

cd backend
pipenv install fastapi dotenv mysql.connector 
pipenv shell
cd api
uvicorn main:app --reload

Backend would be up and running!

3)Frontend

cd frontend
npm i
npm run start

Frontend would be up and running!

File uploaded here is HINDALCO_1D which is a csv file which you need to download and upload by choosing select file