sql-cli 1.73.1

SQL query tool for CSV/JSON with both interactive TUI and non-interactive CLI modes - perfect for exploration and automation
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

use sql_cli::recursive_parser::{detect_cursor_context, CursorContext};

fn main() {
    // Test cases for method completion inside parentheses
    let test_cases = vec![
        // Without parentheses - baseline
        (
            "SELECT * FROM table WHERE Country.",
            "SELECT * FROM table WHERE Country.".len(),
        ),
        (
            "SELECT * FROM table WHERE Country.Con",
            "SELECT * FROM table WHERE Country.Con".len(),
        ),
        // With parentheses - the key test cases
        (
            "SELECT * FROM table WHERE (Country.",
            "SELECT * FROM table WHERE (Country.".len(),
        ),
        (
            "SELECT * FROM table WHERE (Country.Con",
            "SELECT * FROM table WHERE (Country.Con".len(),
        ),
        // Nested parentheses
        (
            "SELECT * FROM table WHERE ((Country.",
            "SELECT * FROM table WHERE ((Country.".len(),
        ),
        // Mixed with AND/OR
        (
            "SELECT * FROM table WHERE (Country.Con",
            "SELECT * FROM table WHERE (Country.Con".len(),
        ),
        (
            "SELECT * FROM table WHERE Age > 10 AND (Country.",
            "SELECT * FROM table WHERE Age > 10 AND (Country.".len(),
        ),
    ];

    for (query, cursor_pos) in test_cases {
        let (context, partial) = detect_cursor_context(query, cursor_pos);

        println!("Query: {}", query);
        println!("  Cursor at: {}", cursor_pos);
        println!("  Context: {:?}", context);
        println!("  Partial: {:?}", partial);

        // Check if we properly detect method call context even with parentheses
        match &context {
            CursorContext::AfterColumn(col) => {
                println!("  ✓ Detected column: {}", col);
                assert_eq!(
                    col, "Country",
                    "Should extract 'Country' without parentheses"
                );
            }
            _ => {
                if query.contains('.') && !query.contains("()") {
                    println!("  ✗ Failed to detect method call context!");
                    panic!("Should detect AfterColumn context for: {}", query);
                }
            }
        }
        println!();
    }

    println!("✅ All tests passed!");
}