pgevolve 0.3.5

Postgres declarative schema management CLI — diff source SQL against a live database and generate reviewable 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
74
75
76
77

//! --shadow-validate flag smoke tests.

#[test]
fn plan_help_shows_shadow_validate_flag() {
    let output = std::process::Command::new(env!("CARGO_BIN_EXE_pgevolve"))
        .arg("plan")
        .arg("--help")
        .output()
        .expect("run pgevolve");
    let stdout = String::from_utf8_lossy(&output.stdout);
    assert!(output.status.success());
    assert!(
        stdout.contains("--shadow-validate"),
        "help should list --shadow-validate: {stdout}"
    );
}

#[test]
fn shadow_strict_requires_shadow_validate() {
    let tmp = tempfile::tempdir().unwrap();
    let dir = tmp.path();
    std::fs::write(
        dir.join("pgevolve.toml"),
        "[project]\nname=\"t\"\nschema_dir=\"schema\"\nplan_dir=\"plans\"\n\
         [environments.dev]\nurl=\"postgres://unused\"\n",
    )
    .unwrap();

    let output = std::process::Command::new(env!("CARGO_BIN_EXE_pgevolve"))
        .arg("plan")
        .arg("--db")
        .arg("dev")
        .arg("--shadow-strict")
        .current_dir(dir)
        .output()
        .expect("run pgevolve");

    // clap should reject --shadow-strict without --shadow-validate at
    // argument-parse time, before any DB connection is attempted.
    assert!(
        !output.status.success(),
        "should refuse --shadow-strict without --shadow-validate"
    );
    let stderr = String::from_utf8_lossy(&output.stderr);
    assert!(
        stderr.contains("shadow-validate") || stderr.contains("requires"),
        "clap should mention the requirement: {stderr}"
    );
}

#[test]
fn diff_help_shows_shadow_validate_flag() {
    let output = std::process::Command::new(env!("CARGO_BIN_EXE_pgevolve"))
        .arg("diff")
        .arg("--help")
        .output()
        .expect("run pgevolve");
    let stdout = String::from_utf8_lossy(&output.stdout);
    assert!(
        stdout.contains("--shadow-validate"),
        "diff help should list --shadow-validate"
    );
}

#[test]
fn validate_help_shows_shadow_validate_flag() {
    let output = std::process::Command::new(env!("CARGO_BIN_EXE_pgevolve"))
        .arg("validate")
        .arg("--help")
        .output()
        .expect("run pgevolve");
    let stdout = String::from_utf8_lossy(&output.stdout);
    assert!(
        stdout.contains("--shadow-validate"),
        "validate help should list --shadow-validate"
    );
}