zippa-db 0.1.0

A fast, lightweight, cross-platform database client for PostgreSQL, MySQL, and SQLite.
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

//! The side panel that lays the focused row out one field per column.

use super::*;

fn panel(
    cx: &mut TestAppContext,
    view: &gpui_kit::Entity<crate::ui::table_view::TableView>,
) -> gpui_kit::Entity<crate::ui::table_view::RowPanel> {
    view.read_with(cx, |view, _| view.row_panel_for_test())
}

#[gpui_kit::test]
fn the_panel_follows_the_focused_row(cx: &mut TestAppContext) {
    let (_database, _handle, view) = table_view(cx);
    cx.run_until_parked();
    let panel = panel(cx, &view);

    select_cell(cx, &view, 1, 1);
    let (focused, name) = panel.read_with(cx, |panel, cx| {
        (
            panel.focused_row_for_test(),
            panel.field_value_for_test(1, cx),
        )
    });
    let expected = view.read_with(cx, |view, cx| {
        view.grid_for_test().read(cx).cell_for_test(1, 1, cx)
    });
    assert_eq!(focused, Some(1));
    assert_eq!(Some(name), expected.or(Some(String::new())));

    view.read_with(cx, |view, _| view.grid_for_test())
        .update(cx, |grid, cx| grid.clear(cx));
    cx.run_until_parked();
    assert_eq!(
        panel.read_with(cx, |panel, _| panel.focused_row_for_test()),
        None
    );
}

#[gpui_kit::test]
fn typing_in_the_panel_stages_like_a_grid_edit(cx: &mut TestAppContext) {
    let (_database, handle, view) = table_view(cx);
    cx.run_until_parked();
    let panel = panel(cx, &view);
    select_cell(cx, &view, 0, 1);

    cx.update_window(handle.into(), |_, window, cx| {
        panel.update(cx, |panel, cx| {
            panel.set_field_for_test(1, "from the panel", window, cx);
            panel.commit_field_for_test(1, window, cx);
        });
    })
    .unwrap();
    cx.run_until_parked();

    let staged = view.read_with(cx, |view, cx| view.grid_for_test().read(cx).staged(cx));
    assert_eq!(staged.len(), 1);
    assert_eq!(
        staged[0].cells,
        vec![(1, Some("from the panel".to_string()))]
    );
}

#[gpui_kit::test]
fn the_filter_narrows_columns_and_survives_a_bad_pattern(cx: &mut TestAppContext) {
    let (_database, handle, view) = table_view(cx);
    cx.run_until_parked();
    let panel = panel(cx, &view);

    cx.update_window(handle.into(), |_, window, cx| {
        panel.update(cx, |panel, cx| panel.set_filter_for_test("NAM", window, cx));
    })
    .unwrap();
    cx.run_until_parked();
    assert_eq!(
        panel.read_with(cx, |panel, _| panel.shown_columns_for_test()),
        vec!["name".to_string()]
    );

    cx.update_window(handle.into(), |_, window, cx| {
        panel.update(cx, |panel, cx| panel.set_filter_for_test("na(", window, cx));
    })
    .unwrap();
    cx.run_until_parked();
    assert!(panel.read_with(cx, |panel, _| panel.shown_columns_for_test().is_empty()));
}

#[gpui_kit::test]
fn the_panel_can_be_hidden_and_brought_back(cx: &mut TestAppContext) {
    let (_database, _handle, view) = table_view(cx);
    cx.run_until_parked();
    assert!(view.read_with(cx, |view, _| view.row_panel_visible_for_test()));

    view.update(cx, |view, cx| view.toggle_row_panel_for_test(cx));
    assert!(!view.read_with(cx, |view, _| view.row_panel_visible_for_test()));

    view.update(cx, |view, cx| view.toggle_row_panel_for_test(cx));
    assert!(view.read_with(cx, |view, _| view.row_panel_visible_for_test()));
}

#[gpui_kit::test]
fn a_staged_field_can_be_reverted_or_set_to_null_from_the_menu_actions(cx: &mut TestAppContext) {
    let (_database, _handle, view) = table_view(cx);
    cx.run_until_parked();
    let grid = view.read_with(cx, |view, _| view.grid_for_test());

    grid.update(cx, |grid, cx| grid.stage_cell(0, 1, None, cx));
    let staged = grid.read_with(cx, |grid, cx| grid.staged(cx));
    assert_eq!(staged[0].cells, vec![(1, None)]);
    assert!(grid.read_with(cx, |grid, cx| grid.is_field_staged(0, 1, cx)));

    grid.update(cx, |grid, cx| grid.reset_cell(0, 1, cx));
    assert!(grid.read_with(cx, |grid, cx| grid.staged(cx).is_empty()));
}