querypie-cli 0.1.0

Query QueryPie databases from the terminal with webview authentication.
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
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119

use anyhow::{anyhow, Result};
use serde::Serialize;

use super::pb;
use super::Client;

#[derive(Debug, Clone, Serialize, PartialEq, Eq)]
pub struct TableStructure {
    pub headers: Vec<String>,
    pub rows: Vec<Vec<String>>,
}

impl Client {
    pub fn get_databases(&self, session: &str, db: &str) -> Result<Vec<String>> {
        let resp: pb::NameListResponse = self.unary(
            "engine.dictionary.database.DatabaseDictionaryService/getDatabases",
            &pb::GetDatabasesRequest {
                session: session.to_string(),
                db: db.to_string(),
            },
        )?;
        Ok(resp.names)
    }

    pub fn get_schemas(&self, session: &str, db: &str) -> Result<Vec<String>> {
        let resp: pb::NameListResponse = self.unary(
            "engine.dictionary.database.DatabaseDictionaryService/getSchemas",
            &pb::GetSchemasRequest {
                session: session.to_string(),
                db: db.to_string(),
            },
        )?;
        Ok(resp.names)
    }

    pub fn get_tables(&self, session: &str, db: &str, schema: &str) -> Result<Vec<String>> {
        let resp: pb::NameListResponse = self.unary(
            "engine.dictionary.table.TableDictionaryService/getTables",
            &pb::GetTablesRequest {
                session: session.to_string(),
                db: db.to_string(),
                schema: schema.to_string(),
                flag: 1,
            },
        )?;
        Ok(resp.names)
    }

    pub fn get_table_script(&self, session: &str, db: &str, table: &str) -> Result<String> {
        let resp: pb::ScriptResponse = self.unary(
            "engine.dictionary.table.TableDictionaryService/getTableScript",
            &pb::GetTableScriptRequest {
                session: session.to_string(),
                db: db.to_string(),
                table: table.to_string(),
                flag: 1,
            },
        )?;
        Ok(resp.script)
    }

    pub fn get_table_structure(
        &self,
        session: &str,
        db: &str,
        table: &str,
    ) -> Result<TableStructure> {
        let resp: pb::StructureResponse = self.unary(
            "engine.dictionary.table.TableDictionaryService/getTableStructure",
            &pb::GetTableScriptRequest {
                session: session.to_string(),
                db: db.to_string(),
                table: table.to_string(),
                flag: 1,
            },
        )?;
        decode_table_structure(resp)
    }
}

fn decode_table_structure(resp: pb::StructureResponse) -> Result<TableStructure> {
    let data_table = resp
        .data_table
        .ok_or_else(|| anyhow!("table structure response did not include data_table"))?;
    let rows = data_table
        .rows
        .into_iter()
        .map(|row| row.values)
        .collect::<Vec<_>>();
    Ok(TableStructure {
        headers: data_table.columns,
        rows,
    })
}

#[cfg(test)]
mod tests {
    use super::*;

    #[test]
    fn decodes_table_structure() {
        // given
        let response = pb::StructureResponse {
            data_table: Some(pb::DictionaryDataTable {
                columns: vec!["ColumnName".to_string(), "DataType".to_string()],
                rows: vec![pb::DictionaryDataTableRow {
                    values: vec!["id".to_string(), "bigint".to_string()],
                }],
            }),
        };

        // when
        let decoded = decode_table_structure(response).unwrap();

        // then
        assert_eq!(decoded.headers, vec!["ColumnName", "DataType"]);
        assert_eq!(decoded.rows, vec![vec!["id", "bigint"]]);
    }
}