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
use sqlx::Pool;
use sqlx::Sqlite;
use sqlx::SqliteConnection;

use tracing::debug_span;
use tracing::Instrument;

use std::sync::Arc;
use tokio::sync::Mutex;
use tokio::sync::OwnedMutexGuard;

#[derive(Debug, Clone)]
pub struct SqlitePool {
    pub writer: Arc<Mutex<SqliteConnection>>,
    reader: Pool<Sqlite>,
}

impl SqlitePool {
    pub fn new(writer: SqliteConnection, reader: Pool<Sqlite>) -> Self {
        Self {
            writer: Arc::new(Mutex::new(writer)),
            reader,
        }
    }

    pub fn read(&self) -> Pool<Sqlite> {
        self.reader.clone()
    }

    pub fn writer(&self) -> Arc<Mutex<SqliteConnection>> {
        self.writer.clone()
    }

    pub fn read_ref(&self) -> &Pool<Sqlite> {
        &self.reader
    }
}

pub async fn write_tx(
    lock: &mut OwnedMutexGuard<SqliteConnection>,
) -> Result<crate::Transaction<'_>, sqlx::Error> {
    use sqlx::Connection;

    let mut tx = lock.begin().instrument(debug_span!("TxBegin")).await?;

    sqlx::query("END").execute(&mut tx).await?;
    sqlx::query("BEGIN EXCLUSIVE").execute(&mut tx).await?;

    Ok(tx)
}