Changes between Initial Version and Version 1 of RateAndReviewBuild


Ignore:
Timestamp:
12/28/25 23:29:43 (10 hours ago)
Author:
233051
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RateAndReviewBuild

    v1 v1  
     1== User opens dashboard ==
     2
     3=== Actors ===
     4User, Admin
     5
     6=== Scenario ===
     71. The user opens the completed builds page, opens the details popup for a build
     82. The user clicks on "REVIEWS"
     93. An option to rate and write a review for the build is displayed
     104. The user rates the build and writes a review
     115. The user clicks on "SUBMIT REVIEW" and the rating and review are submitted
     12
     13{{{
     14INSERT INTO rating_build (user_id, build_id, value)
     15VALUES ($userId, $buildId, $value)
     16ON CONFLICT (user_id, build_id)
     17DO UPDATE SET
     18  value = $value
     19}}}
     20
     21{{{
     22NSERT INTO review (user_id, build_id, content, created_at)
     23VALUES ($userId, $buildId, $content, $createdAt)
     24ON CONFLICT (build_id, user_id)
     25DO UPDATE SET
     26  content = $content,
     27  created_at = $createdAt
     28}}}