EdaCam_Homeworks
This repo was created for Eda Çam's assignments in Akbank Full Stack Bootcamp.
Week 1
A Web API has been designed in which CRUD operations of a product containing id, name, price, brand, barcode, weight, expiry date information are carried out. This Web API has the features of;
- Listing products,
- Displaying the product related to the product's id information,
- Adding a new product to the system,
- Updating the product related to the product's id information,
- Deleting the product related to the product's id information from the system.
Week 2
The API has been tested using Postman, an API platform for the designed Web API, and screenshots of the relevant test results have been added.
- As a result of the product listing request, the response received by calling the method that brings the products in the system.
- As a result of the request to fetch the product related to the product id given as a parameter, the response received by calling the method that brings the product with the id in the system.
- In order to add a new product, the new product information in json format added to the body as a parameter, and the response returned by calling the method that returns the Result object as a response and displays the request status, message and the current product list in the system as response of the addition process.
- In order to add a new product, the product information with the previously existing idy in the system is added to the body as a parameter, the new product information in json format, and as a result of the addition process, the Result object is returned as a response and the request status (failed), the message (this product already exists) and the system The response returned by calling the method that displays the current product list (no new products added).
-
In order to update the product, the id information of the product with the existing id in the system is added to the endpoint and the current product information is added as a parameter to the body, the current product information in json format, and the method that returns the Result object as a response and shows the request status, message and the current product list in the system as a result of the update process. The response returned by the call.
-
In order to update the product, the id information of the product with an id that did not exist in the system before, and the current product information in the endpoint and the current product information as a parameter to the body, is the current product information in json format, and as a result of the update process, it returns the Result object and the request status (failed), the message (this product is not in the system). and the response returned by calling the method that displays the current product list (unchanged) in the system.
- To delete the product, the id information of the product with the existing id in the system is added as a parameter to the endpoint, and the response is returned by calling the method that returns the Result object as a response after the deletion process and displays the request status, message and the current product list in the system (the product has been deleted).
- In order to delete the product, by calling the method that adds the id information of the product with an id that does not exist in the system as a parameter to the endpoint and returns the Result object as a response after the deletion process and displays the request status (failed), the message (the product has already been deleted) and the current product list in the system (the product is not deleted). returning reply.
Week 3
-
A ProductDB database was created to save product information. Then, Product and Brand tables were added to this database.
-
The fields in the product table are as in the figure.
-
The fields in the Brand table are as in the figure.
-
Then it was tested by adding data to these tables.
-
Product
-
Brand
-
Finally, by establishing a one-to-many relationship between these two tables, the brandId information of the product was obtained from the Brand table.
