Changes between Version 1 and Version 2 of UseCase06

Timestamp:

01/25/26 19:14:44 (2 weeks ago)

Author:

231035

Comment:

--

UseCase06

@@ -8 +8 @@
 SELECT user_id, username, name, surname
 FROM users
-WHERE user_id = $1;
+WHERE username = 'client.igor';
 }}}
 2. Clicks the "Leave review" button.
@@ -15 +15 @@
 BEGIN;
 
-INSERT INTO reviews (reviewer_id, rating, comment, created_at)
-VALUES ($1, $2, $3, NOW())
-RETURNING review_id;
+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)
-VALUES ($4, $5);
+SELECT
+  nr.review_id,
+  (SELECT user_id FROM users WHERE username = 'client.igor')
+FROM new_review nr;
 
 COMMIT;