sabiql 1.11.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

use std::path::PathBuf;

use crate::app::ports::ErLogWriter;

pub struct FsErLogWriter;

impl ErLogWriter for FsErLogWriter {
    fn write_er_failure_log(
        &self,
        failed_tables: Vec<(String, String)>,
        cache_dir: PathBuf,
    ) -> std::io::Result<()> {
        write_er_failure_log_blocking(failed_tables, cache_dir)
    }
}

pub fn write_er_failure_log_blocking(
    failed_tables: Vec<(String, String)>,
    cache_dir: PathBuf,
) -> std::io::Result<()> {
    use std::io::Write;

    let log_path = cache_dir.join("er_diagram.log");
    let mut file = std::fs::File::create(&log_path)?;

    writeln!(file, "ER Diagram Generation Failed")?;
    writeln!(file, "Timestamp: {:?}", std::time::SystemTime::now())?;
    writeln!(file)?;
    writeln!(file, "Failed tables ({}):", failed_tables.len())?;

    for (table, error) in &failed_tables {
        writeln!(file, "  - {table}: {error}")?;
    }

    Ok(())
}

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

    mod write_er_failure_log_blocking {
        use super::*;

        #[test]
        fn multiple_failures_writes_all_details() {
            let temp_dir = tempfile::tempdir().unwrap();
            let failed_tables = vec![
                ("public.users".to_string(), "connection timeout".to_string()),
                ("public.orders".to_string(), "permission denied".to_string()),
            ];

            write_er_failure_log_blocking(failed_tables, temp_dir.path().to_path_buf()).unwrap();

            let content = std::fs::read_to_string(temp_dir.path().join("er_diagram.log")).unwrap();
            assert!(content.contains("ER Diagram Generation Failed"));
            assert!(content.contains("Failed tables (2):"));
            assert!(content.contains("public.users: connection timeout"));
            assert!(content.contains("public.orders: permission denied"));
        }

        #[test]
        fn empty_list_writes_zero_count() {
            let temp_dir = tempfile::tempdir().unwrap();

            write_er_failure_log_blocking(vec![], temp_dir.path().to_path_buf()).unwrap();

            let content = std::fs::read_to_string(temp_dir.path().join("er_diagram.log")).unwrap();
            assert!(content.contains("Failed tables (0):"));
        }

        #[test]
        fn output_includes_timestamp() {
            let temp_dir = tempfile::tempdir().unwrap();

            write_er_failure_log_blocking(
                vec![("t".to_string(), "e".to_string())],
                temp_dir.path().to_path_buf(),
            )
            .unwrap();

            let content = std::fs::read_to_string(temp_dir.path().join("er_diagram.log")).unwrap();
            assert!(content.contains("Timestamp:"));
        }
    }
}