Validation: Sponsor seed data fixture (#323)
Ticket
basketball-api#323 — Board item #768. Sponsor seed data JSON fixture (44 businesses).
Environment
Prod: basketball-api pod in k8s namespace basketball-api. Verified 2026-04-06.
Checks
| # | Criterion | How to Verify | Result | Evidence |
|---|---|---|---|---|
| 1 | Valid JSON with 44 entries | python3 json.load + count | PASS | 44 sponsors loaded via seed endpoint |
| 2 | No duplicate emails | QA review on PR #327 | PASS | QA approved — all 44 unique emails |
| 3 | Categories match spec | QA review verified categories | PASS | 7 categories: financial(6), food(21), retail(1), automotive(5), construction(4), fitness(2), dental(5) |
| 4 | Seeded into prod DB | kubectl exec — query Sponsor count | PASS | "Seeded 44 sponsors. Total sponsors in DB: 44" |
Verdict
PASS — 44 sponsors seeded into prod, used in live email blast (23 delivered, 21 bounced).