Loqo.Ai_Product_Management_System

This is a Spring Boot application that interacts with a MySQL database to provide a RESTful API for filtering and sorting product records. The API allows you to fetch product details from the products table with various filtering and sorting options.

Table of Contents

• Getting Started
• Technologies
• Running the Application
• API Endpoints
• Testing

Getting Started

Prerequisites

• Java 8 or higher
• Maven
• MySQL

Installation

1. Clone the repository:

   git clone https://github.com/Chetan0777/Loqo_Product_Management_System.git
   

2. Build the project:

   mvn clean install
   

3. application.properties

    spring.application.name=LOQO AI
    
    spring.datasource.url=jdbc:mysql://localhost:3306/loqoai
    spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
    spring.datasource.username=root
    spring.datasource.password=root123
    
    spring.jpa.hibernate.ddl-auto=update
    spring.jpa.show-sql=true
   
   

4. Set Properties:

    Change database name and  username & password

Technologies

• Java
• Spring Boot
• Spring Data JPA
• Hibernate
• Lombok
• JUnit 5

Running the Application

1. Run the application:

   mvn spring-boot:run
   

2. The application will start on port 8080. You can access the API at http://localhost:8888/products.

API Endpoints

Add Product

Add products in database.

• URL: http://localhost:8080/addProduct
• Method: POST

Screenshot of Add Product API

Get Products

Retrieve the list of products with optional filtering and sorting.

• URL: http://localhost:8080/products
• Method: GET

Screenshot of Get Products API

Testing

The application includes unit and integration tests to ensure the functionality of the service and controller layers.

Test Coverage

• ProductServiceTest: Unit tests for the ProductService class.
• ProductControllerTest: Integration tests for the ProductController class.