devsql 0.2.2

Unified SQL queries across Claude Code + Git data
Documentation 
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
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144

//! `devsql search` -- find symbols by name across the codebase.

use incurs::command::{CommandContext, CommandDef, CommandHandler, Example};
use incurs::output::CommandResult;
use serde_json::{json, Value};

use super::engine_from_options;

// ---------------------------------------------------------------------------
// Schema
// ---------------------------------------------------------------------------

#[derive(incurs::Args, serde::Deserialize)]
#[allow(dead_code)]
struct SearchArgs {
    /// Symbol name or pattern to search for
    query: String,
}

#[derive(incurs::Options, serde::Deserialize)]
#[allow(dead_code)]
struct SearchOptions {
    /// Git repository path
    #[incurs(alias = "r", default = ".")]
    repo: String,
    /// Claude data directory (defaults to ~/.claude)
    #[incurs(alias = "d")]
    data_dir: Option<String>,
    /// Filter by symbol kind (function, struct, enum, trait, impl, etc.)
    #[incurs(alias = "k")]
    kind: Option<String>,
    /// Maximum number of results
    #[incurs(alias = "n", default = "50")]
    limit: i64,
}

// ---------------------------------------------------------------------------
// Handler
// ---------------------------------------------------------------------------

struct SearchHandler;

#[async_trait::async_trait]
impl CommandHandler for SearchHandler {
    async fn run(&self, ctx: CommandContext) -> CommandResult {
        let query = match ctx.args.get("query").and_then(|v| v.as_str()) {
            Some(q) => q.to_string(),
            None => {
                return CommandResult::Error {
                    code: "MISSING_ARG".into(),
                    message: "Missing required argument: query".into(),
                    retryable: false,
                    exit_code: Some(1),
                    cta: None,
                };
            }
        };

        let kind = ctx
            .options
            .get("kind")
            .and_then(|v| v.as_str())
            .map(|s| s.to_string());
        let limit = ctx
            .options
            .get("limit")
            .and_then(|v| v.as_i64())
            .unwrap_or(50);

        let (mut engine, _repo_path) = match engine_from_options(&ctx.options) {
            Ok(v) => v,
            Err(e) => return e,
        };

        // Load the symbols table
        if let Err(e) = engine.load_code_tables(&["symbols"]) {
            return CommandResult::Error {
                code: "LOAD_ERROR".into(),
                message: format!("Failed to load symbols table: {e}"),
                retryable: false,
                exit_code: Some(1),
                cta: None,
            };
        }

        // Build SQL query
        let sql = if let Some(ref k) = kind {
            format!(
                "SELECT file_path, name, kind, line_start, signature \
                 FROM symbols \
                 WHERE name LIKE '%{query}%' AND kind = '{k}' \
                 LIMIT {limit}"
            )
        } else {
            format!(
                "SELECT file_path, name, kind, line_start, signature \
                 FROM symbols \
                 WHERE name LIKE '%{query}%' \
                 LIMIT {limit}"
            )
        };

        match engine.query(&sql) {
            Ok(matches) => CommandResult::Ok {
                data: json!({
                    "query": query,
                    "kind_filter": kind,
                    "total": matches.len(),
                    "matches": Value::Array(matches),
                }),
                cta: None,
            },
            Err(e) => CommandResult::Error {
                code: "QUERY_ERROR".into(),
                message: format!("Search query failed: {e}"),
                retryable: false,
                exit_code: Some(1),
                cta: None,
            },
        }
    }
}

// ---------------------------------------------------------------------------
// Builder
// ---------------------------------------------------------------------------

pub fn build() -> CommandDef {
    CommandDef::build("search", SearchHandler)
        .description("Search for symbols by name across the codebase")
        .args::<SearchArgs>()
        .options::<SearchOptions>()
        .examples(vec![
            Example {
                command: "UnifiedEngine --json".to_string(),
                description: Some("Find all symbols matching 'UnifiedEngine'".to_string()),
            },
            Example {
                command: "load --kind function --json".to_string(),
                description: Some("Find all functions with 'load' in the name".to_string()),
            },
        ])
        .done()
}