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
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

use sql_cli::sql::recursive_parser::{format_ast_tree, Parser};

#[test]
fn test_unclosed_parenthesis_in_where() {
    // Missing closing parenthesis
    let query = "SELECT * FROM table WHERE (price > 100";
    let mut parser = Parser::new(query);
    let result = parser.parse();

    assert!(result.is_err(), "Should fail with unclosed parenthesis");
    let error = result.unwrap_err();
    println!("Error for unclosed paren: {error}");

    // Check AST formatting shows helpful error
    let ast = format_ast_tree(query);
    assert!(ast.contains("PARSE ERROR"));
}

#[test]
fn test_extra_closing_parenthesis() {
    // Extra closing parenthesis
    let query = "SELECT * FROM table WHERE price > 100)";
    let mut parser = Parser::new(query);
    let result = parser.parse();

    assert!(
        result.is_err(),
        "Should fail with extra closing parenthesis"
    );
    let error = result.unwrap_err();
    println!("Error for extra closing paren: {error}");
}

#[test]
fn test_mismatched_parentheses_in_complex_query() {
    // Missing closing paren in first condition
    let query = "SELECT * FROM table WHERE (price > 100 AND quantity < 50) OR (category = 'Books'";
    let mut parser = Parser::new(query);
    let result = parser.parse();

    assert!(result.is_err(), "Should fail with mismatched parentheses");
    let error = result.unwrap_err();
    println!("Error for mismatched parens: {error}");
}

#[test]
fn test_nested_unclosed_parentheses() {
    // Nested parentheses with missing close
    let query = "SELECT * FROM table WHERE ((price > 100 AND quantity < 50)";
    let mut parser = Parser::new(query);
    let result = parser.parse();

    assert!(
        result.is_err(),
        "Should fail with nested unclosed parentheses"
    );
    let error = result.unwrap_err();
    println!("Error for nested unclosed: {error}");
}

#[test]
fn test_method_call_unclosed() {
    // Method call with unclosed parenthesis
    let query = "SELECT * FROM table WHERE name.Contains('test'";
    let mut parser = Parser::new(query);
    let result = parser.parse();

    assert!(result.is_err(), "Should fail with unclosed method call");
    let error = result.unwrap_err();
    println!("Error for unclosed method: {error}");
}

#[test]
fn test_in_clause_unclosed() {
    // IN clause with unclosed parenthesis
    let query = "SELECT * FROM table WHERE category IN ('Books', 'Electronics'";
    let mut parser = Parser::new(query);
    let result = parser.parse();

    assert!(result.is_err(), "Should fail with unclosed IN clause");
    let error = result.unwrap_err();
    println!("Error for unclosed IN: {error}");
}

#[test]
fn test_between_with_unclosed_paren() {
    // BETWEEN inside unclosed parenthesis
    let query = "SELECT * FROM table WHERE (price BETWEEN 50 AND 100";
    let mut parser = Parser::new(query);
    let result = parser.parse();

    assert!(
        result.is_err(),
        "Should fail with unclosed BETWEEN parenthesis"
    );
    let error = result.unwrap_err();
    println!("Error for unclosed BETWEEN: {error}");
}

#[test]
fn test_complex_query_missing_paren() {
    // Complex real-world example with missing paren
    let query = "SELECT * FROM trades WHERE (price > 100 AND quantity < 50 OR (category = 'Tech' AND date > '2024-01-01')";
    let mut parser = Parser::new(query);
    let result = parser.parse();

    // This might actually parse but incorrectly due to precedence
    if result.is_err() {
        println!("Error: {}", result.unwrap_err());
    } else {
        println!(
            "Warning: Query parsed but might have incorrect precedence due to missing parenthesis"
        );
    }
}