#!/usr/bin/env php

=== X.1.2: Gala-Order Happy Path Integration Tests ===

Database: globalgala_2026_dev
Event ID: 1
Mock Order Count: 50

Cleaning up previous test data...
Done.

✓ Test 1: Feature flag enables Gala domain reading
✓ Test 2: GalaReadInterface returns Event data
✗ Test 3: GalaReadInterface returns capacity summary
  → Total: 1425, Available: 381, Expected: 1341
✗ Test 4: Create 50 mock orders reading Gala pricing
  → SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-c58a3923-b340-4d3f-bf4d-44635f022fe4-' for key 'unique_active_event_seat' (SQL: insert into `seat_reservations` (`event_id`, `seat_id`, `session_id`, `order_id`, `status`, `hold_token`, `price_snapshot`, `currency`, `include_booking_fee`, `include_tax`, `updated_at`, `created_at`) values (1, c58a3923-b340-4d3f-bf4d-44635f022fe4, X12_TEST_cd69416e-c44d-4ace-b29a-455a3b78baef, 835, booked, 32feecab-59a7-4867-9d98-ceb503bc014c, 1000, GBP, 1, 1, 2026-05-15 18:41:18, 2026-05-15 18:41:18))
✗ Test 5: Availability calculated correctly (1341 - 50 = 1291)
  → Sold: 1044, Available: 381, Expected Available: 1291
✗ Test 6: Payment status fields captured correctly
  → Count: 1, StatusPaid: 1, PaymentPaid: 1
✓ Test 7: Order status separate from Gala status
✗ Test 8: GalaAvailabilityService counts sold seats
  → Sold: 1044, Expected: 50

=== Test Cleanup ===
Test data cleaned up.

=== Test Summary ===
Passed: 3
Failed: 5
Total: 8