elefant-tools 0.0.2

A library for doing things like pg_dump and pg_restore, with extra features, and probably more bugs.
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

use crate::postgres_client_wrapper::FromRow;
use crate::schema_reader::define_working_query;
use tokio_postgres::Row;

pub struct SchemaResult {
    pub name: String,
    pub comment: Option<String>,
}

impl FromRow for SchemaResult {
    fn from_row(row: Row) -> crate::Result<Self> {
        Ok(Self {
            name: row.try_get(0)?,
            comment: row.try_get(1)?,
        })
    }
}

//language=postgresql
define_working_query!(
    get_schemas,
    SchemaResult,
    r#"
SELECT n.nspname AS name,
       d.description AS comment
FROM pg_namespace n
         LEFT JOIN pg_description d ON d.objoid = n.oid and (n.nspname <> 'public' or d.description <> 'standard public schema')
         left join pg_depend dep on dep.objid = n.oid
WHERE (n.oid > 16384 or n.nspname = 'public')
    and (dep.objid is null or dep.deptype <> 'e' )
    and has_schema_privilege(n.oid, 'CREATE')
ORDER BY n.nspname;
"#
);