fraiseql-wire 2.3.2

Streaming JSON query engine for Postgres 17
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

#![allow(clippy::unwrap_used, clippy::panic)] // Reason: test code, panics acceptable
use super::*;

#[test]
fn test_jsonb_field_ordering() {
    let clause = OrderByClause::jsonb_field("name", SortOrder::Asc);
    let sql = clause.to_sql().unwrap();
    assert_eq!(sql, "(data->'name') ASC");
}

#[test]
fn test_direct_column_ordering() {
    let clause = OrderByClause::direct_column("created_at", SortOrder::Desc);
    let sql = clause.to_sql().unwrap();
    assert_eq!(sql, "created_at DESC");
}

#[test]
fn test_ordering_with_collation() {
    let clause = OrderByClause::jsonb_field("name", SortOrder::Asc).with_collation("en-US");
    let sql = clause.to_sql().unwrap();
    assert_eq!(sql, "(data->'name') COLLATE \"en-US\" ASC");
}

#[test]
fn test_ordering_with_nulls_last() {
    let clause =
        OrderByClause::direct_column("status", SortOrder::Asc).with_nulls(NullsHandling::Last);
    let sql = clause.to_sql().unwrap();
    assert_eq!(sql, "status ASC NULLS LAST");
}

#[test]
fn test_ordering_with_collation_and_nulls() {
    let clause = OrderByClause::jsonb_field("email", SortOrder::Desc)
        .with_collation("C")
        .with_nulls(NullsHandling::First);
    let sql = clause.to_sql().unwrap();
    assert_eq!(sql, "(data->'email') COLLATE \"C\" DESC NULLS FIRST");
}

#[test]
fn test_field_validation() {
    OrderByClause::jsonb_field("valid_name", SortOrder::Asc)
        .validate()
        .unwrap_or_else(|e| panic!("expected Ok for 'valid_name': {e}"));

    let result = OrderByClause::jsonb_field("123invalid", SortOrder::Asc).validate();
    assert!(
        result.is_err(),
        "expected Err for '123invalid', got: {result:?}"
    );

    let result = OrderByClause::jsonb_field("bad-name", SortOrder::Asc).validate();
    assert!(
        result.is_err(),
        "expected Err for 'bad-name', got: {result:?}"
    );
}

#[test]
fn test_collation_validation() {
    let clause = OrderByClause::jsonb_field("name", SortOrder::Asc).with_collation("en-US");
    clause
        .validate()
        .unwrap_or_else(|e| panic!("expected Ok for collation 'en-US': {e}"));

    let clause = OrderByClause::jsonb_field("name", SortOrder::Asc).with_collation("C.UTF-8");
    clause
        .validate()
        .unwrap_or_else(|e| panic!("expected Ok for collation 'C.UTF-8': {e}"));

    let clause =
        OrderByClause::jsonb_field("name", SortOrder::Asc).with_collation("invalid!!!special");
    let result = clause.validate();
    assert!(
        result.is_err(),
        "expected Err for collation 'invalid!!!special', got: {result:?}"
    );
}

#[test]
fn test_sort_order_display() {
    assert_eq!(SortOrder::Asc.to_string(), "ASC");
    assert_eq!(SortOrder::Desc.to_string(), "DESC");
}

#[test]
fn test_field_source_display() {
    assert_eq!(FieldSource::JsonbPayload.to_string(), "JSONB");
    assert_eq!(FieldSource::DirectColumn.to_string(), "DIRECT_COLUMN");
}

#[test]
fn test_collation_enum() {
    assert_eq!(Collation::C.as_str(), "C");
    assert_eq!(Collation::Utf8.as_str(), "C.UTF-8");
    assert_eq!(Collation::Custom("de-DE".to_string()).as_str(), "de-DE");
}