graphile_worker 0.13.3

High performance Rust/PostgreSQL job queue (also suitable for getting jobs generated by PostgreSQL triggers/functions out into a different work queue)
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
60
61
62

use graphile_worker_database::{Database, DbExecutor, DbValue, Schema};
use indoc::formatdoc;
use tracing::error;

use super::super::CompletionRequest;

pub(super) async fn complete_jobs_without_queues(
    database: &Database,
    schema: &Schema,
    job_ids: Vec<i64>,
) -> bool {
    if job_ids.is_empty() {
        return false;
    }

    let jobs = schema.private_table("jobs");
    let sql = formatdoc!(
        r#"
            DELETE FROM {jobs}
            WHERE id = ANY($1::bigint[])
        "#
    );

    match database
        .execute(&sql, vec![DbValue::I64Array(job_ids)].into())
        .await
    {
        Ok(_) => true,
        Err(error) => {
            error!(?error, "Failed to complete jobs without queue");
            false
        }
    }
}

pub(super) async fn complete_one_job_without_queue(
    req: &CompletionRequest,
    database: &Database,
    schema: &Schema,
) -> bool {
    let jobs = schema.private_table("jobs");
    let sql = formatdoc!(
        r#"
            DELETE FROM {jobs}
            WHERE id = $1
        "#
    );

    if let Err(error) = database
        .execute(&sql, vec![DbValue::I64(req.job_id)].into())
        .await
    {
        error!(
            ?error,
            job_id = req.job_id,
            "Failed to complete job directly"
        );
        return false;
    }

    true
}