cratestack-sqlx 0.13.0

Rust-native schema-first framework for typed HTTP APIs, generated clients, and backend services.
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
104
105
106
107
108
109
110
111
112
113
114
115

//! `preview_scoped_sql` must show the SQL that executes. Relation
//! subqueries are rendered twice — by the `QueryBuilder` pushers
//! (`query::support::relation_scope`) and by the string renderer
//! (`render::relation`) — so this holds the two to byte equality,
//! `$n` numbering included, over every scope shape.

use cratestack_core::CratestackContext;

use crate::tests_relation_scope_fixtures::{
    COMMENTS, LEDGERS, TOMBS, USERS, VAULTS, caller, executed_filter, executed_order, hop, name_eq,
    previewed_filter, previewed_order,
};
use crate::{FilterExpr, OrderClause, RelatedReadScope, RelationQuantifier, SortDirection};

fn filters() -> Vec<FilterExpr> {
    let two_hops = [
        hop(
            ("posts", "author_id"),
            ("users", "id"),
            RelationQuantifier::ToOne,
            USERS,
        ),
        hop(
            ("users", "id"),
            ("comments", "user_id"),
            RelationQuantifier::Every,
            COMMENTS,
        ),
    ];
    vec![
        FilterExpr::relation("posts", "author_id", "users", "id", name_eq("a"), USERS),
        FilterExpr::relation_some("posts", "id", "comments", "post_id", name_eq("a"), COMMENTS),
        FilterExpr::relation_every("posts", "id", "comments", "post_id", name_eq("a"), COMMENTS),
        FilterExpr::relation_none("posts", "id", "comments", "post_id", name_eq("a"), COMMENTS),
        FilterExpr::relation("posts", "vault_id", "vaults", "id", name_eq("a"), VAULTS),
        FilterExpr::relation("posts", "ledger_id", "ledgers", "id", name_eq("a"), LEDGERS),
        FilterExpr::relation_some("posts", "id", "tombs", "post_id", name_eq("a"), TOMBS),
        FilterExpr::relation("users", "manager_id", "users", "id", name_eq("a"), USERS),
        FilterExpr::relation(
            "posts",
            "author_id",
            "users",
            "id",
            name_eq("a"),
            RelatedReadScope::Unscoped,
        ),
        crate::wrap_filter(&two_hops, name_eq("a")),
        FilterExpr::any([
            name_eq("root"),
            crate::wrap_filter(&two_hops, name_eq("b")).not(),
        ]),
    ]
}

fn orders() -> Vec<OrderClause> {
    let two_hops = [
        hop(
            ("posts", "author_id"),
            ("users", "id"),
            RelationQuantifier::ToOne,
            USERS,
        ),
        hop(
            ("users", "profile_id"),
            ("profiles", "id"),
            RelationQuantifier::ToOne,
            COMMENTS,
        ),
    ];
    vec![
        OrderClause::relation_scalar(
            "posts",
            "author_id",
            "users",
            "id",
            "email",
            USERS,
            SortDirection::Asc,
        ),
        OrderClause::relation_path(&two_hops, "nickname", SortDirection::Desc),
        OrderClause::relation_scalar(
            "users",
            "manager_id",
            "users",
            "id",
            "name",
            USERS,
            SortDirection::Asc,
        ),
    ]
}

#[test]
fn previewed_relation_filters_match_executed_ones() {
    for ctx in [caller(), CratestackContext::anonymous()] {
        for filter in filters() {
            assert_eq!(
                previewed_filter(&filter, &ctx),
                executed_filter(&filter, &ctx)
            );
        }
    }
}

#[test]
fn previewed_relation_sorts_match_executed_ones() {
    for ctx in [caller(), CratestackContext::anonymous()] {
        for clause in orders() {
            assert_eq!(
                previewed_order(&clause, &ctx),
                executed_order(&clause, &ctx)
            );
        }
    }
}