Retrieves all reviews for a given game, sorted by most recent.
The SKU of the game to retrieve reviews for.
A list of reviews sorted by creation date descending.
Checks whether the user has already reviewed the given game. Each user may only submit one review per purchased game.
The ID of the user to check.
The SKU of the game to check.
True if the user has already reviewed the game, false otherwise.
Checks whether the user has purchased the given game. A user can only review a game they have bought.
TODO: Uncomment the real implementation below once an order flow has been implemented. The order_item and order tables need to exist and be populated for this to work.
The ID of the user to check.
The SKU of the game to check.
Always true until an order flow is implemented.
Submits a review for a game by the logged-in user.
The ID of the user submitting the review.
The SKU of the game being reviewed.
Star rating between 1 and 5.
The written review text.
Service responsible for handling game review logic.