qail-core 0.27.8

AST-native query builder - type-safe expressions, zero SQL strings
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

//! Time function builders (NOW, INTERVAL, etc.)

use crate::ast::{BinaryOp, Expr};

/// NOW() function
pub fn now() -> Expr {
    Expr::FunctionCall {
        name: "NOW".to_string(),
        args: vec![],
        alias: None,
    }
}

/// INTERVAL 'duration' expression
pub fn interval(duration: &str) -> Expr {
    use crate::ast::Value;
    Expr::SpecialFunction {
        name: "INTERVAL".to_string(),
        // Use Expr::Literal so the encoder wraps in quotes properly
        args: vec![(
            None,
            Box::new(Expr::Literal(Value::String(duration.to_string()))),
        )],
        alias: None,
    }
}

/// NOW() - INTERVAL 'duration' helper
pub fn now_minus(duration: &str) -> Expr {
    Expr::Binary {
        left: Box::new(now()),
        op: BinaryOp::Sub,
        right: Box::new(interval(duration)),
        alias: None,
    }
}

/// NOW() + INTERVAL 'duration' helper
pub fn now_plus(duration: &str) -> Expr {
    Expr::Binary {
        left: Box::new(now()),
        op: BinaryOp::Add,
        right: Box::new(interval(duration)),
        alias: None,
    }
}