Changes between Version 1 and Version 2 of UseCase11

Timestamp:

01/25/26 19:15:24 (2 weeks ago)

Author:

231035

Comment:

--

UseCase11

@@ -8 +8 @@
 SELECT clinic_id, name, city, address
 FROM vet_clinics
-WHERE clinic_id = $1;
+WHERE name = 'Happy Paws Clinic';
 }}}
 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.viktor'),
+    5,
+    'Excellent clinic, very professional staff.',
+    NOW()
+  )
+  RETURNING review_id
+)
 INSERT INTO clinic_reviews (review_id, target_clinic_id)
-VALUES ($4, $5);
+SELECT
+  nr.review_id,
+  (SELECT clinic_id FROM vet_clinics WHERE name = 'Happy Paws Clinic')
+FROM new_review nr;
 
 COMMIT;