=== STARTING VERIFICATION SUITE ===

0. Running Master Migrations...
  - Migrations status: SUCCESS (All tables verified/created)

1. Checking Database Tables...
  - Table 'preauthorized_emails': OK (EXISTS)
  - Table 'provider_documents': OK (EXISTS)
  - Table 'provider_references': OK (EXISTS)
  - Table 'provider_bio_change_requests': OK (EXISTS)
Checking provider table columns:
  - Column 'first_name': OK
  - Column 'last_name': OK
  - Column 'date_of_birth': OK
  - Column 'classification': OK
  - Column 'languages': OK
  - Column 'topics_of_focus': OK
  - Column 'bank_iban': OK
  - Column 'bank_bic_swift': OK
  - Column 'bank_name': OK
  - Column 'bank_address': OK
  - Column 'tax_reference_number': OK
  - Column 'vat_status': OK
  - Column 'vat_rate_pct': OK
  - Column 'bio_status': OK
  - Column 'bio_locked': OK
  - Column 'onboarding_step': OK
  - Column 'approval_status': OK
  - Column 'is_match_ready': OK

2. Testing PreauthEngine for Client & Provider Allowlist...
  - Add Client Allowlist: SUCCESS (Token: dd9216e092da1dcdb1af9e800c2ef5fba3047f64dedf9a8a08bb0f6583db4b4d)
  - Check Preauthorization for Valid Client: PASSED (Company: TechCorp Ireland Ltd.)
  - Check Preauthorization for Unauthorized Client: PASSED (Rejected as expected)
  - Add Provider Allowlist: SUCCESS (Token: 974dbda7f456d3e1db297a19f4027d0c3573489f8e334eb97564b45bb18c29e3)

3. Testing Provider Registration (Token vs Direct Email)...
  - Validate Token: VALID (Email: dr.onboarding.test.1788041862@clinicmhc.ie)
  - Reject Unauthorized Direct Email: PASSED (Rejected with message: 'The email 'unauthorized.specialist@nobody.com' is not currently pre-authorized. Please contact our Clinical Governance Team at provider@mentalhealthchange.ie to request an invitation.')
  - Register Provider Direct Email (No Token): SUCCESS (User ID: 47, Provider ID: 8)
  - Register Provider via Token: SUCCESS (User ID: 48, Provider ID: 9)

4. Testing Provider Forms Submission (Unlimited Topics, Languages, Bank, VAT, Timetable, Bio)...
  - Save Forms: SUCCESS (Step: documents)

5. Testing 9 Compliance Document Uploads...
  - Uploaded doc 'photo': OK
  - Uploaded doc 'insurance': OK
  - Uploaded doc 'qualifications': OK
  - Uploaded doc 'membership': OK
  - Uploaded doc 'id_proof': OK
  - Uploaded doc 'cpd_evidence': OK
  - Uploaded doc 'garda_vetting': OK
  - Uploaded doc 'experience_proof': OK
  - Uploaded doc 'references': OK

6. Testing Submit Application for Review...
  - Submit Application: SUCCESS (Status: submitted)

7. Testing Clinical Lead Review & Approval (Modality: COUNSELLOR)...
  - Applications submitted in audit queue: 1
  - Clinical Approval: SUCCESS (Provider approved as COUNSELLOR and activated for client matching.)
  - Provider is_match_ready: 1 (Expected: 1)
  - Provider approval_status: approved (Expected: approved)
  - Provider classification: counsellor (Expected: counsellor)
  - Provider bio_locked: 1 (Expected: 1)

8. Testing Matching Engine for New Approved Specialist...
  - Total Counselling matches found: 7
  - Found newly approved specialist: 'Dr. Eoin Gallagher' (Score: 70, Modality: counsellor)
  - Specialist in Match Results: VERIFIED (MATCHED!)

=== ALL VERIFICATION TESTS COMPLETED SUCCESSFULLY! ===