=== TAF PostgreSQL Database Connection Test ===

1. Testing basic connection...
✅ Basic connection test: PASSED

2. Getting database information...
✅ Database info retrieval: PASSED
Database: frcsdb
User: taf
Version: PostgreSQL 17.6 (Ubuntu 17.6-1.pgdg24.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, 64-bit
Status: Connected

3. Testing query execution...
✅ Query execution: PASSED
Current Time: 2025-12-06 03:57:02.855052+00
DB Version: PostgreSQL 17.6 (Ubuntu 17.6-1.pgdg24.04+1) on x86...

4. Testing direct PDO access...
✅ Direct PDO access: PASSED
Message: Hello from PostgreSQL!

5. Testing table access...
✅ Table access: PASSED
Found 10 tables (showing first 10):
  - account_ai_feedback
  - aging_by_customer
  - aging_summary_by_org
  - appeals
  - applications
  - appraisal_templates
  - attendance
  - audit_logs
  - auth_events
  - auto_launch_modules

=== Test Complete ===

=== Usage Examples ===
1. Get singleton instance:
   $db = DatabaseConnection::getInstance()->getPdo();

2. Use helper function:
   $pdo = getDb();

3. Create new connection:
   $pdo = createDbConnection();

4. Test connection:
   if (testDbConnection()) { /* connection works */ }

5. Custom configuration:
   $pdo = createDbConnection(['host' => 'localhost', 'port' => 5433]);