ccql 0.3.0

Claude Code Query Language - SQL query engine for Claude Code data
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114

use serde::{Deserialize, Serialize};
use std::collections::HashMap;

#[derive(Debug, Clone, Serialize, Deserialize)]
pub struct StatsCache {
    pub version: u32,
    #[serde(rename = "lastComputedDate")]
    pub last_computed_date: String,
    #[serde(rename = "dailyActivity")]
    pub daily_activity: Vec<DailyActivity>,
    #[serde(rename = "dailyModelTokens", default)]
    pub daily_model_tokens: Vec<DailyModelTokens>,
    #[serde(rename = "hourCounts", default)]
    pub hour_counts: HashMap<String, u64>,
    #[serde(rename = "modelUsage", default)]
    pub model_usage: HashMap<String, ModelUsageData>,
    #[serde(rename = "totalMessages")]
    pub total_messages: u64,
    #[serde(rename = "totalSessions")]
    pub total_sessions: u64,
    #[serde(rename = "firstSessionDate")]
    pub first_session_date: String,
    #[serde(rename = "longestSession", skip_serializing_if = "Option::is_none")]
    pub longest_session: Option<LongestSession>,
    #[serde(flatten)]
    pub extra: HashMap<String, serde_json::Value>,
}

#[derive(Debug, Clone, Serialize, Deserialize)]
pub struct DailyActivity {
    pub date: String,
    #[serde(rename = "messageCount")]
    pub message_count: u64,
    #[serde(rename = "sessionCount")]
    pub session_count: u64,
    #[serde(rename = "toolCallCount")]
    pub tool_call_count: u64,
}

#[derive(Debug, Clone, Serialize, Deserialize)]
pub struct DailyModelTokens {
    pub date: String,
    #[serde(rename = "tokensByModel", default)]
    pub tokens_by_model: HashMap<String, u64>,
}

#[derive(Debug, Clone, Serialize, Deserialize)]
pub struct ModelUsageData {
    #[serde(rename = "inputTokens", default)]
    pub input_tokens: u64,
    #[serde(rename = "outputTokens", default)]
    pub output_tokens: u64,
    #[serde(rename = "cacheReadInputTokens", default)]
    pub cache_read_input_tokens: u64,
    #[serde(rename = "cacheCreationInputTokens", default)]
    pub cache_creation_input_tokens: u64,
    #[serde(rename = "webSearchRequests", default)]
    pub web_search_requests: u64,
    #[serde(rename = "costUSD", default)]
    pub cost_usd: f64,
    #[serde(rename = "contextWindow", default)]
    pub context_window: u64,
}

#[derive(Debug, Clone, Serialize, Deserialize)]
pub struct LongestSession {
    #[serde(rename = "sessionId")]
    pub session_id: String,
    #[serde(default)]
    pub duration: u64,
    #[serde(rename = "messageCount")]
    pub message_count: u64,
    #[serde(default)]
    pub timestamp: String,
}

impl StatsCache {
    pub fn total_tokens(&self) -> u64 {
        self.model_usage
            .values()
            .map(|m| m.input_tokens + m.output_tokens)
            .sum()
    }

    pub fn activity_by_date(&self, date: &str) -> Option<&DailyActivity> {
        self.daily_activity.iter().find(|a| a.date == date)
    }
}

#[cfg(test)]
mod tests {
    use super::*;

    #[test]
    fn stats_cache_keeps_unknown_top_level_fields() {
        let json = r#"{
            "version": 1,
            "lastComputedDate": "2026-06-10",
            "dailyActivity": [],
            "totalMessages": 0,
            "totalSessions": 0,
            "firstSessionDate": "2026-01-01",
            "futureUnknownKey": {"a": 1},
            "anotherNewField": "hello"
        }"#;

        let stats: StatsCache = serde_json::from_str(json).expect("parse");
        assert_eq!(
            stats.extra.get("anotherNewField"),
            Some(&serde_json::Value::String("hello".to_string()))
        );
        assert!(stats.extra.contains_key("futureUnknownKey"));
    }
}