sql 0.4.3

The package provides a constructor of SQL statements.
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

//! The `WHERE` clause.

use Result;
use grammar::{Buffer, Clause, Condition};

/// A `WHERE` clause.
#[derive(Debug, Default)]
pub struct Where(Vec<Box<Condition>>);

impl Where {
    #[inline]
    pub fn and<T>(mut self, condition: T) -> Self where T: Condition + 'static {
        self.0.push(Box::new(condition));
        self
    }
}

impl Clause for Where {
    fn compile(&self) -> Result<String> {
        let mut buffer = Buffer::new();
        for condition in &self.0 {
            buffer.push(try!(condition.compile()));
        }
        Ok(format!("WHERE {}", buffer.join(" AND ")))
    }
}

#[cfg(test)]
mod tests {
    use grammar::Clause;
    use prelude::*;

    macro_rules! new(
        ($first:expr) => (super::Where::default().and($first));
    );

    #[test]
    fn one() {
        let clause = new!("foo".like("bar"));
        assert_eq!(clause.compile().unwrap(), "WHERE foo LIKE 'bar'");
    }

    #[test]
    fn and() {
        let clause = new!("foo".like("bar")).and("baz".like("qux"));
        assert_eq!(clause.compile().unwrap(), "WHERE foo LIKE 'bar' AND baz LIKE 'qux'");
    }
}