sql-cli 1.68.0

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

#[derive(Clone)]
pub enum SelectionMode {
    Normal,
    Column,
    Block,
    Visual,
}

#[derive(Clone, Default)]
pub struct FilterState {
    pub active: bool,
    pub pattern: String,
    pub cursor_pos: usize,
}

#[derive(Clone, Default)]
pub struct FuzzyFilterState {
    pub active: bool,
    pub pattern: String,
    pub cursor_pos: usize,
}

#[derive(Clone, Default)]
pub struct ColumnSearchState {
    pub active: bool,
    pub column_index: usize,
    pub pattern: String,
    pub cursor_pos: usize,
    pub results: Vec<usize>,
    pub current_match: usize,
}

#[derive(Clone, Default)]
pub struct SearchState {
    pub pattern: String,
    pub current_match: Option<(usize, usize)>, // (row, col)
    pub matches: Vec<(usize, usize)>,
    pub match_index: usize,
}

#[derive(Clone, Default)]
pub struct CompletionState {
    pub items: Vec<String>,
    pub selected_index: usize,
    pub active: bool,
    pub prefix_len: usize,
}

#[derive(Default)]
pub struct HistoryState {
    pub active: bool,
    pub input: String,
    pub cursor_pos: usize,
}

#[derive(Clone, Default)]
pub struct TuiState {
    pub filter_state: FilterState,
    pub fuzzy_filter_state: FuzzyFilterState,
    pub column_search_state: ColumnSearchState,
    pub search_state: SearchState,
    pub completion_state: CompletionState,
}