qians_xql 0.2.9

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

use crate::clause;

#[derive(Clone, Debug, Default, PartialEq, Eq)]
pub struct Result<'a> {
    pub(crate) with: Option<clause::With<'a>>,
    pub(crate) data: crate::stmt::data::Data<'a>,
    pub(crate) limit: Option<clause::Limit>,
    pub(crate) offset: Option<clause::Offset>,
}

stmt_common!(Result);

crate::macros::gen_display!(Result<'_>);

impl<'a, T> std::convert::From<T> for Result<'a>
where
    T: Into<crate::stmt::data::Data<'a>>,
{
    #[inline]
    fn from(val: T) -> Self {
        Result {
            data: val.into(),
            ..Default::default()
        }
    }
}

#[cfg(test)]
mod tests {
    use crate::stmt::select;
    use crate::stmt::values;

    #[test]
    fn limit() {
        let query = select(["id"]).from("data").limit(10);
        assert_eq!(query.to_string(), "SELECT id FROM data LIMIT 10");
        let query = values([(1,), (2,)]).limit(10);
        assert_eq!(query.to_string(), "VALUES (1), (2) LIMIT 10");
    }

    #[test]
    fn offset() {
        let query = select(["id"]).from("data").offset(10);
        assert_eq!(query.to_string(), "SELECT id FROM data OFFSET 10");
        let query = values([(1,), (2,)]).offset(10);
        assert_eq!(query.to_string(), "VALUES (1), (2) OFFSET 10");
    }
}