diffly 0.2.0

Quickly compare your SQL data with clarity and style.
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

use crate::application::monitoring::PerfReport;
use crate::domain::table_diff::TableDiff;
use chrono::Utc;
use serde::Serialize;
use uuid::Uuid;

#[derive(Debug, Serialize, Clone)]
pub struct Changeset {
    pub changeset_id: String,
    pub source_schema: String,
    pub target_schema: String,
    /// Database driver used to produce this changeset: "postgres", "mysql", "mariadb", "sqlite".
    /// Used by SqlWriter to generate the correct SQL dialect.
    #[serde(default = "default_driver")]
    pub driver: String,
    pub created_at: String,
    pub source_fingerprint: String,
    pub target_fingerprint: String,
    pub tables: Vec<TableDiff>,
    pub summary: Summary,
    /// Optional performance report embedded at diff time.
    /// Present in JSON and HTML outputs when `run_with_timing` is used.
    #[serde(skip_serializing_if = "Option::is_none")]
    pub perf: Option<PerfReport>,
}

#[allow(dead_code)] // invoked by serde(default), not called directly
fn default_driver() -> String {
    "postgres".to_string()
}

#[derive(Debug, Serialize, Clone)]
pub struct Summary {
    pub total_inserts: usize,
    pub total_updates: usize,
    pub total_deletes: usize,
    pub total_changes: usize,
    pub tables_affected: usize,
}

impl Changeset {
    pub fn new(
        source_schema: &str,
        target_schema: &str,
        driver: &str,
        tables: Vec<TableDiff>,
    ) -> Self {
        let total_inserts: usize = tables.iter().map(|t| t.inserts.len()).sum();
        let total_updates: usize = tables.iter().map(|t| t.updates.len()).sum();
        let total_deletes: usize = tables.iter().map(|t| t.deletes.len()).sum();
        let tables_affected = tables.iter().filter(|t| !t.is_empty()).count();

        Changeset {
            changeset_id: format!(
                "cs_{}_{}",
                Utc::now().format("%Y%m%d_%H%M%S"),
                Uuid::new_v4().simple()
            ),
            source_schema: source_schema.to_string(),
            target_schema: target_schema.to_string(),
            driver: driver.to_string(),
            created_at: Utc::now().to_rfc3339(),
            source_fingerprint: String::new(), // Computed during diff if needed
            target_fingerprint: String::new(),
            tables,
            summary: Summary {
                total_inserts,
                total_updates,
                total_deletes,
                total_changes: total_inserts + total_updates + total_deletes,
                tables_affected,
            },
            perf: None,
        }
    }

    /// Attach a [`PerfReport`] to this changeset (builder pattern).
    ///
    /// The report will be included in JSON and HTML outputs.
    pub fn with_perf(mut self, perf: PerfReport) -> Self {
        self.perf = Some(perf);
        self
    }
}