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

use oracle::Batch;

use crate::Error;

pub(crate) fn bind_cell_to_batch<T: oracle::sql_type::ToSql + std::fmt::Debug>(
    batch: &mut Batch<'_>,
    cell: &T,
    idx: usize,
) -> Result<(), Error> {
    match batch.set(idx + 1, cell) {
        Ok(_) => Ok(()),
        Err(e) => Err(Error::OracleError(e)),
    }
}

pub(crate) fn insert_stmt(length: usize, table: &String, header: &String) -> String {
    let mut values = Vec::new();
    for idx in 0..length {
        values.push([":", &(idx + 1).to_string()].concat())
    }
    format!(
        "INSERT INTO {} ({}) VALUES ({})",
        table,
        header,
        values.join(", ")
    )
}