pgmold 0.33.5

PostgreSQL schema-as-code management tool
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
87
88
89
90
91
92
93
94
95
96

mod common;
use common::*;

use proptest::prelude::*;

proptest! {
    #![proptest_config(ProptestConfig::with_cases(32))]

    #[test]
    fn parse_is_deterministic(sql in schema_sql_strategy()) {
        let first = parse_sql_string(&sql);
        let second = parse_sql_string(&sql);
        match (first, second) {
            (Ok(a), Ok(b)) => prop_assert_eq!(a, b),
            (Err(e1), Err(e2)) => prop_assert_eq!(e1.to_string(), e2.to_string()),
            _ => prop_assert!(false, "parse results differed between calls"),
        }
    }

    #[test]
    fn diff_identical_schemas_is_empty(sql in schema_sql_strategy()) {
        let schema = match parse_sql_string(&sql) {
            Ok(s) => s,
            Err(_) => return Ok(()),
        };
        let ops = compute_diff(&schema, &schema);
        prop_assert!(ops.is_empty(), "expected empty diff for identical schemas, got: {ops:?}");
    }

    #[test]
    fn parse_roundtrip_table_names_preserved(sql in schema_sql_strategy()) {
        let schema = match parse_sql_string(&sql) {
            Ok(s) => s,
            Err(_) => return Ok(()),
        };
        for key in schema.tables.keys() {
            prop_assert!(!key.is_empty(), "table key should not be empty");
            prop_assert!(
                key.contains('.'),
                "table key should be schema-qualified (contains '.')"
            );
        }
    }

    #[test]
    fn diff_produces_ops_for_added_table(
        base_sql in schema_sql_strategy(),
        extra_table_name in identifier_strategy(),
    ) {
        let extra_sql = format!(
            "{base_sql}\n\nCREATE TABLE public.{extra_table_name}_extra (\n    id integer PRIMARY KEY\n);"
        );

        let base = match parse_sql_string(&base_sql) {
            Ok(s) => s,
            Err(_) => return Ok(()),
        };
        let extended = match parse_sql_string(&extra_sql) {
            Ok(s) => s,
            Err(_) => return Ok(()),
        };

        prop_assume!(extended.tables.len() > base.tables.len());
        let ops = compute_diff(&base, &extended);
        prop_assert!(
            !ops.is_empty(),
            "diff should be non-empty when extended schema has more tables"
        );
    }

    #[test]
    fn diff_is_not_empty_for_different_schemas(
        table_a in identifier_strategy(),
        table_b in identifier_strategy(),
    ) {
        prop_assume!(table_a != table_b);

        let sql_a = format!("CREATE TABLE public.{table_a} (\n    id integer PRIMARY KEY\n);");
        let sql_b = format!("CREATE TABLE public.{table_b} (\n    id integer PRIMARY KEY\n);");

        let schema_a = match parse_sql_string(&sql_a) {
            Ok(s) => s,
            Err(_) => return Ok(()),
        };
        let schema_b = match parse_sql_string(&sql_b) {
            Ok(s) => s,
            Err(_) => return Ok(()),
        };

        let ops = compute_diff(&schema_a, &schema_b);
        prop_assert!(
            !ops.is_empty(),
            "diff between schemas with different tables should be non-empty"
        );
    }
}