Changes between Version 1 and Version 2 of UseCase14

Timestamp:

05/17/26 20:01:01 (8 days ago)

Author:

181201

Comment:

--

UseCase14

@@ -1 @@
-== Use-case 0014 - Cancel a Pending Booking
+== Use-case 0014 - Cancel an Active Booking
 
 '''Initiating actor:''' Pet Owner
@@ -6 +6 @@
 
 '''Description:'''
-An owner decides they no longer need a sitter and cancels a pending booking request before the sitter accepts it or before payment is made.
+An owner decides they no longer need a sitter and cancels an active (Pending or Confirmed) booking request before the job takes place.
 
 '''Scenario:'''
  1. Pet Owner navigates to their "My Bookings" page.
- 2. System fetches the owner's current pending bookings:
+ 2. System fetches the owner's current active bookings:
 {{{
 #!sql
@@ -16 +16 @@
 FROM bookings 
 WHERE owner_id = (SELECT user_id FROM users WHERE username = 'owner_bojan')
-  AND status = 'PENDING';
+  AND status IN ('Pending', 'Confirmed');
 }}}
- 3. Owner clicks the "Cancel Request" button.
+ 3. Owner clicks the "Cancel Booking" button.
  4. System updates the booking status:
 {{{
 #!sql
 UPDATE bookings
-SET status = 'CANCELLED'
-WHERE booking_id = (
-    SELECT booking_id FROM bookings 
-    WHERE status = 'PENDING' 
-      AND owner_id = (SELECT user_id FROM users WHERE username = 'owner_bojan') 
-    LIMIT 1
-);
+SET status = 'Canceled'
+WHERE booking_id = 'specific-booking-uuid-here';
 }}}