=== Direct API Test ===

1. Testing database...
   ✅ Connected

2. Testing agents query directly...
   Query: SELECT u.id, u.full_name, u.profile_image, u.user_type FROM ...
   Result type: array
   Is array: YES
   Value: [{"id":40,"full_name":"Anika Desmond ","profile_image":null,"user_type":"agent"},{"id":46,"full_name":"Anthony Kwasi Adu","profile_image":null,"user_type":"landlord"},{"id":38,"full_name":"Asuamah Alice ","profile_image":null,"user_type":"landlord"},{"id":37,"full_name":"Baah Zanteyin Charles ","profile_image":null,"user_type":"agent"},{"id":44,"full_name":"Clinton Nana Agyemang ","profile_image":null,"user_type":"agent"},{"id":43,"full_name":"Ebenezer Owusu Takyi ","profile_image":null,"user_type":"agent"},{"id":31,"full_name":"frank ","profile_image":null,"user_type":"landlord"},{"id":4,"full_name":"Frank Asante","profile_image":null,"user_type":"landlord"},{"id":36,"full_name":"kpe Ofe","profile_image":null,"user_type":"landlord"},{"id":33,"full_name":"Michael Adamu","profile_image":null,"user_type":"landlord"},{"id":30,"full_name":"Miracle Oduro Dansowaa","profile_image":null,"user_type":"agent"},{"id":34,"full_name":"Peter Kweidu ","profile_image":null,"user_type":"landlord"},{"id":2,"full_name":"Samuel Nsowaa","profile_image":null,"user_type":"landlord"},{"id":45,"full_name":"Wintim foster ","profile_image":null,"user_type":"landlord"}]
   ✅ Got array with 14 results
   First result: {"id":40,"full_name":"Anika Desmond ","profile_image":null,"user_type":"agent"}

3. Testing room search (no parameters)...
   Query: SELECT r.id, r.title FROM rooms r LIMIT 5
   Result type: array
   Is array: YES
   ✅ Got array with 5 results

4. Testing room search (with parameters)...
   Query: SELECT r.id, r.title FROM rooms r WHERE r.title LIKE ? LIMIT 5
   Params: ["%bedroom%"]
   Result type: array
   Is array: YES
   ✅ Got array with 2 results

=== End Test ===