/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"
                }
            ] 
         }
      ]
    }