=== Database Utility Class Tests ===

Test 1: Establishing database connection...
✓ Connection established successfully
  Connection type: PDO

Test 2: Executing SELECT query...
✓ Query executed successfully
  Found 10 tables: admin_users, allocations, deposits, market_data, positions, trade_results, traders, trades, users, wallets

Test 3: Testing prepared statements...
✓ Prepared statement executed successfully
  Non-demo users count: 1

Test 4: Testing transaction support...
✓ Transaction started
✓ Insert executed: 1 row(s) affected
✓ Last insert ID: 222
✓ Transaction rolled back successfully

Test 5: Verifying rollback...
✓ Rollback verified - test user not found in database

Test 6: Testing execute method with commit...
✓ Execute method: 1 row(s) affected
✓ Last insert ID: 222
✓ Transaction committed successfully
✓ Commit verified - user found in database
✓ Test user cleaned up

Test 7: Verifying foreign key constraints are enabled...
✓ Foreign key constraints are ENABLED

Test 8: Verifying database configuration...
  Journal mode: wal
  Synchronous: 1
✓ Database configuration verified

=== All tests completed ===