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
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135

use std::ops::{Deref, DerefMut};

use anyhow::Context;
use easy_macros::always_context;
use sqlx::Database;
use std::fmt::Debug;

use crate::{
    Driver, EasyExecutor,
    traits::{DriverConnection, InternalDriver, SetupSql},
};
/// Wrapper around [`sqlx::Transaction`](https://docs.rs/sqlx/latest/sqlx/struct.Transaction.html)
///
/// Will contain sql query watch data in the future (gated by a feature)
#[derive(Debug)]
pub struct Transaction<'a, D: Driver> {
    internal: sqlx::Transaction<'a, D::InternalDriver>,
}

#[always_context]
impl<'a, D: Driver> Transaction<'a, D> {
    pub fn new(internal: sqlx::Transaction<'a, D::InternalDriver>) -> Self {
        Transaction { internal }
    }

    pub async fn commit(self) -> anyhow::Result<()> {
        self.internal.commit().await?;
        Ok(())
    }

    pub async fn rollback(self) -> anyhow::Result<()> {
        self.internal.rollback().await?;
        Ok(())
    }
}

#[always_context]
impl<'c, D: Driver> EasyExecutor<D> for Transaction<'c, D>
where
    for<'b> &'b mut DriverConnection<D>: sqlx::Executor<'b, Database = D::InternalDriver>,
{
    type InternalExecutor<'b>
        = &'b mut DriverConnection<D>
    where
        Self: 'b;
    async fn query_setup<O: SetupSql<D> + Send + Sync>(
        &mut self,
        sql: O,
    ) -> anyhow::Result<O::Output>
    where
        DriverConnection<D>: Send + Sync,
    {
        sql.query(self).await
    }

    fn executor<'a>(&'a mut self) -> Self::InternalExecutor<'a> {
        &mut *self.internal
    }
}
impl<'c, D: Driver> Deref for Transaction<'c, D> {
    type Target = <InternalDriver<D> as Database>::Connection;

    fn deref(&self) -> &Self::Target {
        &self.internal
    }
}

impl<'c, D: Driver> DerefMut for Transaction<'c, D> {
    fn deref_mut(&mut self) -> &mut Self::Target {
        &mut self.internal
    }
}
/// Wrapper around [`sqlx::Transaction`](https://docs.rs/sqlx/latest/sqlx/struct.Transaction.html)
///
/// Represents a transaction started from a connection pool, so it can be sent across threads and awaited on without holding up the connection.
///
/// Will contain sql query watch data in the future (gated by a feature)
#[derive(Debug)]
pub struct PoolTransaction<D: Driver> {
    internal: sqlx::Transaction<'static, D::InternalDriver>,
}

#[always_context]
impl<D: Driver> PoolTransaction<D> {
    pub fn new(internal: sqlx::Transaction<'static, D::InternalDriver>) -> Self {
        PoolTransaction { internal }
    }

    pub async fn commit(self) -> anyhow::Result<()> {
        self.internal.commit().await?;
        Ok(())
    }

    pub async fn rollback(self) -> anyhow::Result<()> {
        self.internal.rollback().await?;
        Ok(())
    }
}

#[always_context]
impl<D: Driver> EasyExecutor<D> for PoolTransaction<D>
where
    for<'b> &'b mut DriverConnection<D>: sqlx::Executor<'b, Database = D::InternalDriver>,
{
    type InternalExecutor<'b>
        = &'b mut DriverConnection<D>
    where
        Self: 'b;
    async fn query_setup<O: SetupSql<D> + Send + Sync>(
        &mut self,
        sql: O,
    ) -> anyhow::Result<O::Output>
    where
        DriverConnection<D>: Send + Sync,
    {
        sql.query(self).await
    }

    fn executor<'a>(&'a mut self) -> Self::InternalExecutor<'a> {
        &mut *self.internal
    }
}
impl<D: Driver> Deref for PoolTransaction<D> {
    type Target = <InternalDriver<D> as Database>::Connection;

    fn deref(&self) -> &Self::Target {
        &self.internal
    }
}

impl<D: Driver> DerefMut for PoolTransaction<D> {
    fn deref_mut(&mut self) -> &mut Self::Target {
        &mut self.internal
    }
}