=== Database Cleanup Cron Integration Test ===

Creating test schema...
✓ Schema created

Test 1: Creating test data...
✓ Created valid records and orphaned records

Test 2: Counting records before cleanup...
Studies: 2 (1 valid + 1 orphaned)
Schedules: 2 (1 valid + 1 orphaned)
Notifications: 2 (1 valid + 1 orphaned)

Test 3: Running database cleanup...
✓ Cleanup executed
  - Studies cleaned: 1
  - Schedules cleaned: 1
  - Notifications cleaned: 1

Test 4: Verifying cleanup results...
✓ Valid records preserved
✓ Orphaned records removed

Test 5: Verifying cron integration...
Cron completed
✓ Cron cleanup integration verified
Warning: Cron output may not include cleanup report
Output:
Error processing notification 1: SQLSTATE[HY000]: General error: 1 no such column: phone
Error creating notification for schedule 1: SQLSTATE[HY000]: General error: 1 table notifications has no column named delivery_method
Starting Cron Job at 2026-01-27 07:11:32
Cron Job Finished at 2026-01-27 07:11:32


=== ALL TESTS PASSED ✓ ===