Checkpoint 2

[pawaitemadisoncollege]

This is a reminder to complete the items I identified as needing improvement for #3 Respond to that issue when it is ready for review.

As reminder, checkpoint 2 includes:

• [x] Design and create your database - put your ERD in your repository for review.
• [x] Add one DAO with full CRUD (create, read, update, delete) using Hibernate
• [x] Fully unit test the DAO - include a screenshot showing all unit tests passing
• [x] Implement Log4J and remove all System.out.printlns. Be sure to use the search feature on github to make sure these are all removed!!!!
• [ ] Time log/journal and project plan updated

When your checkpoint is ready for review please respond to this issue.

[misterSokor]

@pawaitemadisoncollege Hi Paula! May I did not get all requirements but could you please check and guide me if I am wrong: 1 Design and create your database - put your ERD in your repository for review:

2 Add one DAO with full CRUD (create, read, update, delete) using Hibernate:

My project aligns with the requirement to add a DAO with full CRUD operations using Hibernate. I have implemented two repositories, BookingRepository and TimeSlotRepository, which serve as my DAOs. These repositories utilize Spring Data JPA and interact with the underlying database.

Create

• New TimeSlot and Booking objects are created using the save methods in TimeSlotRepository and BookingRepository

  Read

• The findAll methods in TimeSlotRepository and BookingRepository provide the functionality to retrieve all time slots and bookings, respectively.

  Update

• Updating data for time slots and bookings is achieved by calling the save methods. The changes made to the objects are automatically reflected in the database.

  Delete

• The delete methods in TimeSlotRepository and BookingRepository enable the removal of time slots and bookings.

3. Fully unit test the DAO - include a screenshot showing all unit tests passing:

4 Implement Log4J and remove all System.out.printlns I finally set logs and now it is working well

5 Paula could you please help to find the example for this step: Time log/journal and project plan updated

Thank you!

[pawaitemadisoncollege]

Hi @misterSokor. In the interest of time at this point in the semester, I am focusing feedback on areas for improvement:

• [ ] There are outstanding tasks from Checkpoint 1 that should be completed.

ERD

• [ ] One of your user stories refers to email, where is the user's email address represented in the ERD?
• [ ] Should the ERD also have a user's first name and last name? How will you know how a username matches up with a given student?
• [ ] The user story refers to contact details? How is this represented in the ERD (and screens!)
• [ ] From the above, it seems like maybe a user table is missing?
• [ ] I'm having a bit of a hard time validating the ERD as I do not see the screen design from Checkpoint 1 representing each user story.

DAO unit Test

• [ ] The tests are using the TimeSlotRepository to create and save. This would be a more thorough test if you set up the database with the test data, rather than relying on the code you are trying to test to do it.

Other

• [ ] While you are logging out some information, it isn't very useful in this format. GET ALL SLOTS AVAILABLE: [com.petersokor.TimeSlotManager.entity.TimeSlot@7416635a, com.petersokor.TimeSlotManager.entity.TimeSlot@20ed6d83, com.petersokor.TimeSlotManager.entity.TimeSlot@46424119, com.petersokor.TimeSlotManager.entity.TimeSlot@1348eaf2, com.petersokor.TimeSlotManager.entity.TimeSlot@7eeedb39, com.petersokor.TimeSlotManager.entity.TimeSlot@35242012, com.petersokor.TimeSlotManager.entity.TimeSlot@61bae526, com.petersokor.TimeSlotManager.entity.TimeSlot@35f19c99, com.petersokor.TimeSlotManager.entity.TimeSlot@3dceae0d, com.petersokor.TimeSlotManager.entity.TimeSlot@29fe2d16, com.petersokor.TimeSlotManager.entity.TimeSlot@1f5b7eda, com.petersokor.TimeSlotManager.entity.TimeSlot@26772cfc, com.petersokor.TimeSlotManager.entity.TimeSlot@6e0140f9, com.petersokor.TimeSlotManager.entity.TimeSlot@36cf46b2]
• [ ] Since we did not cover Spring in class, it's my expectation that you can explain all aspects of your code in detail and clearly explain how it correlates to the techniques we did use in class. Spring abstracts a lot of things and I want to make sure that you fully understand how this works.
• [ ] https://github.com/misterSokor/TimeSlotManager/blob/main/src/main/resources/application.properties this file contains some sensitive data that is publicly available.
• [ ] Missing proper documentation throughout the project.

Time Log and Project Plan

Can you point me to these? Are they current? There were examples in the demo application if you need them.