A Student that completes this project shows they can:
For this project we are starting with your ending project from Shopping Cart. We are going to deploy this project to Heroku.
A shopping cart is a very common application so let's look at one. This Java Spring REST API application will provide endpoints for clients to perform the various CRUD operations on data sets contained in the application's data. Access to these endpoints will be secured using OAuth2 Authentication.
The table layout from your Shopping Cart Project should be
All tables contain the following auditing fields
- created_by - user name who created the row. Should default to SYSTEM
- created_date - date field when the row was created
- last_modified_by - user name who last changed data in the row. Should default to SYSTEM
- last_modified_date - date field when the data in the row was last changed
Table Relationships include
- Users is the driving table.
- Users have a One to Many relationship with Carts. One user can have many shopping carts while each shopping cart is associated with only one user.
- Carts have a Many to Many relationship with Products. Many Carts can have the same product and the same product can be in many carts.
- The Carts - Products many to many relationship is modeled using the join table CartItems which contains the quantity of the product being ordered.
- Users have a Many to Many relationship with Roles. A user can have many roles while many users can have the same role.
Remember the original code for the Shopping Cart application works but code layout is not optimal, comments are sporadic and several features are missing from the application. For example, no code allows you to update a user's information. This is provided as an example of the type of code you might see in industry. Remember we had to start from what we are given!
The application has the following endpoints available.
http://localhost:2019/users/users
[
{
"userid": 1,
"username": "barnbarn",
"comments": "",
"carts": [
{
"cartid": 1,
"products": [
{
"product": {
"productid": 1,
"name": "PEN",
"price": 2.5,
"description": "MAKES WORDS",
"comments": ""
},
"quantity": 4,
"comments": ""
},
{
"product": {
"productid": 2,
"name": "PENCIL",
"price": 1.5,
"description": "DOES MATH",
"comments": ""
},
"quantity": 3,
"comments": ""
},
{
"product": {
"productid": 3,
"name": "COFFEE",
"price": 4.0,
"description": "EVERYONE NEEDS COFFEE",
"comments": ""
},
"quantity": 2,
"comments": ""
}
]
},
{
"cartid": 2,
"products": [
{
"product": {
"productid": 3,
"name": "COFFEE",
"price": 4.0,
"description": "EVERYONE NEEDS COFFEE",
"comments": ""
},
"quantity": 1,
"comments": ""
}
]
}
]
},
{
"userid": 2,
"username": "cinnamon",
"comments": "",
"carts": []
},
{
"userid": 3,
"username": "stumps",
"comments": "",
"carts": [
{
"cartid": 3,
"products": [
{
"product": {
"productid": 3,
"name": "COFFEE",
"price": 4.0,
"description": "EVERYONE NEEDS COFFEE",
"comments": ""
},
"quantity": 17,
"comments": ""
}
]
}
]
}
]http://localhost:2019/users/user/1
{
"userid": 1,
"username": "barnbarn",
"comments": "",
"carts": [
{
"cartid": 1,
"products": [
{
"product": {
"productid": 1,
"name": "PEN",
"price": 2.5,
"description": "MAKES WORDS",
"comments": ""
},
"quantity": 4,
"comments": ""
},
{
"product": {
"productid": 2,
"name": "PENCIL",
"price": 1.5,
"description": "DOES MATH",
"comments": ""
},
"quantity": 3,
"comments": ""
},
{
"product": {
"productid": 3,
"name": "COFFEE",
"price": 4.0,
"description": "EVERYONE NEEDS COFFEE",
"comments": ""
},
"quantity": 2,
"comments": ""
}
]
},
{
"cartid": 2,
"products": [
{
"product": {
"productid": 3,
"name": "COFFEE",
"price": 4.0,
"description": "EVERYONE NEEDS COFFEE",
"comments": ""
},
"quantity": 1,
"comments": ""
}
]
}
]
}POST http://localhost:2019/users/user
DATA
{
"username": "tiger",
"comments": ""
}OUTPUT
STATUS 201 Created
Location Header: http://localhost:2019/users/user/15
DELETE http://localhost:2019/users/user/1
STATUS OK
http://localhost:2019/carts/user/3
[
{
"cartid": 3,
"products": [
{
"product": {
"productid": 3,
"name": "COFFEE",
"price": 4.0,
"description": "EVERYONE NEEDS COFFEE",
"comments": ""
},
"quantity": 17,
"comments": ""
}
],
"user": {
"userid": 3,
"username": "stumps",
"comments": ""
}
}
]http://localhost:2019/carts/cart/3
{
"cartid": 3,
"products": [
{
"product": {
"productid": 3,
"name": "COFFEE",
"price": 4.0,
"description": "EVERYONE NEEDS COFFEE",
"comments": ""
},
"quantity": 17,
"comments": ""
}
],
"user": {
"userid": 3,
"username": "stumps",
"comments": ""
}
}Restarted application
POST http://localhost:2019/carts/create/user/1/product/2
Status 201 Created
PUT http://localhost:2019/carts/update/cart/1/product/1
Status OK
DELETE http://localhost:2019/carts/delete/cart/1/product/1
Status OK
http://localhost:2019/products/products
[
{
"productid": 1,
"name": "PEN",
"price": 2.5,
"description": "MAKES WORDS",
"comments": "",
"carts": [
{
"cart": {
"cartid": 1,
"user": {
"userid": 1,
"username": "barnbarn",
"comments": ""
}
},
"quantity": 4,
"comments": ""
}
]
},
{
"productid": 2,
"name": "PENCIL",
"price": 1.5,
"description": "DOES MATH",
"comments": "",
"carts": [
{
"cart": {
"cartid": 1,
"user": {
"userid": 1,
"username": "barnbarn",
"comments": ""
}
},
"quantity": 3,
"comments": ""
},
{
"cart": {
"cartid": 15,
"user": {
"userid": 1,
"username": "barnbarn",
"comments": ""
}
},
"quantity": 1,
"comments": ""
}
]
},
{
"productid": 3,
"name": "COFFEE",
"price": 4.0,
"description": "EVERYONE NEEDS COFFEE",
"comments": "",
"carts": [
{
"cart": {
"cartid": 1,
"user": {
"userid": 1,
"username": "barnbarn",
"comments": ""
}
},
"quantity": 2,
"comments": ""
},
{
"cart": {
"cartid": 2,
"user": {
"userid": 1,
"username": "barnbarn",
"comments": ""
}
},
"quantity": 1,
"comments": ""
},
{
"cart": {
"cartid": 3,
"user": {
"userid": 3,
"username": "stumps",
"comments": ""
}
},
"quantity": 17,
"comments": ""
}
]
}
]http://localhost:2019/products/product/1
{
"productid": 1,
"name": "PEN",
"price": 2.5,
"description": "MAKES WORDS",
"comments": "",
"carts": [
{
"cart": {
"cartid": 1,
"user": {
"userid": 1,
"username": "barnbarn",
"comments": ""
}
},
"quantity": 4,
"comments": ""
}
]
}POST http://localhost:2019/products/product
DATA
{
"name": "ERASER",
"price": 1.5,
"description": "KEEP TRYING",
"comments": ""
}OUTPUT
Status 201 CREATED
Location Header: http://localhost:2019/products/product/16
PUT http://localhost:2019/products/product/1
DATA
{
"name": "PIN",
"price": 1.5,
"description": "OUCH",
"comments": "PIN vs PEN"
}OUTPUT
STATUS OK
DELETE http://localhost:2019/products/product/1
STATUS OK- Please fork and clone this repository.
- This repository does not have a starter project, so you must start with the Shopping Cart Application from your submission for the module project https://github.com/LambdaSchool/java-shoppingcart.git. Regularly commit and push your code as appropriate.
- For the seed files provided in the original project, that all of the users' passwords are "LambdaLlama".
- Required Unit Testing.
- Write at least 2 unit tests for the user service.
- Write at least 2 unit tests for the user controller.
- Deploy the system to Heroku using PostgreSQL.
- Create a file under main/resources called info.txt
- In this file put the CURL commands needed for the following endpoints.
- Include after each CURL command, its results.
- The CURL commands should be run against your deployment on Heroku.
- Routes for CURL command
- GET /users/myinfo
- GET /carts/user
- Routes for CURL command
- POST /carts/create/product/1
- PUT /carts/update/cart/1/product/1
- DELETE /carts/delete/cart/1/product/1