odbc-api-helper 0.1.18

odbc-api helper
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

use crate::executor::Print;
use crate::extension::odbc::{Column, ColumnItem};
use nu_table::{StyledString, Table, TableTheme, TextStyle};
use std::collections::HashMap;

#[derive(Debug, Default)]
pub struct QueryResult {
    // record table column name with index
    pub column_names: HashMap<String, usize>,
    // table columns header
    pub columns: Vec<Column>,
    // table columns data
    pub data: Vec<Vec<ColumnItem>>,
}

impl Print for QueryResult {
    fn covert_table(&self) -> Table {
        let headers: Vec<StyledString> = self
            .columns
            .iter()
            .map(|x| StyledString::new(x.name.to_string(), TextStyle::default_header()))
            .collect();

        let rows = self
            .data
            .iter()
            .map(|x| {
                x.iter()
                    .map(|y| y.to_string())
                    .map(|y| StyledString::new(y, TextStyle::basic_left()))
                    .collect::<Vec<_>>()
            })
            .collect();
        Table::new(headers, rows, TableTheme::rounded())
    }
}