openauth-sqlx 0.0.2

SQLx database adapters for OpenAuth.
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

use indexmap::IndexMap;
use openauth_core::db::{DbField, DbFieldType, DbRecord, DbValue};
use openauth_core::error::OpenAuthError;
use sqlx::postgres::PgRow;
use sqlx::Row;
use time::OffsetDateTime;

use super::errors::{json_error, sql_error};

pub(super) fn row_record(
    row: &PgRow,
    selection: &[(&str, &DbField)],
) -> Result<DbRecord, OpenAuthError> {
    selection
        .iter()
        .map(|(logical_name, field)| {
            row_value(row, field).map(|value| ((*logical_name).to_owned(), value))
        })
        .collect::<Result<IndexMap<_, _>, _>>()
}

pub(super) fn row_value(row: &PgRow, field: &DbField) -> Result<DbValue, OpenAuthError> {
    row_value_at(row, field, field.name.as_str())
}

pub(super) fn row_value_at(
    row: &PgRow,
    field: &DbField,
    column: &str,
) -> Result<DbValue, OpenAuthError> {
    match field.field_type {
        DbFieldType::String => row
            .try_get::<Option<String>, _>(column)
            .map(|value| value.map(DbValue::String).unwrap_or(DbValue::Null))
            .map_err(sql_error),
        DbFieldType::Number => row
            .try_get::<Option<i64>, _>(column)
            .map(|value| value.map(DbValue::Number).unwrap_or(DbValue::Null))
            .map_err(sql_error),
        DbFieldType::Boolean => row
            .try_get::<Option<bool>, _>(column)
            .map(|value| value.map(DbValue::Boolean).unwrap_or(DbValue::Null))
            .map_err(sql_error),
        DbFieldType::Timestamp => row
            .try_get::<Option<OffsetDateTime>, _>(column)
            .map(|value| value.map(DbValue::Timestamp).unwrap_or(DbValue::Null))
            .map_err(sql_error),
        DbFieldType::Json => row
            .try_get::<Option<serde_json::Value>, _>(column)
            .map(|value| value.map(DbValue::Json).unwrap_or(DbValue::Null))
            .map_err(sql_error),
        DbFieldType::StringArray => {
            let value = row
                .try_get::<Option<serde_json::Value>, _>(column)
                .map_err(sql_error)?;
            value
                .map(|value| {
                    serde_json::from_value::<Vec<String>>(value)
                        .map(DbValue::StringArray)
                        .map_err(json_error)
                })
                .transpose()
                .map(|value| value.unwrap_or(DbValue::Null))
        }
        DbFieldType::NumberArray => {
            let value = row
                .try_get::<Option<serde_json::Value>, _>(column)
                .map_err(sql_error)?;
            value
                .map(|value| {
                    serde_json::from_value::<Vec<i64>>(value)
                        .map(DbValue::NumberArray)
                        .map_err(json_error)
                })
                .transpose()
                .map(|value| value.unwrap_or(DbValue::Null))
        }
    }
}