sabiql 1.7.0

A fast, driver-less TUI for browsing and editing PostgreSQL databases
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
115
116
117
118
119
120
121
122
123

#[derive(Debug, Clone, Copy, PartialEq, Eq, Default)]
pub enum InspectorTab {
    #[default]
    Info,
    Columns,
    Indexes,
    ForeignKeys,
    Rls,
    Triggers,
    Ddl,
}

impl InspectorTab {
    pub fn next(self) -> Self {
        match self {
            Self::Info => Self::Columns,
            Self::Columns => Self::Indexes,
            Self::Indexes => Self::ForeignKeys,
            Self::ForeignKeys => Self::Rls,
            Self::Rls => Self::Triggers,
            Self::Triggers => Self::Ddl,
            Self::Ddl => Self::Info,
        }
    }

    pub fn prev(self) -> Self {
        match self {
            Self::Info => Self::Ddl,
            Self::Columns => Self::Info,
            Self::Indexes => Self::Columns,
            Self::ForeignKeys => Self::Indexes,
            Self::Rls => Self::ForeignKeys,
            Self::Triggers => Self::Rls,
            Self::Ddl => Self::Triggers,
        }
    }

    pub fn display_name(self) -> &'static str {
        match self {
            Self::Info => "Info",
            Self::Columns => "Cols",
            Self::Indexes => "Idx",
            Self::ForeignKeys => "FK",
            Self::Rls => "RLS",
            Self::Triggers => "Trig",
            Self::Ddl => "DDL",
        }
    }

    pub fn all() -> &'static [Self] {
        &[
            Self::Info,
            Self::Columns,
            Self::Indexes,
            Self::ForeignKeys,
            Self::Rls,
            Self::Triggers,
            Self::Ddl,
        ]
    }
}

#[cfg(test)]
mod tests {
    use super::*;

    #[test]
    fn default_returns_info() {
        assert_eq!(InspectorTab::default(), InspectorTab::Info);
    }

    #[test]
    fn next_wraps_from_last_to_first() {
        let tab = InspectorTab::Ddl;
        let result = tab.next();
        assert_eq!(result, InspectorTab::Info);
    }

    #[test]
    fn prev_wraps_from_first_to_last() {
        let tab = InspectorTab::Info;
        let result = tab.prev();
        assert_eq!(result, InspectorTab::Ddl);
    }

    #[test]
    fn next_cycles_through_all_tabs() {
        let mut tab = InspectorTab::Info;
        tab = tab.next();
        assert_eq!(tab, InspectorTab::Columns);
        tab = tab.next();
        assert_eq!(tab, InspectorTab::Indexes);
        tab = tab.next();
        assert_eq!(tab, InspectorTab::ForeignKeys);
        tab = tab.next();
        assert_eq!(tab, InspectorTab::Rls);
        tab = tab.next();
        assert_eq!(tab, InspectorTab::Triggers);
        tab = tab.next();
        assert_eq!(tab, InspectorTab::Ddl);
        tab = tab.next();
        assert_eq!(tab, InspectorTab::Info);
    }

    #[test]
    fn prev_cycles_through_all_tabs_backward() {
        let mut tab = InspectorTab::Info;
        tab = tab.prev();
        assert_eq!(tab, InspectorTab::Ddl);
        tab = tab.prev();
        assert_eq!(tab, InspectorTab::Triggers);
        tab = tab.prev();
        assert_eq!(tab, InspectorTab::Rls);
        tab = tab.prev();
        assert_eq!(tab, InspectorTab::ForeignKeys);
        tab = tab.prev();
        assert_eq!(tab, InspectorTab::Indexes);
        tab = tab.prev();
        assert_eq!(tab, InspectorTab::Columns);
        tab = tab.prev();
        assert_eq!(tab, InspectorTab::Info);
    }
}