pgevolve 0.3.8

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
78
79
80
81
82
83
84
85
86
87
88

//! `pgevolve doctor` and `rewrite-table` smoke tests.

fn cargo_bin() -> std::path::PathBuf {
    let mut p = std::path::PathBuf::from(env!("CARGO_BIN_EXE_pgevolve"));
    if !p.exists() {
        p = std::path::PathBuf::from("target/debug/pgevolve");
    }
    p
}

#[test]
fn doctor_help_includes_command() {
    let output = std::process::Command::new(cargo_bin())
        .arg("doctor")
        .arg("--help")
        .output()
        .expect("run pgevolve");
    let stdout = String::from_utf8_lossy(&output.stdout);
    assert!(
        output.status.success(),
        "stderr: {}",
        String::from_utf8_lossy(&output.stderr)
    );
    assert!(
        stdout.to_lowercase().contains("health") || stdout.contains("doctor"),
        "help should describe the doctor command: {stdout}"
    );
}

#[test]
fn rewrite_table_refuses_without_confirm_flag() {
    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(cargo_bin())
        .arg("rewrite-table")
        .arg("app.users")
        .arg("--db")
        .arg("dev")
        .current_dir(dir)
        .output()
        .expect("run pgevolve");

    assert!(
        !output.status.success(),
        "should refuse without --confirm-rewrite"
    );
    let stderr = String::from_utf8_lossy(&output.stderr);
    assert!(
        stderr.contains("--confirm-rewrite"),
        "stderr should explain the flag: {stderr}"
    );
}

#[test]
fn rewrite_table_with_confirm_reports_not_yet_implemented() {
    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(cargo_bin())
        .arg("rewrite-table")
        .arg("app.users")
        .arg("--db")
        .arg("dev")
        .arg("--confirm-rewrite")
        .current_dir(dir)
        .output()
        .expect("run pgevolve");

    assert!(!output.status.success());
    let stderr = String::from_utf8_lossy(&output.stderr);
    assert!(
        stderr.contains("not yet implemented") || stderr.contains("v0.2"),
        "stderr should explain v0.2 status: {stderr}"
    );
}