Rate & Review a build

Actors

User, Admin

Scenario

1. The user opens the completed builds page, opens the details popup for a build

2. The user clicks on "REVIEWS" and an option to rate and write a review for the build is displayed

3. The user rates the build and writes a review

4. The user clicks on "SUBMIT REVIEW" and the rating and review are submitted

   INSERT INTO rating_build (user_id, build_id, value)
   VALUES ($userId, $buildId, $value)
   ON CONFLICT (user_id, build_id)
   DO UPDATE SET
     value = $value
   

INSERT INTO review (user_id, build_id, content, created_at)
VALUES ($userId, $buildId, $content, $createdAt)
ON CONFLICT (build_id, user_id)
DO UPDATE SET
  content = $content,
  created_at = $createdAt