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
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



/// 通过id，删除数据 ，返回 sql 语句。
/// Delete one data by id (default).
/// ```
/// let sql = mydel!("feedback", 2);  // id = 2
/// 
/// 执行 do
/// myconn.run(sql);
/// 
/// ```
/// 通过指定字段的值，删除数据 ，返回 sql 语句。
/// Delete one data by filed value.
/// ```
/// let sql = mydel!("feedback", {"uid": 12});
/// 
/// 执行 do
/// myconn.run(sql);
/// 
/// ```
#[macro_export] 
macro_rules! mydel {
    ($t:expr, {$k:tt: $v:expr}) => {
        {
            fn type_of<T>(_: T) -> &'static str {
                std::any::type_name::<T>()
            }
            let keys = $k.to_string();
            let temp_v = $v.clone();
            let v_type = type_of($v);
            let values = match v_type {
                "&str" => {
                    let mut v_r = temp_v.to_string().as_str().replace("\\", "\\\\");
                    v_r = v_r.replace("\"", "\\\"");
                    "\"".to_string() + &v_r + "\""
                },
                "alloc::string::String" => {
                    let mut v_r = temp_v.to_string().as_str().replace("\\", "\\\\");
                    v_r = v_r.replace("\"", "\\\"");
                    "\"".to_string() + &v_r + "\""
                },
                _ => {
                    temp_v.to_string() + ""
                }
            };
            
            let sql: String = "DELETE FROM ".to_string() + $t + " WHERE " + keys.as_str() + "=" + values.as_str();

            sql
        }
    };

    ($t:expr, $v: expr) => {
        {
            fn type_of<T>(_: T) -> &'static str {
                std::any::type_name::<T>()
            }
            let temp_v = $v.clone();
            let v_type = type_of($v);
            let values = match v_type {
                "&str" => {
                    let mut v_r = temp_v.to_string().as_str().replace("\\", "\\\\");
                    v_r = v_r.replace("\"", "\\\"");
                    "\"".to_string() + &v_r + "\""
                },
                "alloc::string::String" => {
                    let mut v_r = temp_v.to_string().as_str().replace("\\", "\\\\");
                    v_r = v_r.replace("\"", "\\\"");
                    "\"".to_string() + &v_r + "\""
                },
                _ => {
                    temp_v.to_string() + ""
                }
            };

            let sql: String = "DELETE FROM ".to_string() + $t + " WHERE id=" + values.as_str();

            sql
        }
    };

   
}