sabiql 3.0.0

A fast, driver-less TUI for browsing and editing PostgreSQL, MySQL, and SQLite databases
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

use super::*;
use sabiql_domain::ConnectionId;

#[test]
fn initial_state_no_metadata() {
    let mut state = create_test_state();
    let mut terminal = create_test_terminal();

    let output = render_to_string(&mut terminal, &mut state);

    insta::assert_snapshot!(output);
}

#[test]
fn explorer_shows_not_connected_when_no_active_connection() {
    let mut state = create_test_state();
    state.session.clear_connection();
    let mut terminal = create_test_terminal();

    let output = render_to_string(&mut terminal, &mut state);

    insta::assert_snapshot!(output);
}

#[test]
fn header_shows_effective_user_at_normal_width() {
    let mut state = postgres_connected_state();
    state.session.activate_connection_with_dsn(
        &ConnectionId::new(),
        "test",
        DatabaseType::PostgreSQL,
        "postgresql://localhost/test",
    );
    state
        .session
        .mark_effective_user_loaded(Some("app_user".to_string()));
    let mut terminal = create_test_terminal();

    let output = render_to_string(&mut terminal, &mut state);

    insta::assert_snapshot!(output);
}

#[test]
fn mysql_header_shows_effective_user_without_dsn_password() {
    let mut state = postgres_connected_state();
    state.session.activate_connection_with_dsn(
        &ConnectionId::new(),
        "test",
        DatabaseType::MySQL,
        "mysql://app:header-secret@localhost/app",
    );
    state
        .session
        .mark_effective_user_loaded(Some("app@%".to_string()));
    let mut terminal = create_test_terminal();

    let output = render_to_string(&mut terminal, &mut state);

    assert!(output.contains("user: app@%"));
    assert!(!output.contains("header-secret"));
}

#[test]
fn header_truncates_connection_name_at_narrow_width() {
    let mut state = postgres_connected_state();
    state.session.activate_connection_with_dsn(
        &ConnectionId::new(),
        "very-long-connection-name-that-must-yield-space-to-the-user",
        DatabaseType::PostgreSQL,
        "postgresql://localhost/test",
    );
    state
        .session
        .mark_effective_user_loaded(Some("app_user".to_string()));
    let mut terminal = create_test_terminal_sized(60, 20);

    let output = render_to_string(&mut terminal, &mut state);

    insta::assert_snapshot!(output);
}

#[test]
fn header_shows_read_only_badge_at_narrow_width() {
    let mut state = postgres_connected_state();
    state.session.activate_connection_with_dsn(
        &ConnectionId::new(),
        "test",
        DatabaseType::PostgreSQL,
        "postgresql://localhost/test",
    );
    state.session.enable_read_only();
    state
        .session
        .mark_effective_user_loaded(Some("app_user".to_string()));
    let mut terminal = create_test_terminal_sized(80, 20);

    let output = render_to_string(&mut terminal, &mut state);

    insta::assert_snapshot!(output);
}