apalis-postgres 1.0.0-rc.9

Background task processing for rust using apalis and postgres
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
57
58
59

use std::str::FromStr;

use apalis_core::backend::{Backend, Metrics, StatType, Statistic};

use crate::{PostgresStorage, error::Error};

struct StatisticRow {
    priority: Option<i32>,
    r#type: Option<String>,
    statistic: Option<String>,
    value: Option<f32>,
}

impl<Args> Metrics for PostgresStorage<Args>
where
    PostgresStorage<Args>: Backend<Error = Error>,
{
    fn global(&self) -> impl Future<Output = Result<Vec<Statistic>, Self::Error>> + Send {
        let pool = self.persistence.pool.clone();

        async move {
            let rec = sqlx::query_file_as!(StatisticRow, "queries/backend/overview.sql")
                .fetch_all(&pool)
                .await?
                .into_iter()
                .map(|r| Statistic {
                    priority: Some(r.priority.unwrap_or_default() as u64),
                    stat_type: StatType::from_str(&r.r#type.unwrap_or_default())
                        .unwrap_or_default(),
                    title: r.statistic.unwrap_or_default(),
                    value: r.value.unwrap_or_default().to_string(),
                })
                .collect();
            Ok(rec)
        }
    }
    fn fetch_by_queue(&self) -> impl Future<Output = Result<Vec<Statistic>, Self::Error>> + Send {
        let pool = self.persistence.pool.clone();
        let queue_id = self.persistence.config.queue.to_string();
        async move {
            let rec = sqlx::query_file_as!(
                StatisticRow,
                "queries/backend/overview_by_queue.sql",
                queue_id
            )
            .fetch_all(&pool)
            .await?
            .into_iter()
            .map(|r| Statistic {
                priority: Some(r.priority.unwrap_or_default() as u64),
                stat_type: StatType::from_str(&r.r#type.unwrap_or_default()).unwrap_or_default(),
                title: r.statistic.unwrap_or_default(),
                value: r.value.unwrap_or_default().to_string(),
            })
            .collect();
            Ok(rec)
        }
    }
}