kali 0.1.0

A query builder and orm-ish crate built on sqlx
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

use crate::builder::{expr::Expr, ordering::ColumnOrdering, value::Value};

pub trait Column: Copy + Send + Sync {
    fn to_col_name(&self) -> &str;

    fn write(&self, f: &mut String) {
        f.push('"');
        f.push_str(self.to_col_name());
        f.push('"');
    }
}

pub trait ColumnExpr<'a, C: Column> {
    fn eq<V: Into<Value>>(self, value: V) -> Expr<'a, C>;
    fn gt<V: Into<Value>>(self, value: V) -> Expr<'a, C>;
    fn lt<V: Into<Value>>(self, value: V) -> Expr<'a, C>;
    fn like<V: Into<Value>>(self, value: V) -> Expr<'a, C>;
    fn in_list<V: Into<Value>>(self, values: Vec<V>) -> Expr<'a, C>;
    fn is_null(self) -> Expr<'a, C>;

    fn asc(self) -> ColumnOrdering<C>;
    fn desc(self) -> ColumnOrdering<C>;
    fn asc_nulls_first(self) -> ColumnOrdering<C>;
    fn asc_nulls_last(self) -> ColumnOrdering<C>;
    fn desc_nulls_first(self) -> ColumnOrdering<C>;
    fn desc_nulls_last(self) -> ColumnOrdering<C>;
}

impl<'a, C: Column> ColumnExpr<'a, C> for C {
    fn eq<V: Into<Value>>(self, value: V) -> Expr<'a, C> {
        Expr::Equal(self, value.into())
    }

    fn gt<V: Into<Value>>(self, value: V) -> Expr<'a, C> {
        Expr::Gt(self, value.into())
    }

    fn lt<V: Into<Value>>(self, value: V) -> Expr<'a, C> {
        Expr::Lt(self, value.into())
    }

    fn like<V: Into<Value>>(self, value: V) -> Expr<'a, C> {
        Expr::Like(self, value.into())
    }

    fn in_list<V: Into<Value>>(self, values: Vec<V>) -> Expr<'a, C> {
        let values = values.into_iter().map(|v| v.into()).collect();
        Expr::In(self, values)
    }

    fn is_null(self) -> Expr<'a, C> {
        Expr::Equal(self, Value::Null)
    }

    fn asc(self) -> ColumnOrdering<C> {
        ColumnOrdering::Asc(self)
    }

    fn desc(self) -> ColumnOrdering<C> {
        ColumnOrdering::Desc(self)
    }

    fn asc_nulls_first(self) -> ColumnOrdering<C> {
        ColumnOrdering::AscNullsFirst(self)
    }

    fn asc_nulls_last(self) -> ColumnOrdering<C> {
        ColumnOrdering::AscNullsLast(self)
    }

    fn desc_nulls_first(self) -> ColumnOrdering<C> {
        ColumnOrdering::DescNullsFirst(self)
    }

    fn desc_nulls_last(self) -> ColumnOrdering<C> {
        ColumnOrdering::DescNullsLast(self)
    }
}