Changes between Initial Version and Version 1 of LeaveReview

Timestamp:

12/30/25 16:20:18 (14 hours ago)

Author:

235018

Comment:

--

LeaveReview

@@ +1 @@
+== Leaving a Review
+
+==== Actors: **Registered Shopper**
+
+**1.** The user wants to submit a review after for their order.
+
+**2.** System checks if order is completed, but not canceled.
+
+{{{#!sql
+SELECT CASE 
+         WHEN EXISTS (
+             SELECT 1
+             FROM order
+             WHERE order_num = '0022025000001' AND (status='delivered')
+         ) THEN 'Yes'
+         ELSE 'No'
+       END AS has_review_permission;
+
+}}}
+
+**3.*** The application inserts the review into {{{review}}}.
+
+{{{#!sql
+INSERT INTO review (order_num, comment, rating, last_mod_date) VALUES
+('00125100001', 'Excellent quality!', 5, CURRENT_TIMESTAMP);
+
+}}}