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

use util::{fetch_all, fetch_one};

mod util;

#[tokio::test]
async fn real_negative_as_f32() {
    let row: f32 = fetch_one("SELECT -4.2 :: REAL AS value").await.unwrap();
    assert_eq!(row, -4.2);
}

#[tokio::test]
async fn real_as_f32_opt() {
    let rows: Vec<f32> = fetch_all("SELECT 10.0 :: REAL AS value UNION ALL SELECT -10.0")
        .await
        .unwrap();
    assert_eq!(rows, vec![10.0, -10.0]);
}

#[tokio::test]
async fn real_nan_as_f32() {
    let row: f32 = fetch_one("SELECT 'NaN'::REAL AS value").await.unwrap();
    assert!(row.is_nan(), "Expected NaN for f32");
}

#[tokio::test]
async fn double_precision_nan_as_f64() {
    let row: f64 = fetch_one("SELECT 'NaN'::DOUBLE PRECISION AS value")
        .await
        .unwrap();
    assert!(row.is_nan(), "Expected NaN for f64");
}

#[tokio::test]
async fn double_precision_infinity_as_f64() {
    let row: f64 = fetch_one("SELECT 'Infinity'::DOUBLE PRECISION AS value")
        .await
        .unwrap();
    assert!(
        row.is_infinite() && row.is_sign_positive(),
        "Expected positive infinity"
    );
}

#[tokio::test]
async fn double_precision_negative_infinity_as_f64() {
    let row: f64 = fetch_one("SELECT '-Infinity'::DOUBLE PRECISION AS value")
        .await
        .unwrap();
    assert!(
        row.is_infinite() && row.is_sign_negative(),
        "Expected negative infinity"
    );
}