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

use crate::domain::{DatabaseMetadata, MetadataState, Table, TableSummary};

#[derive(Debug, Clone, Default)]
pub struct MetadataCache {
    pub state: MetadataState,
    pub metadata: Option<DatabaseMetadata>,
    pub table_detail: Option<Table>,
    pub current_table: Option<String>,
    pub selection_generation: u64,
}

impl MetadataCache {
    pub fn tables(&self) -> Vec<&TableSummary> {
        self.metadata
            .as_ref()
            .map(|m| m.tables.iter().collect())
            .unwrap_or_default()
    }
}

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

    #[test]
    fn default_creates_empty_cache() {
        let cache = MetadataCache::default();

        assert_eq!(cache.state, MetadataState::NotLoaded);
        assert!(cache.metadata.is_none());
        assert!(cache.table_detail.is_none());
        assert!(cache.current_table.is_none());
        assert_eq!(cache.selection_generation, 0);
    }

    #[test]
    fn tables_returns_empty_when_no_metadata() {
        let cache = MetadataCache::default();

        let tables = cache.tables();

        assert!(tables.is_empty());
    }

    #[test]
    fn tables_returns_all_when_metadata_exists() {
        let cache = MetadataCache {
            metadata: Some(DatabaseMetadata {
                database_name: "test".to_string(),
                schemas: vec![],
                tables: vec![
                    TableSummary::new("public".to_string(), "users".to_string(), Some(100), false),
                    TableSummary::new("public".to_string(), "posts".to_string(), Some(50), false),
                ],
                fetched_at: std::time::Instant::now(),
            }),
            ..Default::default()
        };

        let tables = cache.tables();

        assert_eq!(tables.len(), 2);
    }
}