Changes between Initial Version and Version 1 of UseCase11

Timestamp:

01/24/26 13:43:23 (2 weeks ago)

Author:

231035

Comment:

--

UseCase11

@@ +1 @@
+= UseCase11 - Leave a !VetClinic review
+** Initiating actor: Client **
+== Description
+A logged-in client can submit a review about a vet clinic in the system. A client can review a vet clinic only if the client has at least one completed (DONE) appointment at that clinic for at least one of their pets(he is the current owner).
+== Scenario
+1. Client opens the clinics page.
+{{{
+SELECT clinic_id, name, city, address
+FROM vet_clinics
+WHERE clinic_id = $1;
+}}}
+2. Clicks the "Leave review" button.
+3. Client enters rating, comment and submits.
+{{{
+BEGIN;
+
+INSERT INTO reviews (reviewer_id, rating, comment, created_at)
+VALUES ($1, $2, $3, NOW())
+RETURNING review_id;
+
+INSERT INTO clinic_reviews (review_id, target_clinic_id)
+VALUES ($4, $5);
+
+COMMIT;
+}}}