easy-sql 0.101.1

Macro-first SQL toolkit with compile-time checked queries, optional migrations on top of sqlx.
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
80
81
82
83
84
85
86
87
88
89

use easy_macros::always_context;
use sqlx::ColumnIndex;

use crate::{
    Driver,
    traits::{DriverRow, InternalDriver, ToConvert},
};

use super::TestDriver;

#[allow(dead_code)]
struct ExampleTableStruct {
    field0: String,
    field1: String,
    field2: i32,
    field3: i64,
    field4: i16,
}

#[allow(dead_code)]
struct ExampleStruct {
    field1: String,
    field2: i32,
    field3: i64,
}
//Remove in derive
#[always_context]
impl<D: Driver> crate::Output<ExampleTableStruct, D> for ExampleStruct
where
    DriverRow<D>: ToConvert<D>,
    str: ColumnIndex<DriverRow<D>>,
    for<'x> String: sqlx::Decode<'x, InternalDriver<D>>,
    String: sqlx::Type<InternalDriver<D>>,
    for<'x> i32: sqlx::Decode<'x, InternalDriver<D>>,
    i32: sqlx::Type<InternalDriver<D>>,
    for<'x> i64: sqlx::Decode<'x, InternalDriver<D>>,
    i64: sqlx::Type<InternalDriver<D>>,
{
    type UsedForChecks = Self;
    type DataToConvert = DriverRow<D>;

    fn select(current_query: &mut String) {
        current_query.push_str("field1, field2, field3");
    }
    //Remove in derive
    #[no_context]
    fn convert(data: DriverRow<D>) -> anyhow::Result<Self> {
        use anyhow::Context;
        use easy_macros::context;

        let _ = |data: DriverRow<TestDriver>| {
            anyhow::Result::<Self>::Ok(Self {
                field1: <DriverRow<TestDriver> as crate::macro_support::SqlxRow>::try_get(
                    &data, "field1",
                )
                .with_context(context!(
                    "Getting field `field1` with type String for struct ExampleStruct"
                ))?,
                field2: <DriverRow<TestDriver> as crate::macro_support::SqlxRow>::try_get(
                    &data, "field2",
                )
                .with_context(context!(
                    "Getting field `field2` with type i32 for struct ExampleStruct"
                ))?,
                field3: <DriverRow<TestDriver> as crate::macro_support::SqlxRow>::try_get(
                    &data, "field3",
                )
                .with_context(context!(
                    "Getting field `field3` with type i64 for struct ExampleStruct"
                ))?,
            })
        };

        Ok(Self {
            field1: <DriverRow<D> as crate::macro_support::SqlxRow>::try_get(&data, "field1")
                .with_context(context!(
                    "Getting field `field1` with type String for struct ExampleStruct"
                ))?,
            field2: <DriverRow<D> as crate::macro_support::SqlxRow>::try_get(&data, "field2")
                .with_context(context!(
                    "Getting field `field2` with type i32 for struct ExampleStruct"
                ))?,
            field3: <DriverRow<D> as crate::macro_support::SqlxRow>::try_get(&data, "field3")
                .with_context(context!(
                    "Getting field `field3` with type i64 for struct ExampleStruct"
                ))?,
        })
    }
}