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

use sql_cli::data::datatable::{DataColumn, DataRow, DataTable, DataValue};
use sql_cli::data::query_engine::QueryEngine;
use std::sync::Arc;

fn create_simple_test_table() -> Arc<DataTable> {
    let mut table = DataTable::new("test");
    table.add_column(DataColumn::new("a"));
    table.add_column(DataColumn::new("b"));

    table
        .add_row(DataRow::new(vec![
            DataValue::Integer(10),
            DataValue::Float(2.5),
        ]))
        .unwrap();

    Arc::new(table)
}

#[test]
fn test_basic_multiplication() {
    let table = create_simple_test_table();
    let engine = QueryEngine::new();

    let view = engine
        .execute(table.clone(), "SELECT a * b as result FROM test")
        .unwrap();

    assert_eq!(view.row_count(), 1);
    assert_eq!(view.column_count(), 1);

    let columns = view.column_names();
    assert_eq!(columns, vec!["result"]);

    // Get the result value
    let row = view.get_row(0).unwrap();
    let result_value = row.get(0).unwrap().clone();

    // Should be 10 * 2.5 = 25.0
    assert_eq!(result_value, DataValue::Float(25.0));
}

#[test]
fn test_literal_arithmetic() {
    let table = create_simple_test_table();
    let engine = QueryEngine::new();

    let view = engine
        .execute(table.clone(), "SELECT 2 + 3 * 4 as result FROM test")
        .unwrap();

    assert_eq!(view.row_count(), 1);

    let row = view.get_row(0).unwrap();
    let result_value = row.get(0).unwrap().clone();

    // Should be 2 + (3 * 4) = 2 + 12 = 14
    assert_eq!(result_value, DataValue::Integer(14));
}

#[test]
fn test_mixed_columns_and_literals() {
    let table = create_simple_test_table();
    let engine = QueryEngine::new();

    let view = engine
        .execute(table.clone(), "SELECT a, a * 2 as doubled FROM test")
        .unwrap();

    assert_eq!(view.row_count(), 1);
    assert_eq!(view.column_count(), 2);

    let row = view.get_row(0).unwrap();
    let a_value = row.get(0).unwrap().clone();
    let doubled_value = row.get(1).unwrap().clone();

    assert_eq!(a_value, DataValue::Integer(10));
    assert_eq!(doubled_value, DataValue::Integer(20)); // 10 * 2
}