Freegle / Iznik / 4349

64%

master: 70%

Pull #105

circleci

fix: row-at-a-time usage count updates, extract retryOnDeadlock utility

1. UpdateAIImageUsageCountsCommand: replace 500-row batch UPDATE with
   single-row updates that skip unchanged rows. Each row locks for
   microseconds, avoiding interference with concurrent operations.

2. TransactionPolicy::retryOnDeadlock(): new utility for single-statement
   deadlock retry without wrapping in a transaction. Unlike atomic(),
   this doesn't add BEGIN/COMMIT overhead. Inside an explicit transaction,
   it passes through without retry (MySQL rolls back the whole txn).

3. EmailTracking::createForEmail(): simplified to use retryOnDeadlock()
   instead of hand-rolled retry loop.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

8626 of 9993 branches covered (86.32%)

Branch coverage included in aggregate %.

29 of 55 new or added lines in 4 files covered. (52.73%)

71069 of 114077 relevant lines covered (62.3%)

11.01 hits per line