In this lab you will develop a Product Review Application.
-
Make domain models for
Category
withid
andname
.- A
Category
can have manyProducts
.
- A
Product
withid, name, price
andrating
.- A
Product
can belong to only oneCategory
.
- A
User
withid, email, password, firstName, lastname
.User
can create manyReviews
.User
can have only oneAddress
.
Address
withid, street, zip
andcity
.- An
Address
can belong to only oneUser
.
- An
Review
withid, comment
.- A
Review
can only belong to oneUser
.
- A
-
Implement CRUD operations and build REST API for all domain models.
-
Implement the following queries by using
Naming Convention
andJPQL
. Create REST endpoints for them.- Find all products that cost more than
minPrice
. - Find all products in
cat
category and cost less thanmaxPrice
. - Find all products that contain
keyword
in the name. - Find reviews of the product whose id is
id
.
- Find all products that cost more than
- Use n-tier software architecture model.
- Use DTOs.
- PostgreSQL is recommended as a Relational Database system.
- Populate your database with dummy data using
data.sql
.
- Create a postman collection that includes sample requests for all of your endpoints.
- Fork the repository and push your changes.
- Once you finished your project, send a Pull Request. (Send only one Pull Request once you finish the assignment.)
- You are not allowed to share codes with your classmates. If detected, you will get NC.
- For pairs:
- Individual's work will be checked from the commits.
- Share tasks evenly and fairly.
- To have a clearer understanding of pair programming:
-
Pair programming is an agile software development technique in which two programmers work together at one workstation. One, the driver, writes code while the other, the observer or navigator reviews each line of code as it is typed in. The two programmers switch roles frequently.
- Wikipedia
-
-
Remember to respect the code honor submission policy. All written code must be original. Presenting something as one’s own work when it came from another source is plagiarism and is forbidden.
-
Plagiarism is a very serious thing in all American academic institutions and is guarded against vigilantly by every professor.