sqlite

type ListFilters struct {
	Since         time.Time // ts_start >= Since (zero = no bound)
	Until         time.Time // ts_start <  Until (zero = no bound)
	Status        *int      // exact match if set
	StatusBucket  int       // 0 = no constraint; 2/4/5 = match 2xx/4xx/5xx range
	Model         string    // exact match if set
	Path          string    // exact match if set
	PathPrefix    string    // matched as `LIKE <prefix>%`; mutually exclusive with Path
	KeyHashPrefix string    // accepts 8- or 16-char prefix; matches by LIKE
	SessionRootID string    // exact match if set
	Project       string    // exact match on client_project if set
	Limit         int       // 1..500; <=0 means default 100

	// Cursor is opaque base64 of "<ts_start_ms>:<id>"; rows strictly older
	// than the cursor (ts_start DESC, id DESC ordering) are returned.
	// Empty = first page.
	CursorTsStart int64
	CursorID      string
}

type ListPage struct {
	Rows         []Row
	NextCursorMs int64  // 0 if no next page
	NextCursorID string // empty if no next page
}

type Row struct {
	ID       string
	TsStart  time.Time
	TsEnd    time.Time
	Client   string
	Method   string
	Path     string
	Upstream string
	Status   int

	Disconnected  bool
	TruncatedReq  bool
	TruncatedResp bool

	// Protocol field copies (may be NULL if absent). Populated from
	// trace.Trace by the writer; pass nil for unknown.
	Model            *string
	Stream           *bool
	PromptTokens     *int64
	CompletionTokens *int64
	TotalTokens      *int64
	FinishReason     *string

	// Extracted usage fields (T3). Deterministic copies of named protocol
	// usage fields — PHILOSOPHY § 1 carve-out 1. Nil when the upstream
	// response didn't carry the field; nil is distinct from a real zero.
	CachedTokens        *int64 // sum of cache-hit tokens across protocols
	CacheCreationTokens *int64 // Anthropic cache_creation_input_tokens (cache miss writes)
	ReasoningTokens     *int64 // OpenAI Responses reasoning tokens from output

	// Client-identity fields (R5a). Deterministic copies of named request-
	// header fields routed through the taxonomy table in ExtractClient.
	// PHILOSOPHY § 1 + § 7: no heuristic UA parsing — nil when the header
	// doesn't match a known taxonomy row.
	ClientKind    *string // taxonomy row key (e.g. "claude-code-desktop")
	ClientVersion *string // version string from the matching header (if any)

	// Project-context field (W4.1 Phase 2). Deterministic copy of the L2
	// project name parsed out of the request body's system / instructions
	// text by parser.ExtractProjectContext. PHILOSOPHY § 1: nil when the
	// trace carried no project signal (distinct from a real empty string).
	ClientProject *string // project name (e.g. "my-repo" from `# my-repo` heading)

	// Identifiers.
	KeyHash string

	// Session fields. Populated by AppendTrace (writer side) or by
	// scanRow (read side). Callers should NOT set these on the writer
	// path — they are derived inside the transaction.
	PrefixLen           *int
	PrefixCanonicalHash *string
	ParentID            *string
	SessionRootID       string

	// JSONL location.
	JSONLPath   string
	JSONLOffset int64

	// MediaCount is the number of extracted media files for this trace
	// (Phase K). Filled by the writer after extraction runs; default 0
	// when extraction is disabled or the trace has no extractable media.
	// PHILOSOPHY § 1: deterministic count of named protocol fields only.
	MediaCount int
}

type SessionSummary struct {
	SessionRootID    string
	NTurns           int64
	FirstTs          time.Time
	LastTs           time.Time
	LastPath         string
	LastStatus       int
	LastModel        string
	DistinctKeyCount int64
	OkCount          int64
	ErrCount         int64
}

type Store struct {
	// contains filtered or unexported fields
}