sql-middleware 0.9.0

Lightweight async wrappers for tokio-postgres, rusqlite, turso, and tiberius.
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

use crate::adapters::params::convert_params;
use crate::middleware::{
    ConversionMode, ResultSet, RowValues, SqlMiddlewareDbError, StatementCacheMode,
};

use super::connection::SqliteConnection;
use super::params::Params;
use super::query::build_result_set;

/// Execute a batch of SQL statements for `SQLite` using auto-commit.
///
/// # Errors
///
/// Returns `SqlMiddlewareDbError::ExecutionError` if execution fails.
pub async fn execute_batch(
    sqlite_client: &mut SqliteConnection,
    query: &str,
) -> Result<(), SqlMiddlewareDbError> {
    sqlite_client.execute_batch(query).await
}

/// Execute a SELECT query in `SQLite`.
///
/// # Errors
///
/// Returns `SqlMiddlewareDbError::ExecutionError` if execution or result processing fails.
pub async fn execute_select(
    sqlite_client: &mut SqliteConnection,
    query: &str,
    params: &[RowValues],
    statement_cache_mode: StatementCacheMode,
) -> Result<ResultSet, SqlMiddlewareDbError> {
    let params_owned = convert_params::<Params>(params, ConversionMode::Query)?.0;
    sqlite_client
        .execute_select(query, &params_owned, build_result_set, statement_cache_mode)
        .await
}

/// Execute a DML query (INSERT, UPDATE, DELETE) in `SQLite`.
///
/// # Errors
///
/// Returns `SqlMiddlewareDbError::ExecutionError` if execution fails or rows affected cannot be converted.
pub async fn execute_dml(
    sqlite_client: &mut SqliteConnection,
    query: &str,
    params: &[RowValues],
    statement_cache_mode: StatementCacheMode,
) -> Result<usize, SqlMiddlewareDbError> {
    let params_owned = convert_params::<Params>(params, ConversionMode::Execute)?.0;
    sqlite_client
        .execute_dml(query, &params_owned, statement_cache_mode)
        .await
}