pg-setup 0.2.0

Helper to create and drop postgres DBs. Useful for testing.
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

use crate::{
    db::DBStrategy,
    db_url::{self, PgDbUrl},
    error::Result,
    shell,
};

pub(crate) struct CmdStrategy;

#[async_trait]
impl DBStrategy for CmdStrategy {
    fn setup(&self, db_uri: &str) -> Result<()> {
        info!("Creating {db_uri}");

        let db_url: PgDbUrl = db_uri.parse()?;
        let db = db_url.database;
        let maintenance_url = db_url::maintenance_url(db_uri)?;
        shell::cmd_with_args(
            "psql",
            [
                maintenance_url,
                "-c".to_string(),
                format!("CREATE DATABASE {db}"),
            ],
        )?
        .wait()?;

        Ok(())
    }

    fn tear_down(&self, db_uri: &str) -> Result<()> {
        info!("Dropping {db_uri}");

        let db_url: PgDbUrl = db_uri.parse()?;
        let db = db_url.database;
        let maintenance_url = db_url::maintenance_url(db_uri)?;

        // make sure all connections are closed
        shell::cmd_with_args(
            "psql",
            [
                maintenance_url.clone(),
                "-c".to_string(),
                format!(
                    r#"
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = '{db}'
  AND pid <> pg_backend_pid();
"#
                ),
            ],
        )?
        .wait()?;

        shell::cmd_with_args(
            "psql",
            [
                maintenance_url,
                "-c".to_string(),
                format!("DROP DATABASE {db}"),
            ],
        )?
        .wait()?;

        Ok(())
    }

    async fn execute(&self, db_uri: &str, sql: &str) -> Result<()> {
        info!("execute {db_uri} {sql}");
        shell::cmd_with_args("psql", [db_uri, "-c", sql])?.wait()?;
        Ok(())
    }
}