Build Restful CRUD API for a simple Note-Taking application using Spring Boot, Mysql, JPA and Hibernate.

1. Java - 1.8.x

2. Maven - 3.x.x

3. Mysql - 5.x.x

1. Clone the application

git clone https://github.com/raydana/raydana_api_notes.git

2. Create Mysql database

create database new_db

3. Change mysql username and password as per your installation

• open src/main/resources/application.properties

• change spring.datasource.url to your mysql engine server IP

• change spring.datasource.username and spring.datasource.password as per your mysql installation

4. Run the app using maven

mvn spring-boot:run

The app will start running at http://localhost:8080.

you can use this script for insert sample users

insert into user(id, email, password,created_at,updated_at)
values (1,'[email protected]','1',CURDATE(),CURDATE());

The app defines CRUD APIs. You can view or test them using this link http://localhost:8080/swagger-ui/index.html?configUrl=/v3/api-docs/swagger-config.

notice

• for createNode api you can use this JSON body for input { "title": "sample title", "note": "sample note" }

• for updateNode api you can use this body for input { "id" : "1" "title": "sample title", "note": "sample note" }

In this app, an xml file of users and notes is created alternately and every hour and saved in Drive; you can config xml directory path. first open src/main/resources/application.properties and then change value of the key 'dataTransform.export.directoryPath'.

https://www.raydana.com/