Changes between Initial Version and Version 1 of UseCase07

Timestamp:

05/08/26 03:11:46 (4 hours ago)

Author:

181201

Comment:

--

UseCase07

@@ +1 @@
+== Use-case 0007 - Accept a Booking
+
+'''Initiating actor:''' Pet Sitter
+
+'''Other actors:''' Pet Owner
+
+'''Description:'''
+A Pet Sitter logs in and sees they have a new pending booking request. They review the dates, the requested service, and decide to accept the job. The system updates the booking status.
+
+'''Scenario:'''
+ 1. Pet Sitter goes to their "Pending Requests" dashboard.
+ 2. System fetches all bookings assigned to them that are still pending:
+{{{
+#!sql
+SELECT booking_id, date_from, date_to, address 
+FROM bookings 
+WHERE sitter_id = (SELECT user_id FROM users WHERE username = 'sitter_filip')
+  AND status = 'PENDING';
+}}}
+ 3. Sitter clicks the "Accept Booking" button on a specific request.
+ 4. System updates the status of the booking in the database to CONFIRMED:
+{{{
+#!sql
+UPDATE bookings
+SET status = 'CONFIRMED'
+WHERE booking_id = (
+    SELECT booking_id FROM bookings 
+    WHERE status = 'PENDING' 
+      AND sitter_id = (SELECT user_id FROM users WHERE username = 'sitter_filip') 
+    LIMIT 1
+);
+}}}