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 r1_0.review_id,
r1_0.comment,
r1_0.created_at,
r1_0.is_deleted,
r1_0.rating,
r1_0.reviewer_id,
r2_0.user_id,
r2_0.created_at,
r2_0.email,
r2_0.name,
r2_0.surname,
r2_0.password_hash,
r2_0.username,
r1_0.updated_at 
from user_reviews ur1_0 
join reviews r1_0 on r1_0.review_id=ur1_0.review_id 
join users r2_0 on r2_0.user_id=r1_0.reviewer_id 
where ur1_0.target_user_id=? and r1_0.is_deleted=false
 order by r1_0.created_at desc

2. Clicks the "Leave review" button.

3. Client enters rating, comment and submits.

insert into reviews (comment,created_at,is_deleted,rating,reviewer_id,updated_at) 
values (?,?,?,?,?,?)