Changes between Version 1 and Version 2 of UseCase06PrototypeImplementation


Ignore:
Timestamp:
02/08/26 15:23:59 (112 minutes ago)
Author:
231035
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • UseCase06PrototypeImplementation

    v1 v2  
    55== Scenario
    661. Client opens a target user profile.
    7 {{{
    8 SELECT user_id, username, name, surname
    9 FROM users
    10 WHERE username = 'client.igor';
    11 }}}
     7[[Image(creview.png)]]
    1282. Clicks the "Leave review" button.
     9[[Image(creview1.png)]]
    13103. Client enters rating, comment and submits.
    14 {{{
    15 BEGIN;
    16 
    17 WITH new_review AS (
    18   INSERT INTO reviews (reviewer_id, rating, comment, created_at)
    19   VALUES (
    20     (SELECT user_id FROM users WHERE username = 'client.sara'),
    21     5,
    22     'Very helpful and professional. Recommended!',
    23     NOW()
    24   )
    25   RETURNING review_id
    26 )
    27 
    28 INSERT INTO user_reviews (review_id, target_user_id)
    29 SELECT
    30   nr.review_id,
    31   (SELECT user_id FROM users WHERE username = 'client.igor')
    32 FROM new_review nr;
    33 
    34 COMMIT;
    35 }}}
     11[[Image(creview2.png)]]
     12[[Image(creview3.png)]]