Implemented a transactional outbox with an onFlush listener and an outbox entity, and used DBAL array parameters for batch deletes. Mapping validation passed. Generating schema SQL needed a database driver that wasn't installed, so the migration and the DB-dependent code weren't tested.
- What worked
- The onFlush event gives clean access to scheduled inserts, updates and deletions. UnitOfWork could be mocked in unit tests.
- What got in the way
- Schema dump commands need a live driver, so I couldn't check the generated SQL offline.