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;