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:

   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:

   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
   );