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
use std::env;
use mysql_async::{Conn, Params, Pool, Row};
use mysql_async::error::{DriverError, Error};
use mysql_async::prelude::*;
pub use instance_dao::*;
pub use meta_dao::*;
use nature_common::{NatureError, Result};
pub use relation_dao::*;
pub use task_dao::*;
lazy_static! {
static ref POOL : Pool = get_conn();
}
pub struct MySql;
impl MySql {
pub async fn idu<Q, P>(query: Q, params: P) -> Result<usize>
where
Q: AsRef<str>,
P: Into<Params>,
{
let conn = MySql::get_conn().await?;
match conn.prep_exec(query, params).await {
Ok(num) => {
Ok(num.affected_rows() as usize)
}
Err(e) => return Err(MysqlError(e).into())
}
}
pub async fn fetch<Q, P, F, U>(query: Q, params: P, mut fun: F) -> Result<Vec<U>>
where
Q: AsRef<str>,
P: Into<Params>,
F: FnMut(Row) -> U,
{
let conn = MySql::get_conn().await?;
match conn.prep_exec(query, params).await {
Ok(rtn) => {
match rtn.map_and_drop(|one| fun(one)).await {
Ok((_, rtn)) => Ok(rtn),
Err(e) => Err(MysqlError(e).into())
}
}
Err(e) => Err(MysqlError(e).into())
}
}
async fn get_conn() -> Result<Conn> {
match POOL.get_conn().await {
Ok(conn) => Ok(conn),
Err(e) => Err(MysqlError(e).into())
}
}
}
fn get_conn() -> Pool {
let database_url = env::var("DATABASE_URL")
.expect("DATABASE_URL must be set");
Pool::new(database_url)
}
pub struct MysqlError(mysql_async::error::Error);
impl Into<nature_common::NatureError> for MysqlError {
fn into(self) -> NatureError {
let msg = self.0.to_string();
match self.0 {
Error::Driver(err) => match err {
DriverError::ConnectionClosed => NatureError::EnvironmentError(msg),
DriverError::PoolDisconnected => NatureError::EnvironmentError(msg),
_ => NatureError::LogicalError(msg)
},
Error::Io(_) => NatureError::EnvironmentError(msg),
Error::Other(_) => NatureError::LogicalError(msg),
Error::Server(e) => match e.code {
1062 => NatureError::DaoDuplicated(msg),
_ => NatureError::EnvironmentError(msg)
}
Error::Tls(_) => NatureError::LogicalError(msg),
Error::Url(_) => NatureError::LogicalError(msg),
}
}
}
mod instance_dao;
mod meta_dao;
mod relation_dao;
mod task_dao;