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

use sql_cli::sql::parser::ast::SqlExpression;
use sql_cli::sql::recursive_parser::Parser;

#[test]
fn test_between_simple() {
    let mut parser = Parser::new("SELECT * FROM table WHERE price BETWEEN 50 AND 100");
    let stmt = parser.parse().expect("Should parse BETWEEN");

    assert!(stmt.where_clause.is_some());
    // The query should parse successfully
}

#[test]
fn test_between_in_parentheses() {
    let mut parser = Parser::new("SELECT * FROM table WHERE (price BETWEEN 50 AND 100)");
    let stmt = parser.parse().expect("Should parse BETWEEN in parentheses");

    assert!(stmt.where_clause.is_some());
    // The query should parse successfully
}

#[test]
fn test_between_with_or() {
    let query = "SELECT * FROM test_sorting WHERE (Price BETWEEN 50 AND 100) OR (Product.Length() > 5) ORDER BY Category ASC, price DESC";
    let mut parser = Parser::new(query);
    let stmt = parser
        .parse()
        .expect("Should parse complex query with BETWEEN and OR");

    assert!(stmt.where_clause.is_some());
    assert!(stmt.order_by.is_some());

    let order_by = stmt.order_by.unwrap();
    assert_eq!(order_by.len(), 2);
    if let SqlExpression::Column(col_ref) = &order_by[0].expr {
        assert_eq!(col_ref.name, "Category");
    } else {
        panic!("Expected Column expression");
    }
    if let SqlExpression::Column(col_ref) = &order_by[1].expr {
        assert_eq!(col_ref.name, "price");
    } else {
        panic!("Expected Column expression");
    }
}

#[test]
fn test_between_with_and() {
    let query = "SELECT * FROM table WHERE category = 'Books' AND price BETWEEN 10 AND 50";
    let mut parser = Parser::new(query);
    let stmt = parser.parse().expect("Should parse BETWEEN with AND");

    assert!(stmt.where_clause.is_some());
}

#[test]
fn test_multiple_between() {
    let query =
        "SELECT * FROM table WHERE (price BETWEEN 10 AND 50) AND (quantity BETWEEN 5 AND 20)";
    let mut parser = Parser::new(query);
    let stmt = parser
        .parse()
        .expect("Should parse multiple BETWEEN clauses");

    assert!(stmt.where_clause.is_some());
}

#[test]
fn test_between_with_expressions() {
    // Test BETWEEN with column names and numeric literals
    let query = "SELECT * FROM table WHERE total BETWEEN min_value AND max_value";
    let mut parser = Parser::new(query);
    let stmt = parser
        .parse()
        .expect("Should parse BETWEEN with column references");

    assert!(stmt.where_clause.is_some());
}