devsql 0.2.1

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
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161

//! `devsql context` -- retrieve file metadata and symbols for a given path.

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 ContextArgs {
    /// File path (or partial path) to get context for
    file: String,
}

#[derive(incurs::Options, serde::Deserialize)]
#[allow(dead_code)]
struct ContextOptions {
    /// Git repository path
    #[incurs(alias = "r", default = ".")]
    repo: String,
    /// Claude data directory (defaults to ~/.claude)
    #[incurs(alias = "d")]
    data_dir: Option<String>,
    /// Include symbol details
    #[incurs(alias = "s")]
    symbols: bool,
}

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

struct ContextHandler;

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

        let include_symbols = ctx
            .options
            .get("symbols")
            .and_then(|v| v.as_bool())
            .unwrap_or(true); // default to true -- symbols are the main value

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

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

        // Query source files matching the path
        let files_sql = format!(
            "SELECT path, language, line_count, size_bytes \
             FROM source_files \
             WHERE path LIKE '%{file}%'"
        );

        let file_rows = match engine.query(&files_sql) {
            Ok(rows) => rows,
            Err(e) => {
                return CommandResult::Error {
                    code: "QUERY_ERROR".into(),
                    message: format!("File query failed: {e}"),
                    retryable: false,
                    exit_code: Some(1),
                    cta: None,
                };
            }
        };

        // For each file, optionally get its symbols
        let mut results = Vec::new();
        for file_row in &file_rows {
            let path = file_row
                .get("path")
                .and_then(|v| v.as_str())
                .unwrap_or("");

            let mut entry = file_row.clone();

            if include_symbols {
                let sym_sql = format!(
                    "SELECT name, kind, line_start, line_end, signature, visibility \
                     FROM symbols \
                     WHERE file_path = '{path}' \
                     ORDER BY line_start"
                );

                if let Ok(syms) = engine.query(&sym_sql) {
                    if let Some(obj) = entry.as_object_mut() {
                        obj.insert("symbols".to_string(), Value::Array(syms));
                    }
                }
            }

            results.push(entry);
        }

        CommandResult::Ok {
            data: json!({
                "file_pattern": file,
                "total": results.len(),
                "files": results,
            }),
            cta: None,
        }
    }
}

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

pub fn build() -> CommandDef {
    CommandDef::build("context", ContextHandler)
        .description("Get file metadata and symbols for a given path")
        .args::<ContextArgs>()
        .options::<ContextOptions>()
        .examples(vec![
            Example {
                command: "src/engine.rs --json".to_string(),
                description: Some("Get context for engine.rs".to_string()),
            },
            Example {
                command: "main.rs --no-symbols --json".to_string(),
                description: Some("Get file info without symbols".to_string()),
            },
        ])
        .done()
}