2026-05-14: Fix docker:dev stale images and seed historical snapshots

Problems

Issue 1 — docker:dev shows wrong version, stale code

docker:dev runs docker-compose up with no rebuild and no gen-version call. If images were built previously by docker:prod (or any build without STRATA_ENV=development), the version baked into the frontend bundle is the clean tag → shows as v1.1.0 (production label), not v1.1.0-2-g185cf43 — DEV. Any code change committed since the last docker:reset is also invisible.

Root cause: docker:dev intentionally skipped rebuild for speed (~10s startup). This worked when the user always ran docker:reset after code changes, but created confusion when images were stale.

Fix: Add STRATA_ENV=development node scripts/gen-version.mjs all + layer-cached build to docker:dev. New distinction:

Command	Gen version	Build	DB
docker:dev	✅ DEV	✅ layer-cached	Preserved
docker:reset	✅ DEV	✅ layer-cached	Wiped
docker:nuke	✅ DEV	✅ no-cache	Wiped

Issue 2 — Colors still blue in docker:dev

Same root cause as Issue 1: old Docker image (built before useNetWorthBreakdown color fix). Fixed by fixing Issue 1 (rebuild picks up new code).

Issue 3 — Seed only has one snapshot per asset

After the useNetWorthBreakdown hook was changed to use asset snapshot dates as the X-axis, short time filters (1D, 7D, 1M, 3M) showed empty chart — because the seed only creates one snapshot at a hardcoded past date (2025-01-15), far outside the short ranges.

Fix: Generate 15 monthly relative-date snapshots per demo asset using new Date() at seed runtime (14 months ago → today). Values evolve realistically.

---

Implementation

package.json — docker:dev

"docker:dev": "DB_FILE=strata-dev.db node scripts/check-ports.mjs && DB_FILE=strata-dev.db docker-compose up",
"docker:dev": "DB_FILE=strata-dev.db node scripts/check-ports.mjs && STRATA_ENV=development node scripts/gen-version.mjs all && DB_FILE=strata-dev.db docker-compose build --parallel && DB_FILE=strata-dev.db docker-compose up",

backend/prisma/seed.ts — snapshot history

15 monthly snapshots per asset (index 0 = 14 months ago, index 14 = today):

Asset	Monthly delta	Value at 14mo ago	Value today
BNP Checking	+30	~3830	~4250
Livret A	+75	~21900	~22950
Apartment Paris	+1200	~368200	~385000
Home Loan	-429	~186000	~180000
Toyota Yaris	-100	~6400	~5000
Renault Kangoo	-40	~2560	~2000

Dates computed at runtime → all time filters always have data.

Docs updated

• docs/src/content/docs/plans/2026-05-05-docker-startup-optimization.md — section 6 rewritten
• docs/src/content/docs/adr/adr-003-database-strategy.md — docker:dev row updated

---

Acceptance Criteria

1. npm run docker:dev generates version + rebuilds (layer-cached) before starting
2. Version shows DEV label after docker:dev
3. Colors show distinct per type/category (previous fix now visible)
4. Seed creates 15 monthly snapshots per demo asset
5. All 6 time filters (1D/7D/1M/3M/YTD/1Y) show data in dev stack
6. Backend unit + e2e tests pass

Execution Summary

Commit: 2375915

Actual changes

File	Change
package.json	docker:dev now runs STRATA_ENV=development gen-version.mjs all && docker-compose build --parallel before docker-compose up
backend/prisma/seed.ts	Replaced single hardcoded snapshot at 2025-01-15 with 15 monthly relative-date snapshots per asset; added buildSnapshotHistory() + DEMO_ASSET_HISTORY constants; added back seedPortfolioSnapshot() (1 record required by e2e test)
docs/.../2026-05-05-docker-startup-optimization.md	Section 6 rewritten; Results table updated
docs/.../adr-003-database-strategy.md	docker:dev row updated
docs/.../2026-05-14-fix-docker-dev-and-seed.md	This plan doc

Deviations from plan

• Portfolio snapshot seed: I had planned to remove all portfolio snapshot seeding, but the e2e test GET /api/v1/portfolio-snapshots → returns seeded snapshots depends on at least 1 seeded portfolio snapshot. Added back a single minimal record (seedPortfolioSnapshot()). The old HISTORICAL_SNAPSHOTS array (4 records, Jan–Apr 2025) was replaced by this single record.
• Loan delta correction: Initial delta of -429 produced 179994 at index 14 (not 180000), causing the e2e portfolio value assertion to fail by 6. Fixed to startValue: 186020, monthlyDelta: -430 → exactly 180000 at index 14 → net worth = 239200 as expected by tests.

Test results

Gate	Result
Backend unit	✅ 315 tests passed (30 suites)
Backend e2e	✅ 70 tests passed (8 suites)
Frontend unit	✅ 393 tests passed (63 files)
Frontend e2e	⏭ skipped (needs running app)

Key discoveries

• The e2e test GET /api/v1/portfolio-snapshots → returns seeded snapshots violates Convention 6 (it depends on seeded data). Left for a future cleanup; re-adding a minimal portfolio snapshot seed unblocks it.
• Relative-date snapshot math: monthlyDelta must be chosen so startValue + 14 * delta equals the expected current value exactly (for integer comparison in e2e). Loan required adjusting delta from -429 to -430 and startValue from 186000 to 186020.