access_db 0.2.1

数据库连接
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
54
55
56



/// 新增数据 ，返回 sql 语句。
/// 下面示例中，user 为表名，，name、num 为字段名，，后面为新增的值。
/// Add new data, then return sql. exp: users table, field name and num. after them is value.
/// ```
/// let sql = myset!("users", {
///     "name": string_t.clone(),
///     "num": 882,
/// });
/// 
/// 执行 
/// myconn.run(sql);
/// ```
#[macro_export] 
macro_rules! myset {
    ($t:expr, {$($k:tt: $v:expr),+$(,)?}) => {
        {
            fn type_of<T>(_: T) -> &'static str {
                std::any::type_name::<T>()
            }
            let mut keys = String::from("");
            let mut values = String::from("");
            $(
                keys = keys + $k + ",";
            )+
            $(
                let temp_v = $v.clone();
                let v_type = type_of($v);
                values = match v_type {
                    "&str" => {
                        let mut v_r = temp_v.to_string().as_str().replace("\\", "\\\\");
                        v_r = v_r.replace("\"", "\\\"");
                        values + "\"" + &v_r + "\","
                    },
                    "alloc::string::String" => {
                        let mut v_r = temp_v.to_string().as_str().replace("\\", "\\\\");
                        v_r = v_r.replace("\"", "\\\"");
                        values + "\"" + &v_r + "\","
                    },
                    _ => {
                        values + temp_v.to_string().as_str() + ","
                    }
                };
            )+
            
            keys.pop();
            values.pop();
    
            let sql: String = "INSERT INTO ".to_string() + $t + " ( " + keys.as_str() + " ) "
                + " VALUES ( " + values.as_str() + " )";
    
            sql
        }
    };
}