mysql_quick 2.0.1

mysql 数据库快速连接方法
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
84
85
86
87
88
89
90
91
92
93
94

use serde::{Deserialize, Serialize};

#[macro_use]
mod mycount;

#[macro_use]
mod mydel;

#[macro_use]
mod mydelmany;

#[macro_use]
mod myfind;

#[macro_use]
mod myget;

#[macro_use]
mod myset;

#[macro_use]
mod mysetmany;

#[macro_use]
mod mysetupdate;

#[macro_use]
mod mysetupdatemany;

#[macro_use]
mod myupdate;

#[macro_use]
mod myupdatemany;

mod method;
pub use method::*;

/// 常用的 mysql 锁类型。直接加在 sql 语句后面
pub const MY_SHARED_LOCK: &str = " LOCK IN SHARE MODE";
/// 悲观锁，用于抢单什么的
pub const MY_EXCLUSIVE_LOCK: &str = " FOR UPDATE";

#[derive(Deserialize, Serialize, Debug, PartialEq, Eq)]
pub struct MysqlQuickCount {
    pub mysql_quick_count: u64,
}

#[cfg(test)]
mod test {
    #[test]
    fn test_myset() {
        let name = Some("a");
        let name2: Option<String> = None;
        let aa = r#"m'y,,a#@!@$$^&^%&&#$,,adflll+_)"(\_)*)(32389)d(ŐдŐ๑)🍉 .',""#;
        let sql = myset!("table", {
           "id": 23,
           "nick": aa,
           "name": name,
           "name2": name2,
           "age": Some(33),
           "empty": Some(""),
           "empty2": "",
           "aa": &aa,
           "aa2": &Some(aa),
        });
        assert_eq!(
            r#"INSERT INTO table ( id,nick,name,name2,age,empty,empty2,aa,aa2 )  VALUES ( 23,"m'y,,a#@!@$$^&^%&&#$,,adflll+_)\"(\\_)*)(32389)d(ŐдŐ๑)🍉 .',\"","a",NULL,33,"","","m'y,,a#@!@$$^&^%&&#$,,adflll+_)\"(\\_)*)(32389)d(ŐдŐ๑)🍉 .',\"","m'y,,a#@!@$$^&^%&&#$,,adflll+_)\"(\\_)*)(32389)d(ŐдŐ๑)🍉 .',\"" )"#,
            sql
        )
    }
    #[test]
    fn test_myupdate() {
        let name = Some("a");
        let name2: Option<String> = None;
        let aa = r#"m'y,,a#@!@$$^&^%&&#$,,adflll+_)"(_)*)(32389)d(ŐдŐ๑)🍉 .',""#;
        let sql = myupdate!("table", 32, {
           "id": 23,
           "nick": aa,
           "name": name,
           "name2": name2,
           "age": Some(33),
           "empty": Some(""),
           "empty2": "",
           "aa": &aa,
           "aa2": &Some(aa),
        });
        println!(",,,,,,,,,,  {}", sql);
        assert_eq!(
            r#"UPDATE table SET id=23,nick="m'y,,a#@!@$$^&^%&&#$,,adflll+_)\"(_)*)(32389)d(ŐдŐ๑)🍉 .',\"",name="a",name2=NULL,age=33,empty="",empty2="",aa="m'y,,a#@!@$$^&^%&&#$,,adflll+_)\"(_)*)(32389)d(ŐдŐ๑)🍉 .',\"",aa2="m'y,,a#@!@$$^&^%&&#$,,adflll+_)\"(_)*)(32389)d(ŐдŐ๑)🍉 .',\"" WHERE id=32"#,
            sql
        )
    }
}