rqb 0.1.7

sqlx-first typed Postgres query builder.
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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103

use crate::common::{order_search, uuid};
use serde_json::json;
use uuid::Uuid;

#[allow(dead_code)]
#[derive(Debug, sqlx::FromRow)]
struct SearchRow {
    id: Uuid,
    email: String,
    channel: String,
    total_cents: i64,
}

#[tokio::test]
#[ignore = "requires Postgres 18 and RQB_TEST_DATABASE_URL"]
async fn search_request_filter_and_sort_round_trip() {
    let pool = crate::common::pool().await;
    let request: rqb::SearchRequest = serde_json::from_value(json!({
        "filter": { "field": "channel", "operator": "equals", "value": "web" },
        "sort": [{ "field": "total_cents", "dir": "desc" }],
        "limit": 2
    }))
    .unwrap();

    let rows = rqb::select(order_search::view())
        .columns((
            order_search::ID,
            order_search::EMAIL,
            order_search::CHANNEL,
            order_search::TOTAL_CENTS,
        ))
        .apply_search(request)
        .unwrap()
        .fetch_all_as::<SearchRow>(&pool)
        .await
        .unwrap();

    assert_eq!(rows.len(), 2);
    assert!(rows.iter().all(|row| row.channel == "web"));
    assert!(rows[0].total_cents >= rows[1].total_cents);
}

#[tokio::test]
#[ignore = "requires Postgres 18 and RQB_TEST_DATABASE_URL"]
async fn search_request_multi_key_sort_round_trip() {
    let pool = crate::common::pool().await;
    let request: rqb::SearchRequest = serde_json::from_value(json!({
        "sort": [
            { "field": "channel", "dir": "asc" },
            { "field": "total_cents", "dir": "desc" }
        ],
        "limit": 4
    }))
    .unwrap();

    let rows = rqb::select(order_search::view())
        .columns((
            order_search::ID,
            order_search::EMAIL,
            order_search::CHANNEL,
            order_search::TOTAL_CENTS,
        ))
        .apply_search(request)
        .unwrap()
        .fetch_all_as::<SearchRow>(&pool)
        .await
        .unwrap();

    assert_eq!(rows.len(), 4);
    assert!(rows.windows(2).all(|pair| {
        pair[0].channel < pair[1].channel
            || (pair[0].channel == pair[1].channel && pair[0].total_cents >= pair[1].total_cents)
    }));
}

#[tokio::test]
#[ignore = "requires Postgres 18 and RQB_TEST_DATABASE_URL"]
async fn search_request_limit_offset_round_trip() {
    let pool = crate::common::pool().await;
    let request: rqb::SearchRequest = serde_json::from_value(json!({
        "sort": [{ "field": "created_at", "dir": "asc" }],
        "limit": 2,
        "offset": 1
    }))
    .unwrap();

    let rows = rqb::select(order_search::view())
        .columns((
            order_search::ID,
            order_search::EMAIL,
            order_search::CHANNEL,
            order_search::TOTAL_CENTS,
        ))
        .apply_search(request)
        .unwrap()
        .fetch_all_as::<SearchRow>(&pool)
        .await
        .unwrap();

    assert_eq!(rows.len(), 2);
    assert_eq!(rows[0].id, uuid("30000000-0000-0000-0000-000000000001"));
    assert_eq!(rows[1].id, uuid("30000000-0000-0000-0000-000000000002"));
}