Changes between Initial Version and Version 1 of UseCase06PrototypeImplementation

Timestamp:

02/08/26 13:32:56 (4 hours ago)

Author:

231035

Comment:

--

UseCase06PrototypeImplementation

@@ +1 @@
+= UseCase06 - Leave a client review
+** Initiating actor: Client **
+== Description
+A logged-in client can submit a review about another user in the system.
+== Scenario
+1. Client opens a target user profile.
+{{{
+SELECT user_id, username, name, surname
+FROM users
+WHERE username = 'client.igor';
+}}}
+2. Clicks the "Leave review" button.
+3. Client enters rating, comment and submits.
+{{{
+BEGIN;
+
+WITH new_review AS (
+  INSERT INTO reviews (reviewer_id, rating, comment, created_at)
+  VALUES (
+    (SELECT user_id FROM users WHERE username = 'client.sara'),
+    5,
+    'Very helpful and professional. Recommended!',
+    NOW()
+  )
+  RETURNING review_id
+)
+
+INSERT INTO user_reviews (review_id, target_user_id)
+SELECT
+  nr.review_id,
+  (SELECT user_id FROM users WHERE username = 'client.igor')
+FROM new_review nr;
+
+COMMIT;
+}}}