by S.M.Lee(phantasmicmeans)

RESTful API using Spring Boot, Swagger2, JPA hibernate and Mysql, One to Many, Many to One bidirectional mapping

• Project - Problem (One-To-Many)

• Problem - Project (Many-To-One)

• Problem - SubProblem (One-To-Many)

• SubProblem - Problem (Many-To-One)

1. Problem.java(part of)

@OneToMany(mappedBy = "project", cascade = CascadeType.REMOVE, fetch = FetchType.LAZY, orphanRemoval = true)
private Set <Problem> problems = new HashSet<>();
/* Project <-> Problem One to Many bidirectional */

2. Problem.java(part of)

@ManyToOne(cascade = CascadeType.REMOVE)
@JoinColumn(name = "code", referencedColumnName = "code", nullable = false)
private Project project; 
/* Problem <-> Project  Many to One bidirectional */

@OneToMany(mappedBy = "problem", cascade = CascadeType.ALL, fetch = FetchType.LAZY, orphanRemoval = true)
private Set<subProblem> subProblems = new HashSet<>();
//Problem <-> SubProblem  One to Many bidirectional

3. SubProblem.java(part of)

@ManyToOne(cascade = CascadeType.REMOVE)
@JoinColumn(name = "pro_idx", referencedColumnName = "idx", nullable = false)
private Problem problem; 
/* Problem <-> Project Many to One bidirectional */

  1. API Description for Project

  2. API Description for Problem & SubProblem

  1. Curl for Project

1. Get a Project with code

curl -X GET http://localhost:8080/problem/0gn547 

2. Save a Project with code

curl -d '{"title":"first project"}' -H "Content-Type: application/json" -X POST http://localhost:8080/project

3. Delete a Project with code

curl -X DELETE http://localhost:8001/project/0gn547

4. Update a Project with code

curl -X PUT -H "Content-Type: application/json; charset=utf-8" -d '{"title":"first-project-renewal"}' http://localhost:8080/project/hx6029

2. Curl for Problem & SubProblem  

1. Get a Problem with code

curl -X GET http://localhost:8001/problem/0gn547 

2. Save a Problem with code

curl -d '{"title":"first problem"}' -H "Content-Type: application/json" -X POST http://localhost:8080/problem/hx6029

3. Delete a Problem-SubProblem with code

curl -X DELETE http://localhost:8001/problem/hx6029/all 

4. Save a SubProblem

curl -d '{"content":"first-subproblem","pro_idx":1}' -H "Content-Type: application/json" -X POST http://localhost:8080/subproblem

append this at the end of application.yml  

spring:
    application:
      name: project-api
       
## Hibernate Properties
# The SQL dialect makes Hibernate generate better SQL for the chosen database
    jpa: 
      properties:
        hibernate:
          dialect: org.hibernate.dialect.MySQL5InnoDBDialect
      hibernate:
        ddl-auto: update
        # Hibernate ddl auto (create, create-drop, validate, update)
      
    datasource:
      url: jdbc:mysql://{YOUR_MSQL_SERVER}:3306/{DATABASE NAME}?useSSL=false
      username: {YOUR_MYSQL_ID}
      password: {YOUR_MYSQL{PASSWORD}
      driver-class-name: com.mysql.jdbc.Driver
      hikari:
        maximum-pool-size: 2

You can use the Swagger API Documentation at http://{Your_Server}:{Port}/swagger-ui.html