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

use graphile_worker::escape_identifier;

mod helpers;

#[tokio::test]
async fn escape_identifier_matches_postgres_format_identifier() {
    helpers::with_test_db(|test_db| async move {
        let cases = [
            "graphile_worker",
            "foo_bar1",
            "schema",
            "",
            "Foo",
            "has-dash",
            "123abc",
            "with\"quote",
            "select",
            "between",
            "éclair",
        ];

        for identifier in cases {
            let expected: String = sqlx::query_scalar("select format('%I', $1::text)")
                .bind(identifier)
                .fetch_one(&test_db.test_pool)
                .await
                .expect("Failed to escape identifier with PostgreSQL");

            assert_eq!(escape_identifier(identifier), expected);
        }
    })
    .await;
}