The RESTful API I made is here: https://github.com/frankymz/databaseAPI. View the Service.js file here in the src/API folder to see how these were implemented.
The project is not yet meant to be ran from another device as the data on MySQL Workbench is not accessible remotely as of now.
The client side project structure is a Pages folder and a Components folder inside of src.
2021-08-24.22-19-07.mp4
/books : get all books
/bookById/{id} : get book by id
/book/{name} : get book by name
/books/{genre} : get list of books by genre
/addBook : add a book
/addBooks : add multiple books
/update : update book
/delete/{id} : delete a book by id
/reviews/{book} : gets list of reviews for a book
/review/{date} : gets list of reviews from a certain day
/addReview : adds a review
/addUser : adds a user
/userSaved/{user}/{book} : get user by username and book
/userSaved : get list of all saved books by all users
/userSaves/{user} : get list of books saved by a certain user
/addUserSave : add a user saved book
/deleteById/{id} : delete a user saved book by id