YachtMemory - Stay Processing Phase 1C.1e-b2 Test 2
=======================================================
This package performs the first real SQL transition test.

Safety model
------------
- Uses the existing CLOSED Stay #1 only after checking its validated baseline.
- Starts one MariaDB transaction.
- Injects that exact PDO into StayProcessingTransitionService.
- All synthetic changes and transition writes therefore use the same connection.
- A finally block always issues ROLLBACK while the transaction is active.
- After rollback, a fresh PDO reads the full stay_processing row and compares it
  with the pre-test snapshot.
- RESULT: OK requires the row to be exactly equal before and after.

Tests
-----
1 PENDING -> PROCESSING
2 PROCESSING -> RETRY
3 RETRY -> PROCESSING
4 PROCESSING -> COMPLETE
5 PROCESSING -> FAILED
6 stale worker for revision N rejected after input revision advances to N+1

Installation / execution
------------------------
  unzip -o YachtMemory_StayProcessing_Phase1C1e_b2_Test2_v1.zip

  php -l src/services/StayProcessingTransitionService.php
  php -l shared_dashboard/scripts/test_stay_processing_transitions_b2.php

  php shared_dashboard/scripts/test_stay_processing_transitions_b2.php

Expected final lines:
  ROLLBACK: OK
  POST-ROLLBACK DATABASE CHECK: OK
  REAL DATA CHANGED: NO
  TESTS=6 PASS=6 FAIL=0
  RESULT: OK

No SQL migration is included.
