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
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163

use serde::{Serialize};
use std::fmt::{Display, Formatter, Result as FmtResult};
use serde_json::{to_string_pretty};
use std::collections::HashMap;
use crate::{connect_db};
use unidb::build_sql;
use unidb::model::Value;

#[derive(Debug, Serialize)]
pub enum OraDaoError {

    ConnectionError(String),

    StatementError(String),

    QueryError(String),

    RowError(String),

    ExecutionError(String),

    CommitError(String),

}
pub struct UpsertMapInput {
    pub sql_id: String,
    pub data: HashMap<String, Value>,
}
impl Display for OraDaoError {
    fn fmt(&self, f: &mut Formatter) -> FmtResult {
        let error = to_string_pretty(self).unwrap();
        error!("{}", &error);
        write!(f, "{}", error)
    }
}
#[deprecated(
since = "0.3.6",
note = "Please use execute_dao instead"
)]
pub fn cud_dao(sql_id: &str, item: &HashMap<String, Value>) -> Result<usize, OraDaoError> {
    execute_dao(sql_id, item)
}
pub fn execute_dao(sql_id: &str, item: &HashMap<String, Value>) -> Result<usize, OraDaoError> {

    let sql = build_sql(sql_id, "", item);
    return match connect_db() {

        Ok(conn) => {
            match conn.execute(&sql, &[]) {
                Ok(_s) => {
                    match conn.commit() {
                        Ok(_t) => {
                            debug!("Commit OK");
                            Ok(1)
                        }
                        Err(e) => {
                            error!("CommitError:\t{}", e);
                            Err(OraDaoError::CommitError(format!("{}\n{}", e, &sql)))
                        }
                    }
                }
                Err(e) => {
                    error!("ExecutionError:\t{}", e);
                    Err(OraDaoError::ExecutionError(format!("{}\n{}", e, &sql)))
                }
            }

        }
        Err(e) => {
            error!("ConnectionError:\t{}", e);
            Err(OraDaoError::ConnectionError(format!("{}\n{}", e, &sql)))
        }
    }
}
#[deprecated(
since = "0.3.6",
note = "Please use execute_multi_entries_dao instead"
)]
pub fn cud_multi_entries_dao(sql_id: &str, list : Vec<HashMap<String, Value>>) -> Result<usize, OraDaoError> {
    execute_multi_entries_dao(sql_id, list)
}
pub fn execute_multi_entries_dao(sql_id: &str, list : Vec<HashMap<String, Value>>) -> Result<usize, OraDaoError> {

    return match connect_db() {
        Ok(conn) => {
            let mut count = 0;

            for item in list{

                let sql = build_sql(sql_id, "", &item);

                match conn.execute(&sql, &[]) {
                    Ok(_t)=> {
                        count = count + 1;
                    }
                    Err(e) => {
                        error!("ExecutionError:\t{}", e);
                        match conn.rollback() {
                            Ok(_t) => {}
                            Err(_e) => {}
                        }
                        return Err(OraDaoError::ExecutionError(format!("{}\n{}", e, &sql)))
                    }
                }
            }
            match conn.commit() {
                Ok(_t) => {
                    debug!("Commit OK");
                    Ok(count)
                }
                Err(e) => {
                    error!("CommitError:\t{}", e);
                    Err(OraDaoError::CommitError(format!("{}", e)))
                }
            }
        }
        Err(e) => {
            error!("ConnectionError:\t{}", e);
            Err(OraDaoError::ConnectionError(format!("{}", e)))
        }
    }
}
pub fn execute_multi_tables_dao(input: Vec<UpsertMapInput>) -> Result<usize, OraDaoError> {

    return match connect_db() {
        Ok(conn) => {
            let mut count = 0;

            for item in input{

                let sql = build_sql(&item.sql_id, "", &item.data);

                match conn.execute(&sql, &[]) {
                    Ok(_t)=> {
                        count = count + 1;
                    }
                    Err(e) => {
                        error!("ExecutionError:\t{}", e);
                        match conn.rollback() {
                            Ok(_t) => {}
                            Err(_e) => {}
                        }
                        return Err(OraDaoError::ExecutionError(format!("{}\n{}", e, &sql)))
                    }
                }
            }
            match conn.commit() {
                Ok(_t) => {
                    debug!("Commit OK");
                    Ok(count)
                }
                Err(e) => {
                    error!("CommitError:\t{}", e);
                    Err(OraDaoError::CommitError(format!("{}", e)))
                }
            }
        }
        Err(e) => {
            error!("ConnectionError:\t{}", e);
            Err(OraDaoError::ConnectionError(format!("{}", e)))
        }
    }
}