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

use super::*;

async fn test_delete<'store>(
    pool: &mut sqlx::PgPool,
    query_end: &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::Delete;

    let req_builder = CibouletteRequestBuilder::new(INTENTION, &parsed_url, &None);
    let request = req_builder.build(&ciboulette_store).unwrap();
    let ciboulette_request = CibouletteDeleteRequest::try_from(request).unwrap();
    let builder =
        Ciboulette2PgBuilder::gen_delete(&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
}

macro_rules! baseline {
    ($pool:ident) => {
        snapshot_table(
            &mut $pool,
            "normal_people_table_and_people_article",
            &["peoples", "people-article"],
        )
        .await;
    };
}

#[basiliq_test(run_migrations)]
async fn main(mut pool: sqlx::PgPool) {
    let data = basiliq_db_test_utils::init_values(&mut pool).await;
    baseline!(pool);
    let people_id = data.get("peoples").unwrap().first().unwrap();
    let raw_rows = test_delete(&mut pool, format!("/peoples/{}", people_id).as_str()).await;
    Ciboulette2PgRow::from_raw(&raw_rows).expect("to deserialize the returned rows");
    snapshot_table(&mut pool, "delete_main", &["peoples", "people-article"]).await;
}

#[basiliq_test(run_migrations)]
async fn one_to_one(mut pool: sqlx::PgPool) {
    let data = basiliq_db_test_utils::init_values(&mut pool).await;
    baseline!(pool);
    let people_id = data.get("peoples").unwrap().first().unwrap();
    let raw_rows = test_delete(
        &mut pool,
        format!("/peoples/{}/relationships/favorite_color", people_id).as_str(),
    )
    .await;
    Ciboulette2PgRow::from_raw(&raw_rows).expect("to deserialize the returned rows");
    snapshot_table(
        &mut pool,
        "delete_one_to_one",
        &["peoples", "people-article"],
    )
    .await;
}