prax-sqlx 0.8.0

SQLx query engine backend for Prax ORM with compile-time checked queries
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

//! Connection wrapper for SQLx.

use crate::config::DatabaseBackend;
use crate::error::SqlxResult;
use crate::pool::SqlxPool;

/// A database connection acquired from the pool.
pub enum SqlxConnection {
    /// PostgreSQL connection
    #[cfg(feature = "postgres")]
    Postgres(sqlx::pool::PoolConnection<sqlx::Postgres>),
    /// MySQL connection
    #[cfg(feature = "mysql")]
    MySql(sqlx::pool::PoolConnection<sqlx::MySql>),
    /// SQLite connection
    #[cfg(feature = "sqlite")]
    Sqlite(sqlx::pool::PoolConnection<sqlx::Sqlite>),
}

impl SqlxConnection {
    /// Acquire a connection from the pool.
    pub async fn acquire(pool: &SqlxPool) -> SqlxResult<Self> {
        match pool {
            #[cfg(feature = "postgres")]
            SqlxPool::Postgres(p) => {
                let conn = p.acquire().await?;
                Ok(Self::Postgres(conn))
            }
            #[cfg(feature = "mysql")]
            SqlxPool::MySql(p) => {
                let conn = p.acquire().await?;
                Ok(Self::MySql(conn))
            }
            #[cfg(feature = "sqlite")]
            SqlxPool::Sqlite(p) => {
                let conn = p.acquire().await?;
                Ok(Self::Sqlite(conn))
            }
        }
    }

    /// Get the database backend type.
    pub fn backend(&self) -> DatabaseBackend {
        match self {
            #[cfg(feature = "postgres")]
            Self::Postgres(_) => DatabaseBackend::Postgres,
            #[cfg(feature = "mysql")]
            Self::MySql(_) => DatabaseBackend::MySql,
            #[cfg(feature = "sqlite")]
            Self::Sqlite(_) => DatabaseBackend::Sqlite,
        }
    }
}

/// A transaction handle.
pub enum SqlxTransaction<'c> {
    /// PostgreSQL transaction
    #[cfg(feature = "postgres")]
    Postgres(sqlx::Transaction<'c, sqlx::Postgres>),
    /// MySQL transaction
    #[cfg(feature = "mysql")]
    MySql(sqlx::Transaction<'c, sqlx::MySql>),
    /// SQLite transaction
    #[cfg(feature = "sqlite")]
    Sqlite(sqlx::Transaction<'c, sqlx::Sqlite>),
}

impl<'c> SqlxTransaction<'c> {
    /// Commit the transaction.
    pub async fn commit(self) -> SqlxResult<()> {
        match self {
            #[cfg(feature = "postgres")]
            Self::Postgres(tx) => tx.commit().await?,
            #[cfg(feature = "mysql")]
            Self::MySql(tx) => tx.commit().await?,
            #[cfg(feature = "sqlite")]
            Self::Sqlite(tx) => tx.commit().await?,
        }
        Ok(())
    }

    /// Rollback the transaction.
    pub async fn rollback(self) -> SqlxResult<()> {
        match self {
            #[cfg(feature = "postgres")]
            Self::Postgres(tx) => tx.rollback().await?,
            #[cfg(feature = "mysql")]
            Self::MySql(tx) => tx.rollback().await?,
            #[cfg(feature = "sqlite")]
            Self::Sqlite(tx) => tx.rollback().await?,
        }
        Ok(())
    }

    /// Get the database backend type.
    pub fn backend(&self) -> DatabaseBackend {
        match self {
            #[cfg(feature = "postgres")]
            Self::Postgres(_) => DatabaseBackend::Postgres,
            #[cfg(feature = "mysql")]
            Self::MySql(_) => DatabaseBackend::MySql,
            #[cfg(feature = "sqlite")]
            Self::Sqlite(_) => DatabaseBackend::Sqlite,
        }
    }
}

impl SqlxPool {
    /// Begin a transaction.
    pub async fn begin(&self) -> SqlxResult<SqlxTransaction<'_>> {
        match self {
            #[cfg(feature = "postgres")]
            Self::Postgres(pool) => {
                let tx = pool.begin().await?;
                Ok(SqlxTransaction::Postgres(tx))
            }
            #[cfg(feature = "mysql")]
            Self::MySql(pool) => {
                let tx = pool.begin().await?;
                Ok(SqlxTransaction::MySql(tx))
            }
            #[cfg(feature = "sqlite")]
            Self::Sqlite(pool) => {
                let tx = pool.begin().await?;
                Ok(SqlxTransaction::Sqlite(tx))
            }
        }
    }
}