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 anyhow::Result;
use sql_cli::csv_datasource::CsvApiClient;

fn main() -> Result<()> {
    println!("Testing ORDER BY with sample_trades.json...");

    let mut client = CsvApiClient::new();
    client.load_json("sample_trades.json", "trade_deal")?;

    println!("\n=== Sample data (first 3 rows) ===");
    let result = client.query_csv("SELECT * FROM trade_deal")?;
    println!("Total rows: {}", result.data.len());
    for (i, row) in result.data.iter().take(3).enumerate() {
        if let Some(obj) = row.as_object() {
            let id = obj.get("id").unwrap_or(&serde_json::Value::Null);
            let price = obj.get("price").unwrap_or(&serde_json::Value::Null);
            let counterparty = obj.get("counterparty").unwrap_or(&serde_json::Value::Null);
            println!(
                "  {}: id={}, price={}, counterparty={}",
                i + 1,
                id,
                price,
                counterparty
            );
        }
    }

    println!("\n=== ORDER BY id (first 5 rows) ===");
    let result = client.query_csv("SELECT * FROM trade_deal ORDER BY id")?;
    for (i, row) in result.data.iter().take(5).enumerate() {
        if let Some(obj) = row.as_object() {
            let id = obj.get("id").unwrap_or(&serde_json::Value::Null);
            let price = obj.get("price").unwrap_or(&serde_json::Value::Null);
            println!("  {}: id={}, price={}", i + 1, id, price);
        }
    }

    println!("\n=== ORDER BY price (first 5 rows) ===");
    let result = client.query_csv("SELECT * FROM trade_deal ORDER BY price")?;
    for (i, row) in result.data.iter().take(5).enumerate() {
        if let Some(obj) = row.as_object() {
            let id = obj.get("id").unwrap_or(&serde_json::Value::Null);
            let price = obj.get("price").unwrap_or(&serde_json::Value::Null);
            println!("  {}: id={}, price={}", i + 1, id, price);
        }
    }

    println!("\n=== ORDER BY counterparty, price (first 5 rows) ===");
    let result = client.query_csv("SELECT * FROM trade_deal ORDER BY counterparty, price")?;
    for (i, row) in result.data.iter().take(5).enumerate() {
        if let Some(obj) = row.as_object() {
            let id = obj.get("id").unwrap_or(&serde_json::Value::Null);
            let price = obj.get("price").unwrap_or(&serde_json::Value::Null);
            let counterparty = obj.get("counterparty").unwrap_or(&serde_json::Value::Null);
            println!(
                "  {}: counterparty={}, price={}, id={}",
                i + 1,
                counterparty,
                price,
                id
            );
        }
    }

    println!("\n✅ ORDER BY working correctly with real data!");

    Ok(())
}