=================
Product API
================

=> We have to implement below functionalities as part Product API

a) getting categories

b) get products based on category id

c) get products based on product name (search operation)

d) get product by product id

=======================
development procedure
======================

1) Create boot application with required dependencies

		a) web-starter
		b) data-jpa
		c) mysql-driver
		d) lombok
		e) model-mapper

2) Create Entities and Repositories

		parent : product_category_table

		child : product_table (category_id as FK)

3) Create DTO classes

4) Create Mapper classes (ProductMapper & CategoryMapper)

5) Create Service Layer interface & impl

6) Create ApiResponse to prepare response payload 

7) Create Rest Controller with required methods

8) Load data into categories and products table by writing sql queries

9) Create POSTMAN collection and test api functionality

=================================================================================

-- -----------------------------------------------------
-- insert product categories
-- -----------------------------------------------------

INSERT INTO product_category(category_name) VALUES ('Laptops');
INSERT INTO product_category(category_name) VALUES ('Mobiles');
INSERT INTO product_category(category_name) VALUES ('Shirts');
INSERT INTO product_category(category_name) VALUES ('Beauty');


-- -----------------------------------------------------
-- insert products
-- -----------------------------------------------------



------------------------------ Laptops -----------------------------------------------

INSERT INTO product (title, name, description, image_url, active, units_in_stock,
unit_price, category_id, date_created)
VALUES ('DELL-LAPTOP-1000', 'DELL - Laptop', 'Processor: Intel Core i5-1235U 12th Generation (up to 4.40 GHz, 12MB 10 Cores)',
'assets/images/products/laptops/dell-laptop-1000.png',1,100,19.99,1, NOW());

INSERT INTO product (title, name, description, image_url, active, units_in_stock,
unit_price, category_id, date_created)
VALUES ('HP-LAPTOP-1001', 'HP - Laptop', 'Processor: Intel Core i5-1235U 12th Generation (up to 4.40 GHz, 12MB 10 Cores)',
'assets/images/products/laptops/hp-laptop-1001.png',1,100,59.99,1, NOW());

INSERT INTO product (title, name, description, image_url, active, units_in_stock,
unit_price, category_id, date_created)
VALUES ('ACER-LAPTOP-1002', 'ACER - Laptop', 'Acer Aspire Lite 12th Gen Intel Core i5-1235U Thin and Light Laptop ',
'assets/images/products/laptops/acer-laptop-1002.png',1,100,49.99,1, NOW());

INSERT INTO product (title, name, description, image_url, active, units_in_stock,
unit_price, category_id, date_created)
VALUES ('LENOVO-LAPTOP-1003', 'Lenovo ThinkPad E14', 'Lenovo ThinkPad E14 AMD Ryzen 5',
'assets/images/products/laptops/lenovo-laptop-1003.png',1,100,45.00,1, NOW());


----------------------------------Mobiles-----------------------------------------

INSERT INTO product (title, name, description, image_url, active, units_in_stock,
unit_price, category_id, date_created)
VALUES ('Apple-IPhone-1000', 'Apple-Iphone', 'Apple iPhone 13 (128GB) - Green',
'assets/images/products/mobiles/apple-mobile-1000.png',1,100,59,2, NOW());

INSERT INTO product (title, name, description, image_url, active, units_in_stock,
unit_price, category_id, date_created)
VALUES ('RED-MI-1001', 'Redmi 13C', 'Redmi 13C (Stardust Black, 6GB RAM, 128GB Storage)',
'assets/images/products/mobiles/redmi-mobile-1001.png',1,100,29,2, NOW());

INSERT INTO product (title, name, description, image_url, active, units_in_stock,unit_price, category_id, date_created)
VALUES ('SAMSUNG-Galaxy-1002', 'Samsung Mobile', 'SAMSUNG Galaxy F14 5G 6GB RAM 128GB STORAGE',
'assets/images/products/mobiles/samsung-mobile-1002.png',1,100,39,2, NOW());

INSERT INTO product (title, name, description, image_url, active, units_in_stock,unit_price, category_id, date_created)
VALUES ('POCO C65', 'POCO C65', 'POCO C65 (Pastel Green 4GB RAM 128GB Storage)',
'assets/images/products/mobiles/poco-mobile-1003.png',1,100,49,2, NOW());

----------------------------------Shirts-----------------------------------------

INSERT INTO product (title, name, description, image_url, active, units_in_stock,
unit_price, category_id, date_created)
VALUES ('Mens Cotton Shirt', 'Mens Cotton Shirt', 'Amazon Brand - Symbol Mens Cotton Shirt','assets/images/products/clothes/shirt-1000.png',1,100,5,3, NOW());

------------------------------------------------------------------------------------------------