Table of Contents
This project allows the user to visualize their yearly bank activity in a "wrapped" format (similar to Spotify Wrapped).
Here are the trends available on the project:
- Anual expense
- Monthly expenses + month most spent
- Categories most spent on (Food, Services, Health...)
- Methods most spent on (Credit, Debit...)
- Top 3 locations transactions were made
- Anual income + total saved
This repository contains two projects: hyperbank-front - the client side application - and hyperbank-back - the server.
To get a local copy up and running follow these steps.
To run the application you must have the following installed:
-
Clone the repo
git clone https://github.com/maalucf/hyperbank.git
-
Install NPM packages
a. Go to the hyperbank-front folder and run the command
npm install
b. Go to the hyperbank-back folder and run the command
npm install
-
Create a mysql database
a. Log into the mysql terminal using your credentials
mysql -u your_user -p
b. Inside the mysql terminal, create a new database
CREATE DATABASE your_database_name;
c. Out of the mysql terminal, populate the database using the hyperbank-database.sql file (make sure you are inside the hyperbank folder)
mysql -u your_username -p your_database_name < hyperbank-database.sql
-
Create a
.env
file inside the hyperbank-back folder to configure the databaseMYSQL_HOST='your_host' MYSQL_USER='your_user' MYSQL_PASSWORD='your_password' MYSQL_DB='your_database_name'
To run the application make sure you are inside the hyperbank-back folder. Once you are in the correct folder, run the script
npm run start
When the server is running, you can access the web page through the http://localhost:5000
link in your browser.
Database schema:
app-demo.mp4
Project Link: https://github.com/maalucf/hyperbank