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

use crate::clause;
use crate::stmt::result::Result;

/// Binary statement builder.
///
/// Binary statement is two statement combined with `UNION [ALL]`, `EXCEPT
/// [ALL]` or `INTERSECT [ALL]`.
#[derive(Clone, Debug, PartialEq, Eq)]
pub struct Binary<'a> {
    pub(crate) with: Option<clause::With<'a>>,
    pub(crate) left: Box<Result<'a>>,
    pub(crate) op: &'static str,
    pub(crate) right: Box<Result<'a>>,
}

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

#[test]
#[cfg(test)]
fn test() {
    use crate::stmt;

    let query = stmt::union(stmt::select([1]), stmt::select([2]));
    assert_eq!(query.to_string(), "SELECT 1 UNION SELECT 2");
    let query = stmt::union_all(stmt::select([1]), stmt::select([2]));
    assert_eq!(query.to_string(), "SELECT 1 UNION ALL SELECT 2");
    let query = stmt::except(stmt::select([1]), stmt::select([2]));
    assert_eq!(query.to_string(), "SELECT 1 EXCEPT SELECT 2");
    let query = stmt::except_all(stmt::select([1]), stmt::select([2]));
    assert_eq!(query.to_string(), "SELECT 1 EXCEPT ALL SELECT 2");
    let query = stmt::intersect(stmt::select([1]), stmt::select([2]));
    assert_eq!(query.to_string(), "SELECT 1 INTERSECT SELECT 2");
    let query = stmt::intersect_all(stmt::select([1]), stmt::select([2]));
    assert_eq!(query.to_string(), "SELECT 1 INTERSECT ALL SELECT 2");
}