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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53

use crate::{
    Error, QueryBuilder, SQLImplementation,
    data_types::ToSQLData,
    sql_implementations::OracleConnect,
    statements::{
        alter::AlterProps,
        create::CreateProps,
        delete::DeleteProps,
        insert::InsertProps,
        select::{Column, SelectProps},
        update::UpdateProps,
    },
};

impl OracleConnect {
    #[inline]
    pub fn new(connection_string: &str, username: &str, password: &str) -> Result<Self, Error> {
        match oracle::Connection::connect(&username, &password, &connection_string) {
            Ok(_) => Ok(Self {
                connection_string: connection_string.to_string(),
                username: username.to_string(),
                password: password.to_string(),
            }),
            Err(e) => Err(Error::OracleError(e)),
        }
    }
}

impl QueryBuilder for OracleConnect {
    fn select(&self, table: &str, columns: Vec<Column>) -> SelectProps {
        SQLImplementation::Oracle(self.clone()).select_initialization(table, columns)
    }

    fn update(&self, table: &str) -> UpdateProps {
        SQLImplementation::Oracle(self.clone()).update_initialization(table)
    }

    fn insert<T: ToSQLData>(&self, table: &str, data: Vec<Vec<T>>) -> Result<InsertProps, Error> {
        SQLImplementation::Oracle(self.clone()).insert_initialization(table, data)
    }

    fn create(&self) -> CreateProps {
        SQLImplementation::Oracle(self.clone()).create_initialization()
    }

    fn alter(&self) -> AlterProps {
        SQLImplementation::Oracle(self.clone()).alter_initialization()
    }

    fn delete(&self, table: &str) -> DeleteProps {
        SQLImplementation::Oracle(self.clone()).delete_initialization(table)
    }
}