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