The following tasks are part of milestone 3 and relate to the pages that you have worked on in this lab:
The "All" category.
You will need to add another button/link to the products page (if you haven't already got an All button/link) that will display all of the products when a user clicks it. The existing
getAllProducts function can be used as the click handler for this button/link.
Add a customer table to the database.
The customer ID field should be used as the primary key and should be generated by the database using an
auto_increment integer. Refer to lecture 8, slide 18 for more details. Note that you can use
integer --- there is no need for
bigint as shown in the lecture, particularly since your customer domain's equivalent field is also an integer.
The username should have a unique constraint. Refer to lecture 8, slide 13 for more details.
Create a persistent DAO for customers using JDBI.
saveCustomer method should not attempt to save the customer ID --- it is generated by the database.
validateCredentials method needs an SQL query that returns a
Boolean. See reference section <> for the details of how to do this.
Your Jooby customer module should be switched to using the persistent customer DAO.