grant 0.0.1-beta.3

Manage database roles and privileges in GitOps style
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

use crate::config::Config;
use crate::connection::DbConnection;
use anyhow::Result;
use ascii_table::AsciiTable;
use log::info;

pub fn inspect(config: &Config) -> Result<()> {
    let mut conn = DbConnection::new(config);

    let users_in_db = conn.get_users()?;
    let mut users = users_in_db
        .iter()
        .map(|u| {
            vec![
                u.name.clone(),
                u.user_createdb.to_string(),
                u.user_super.to_string(),
                u.password.clone(),
            ]
        })
        .collect::<Vec<_>>();

    users.insert(
        0,
        vec![
            "User".to_string(),
            "CreateDB".to_string(),
            "Super".to_string(),
            "Password".to_string(),
        ],
    );
    users.insert(
        1,
        vec![
            "---".to_string(),
            "---".to_string(),
            "---".to_string(),
            "---".to_string(),
        ],
    );

    // Print the table
    let table = AsciiTable::default();
    info!(
        "Current users in {}:\n{}",
        config.connection.url,
        table.format(users)
    );

    Ok(())
}