smbea/FEUP-SINF

Web application for inter-company product management with Primavera EPR integration.

FEUP-SINF

Project developed in the context of the 4th year course Information Systems at FEUP.

1. Winerd
2. Technologies
3. Screenshots
4. How To Run

Winerd

Full-stack application for inter-company product management with Primavera EPR integration.

Technologies

Frontend

• React
• Gatsby
• Material UI

Backend

• Node.js
• Express
• PostgreSQL

How to Run

To run the frontend:

cd client
npm install
npm start

To run the backend:

First setup local database:

1. Install postgres:

   sudo apt update
   sudo apt install postgresql postgresql-contrib
   

2. Get postgres running: sudo service postgresql start
3. Enter psql command line: sudo -i -u postgres
4. Login to postgres: psql
5. Create user with permission to create db:

   CREATE ROLE api_user WITH LOGIN PASSWORD 'password';
   ALTER ROLE api_user CREATEDB;

6. Create database: create database winerd;
7. Exit postgres: \q
8. Run .sql file: psql -h localhost -d winerd -U api_user -f /home/{rest of path to the project}/FEUP-SINF/api/public/database/init.sql
9. Enter database command line: psql winerd
10. Confirm tables were created successfully: \dt

cd express
npm install
npm start

Screenshots