/spring-boot-jpa-relation-database

SpringBoot application Java Persistent API (JPA) hibernate with multiple relationship databases

Primary LanguageKotlin

Documentation

SpringBoot application Java Persistent API (JPA) hibernate with multiple relationship databases

TechStack

  • SpringBoot (2.7.3)
  • Kotlin
  • Spring Data JPA
  • MySQL Database

API

One-to-One Relationship

Request

  • Method : GET
  • Endpoint : /api/v1/{user_id}/wallet example user_id = 1 until 3
  • Header :
    • Accept: application/json

Response

  • Body : 
    {
  "code": "integer",
  "message": "number",
  "data": {
    "id": "number",
    "name": "string",
    "user": {
        "id": "number",
        "name": "string",
        "email": "string"
    }
  }
}

One-to-Many Relationship

Request

  • Method : GET
  • Endpoint : /api/v1/{user_id}/product example user_id = 1 until 3
  • Header :
    • Accept: application/json

Response

  • Body : 
    {
  "code": "number",
  "message": "string",
  "data": [
     {
        "id": "number",
        "name" : "string",
        "price" : "number",
        "qty": "number"
     }
  ]
}

Many-to-Many Relationship (with Extra Columns)

Request

  • Method : GET
  • Endpoint : /api/v1/{user_id}/order example user_id = 1 until 3
  • Header :
    • Accept: application/json

Response

  • Body : 
    {
  "code": "number",
  "message": "string",
  "data": [
     {
        "id": "number",
        "createdAt": "string",
        "updatedAt": "string",
        "orderProduct": [
            {
              "id": "number",
              "price": "number",
              "qty": "number",
              "productName": "string"
            }
        ] 
     }
  ]
}