Web page

The application was deploy on: Heroku

Destination:

An application designed to organize bills in the household. Created for easier budget management. It allows you to make savings by monitoring individual purchases.

Deployment guide

Running application on local machine

1. Cloning repository with use IntelliJ IDEA: File > New > Project from Version Control. Copy and paste correct link from Github.

2. Check application.properties file on location calc-bill/src/main/resources. You need database engine and software, in this case MySQL. Application used relation database: you need to create a new database according to the parameters in the file.

   • db name: CALC_BILL
   • db host: localhost
   • db user: cecherz
   • db password: Pangeon66#

3. Folder calc-bill/src/main/resources/static/sql consist:

   • SQL db create script: create_db.sql
   • SQL db insert sample data script: insert.sql

The application uses ORM, it is not necessary to generate a database structure after it is created, all you need is a running environment and an empty database.

Config database on local machine

1. Create a new MySQL database via console or GUI:
   CREATE DATABASE CALC_BILL CHARACTER SET utf8mb4 COLLATE utf8mb4_polish_ci;
2. create a new MySQL user account
   CREATE USER 'cecherz'@'localhost' IDENTIFIED BY 'Pangeon66#';
3. Grand all privileges to a user account over a specific database
   GRANT ALL PRIVILEGES ON CALC_BILL.* TO 'cecherz'@'localhost';

Database CALC_BILL

Structure:

• owner

    +---------+---------+------+-----+---------+----------------+
    | Field   | Type    | Null | Key | Default | Extra          |
    +---------+---------+------+-----+---------+----------------+
    | id      | int(11) | NO   | PRI | NULL    | auto_increment |
    | name    | text    | NO   |     | NULL    |                |
    | surname | text    | NO   |     | NULL    |                |
    +---------+---------+------+-----+---------+----------------+
  

• payments

    +----------+-----------+------+-----+-------------------+-------------------+
    | Field    | Type      | Null | Key | Default           | Extra             |
    +----------+-----------+------+-----+-------------------+-------------------+
    | id       | int       | NO   | PRI | NULL              | auto_increment    |
    | amount   | double    | NO   |     | NULL              |                   |
    | date     | timestamp | YES  |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
    | kind     | tinytext  | NO   |     | NULL              |                   |
    | owner_id | int       | YES  | MUL | NULL              |                   |
    +----------+-----------+------+-----+-------------------+-------------------+
  

Relations:

Troubles

• Redirects on files: success.html and error.html on head sections.
• Application require JDK 11