Changes between Initial Version and Version 1 of UseCase04

Timestamp:

05/08/26 03:06:01 (4 hours ago)

Author:

181201

Comment:

--

UseCase04

@@ +1 @@
+== Use-case 0004 - Create a Booking
+
+'''Initiating actor:''' Pet Owner
+
+'''Other actors:''' Pet Sitter
+
+'''Description:'''
+A Pet Owner finds a Pet Sitter they like and requests a booking. They must select the specific service they want. The system creates the booking and links the requested services using a secure database transaction.
+
+'''Scenario:'''
+ 1. Pet Owner views the profile of a sitter (e.g., `sitter_filip`) and clicks "Request Booking".
+ 2. System provides the specific services that this sitter offers to display in the booking form:
+{{{
+#!sql
+SELECT s.service_id, s.type, s.description 
+FROM services s
+JOIN sitter_services ss ON s.service_id = ss.service_id
+WHERE ss.sitter_id = (SELECT user_id FROM users WHERE username = 'sitter_filip');
+}}}
+ 3. Owner fills out the dates, location, selects the service, and submits.
+ 4. System creates the booking with a 'PENDING' status and attaches the requested service simultaneously:
+{{{
+#!sql
+BEGIN;
+
+WITH new_booking AS (
+    INSERT INTO bookings (status, date_from, date_to, address, owner_id, sitter_id)
+    VALUES (
+        'PENDING', '2026-06-10', '2026-06-12', 'ul. Partizanska br. 10',
+        (SELECT user_id FROM users WHERE username = 'owner_bojan'),
+        (SELECT user_id FROM users WHERE username = 'sitter_filip')
+    )
+    RETURNING booking_id
+)
+INSERT INTO booking_services (booking_id, service_id)
+SELECT nb.booking_id, (SELECT service_id FROM services WHERE type = 'Dog Walking')
+FROM new_booking nb;
+
+COMMIT;
+}}}