The project idea is from the challenge shown in this repo. The solution shown here is a React app that reads a .txt files and inserts the content to a PostgreSQL table. Once the data is loaded then it is fetched from the database and then presented in a table with the total count of sales.
npm 6.14.12
create-react-app 4.0.2
lodash 4.17.21
axios 0.21.1
flask 2.0.1
flask_api 3.0.x
flask_cors 3.0.10
pandas 1.2.4
psycopg2 2.8.6
First the PostgreSQL server must be running. From the terminal run:
pg_ctl -D /usr/local/var/postgres start
Then, the server can be accesed from terminal with:
psql postgres
Run the following command to create the database that the API will be using:
CREATE DATABASE project ENCODING='UTF8' TEMPLATE='template0';
In the terminal, from the api directory run:
python main.py
On another terminal, create a react app with my-app directory:
npx create-react-app web_app my-app
Next, replace content of my-app/src directory with the content of web_app/src from this repository. Also, add <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/semantic-ui/2.4.1/semantic.min.css" /> to head tag of my-app/public/index.html file.
On my-app directory run:
npm start