===========================
Product API Development
===========================

=> We have to implement below functionalities in Product API

1) GET all product_categories for side menu bar display

2) GET products based on category_id

3) GET products based on product_name (search option)

4) GET product by product id (for product master view)

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

Step-0 : Load Product Categories and Products Into DB tables using sql script provided below

Step-1 : Create Project with required dependencies

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

Step-2 : Configure Data Source Properties in application.properties file    

Step-3 : Create Entities & Repo interfaces

Step-4 : Create DTO classes to map request and response data

Step-5 : Create mapper classes to map entity data to dto and vice versa

Step-6 : Create Service interface and impl class

Step-7 : Create ApiResponse to represent response data as a container

Step-8 : Create Rest Controller to handle requests and response

Step-9 : Run the API and test it using POSTMAN Collection

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

-- -----------------------------------------------------
-- Schema fullstack
-- -----------------------------------------------------
DROP SCHEMA IF EXISTS `ashokit_ecomm`;

CREATE SCHEMA `ashokit_ecomm`;
USE `ashokit_ecomm` ;

-- -----------------------------------------------------
-- Table `fullstack`.`product_category`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ashokit_ecomm`.`product_category` (
  `category_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `category_name` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`category_id`))
ENGINE=InnoDB
AUTO_INCREMENT = 1;

-- -----------------------------------------------------
-- Table `fullstack`.`product`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ashokit_ecomm`.`product` (
  `product_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(255) DEFAULT NULL,
  `name` VARCHAR(255) DEFAULT NULL,
  `description` VARCHAR(255) DEFAULT NULL,
  `unit_price` DECIMAL(13,2) DEFAULT NULL,
  `image_url` VARCHAR(255) DEFAULT NULL,
  `active` BIT DEFAULT 1,
  `units_in_stock` INT(11) DEFAULT NULL,
   `date_created` DATETIME(6) DEFAULT NULL,
  `last_updated` DATETIME(6) DEFAULT NULL,
  `category_id` BIGINT(20) NOT NULL,
  PRIMARY KEY (`product_id`),
  KEY `fk_category` (`category_id`),
  CONSTRAINT `fk_category` FOREIGN KEY (`category_id`) REFERENCES `product_category` (`category_id`)
) 
ENGINE=InnoDB
AUTO_INCREMENT = 1;

-- -----------------------------------------------------
-- 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
-- -----------------------------------------------------


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());

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

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());

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

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());

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