NoteKeeper

Note service for keeping yours notes in the cloud. This repository contains two application.

Java Backend

Goal

Purpose of this application - provide REST service with security using as storage DataBase(MySql).

Used for the development of:

• JavaEE 7
• Spring Framework
• Persistence API
• MySql
• Junit
• Log4j
• H2 in memory database

Frontend

Goal

WebUI support.

Used for the development of:

• Angular.JS
• BootStrap
• jQuery

Installation guide

Requirements

1. DataBase, your choice is not critical, tested on MySql.
2. Application server, tested on Tomcat and GlassFish.

Steps

1. Create schema, tables and keys in your DataBase.

CREATE SCHEMA notekeeper;
CREATE TABLE note
(
  head           CHAR(255),
  body           LONGTEXT,
  creationDate   DATETIME,
  lastChangeDate DATETIME,
  noteId         BIGINT UNIQUE PRIMARY KEY NOT NULL,
  userId         BIGINT                    NOT NULL
);
CREATE TABLE user
(
  userId   BIGINT PRIMARY KEY NOT NULL,
  email    CHAR(40) UNIQUE    NOT NULL,
  login    CHAR(40) UNIQUE    NOT NULL,
  password CHAR(40)           NOT NULL
);
ALTER TABLE note ADD CONSTRAINT note_ibfk_1 FOREIGN KEY (userId)
REFERENCES user (userId)
  ON DELETE CASCADE;
CREATE INDEX R_3 ON note (userId);

2. Clone git repository.

git clone https://github.com/BioQwer/NoteKeeper.git

3. Install Bower dependencies for WebApplication.

cd webUI/src/main/webapp/
bower i

4. Edit configs for DataBase app.properties, if you use not MySql you need to add Maven dependency for your JDBC.

cd serverSide/src/main/resources/app.properties

5. Compile project.

mvn clean package

5. Deploy to Application server.
6. Enjoy.