sqlstr 0.1.0

Sql string builder
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
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

#[allow(unused_macros)]
macro_rules! static_comparison {
    (=) => {
        "="
    };
    (!=) => {
        "<>"
    };
    (>) => {
        ">"
    };
    (<) => {
        "<"
    };
    (>=) => {
        ">="
    };
    (<=) => {
        "<="
    };
}

#[allow(unused_macros)]
macro_rules! static_logical_op {
    (NOT) => {
        "NOT"
    };
    (AND) => {
        "AND"
    };
    (OR) => {
        "OR"
    };
    (AND_NOT) => {
        "AND NOT"
    };
    (OR_NOT) => {
        "OR NOT"
    };
}

#[allow(unused_imports)]
pub(super) use static_comparison;

#[allow(unused_imports)]
pub(super) use static_logical_op;

#[macro_export]
macro_rules! static_condition {
    ($a:literal $op:tt $b:literal) => {
        concat!(
            $a,
            " ",
            $crate::expr::static_comparison!($op),
            " ",
            $b
        )
    };
    ($pre_logic:tt $a:literal $op:tt $b:literal) => {
        concat!(
            $crate::expr::static_logical_op!($pre_logic),
            " ",
            $a,
            " ",
            $crate::expr::static_comparison!($op),
            " ",
            $b
        )
    };

    ($a:literal $op:tt $b:literal $($logic_op:tt $ax:literal $opx:tt $bx:literal)+) => {
        concat!(
            $crate::expr::static_condition!($a $op $b),
            $(
                " ",
                $crate::expr::static_logical_op!($logic_op),
                " ",
                $crate::expr::static_condition!($ax $opx $bx)
            )+
        )
    };
    ($pre_logic:tt $a:literal $op:tt $b:literal $($logic_op:tt $ax:literal $opx:tt $bx:literal)+) => {
        concat!(
            $crate::expr::static_logical_op!($pre_logic),
            " ",
            $crate::expr::static_condition!($a $op $b),
            $(
                " ",
                $crate::expr::static_logical_op!($logic_op),
                " ",
                $crate::expr::static_condition!($ax $opx $bx)
            )+
        )
    };
}

pub use static_condition;

#[cfg(test)]
mod test {

    #[test]
    fn static_condition_macro() {
        assert_eq!(
            static_condition!(NOT "access_history.user_id" = "user.id"),
            "NOT access_history.user_id = user.id"
        );
        assert_eq!(
            static_condition!("access_history.user_id" > "user.id"),
            "access_history.user_id > user.id"
        );
        assert_eq!(
            static_condition!(AND_NOT "access_history.user_id" >= "user.id"),
            "AND NOT access_history.user_id >= user.id"
        );
        assert_eq!(
            static_condition!("user.id" = "access_history.user_id" OR "user.updated" < "access_history.created"),
            "user.id = access_history.user_id OR user.updated < access_history.created"
        );
        assert_eq!(
            static_condition!("user.id" != "access_history.user_id"),
            "user.id <> access_history.user_id"
        );
        assert_eq!(
            static_condition!(NOT "user.id" = "access_history.user_id" AND_NOT "user.updated" < "access_history.created"),
            "NOT user.id = access_history.user_id AND NOT user.updated < access_history.created"
        )
    }
}