sql_tools 0.11.10

A rust crate meant to make SQL queries simple and communication between various SQL versions easy.
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::{
    Error, SQLImplementation,
    statements::select::{ColumnProps, SelectProps},
};

pub fn get_column_names_oracle(select_props: &SelectProps) -> Result<Vec<ColumnProps>, Error> {
    let conn_info = match &select_props.connect {
        SQLImplementation::Oracle(connect) => connect,
        SQLImplementation::SQLite(_) => return Err(Error::SQLVariationError),
    };
    let sql = format!(
        "SELECT column_name FROM all_tab_columns WHERE UPPER(table_name) = '{}'",
        select_props.table.to_ascii_uppercase()
    );
    let conn: oracle::Connection = oracle::Connection::connect(
        conn_info.username.clone(),
        conn_info.password.clone(),
        conn_info.connection_string.clone(),
    )?;

    let mut header: Vec<ColumnProps> = Vec::new();
    let rows = conn.query(&sql, &[])?;
    for row_result in rows {
        let row = row_result?;
        for val in row.sql_values() {
            let res = val.get::<String>()?;
            header.push(ColumnProps {
                name: res,
                table: select_props.table.to_owned(),
            })
        }
    }
    Ok(header)
}