Validation: Seed practice_schedules table (#279)
Validation: basketball-api#279
Verdict: PASS
Checks
- Row count:
SELECT count(*) FROM practice_schedules= 17 ✓ - No NULLs: All start_time and end_time populated ✓
- Monday (day 0): 2 rows — 16U Local Kings + 17U Local Kings @ BWill 19:00-21:00 ✓
- Tuesday (day 1): 6 rows — all 7 teams across 3 courts @ West High 18:00-20:00 ✓
- Thursday (day 3): 3 rows — Elite/Select Kings @ LCA 17:00-20:00 (optional) ✓
- Friday (day 4): 3 rows — 16U Local Kings + both Queens @ BWill 19:00-21:00 ✓
- Sunday (day 6): 3 rows — 16U Elite + 17U Elite + 17U Select Kings @ Kongo 14:00-16:00 ✓
- Labels: All 17 rows have non-null labels (e.g. "16U Local Kings Mon Practice") ✓
- Tenant: All rows tenant_id=1 ✓
- Division: boys/girls correctly assigned per team ✓
Method
Direct SQL query via
kubectl exec -n basketball-api postgres-9b5b87b5-5nccx -- psql. Full 17-row output verified against westside-practice-schedule pal-e-docs note.Source
Board item #739, Forgejo issue forgejo_admin/basketball-api#279.