The application was deploy on: Heroku
An application designed to organize bills in the household. Created for easier budget management. It allows you to make savings by monitoring individual purchases.
-
Cloning repository with use IntelliJ IDEA: File > New > Project from Version Control. Copy and paste correct link from Github.
-
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#
-
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.
-
Create a new MySQL database via console or GUI:
CREATE DATABASE CALC_BILL CHARACTER SET utf8mb4 COLLATE utf8mb4_polish_ci;
-
create a new MySQL user account
CREATE USER 'cecherz'@'localhost' IDENTIFIED BY 'Pangeon66#';
-
Grand all privileges to a user account over a specific database
GRANT ALL PRIVILEGES ON CALC_BILL.* TO 'cecherz'@'localhost';
-
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 | | +----------+-----------+------+-----+-------------------+-------------------+
- Redirects on files: success.html and error.html on head sections.
- Application require JDK 11