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

use criterion::{black_box, criterion_group, criterion_main, Criterion};
use sql_cli::data::datatable::{DataColumn, DataRow, DataTable, DataValue};
use sql_cli::data::query_engine::QueryEngine;
use std::sync::Arc;

fn create_test_data(rows: usize) -> DataTable {
    let mut table = DataTable::new("test");

    // Add columns
    table.add_column(DataColumn::new("book"));
    table.add_column(DataColumn::new("value"));
    table.add_column(DataColumn::new("status"));

    // Add rows with varying book values
    let book_values = [
        "Commodities Trading",
        "Equity Trading",
        "FX Trading",
        "Bond Trading",
        "Derivatives",
        "Options",
        "Futures",
        "ETF Trading",
        "Structured Products",
        "Money Markets",
    ];

    for i in 0..rows {
        let book = book_values[i % book_values.len()].to_string();
        let row = DataRow::new(vec![
            DataValue::String(book),
            DataValue::Integer(i as i64),
            DataValue::String(format!("STATUS_{}", i % 5)),
        ]);
        table.add_row(row).unwrap();
    }

    table
}

fn benchmark_contains_query(c: &mut Criterion) {
    let table_10k = Arc::new(create_test_data(10_000));
    let table_50k = Arc::new(create_test_data(50_000));
    let table_100k = Arc::new(create_test_data(100_000));

    let mut group = c.benchmark_group("where_contains");

    // Test with 10k rows
    group.bench_function("10k_rows", |b| {
        let engine = QueryEngine::new();
        let query = "SELECT * FROM test WHERE book.Contains('comm')";
        b.iter(|| {
            let result = engine.execute(table_10k.clone(), black_box(query));
            assert!(result.is_ok());
        });
    });

    // Test with 50k rows
    group.bench_function("50k_rows", |b| {
        let engine = QueryEngine::new();
        let query = "SELECT * FROM test WHERE book.Contains('comm')";
        b.iter(|| {
            let result = engine.execute(table_50k.clone(), black_box(query));
            assert!(result.is_ok());
        });
    });

    // Test with 100k rows
    group.bench_function("100k_rows", |b| {
        let engine = QueryEngine::new();
        let query = "SELECT * FROM test WHERE book.Contains('comm')";
        b.iter(|| {
            let result = engine.execute(table_100k.clone(), black_box(query));
            assert!(result.is_ok());
        });
    });

    group.finish();
}

fn benchmark_simple_comparison(c: &mut Criterion) {
    let table_100k = Arc::new(create_test_data(100_000));

    let mut group = c.benchmark_group("where_comparison");

    // Simple equality comparison
    group.bench_function("equality", |b| {
        let engine = QueryEngine::new();
        let query = "SELECT * FROM test WHERE status = 'STATUS_1'";
        b.iter(|| {
            let result = engine.execute(table_100k.clone(), black_box(query));
            assert!(result.is_ok());
        });
    });

    // Numeric comparison
    group.bench_function("numeric_gt", |b| {
        let engine = QueryEngine::new();
        let query = "SELECT * FROM test WHERE value > 50000";
        b.iter(|| {
            let result = engine.execute(table_100k.clone(), black_box(query));
            assert!(result.is_ok());
        });
    });

    group.finish();
}

criterion_group!(
    benches,
    benchmark_contains_query,
    benchmark_simple_comparison
);
criterion_main!(benches);