patchworks 0.3.0

Git-style visual diffs for SQLite databases. Inspect, compare, snapshot, and generate SQL migrations.
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

//! Schema diff tree rendering.

use egui::{Color32, RichText, Ui};

use crate::db::types::SchemaDiff;

/// Renders schema diff results.
pub fn render_schema_diff(ui: &mut Ui, schema_diff: &SchemaDiff) {
    ui.heading("Schema Diff");

    for table in &schema_diff.added_tables {
        egui::CollapsingHeader::new(
            RichText::new(format!("+ {}", table.name)).color(Color32::GREEN),
        )
        .default_open(true)
        .show(ui, |ui| {
            for column in &table.columns {
                ui.colored_label(
                    Color32::GREEN,
                    format!("+ {} {}", column.name, column.col_type),
                );
            }
        });
    }

    for table in &schema_diff.removed_tables {
        egui::CollapsingHeader::new(RichText::new(format!("- {}", table.name)).color(Color32::RED))
            .default_open(true)
            .show(ui, |ui| {
                for column in &table.columns {
                    ui.colored_label(
                        Color32::RED,
                        format!("- {} {}", column.name, column.col_type),
                    );
                }
            });
    }

    for table in &schema_diff.modified_tables {
        egui::CollapsingHeader::new(
            RichText::new(format!("~ {}", table.table_name)).color(Color32::YELLOW),
        )
        .default_open(true)
        .show(ui, |ui| {
            for column in &table.added_columns {
                ui.colored_label(
                    Color32::GREEN,
                    format!("+ {} {}", column.name, column.col_type),
                );
            }
            for column in &table.removed_columns {
                ui.colored_label(
                    Color32::RED,
                    format!("- {} {}", column.name, column.col_type),
                );
            }
            for (left, right) in &table.modified_columns {
                ui.colored_label(
                    Color32::YELLOW,
                    format!("~ {}: {} -> {}", left.name, left.col_type, right.col_type),
                );
            }
        });
    }

    if !schema_diff.unchanged_tables.is_empty() {
        ui.separator();
        ui.label(RichText::new("Unchanged").strong());
        for table in &schema_diff.unchanged_tables {
            ui.label(table);
        }
    }
}