Method transaction_ex

src/sql.rs:468–489

Execute the function inside a transaction. `query_only` - Whether the function only executes read statements (queries) and can be run in parallel with other transactions. NB: Creating and modifying temporary tables are also allowed with `query_only`, temporary tables aren't visible in other connections, but you need to pass `PRAGMA query_only=0;` to SQLite before that: ```text pragma_update(None,

(&self, query_only: bool, callback: G)

    /// If the function returns an error, the transaction will be rolled back. If it does not return
    /// an error, the transaction will be committed.
    pub async fn transaction_ex<G, H>(&self, query_only: bool, callback: G) -> Result<H>
    where
        H: Send + 'static,
        G: Send + FnOnce(&mut rusqlite::Transaction<'_>) -> Result<H>,
    {
        self.call(query_only, move |conn| {
            let mut transaction = conn.transaction()?;
            let ret = callback(&mut transaction);

            match ret {
                Ok(ret) => {
                    transaction.commit()?;
                    Ok(ret)
                }
                Err(err) => {
                    transaction.rollback()?;
                    Err(err)
                }
            }
        })
        .await
    }

    /// Query the database if the requested table already exists.
    pub async fn table_exists(&self, name: &str) -> Result<bool> {