feat: add State of Kokonut ecosystem report with multi-location scope (KI-38)

feat: add State of Kokonut ecosystem report with multi-location scope #38

Merged

wasabi opened 1 week ago

Summary

New network/ecosystem-level state_of_kokonut report: composes existing per-location generators across one, many, or all locations (repeatable --location-id or --all) within a user-specified date range.
Ecosystem-actor view (Network / DAO / Foundation / Genesis / Seeds) of funding raised, funding sources, and per-project participation decisions.
New schema 326_state_of_kokonut_funding.sql (funding_round + project_funding, idempotent) and seed 114_state_of_kokonut_funding.sql (pilot 2021-2024 data).
CLI extended: --location-id is now repeatable and --all selects every location; network-level scope stored as NULL snapshot (UUID-guard added to store_snapshot / fetch_public_interest_context).
Generator isolates per-section failures so one bad location section does not break the composite.
Tests: tests/test_state_of_kokonut.py (5 passing) covering registration, UUID-scope guard, rollups, selection parsing, section-error isolation.

Verification

ruff check services/export/report_generator.py tests/test_state_of_kokonut.py → All checks passed
python3 -m pytest tests/test_state_of_kokonut.py tests/test_dao_proposal_history.py → 8 passed
Live DB smoke: --type state_of_kokonut --all --period-start 2021-01-01 --period-end 2024-12-31 returns total_raised 815000 across 5 actors; 2023-only filter returns 115000 (genesis + seeds).

Scope notes

Multimedia / narrative storytelling / community-impact stories deferred (JSON-only report engine).
Funding data is seeded pilot data, self-reported, not on-chain verified.

Follows the 3-step branch → PR → merge flow from AGENTS.md.

Commits were merged into target branch

feat: add State of Kokonut ecosystem report with multi-location scope

Add a network/ecosystem-level "state_of_kokonut" report that composes existing
per-location generators across one, many, or all locations (--all or repeated
--location-id) within a user-specified date range, plus an ecosystem-actor view
(Network / DAO / Foundation / Genesis / Seeds) of funding raised, funding
sources, and per-project participation.

- New schema (326): funding_round + project_funding tables (idempotent).
- New seed (114): pilot 2021-2024 funding data across the five actors.
- Generator composes farm/financial/social/environmental/governance sections and
  isolates per-section failures; network-level scope stored as NULL snapshot.
- CLI extended: --location-id is repeatable and --all selects every location.
- Tests cover registration, UUID-scope guard, rollups, selection parsing, and
  section-error isolation.

Co-Authored-By: opencode <opencode@users.noreply.kokonut.network>

1 week ago

ac3bb76b

wasabi merged 1 week ago
Login to comment

Submitter	wasabi
Target	main
Source	feat/state-of-kokonut

Jobs

Merge Strategy

Create Merge Commit

Watchers (1)

Reference

pull request KI-38