pgqrs 0.15.1

A high-performance PostgreSQL-backed job queue for Rust applications
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

#[derive(Debug, Clone)]
pub enum QueryParam {
    I64(i64),
    I32(i32),
    String(String),
    Json(serde_json::Value),
    DateTime(Option<chrono::DateTime<chrono::Utc>>),
}

#[derive(Debug, Clone)]
pub struct QueryBuilder {
    sql: String,
    params: Vec<QueryParam>,
}

impl QueryBuilder {
    pub fn new(sql: impl Into<String>) -> Self {
        Self {
            sql: sql.into(),
            params: Vec::new(),
        }
    }

    pub fn bind_i64(mut self, value: i64) -> Self {
        self.params.push(QueryParam::I64(value));
        self
    }

    pub fn bind_i32(mut self, value: i32) -> Self {
        self.params.push(QueryParam::I32(value));
        self
    }

    pub fn bind_string(mut self, value: impl Into<String>) -> Self {
        self.params.push(QueryParam::String(value.into()));
        self
    }

    pub fn bind_json(mut self, value: serde_json::Value) -> Self {
        self.params.push(QueryParam::Json(value));
        self
    }

    pub fn bind_datetime(mut self, value: Option<chrono::DateTime<chrono::Utc>>) -> Self {
        self.params.push(QueryParam::DateTime(value));
        self
    }

    pub fn sql(&self) -> &str {
        &self.sql
    }

    pub fn params(&self) -> &[QueryParam] {
        &self.params
    }
}