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 serde_json::json;
use sql_cli::data::csv_datasource::CsvApiClient;
use std::io::Write;
use tempfile::NamedTempFile;

#[test]
fn test_column_auto_sizing() {
    // Create test data with varying column widths
    let test_data = json!([
        {
            "id": 1,                    // Very short: 1 character
            "platformOrderId": "ORDER-2024-001",  // Long: 14 characters
            "quantity": 1000,           // Medium: 4 characters
            "status": "Completed",      // Medium: 9 characters
            "counterparty": "Bank of America"  // Long: 15 characters
        },
        {
            "id": 2,
            "platformOrderId": "ORDER-2024-002",
            "quantity": 500,
            "status": "Pending",
            "counterparty": "JP Morgan"
        },
        {
            "id": 999,
            "platformOrderId": "ORDER-2024-003",
            "quantity": 750,
            "status": "Completed",
            "counterparty": "Mizuho Bank"
        }
    ]);

    let mut temp_file = NamedTempFile::new().unwrap();
    write!(temp_file, "{test_data}").unwrap();

    let mut client = CsvApiClient::new();
    client.load_json(temp_file.path(), "test").unwrap();

    let result = client.query_csv("SELECT * FROM test").unwrap();
    assert_eq!(result.data.len(), 3);

    // Expected column widths (content + 2 padding, min 4, max 50):
    // id: max(2, 3) + 2 = 5 (header "id"=2, max value "999"=3)
    // platformOrderId: max(15, 14) + 2 = 17 (header=15, values=14)
    // quantity: max(8, 4) + 2 = 10 (header=8, max value "1000"=4)
    // status: max(6, 9) + 2 = 11 (header=6, max value "Completed"=9)
    // counterparty: max(12, 15) + 2 = 17 (header=12, max value "Bank of America"=15)

    println!("✓ Column auto-sizing calculation completed");
    println!("  Expected optimal widths:");
    println!("    id: ~5 chars (short)");
    println!("    platformOrderId: ~17 chars (long)");
    println!("    quantity: ~10 chars (medium)");
    println!("    status: ~11 chars (medium)");
    println!("    counterparty: ~17 chars (long)");

    // Verify the data can be loaded and processed
    for (i, row) in result.data.iter().enumerate() {
        assert!(row.is_object(), "Row {i} should be an object");
        if let Some(obj) = row.as_object() {
            assert!(obj.contains_key("id"));
            assert!(obj.contains_key("platformOrderId"));
            assert!(obj.contains_key("quantity"));
            assert!(obj.contains_key("status"));
            assert!(obj.contains_key("counterparty"));
        }
    }
}