sova-db 0.1.2

SeaORM database plugin for Sova (postgres / sqlite / mysql)
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

use crate::DbError;
use sova_core::Request;
use sea_orm::{
    ConnectionTrait, DatabaseConnection, DatabaseTransaction, DbBackend, DbErr, ExecResult,
    QueryResult, Statement,
};
use std::sync::Arc;
use tokio::sync::RwLock;

/// Shared pool handle filled during `on_startup`.
#[derive(Clone, Default)]
pub struct DbPool {
    inner: Arc<RwLock<Option<DatabaseConnection>>>,
}

impl DbPool {
    pub fn new() -> Self {
        Self::default()
    }

    pub async fn set(&self, conn: DatabaseConnection) {
        *self.inner.write().await = Some(conn);
    }

    pub async fn get(&self) -> Result<DatabaseConnection, DbError> {
        self.inner
            .read()
            .await
            .clone()
            .ok_or_else(|| DbError(DbErr::Custom("database not connected".into())))
    }

    pub async fn clear(&self) {
        let _ = self.inner.write().await.take();
    }
}

/// Request-scoped DB handle: pool connection or open transaction.
#[derive(Clone)]
pub enum DbHandle {
    Conn(DatabaseConnection),
    Tx(Arc<DatabaseTransaction>),
}

impl DbHandle {
    pub fn as_conn(&self) -> Option<&DatabaseConnection> {
        match self {
            Self::Conn(c) => Some(c),
            Self::Tx(_) => None,
        }
    }
}

#[async_trait::async_trait]
impl ConnectionTrait for DbHandle {
    fn get_database_backend(&self) -> DbBackend {
        match self {
            Self::Conn(c) => c.get_database_backend(),
            Self::Tx(t) => t.get_database_backend(),
        }
    }

    async fn execute_raw(&self, stmt: Statement) -> Result<ExecResult, DbErr> {
        match self {
            Self::Conn(c) => c.execute_raw(stmt).await,
            Self::Tx(t) => t.execute_raw(stmt).await,
        }
    }

    async fn execute_unprepared(&self, sql: &str) -> Result<ExecResult, DbErr> {
        match self {
            Self::Conn(c) => c.execute_unprepared(sql).await,
            Self::Tx(t) => t.execute_unprepared(sql).await,
        }
    }

    async fn query_one_raw(&self, stmt: Statement) -> Result<Option<QueryResult>, DbErr> {
        match self {
            Self::Conn(c) => c.query_one_raw(stmt).await,
            Self::Tx(t) => t.query_one_raw(stmt).await,
        }
    }

    async fn query_all_raw(&self, stmt: Statement) -> Result<Vec<QueryResult>, DbErr> {
        match self {
            Self::Conn(c) => c.query_all_raw(stmt).await,
            Self::Tx(t) => t.query_all_raw(stmt).await,
        }
    }
}

/// Convenient access to the request [`DbHandle`].
pub trait DbExt {
    fn db(&self) -> &DbHandle;
}

impl DbExt for Request {
    fn db(&self) -> &DbHandle {
        self.get::<DbHandle>()
            .expect("Db plugin is not installed (missing req.db())")
    }
}