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
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

//! State events and changes

use crate::buffer::{AppMode, FilterState, FuzzyFilterState, SearchState};
use crate::ui::state::shadow_state::SearchType;

/// Events that can trigger state changes
#[derive(Debug, Clone)]
pub enum StateEvent {
    /// Mode changed
    ModeChanged { from: AppMode, to: AppMode },

    /// Search started
    SearchStarted { search_type: SearchType },

    /// Search ended (cleared/cancelled)
    SearchEnded { search_type: SearchType },

    /// Search pattern updated
    SearchPatternUpdated {
        search_type: SearchType,
        pattern: String,
    },

    /// Filter activated/deactivated
    FilterToggled {
        filter_type: FilterType,
        active: bool,
    },

    /// Data view updated (query executed)
    DataViewUpdated,

    /// Column operation (hide, pin, sort)
    ColumnOperation { op: ColumnOp },

    /// Viewport changed
    ViewportChanged { row: usize, col: usize },
}

#[derive(Debug, Clone)]
pub enum FilterType {
    Regex,
    Fuzzy,
    Column,
}

#[derive(Debug, Clone)]
pub enum ColumnOp {
    Hide(usize),
    Pin(usize),
    Sort(usize),
    Reset,
}

/// Changes to apply to buffer state
#[derive(Debug, Default, Clone)]
pub struct StateChange {
    pub mode: Option<AppMode>,
    pub search_state: Option<SearchState>,
    pub filter_state: Option<FilterState>,
    pub fuzzy_filter_state: Option<FuzzyFilterState>,
    pub clear_all_searches: bool,
}

impl StateChange {
    /// Create a change that clears all search states
    #[must_use]
    pub fn clear_searches() -> Self {
        Self {
            search_state: Some(SearchState::default()),
            filter_state: Some(FilterState::default()),
            fuzzy_filter_state: Some(FuzzyFilterState::default()),
            clear_all_searches: true,
            ..Default::default()
        }
    }

    /// Create a mode change
    #[must_use]
    pub fn mode(mode: AppMode) -> Self {
        Self {
            mode: Some(mode),
            ..Default::default()
        }
    }

    /// Combine with another change
    pub fn and(mut self, other: StateChange) -> Self {
        if other.mode.is_some() {
            self.mode = other.mode;
        }
        if other.search_state.is_some() {
            self.search_state = other.search_state;
        }
        if other.filter_state.is_some() {
            self.filter_state = other.filter_state;
        }
        if other.fuzzy_filter_state.is_some() {
            self.fuzzy_filter_state = other.fuzzy_filter_state;
        }
        if other.clear_all_searches {
            self.clear_all_searches = true;
        }
        self
    }
}