Changes between Version 2 and Version 3 of UseCase06PrototypeImplementation

Timestamp:

02/08/26 15:26:53 (109 minutes ago)

Author:

231035

Comment:

--

UseCase06PrototypeImplementation

@@ -6 +6 @@
 1. Client opens a target user profile.
 [[Image(creview.png)]]
+{{{
+ 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.
 [[Image(creview1.png)]]
@@ -11 +32 @@
 [[Image(creview2.png)]]
 [[Image(creview3.png)]]
+{{{
+insert into reviews (comment,created_at,is_deleted,rating,reviewer_id,updated_at) 
+values (?,?,?,?,?,?)
+}}}