Git Product home page Git Product logo

spshoppingcart's Introduction

Project Name: SpShoppingCart

Technology Used:

Java
Maven
Spring Boot
Spring MVC
Junit, Mockito
H2-Database
Postman
Apache TomCat
Hibernate
Exception Handling
Logger Log4j- implemented using AOP
CommandLine Runner implemented for loading database while launching application.

SPShopping cart:

  1. Develop a product service to publish the details of the products - DONE
  2. Develop an order service to place the orders details and get persisted to H2 DB. Ensure that the atomicity is achieved - DONE
  3. Cover Unit test cases using JUNIT, Mockito - DONE

Table structure

Table : Product

1. productId(int)
2. name(String)
3. status(String)
4. brands(List<Brand>)

Table: Brand

1. brandId(int)
2. productId(int)
3. brand(String)
4. quantity(int)
  1. price(Double)

Table: Orders

1. orderId(int)
2. orderDate(Date)
3. orderDileveredDate(Date)
4. orderStatus(String)
5. productId(int)
6. paymentSource(String)
7. paymentStatus(String)
8. customers(List<Customer>)

Table: Customer

1. orderId(int)
2. customerName(String)
3. address(String)

1. Get. Service implemented for Products and Brands:

a. getting all products details
	/products
b. getting products detail by id
	/products/id/{id}
c. getting products detail by name
	/products/name/{name}

a. getting all brands details
	/brands
b. getting brands by brand id
	/brands/id/{id}
c. getting brands by brand name
	/brands/brand/{name}
d. getting brands by productId
	brands/productId/{productId}

2. Post service implemented for Orders and customer:

a. /orders

need to send data for this post service. Below is example given:

{

"orderDate":"2022-02-25",

"orderDileveredDate":"2022-02-29",

"orderStatus": "Delivered",

"productId": 6,

"paymentSource":"Online",

"paymentStatus": "Pending",

"customers":

[{

"userId": 4,

"customerName":"XYZ",

"address":"Nashik"

}]

}

3.Get Services implemented for orders

a. getting all order details
	/orders
b. getting order details by order ID
	/orders/id/{id}

/customers

We are posting customer details from /order service but for testing we can send below data for this service :

 {    

     "customerName":"Sukanya",    

      "address":"Pune"

 }

QUERY:

SELECT O.*,C.CUSTOMER_NAME ,C.ADDRESS FROM TBL_ORDERS O,TBL_CUSTOMER C

spshoppingcart's People

Contributors

patilsukanya avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.