serde-sqlx 0.0.1

Allows deserializing Postgres rows into Rust types using serde
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

mod util;

use util::fetch_all;

#[tokio::test]
async fn tuple_struct() {
    #[derive(Debug, serde::Deserialize, PartialEq, Eq)]
    struct TupleStruct(bool, i32);

    let rows: Vec<TupleStruct> = fetch_all("SELECT true _0, 42 _1 UNION ALL SELECT false, 0")
        .await
        .unwrap();
    assert_eq!(rows, vec![TupleStruct(true, 42), TupleStruct(false, 0)]);
}

#[tokio::test]
async fn tuple() {
    let rows: Vec<(bool, i32)> = fetch_all("SELECT true _0, 42 _1 UNION ALL SELECT false, 0")
        .await
        .unwrap();
    assert_eq!(rows, vec![(true, 42), (false, 0)]);
}

#[tokio::test]
async fn a_one_item_tuple() {
    let rows: Vec<(bool,)> = fetch_all("SELECT true _0 UNION ALL SELECT false")
        .await
        .unwrap();
    assert_eq!(rows, vec![(true,), (false,)]);
}

#[tokio::test]
async fn a_one_item_tuple_unannotated() {
    let rows: Vec<(bool,)> = fetch_all("SELECT true UNION ALL SELECT false")
        .await
        .unwrap();
    assert_eq!(rows, vec![(true,), (false,)]);
}