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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56

mod util;

use std::collections::HashMap;
use util::fetch_all;

#[tokio::test]
async fn text_columns_into_hashmap() {
    #[derive(Debug, ::serde::Deserialize, PartialEq, Eq)]
    struct Record {
        #[serde(flatten)]
        fields: HashMap<String, i32>,
    }

    let rows: Vec<Record> = fetch_all("SELECT 1 one, 2 two, 3 three").await.unwrap();
    let fields: HashMap<String, i32> = vec![
        ("one".to_owned(), 1),
        ("two".to_owned(), 2),
        ("three".to_owned(), 3),
    ]
    .into_iter()
    .collect();
    assert_eq!(rows, vec![Record { fields }]);
}

#[tokio::test]
async fn int4_columns_into_struct_with_flattenned_field() {
    #[derive(Debug, ::serde::Deserialize, PartialEq, Eq)]
    struct Record {
        one: i32,
        #[serde(flatten)]
        the_rest: HashMap<String, i32>,
    }
    let rows: Vec<Record> = fetch_all("SELECT 1 one, 2 two, 3 three").await.unwrap();
    let the_rest: HashMap<String, i32> = vec![("two".to_owned(), 2), ("three".to_owned(), 3)]
        .into_iter()
        .collect();
    assert_eq!(rows, vec![Record { one: 1, the_rest }]);
}

#[tokio::test]
#[ignore]
async fn int4_columns_into_struct_with_flattened_field_with_tuple_idx_prefix() {
    #[derive(Debug, ::serde::Deserialize, PartialEq, Eq)]
    struct Record {
        one: i32,
        #[serde(flatten)]
        the_rest: HashMap<String, i32>,
    }
    let rows: Vec<(Record, i32)> = fetch_all("SELECT 1 _0_one, 2 _0_two, 3 _0_three, 4 _1")
        .await
        .unwrap();
    let the_rest: HashMap<String, i32> = vec![("two".to_owned(), 2), ("three".to_owned(), 3)]
        .into_iter()
        .collect();
    assert_eq!(rows, vec![(Record { one: 1, the_rest }, 4)]);
}