OpenCode provider returns zero usage although opencode.db has sessions/messages/parts.

[myStanZQ]

OpenCode provider returns zero usage although opencode.db has sessions/messages/parts.

OpenCode DB schema has session.time_created/time_updated and session-level token columns:
cost, tokens_input, tokens_output, tokens_reasoning, tokens_cache_read, tokens_cache_write.

There is no session.time column.

Counts:
session=13, message=226, part=883
root sessions=11, child sessions=2

Command:
codeburn report --provider opencode -p all --format json

Result:
overview.cost=0, calls=0, sessions=0

[iamtoruk]

Looking into this. The parser expects a specific message.data JSON structure (role, tokens, modelID fields) and specific part.data types (text, tool). If your OpenCode version stores data differently, messages get silently skipped.

Fix incoming on main shortly. Changes:

1. Recognize additional part types (tool-call, tool_call, tool-result, reasoning, file) as activity — previously only text and tool counted
2. Accept role: "model" in addition to role: "assistant"
3. Fall back to data.usage.{input_tokens, output_tokens, ...} when data.tokens is absent
4. Fall back to data.model when data.modelID is absent
5. Session-level token fallback: when per-message parsing yields zero calls, read tokens_input, tokens_output etc. from the session row if those columns exist
6. Diagnostic warning with --verbose flag showing parse/skip counts

To help diagnose the exact root cause, could you run:

CODEBURN_VERBOSE=1 codeburn report --verbose --provider opencode -p all --format json 2>opencode-debug.txt

and share opencode-debug.txt? Also:

• What OpenCode version are you running? (opencode --version)
• A sample of what's in message.data for one row: sqlite3 ~/.local/share/opencode/opencode.db "SELECT data FROM message LIMIT 1"

The fix should resolve it regardless, but knowing the exact format helps us stay compatible going forward.