Food Ratings (backend)

[bjsilva1]

Database

Under the dishes table, we should add a two new columns to allow us to calculate the average rating of the dish:

• totalRating (an integer storing the sum of all ratings given)
• numRatings (an integer storing the total number of ratings given)

Procedures

We will also need to add a few tRPC procedures to access this data on the frontend.

• getRating - Given a dishID, returns the average rating of the dish. This is simply totalRating / numRatings
• addRating - Given a dishID and rating, adds 1 to the dish's numRatings and rating to the totalRating
• updateRating - Given a dishID, oldRating, and newRating, adds (newRating - oldRating) to the totalRating