ciboulette2pg 0.1.3

Library to execute Ciboulette query to Postgres and build responses back
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
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136

use super::*;

async fn test_insert<'store>(
    pool: &mut sqlx::PgPool,
    query_end: &str,
    body: &str,
) -> Vec<sqlx::postgres::PgRow> {
    let ciboulette_store = gen_bag();
    let table_store = gen_table_store(&ciboulette_store);
    let parsed_url = Url::parse(format!("http://localhost{}", query_end).as_str()).unwrap();
    const INTENTION: CibouletteIntention = CibouletteIntention::Create;
    let body: Option<&str> = Some(body);

    let req_builder = CibouletteRequestBuilder::new(INTENTION, &parsed_url, &body);
    let request = req_builder.build(&ciboulette_store).unwrap();
    let ciboulette_request = CibouletteCreateRequest::try_from(request).unwrap();
    let builder =
        Ciboulette2PgBuilder::gen_insert(&ciboulette_store, &table_store, &ciboulette_request)
            .unwrap();
    let (query, args) = builder.build().unwrap();

    let raw_rows: Vec<sqlx::postgres::PgRow> = sqlx::query_with(&query, args)
        .fetch_all(&mut pool.acquire().await.unwrap())
        .await
        .unwrap();
    raw_rows
}

#[basiliq_test(run_migrations)]
async fn insert_main_all_fields(mut pool: sqlx::PgPool) {
    let raw_rows = test_insert(
        &mut pool,
        "/peoples",
        json!({
            "data": json!({
                "type": "peoples",
                "attributes": json!({
                    "first-name": "Hello",
                    "last-name": "World",
                    "twitter": "@myhandle",
                    "gender": "M",
                    "age": 19
                })
            })
        })
        .to_string()
        .as_str(),
    )
    .await;
    Ciboulette2PgRow::from_raw(&raw_rows).expect("to deserialize the returned rows");
    snapshot_table(
        &mut pool,
        "insert_main_all_fields",
        &["peoples", "people-article", "favorite_color"],
    )
    .await;
}

#[basiliq_test(run_migrations)]
async fn insert_main_required_only(mut pool: sqlx::PgPool) {
    let raw_rows = test_insert(
        &mut pool,
        "/peoples",
        json!({
            "data": json!({
                "type": "peoples",
                "attributes": json!({
                    "first-name": "Hello",
                    "last-name": "World"
                })
            })
        })
        .to_string()
        .as_str(),
    )
    .await;
    Ciboulette2PgRow::from_raw(&raw_rows).expect("to deserialize the returned rows");
    snapshot_table(
        &mut pool,
        "insert_main_required_fields",
        &["peoples", "people-article", "favorite_color"],
    )
    .await;
}

#[basiliq_test(run_migrations)]
async fn insert_main_with_favorite_color(mut pool: sqlx::PgPool) {
    let raw_rows_color = test_insert(
        &mut pool,
        "/favorite_color",
        json!({
            "data": json!({
                "type": "favorite_color",
                "attributes": json!({
                    "color": "red"
                })
            })
        })
        .to_string()
        .as_str(),
    )
    .await;
    let color_rows =
        Ciboulette2PgRow::from_raw(&raw_rows_color).expect("to deserialize the returned rows");
    let raw_rows_main = test_insert(
        &mut pool,
        "/peoples",
        json!({
            "data": json!({
                "type": "peoples",
                "attributes": json!({
                    "first-name": "Hello",
                    "last-name": "World"
                }),
                "relationships": json!({
                    "favorite_color": json!({
                        "data": json!({
                            "id": color_rows.first().unwrap().id(),
                            "type": "favorite_color"
                        })
                    })
                })
            })
        })
        .to_string()
        .as_str(),
    )
    .await;
    Ciboulette2PgRow::from_raw(&raw_rows_main).expect("to deserialize the returned rows");
    snapshot_table(
        &mut pool,
        "insert_main_with_color",
        &["peoples", "people-article", "favorite_color"],
    )
    .await;
}