renovate 0.2.23

A new way to handle Postgres schema migration.
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

use super::{git_commit, Args, CommandExecutor};
use crate::{DatabaseRepo, RenovateConfig};
use clap_utils::prelude::*;
use std::{env::set_current_dir, fs, path::PathBuf};
use url::Url;

#[derive(Parser, Debug, Clone)]
pub struct SchemaInitCommand {
    #[clap(value_parser = parse_url)]
    pub url: Url,
}

#[async_trait]
impl CommandExecutor for SchemaInitCommand {
    async fn execute(&self, _args: &Args) -> Result<(), Error> {
        let path = PathBuf::from(format!(".{}", self.url.path()));
        if path.exists() && path.read_dir()?.next().is_some() {
            bail!("directory {} already exists and not empty", path.display());
        } else {
            fs::create_dir(&path)?;
        }

        set_current_dir(&path)?;
        let config = RenovateConfig::new(self.url.clone());
        config.save("renovate.yml").await?;

        let db_repo = DatabaseRepo::new(&config);
        db_repo.init_local_database().await?;

        db_repo.fetch().await?;

        git_commit(format!("init schema migration repo for {}", self.url))?;

        println!(
            "Database schema for {} has successfully dumped into {}.",
            self.url,
            path.display()
        );
        Ok(())
    }
}

fn parse_url(s: &str) -> Result<Url, Error> {
    let url = Url::parse(s)?;
    if url.scheme() != "postgres" {
        bail!("only postgres url is supported");
    }
    if url.path().is_empty() {
        bail!("database name is required in the url");
    }
    Ok(url)
}

#[allow(dead_code)]
async fn fetch_and_save(url: &Url) -> Result<()> {
    let config = RenovateConfig::new(url.clone());
    config.save("renovate.yml").await?;

    let db_repo = DatabaseRepo::new(&config);
    db_repo.init_local_database().await?;

    db_repo.fetch().await?;

    git_commit(format!("init schema migration repo for {}", url))?;
    Ok(())
}