WP-10: Pack Opening Hook — evolution_card_state Initialization #75

New Issue

cal · 2026-03-12T20:56:26Z

cal commented

2026-03-12 20:56:26 +00:00

Description

When cards are acquired (pack opening or trade), check if an evolution_card_state record exists for the (player_id, team_id) pair. If not, create one with the correct track assignment. Lightweight get_or_create that must NOT block or slow down pack opening.

Repo: database
Phase: 1b (API & Formula Engine)
Dependencies: WP-01, WP-03
Complexity: S

Card Type Determination

player.pos_1 contains "SP" → 'sp' track
player.pos_1 contains "RP" or "CP" → 'rp' track
Otherwise → 'batter' track

Files

Create: database/app/services/evolution_init.py
Modify: database/app/routers_v2/cards.py — add hook after card POST

Tests (write first in `database/tests/test_evolution_init.py`)

Unit: track assignment for batter/sp/rp
Integration: first card creates state (current_tier=0, current_value=0.0)
Integration: duplicate card skips creation (still one row)
Integration: different player creates new state
Integration: card_type determination from positions

Acceptance Criteria

Every new card acquisition triggers the check
First card for (player_id, team_id) creates state
Duplicate cards don't create duplicate states
Track assignment correct for all card types
Evolution init failure does NOT break card creation (try/except)

Plan reference: docs/prd-evolution/PHASE1_PROJECT_PLAN.md WP-10

## Description When cards are acquired (pack opening or trade), check if an `evolution_card_state` record exists for the `(player_id, team_id)` pair. If not, create one with the correct track assignment. Lightweight `get_or_create` that must NOT block or slow down pack opening. **Repo:** `database` **Phase:** 1b (API & Formula Engine) **Dependencies:** WP-01, WP-03 **Complexity:** S ## Card Type Determination 1. `player.pos_1` contains "SP" → 'sp' track 2. `player.pos_1` contains "RP" or "CP" → 'rp' track 3. Otherwise → 'batter' track ## Files - **Create:** `database/app/services/evolution_init.py` - **Modify:** `database/app/routers_v2/cards.py` — add hook after card POST ## Tests (write first in `database/tests/test_evolution_init.py`) - [ ] Unit: track assignment for batter/sp/rp - [ ] Integration: first card creates state (current_tier=0, current_value=0.0) - [ ] Integration: duplicate card skips creation (still one row) - [ ] Integration: different player creates new state - [ ] Integration: card_type determination from positions ## Acceptance Criteria 1. Every new card acquisition triggers the check 2. First card for (player_id, team_id) creates state 3. Duplicate cards don't create duplicate states 4. Track assignment correct for all card types 5. Evolution init failure does NOT break card creation (try/except) **Plan reference:** `docs/prd-evolution/PHASE1_PROJECT_PLAN.md` WP-10

cal added this to the Card Evolution Phase 1 milestone 2026-03-12 20:59:13 +00:00

cal added the

evolution

phase-1b

labels 2026-03-12 20:59:25 +00:00

cal referenced this issue

2026-03-12 20:59:51 +00:00

Card Evolution Phase 1 — Master Tracker #81

Claude added the

ai-working

label 2026-03-13 07:01:37 +00:00

cal referenced this issue from a commit