Function detect_tables

crates/devsql/src/engine.rs:764–822

Detect which tables are needed from a SQL query. Returns a 3-tuple: (claude_tables, git_tables, code_tables).

(query: &str)

///
/// Returns a 3-tuple: (claude_tables, git_tables, code_tables).
pub fn detect_tables(query: &str) -> (Vec<String>, Vec<String>, Vec<String>) {
    let query_upper = query.to_uppercase();

    let claude_tables = [
        "history",
        "jhistory",
        "codex_history",
        "transcripts",
        "sessions",
        "todos",
        "stats",
    ];
    let git_tables = [
        "commits",
        "commit_parents",
        "branches",
        "tags",
        "refs",
        "stashes",
        "reflog",
        "diffs",
        "diff_files",
        "blame",
        "config",
        "remotes",
        "submodules",
        "status",
        "worktrees",
        "hooks",
        "notes",
    ];
    let code_tables = [
        "source_files",
        "source_lines",
        "symbols",
        "imports",
        "ast_nodes",
    ];

    let needed_claude: Vec<String> = claude_tables
        .iter()
        .filter(|t| query_mentions_table(&query_upper, t))
        .map(|s| s.to_string())
        .collect();

    let needed_git: Vec<String> = git_tables
        .iter()
        .filter(|t| query_mentions_table(&query_upper, t))
        .map(|s| s.to_string())
        .collect();

    let needed_code: Vec<String> = code_tables
        .iter()
        .filter(|t| query_mentions_table(&query_upper, t))
        .map(|s| s.to_string())
        .collect();

    (needed_claude, needed_git, needed_code)