Struct SqliteTypedConnection 

pub struct SqliteTypedConnection<State> { /* private fields */ }

Typestate wrapper around a pooled SQLite connection.

When in InTx state, dropping without calling commit or rollback will trigger a best-effort synchronous rollback in Drop to keep the pool clean. Prefer finishing transactions explicitly to avoid surprise blocking work during drop.

Implementations

impl SqliteTypedConnection<Idle>

pub async fn from_pool( pool: &Pool<SqliteManager>, ) -> Result<Self, SqlMiddlewareDbError>

Checkout a connection from the pool.

Errors

Returns SqlMiddlewareDbError if acquiring a pooled connection fails.

impl SqliteTypedConnection<Idle>

pub async fn execute_batch( &mut self, sql: &str, ) -> Result<(), SqlMiddlewareDbError>

Auto-commit batch (BEGIN/COMMIT around it).

Errors

Returns SqlMiddlewareDbError if executing the batch fails.

pub async fn dml( &mut self, query: &str, params: &[RowValues], ) -> Result<usize, SqlMiddlewareDbError>

Auto-commit DML.

Errors

Returns SqlMiddlewareDbError if executing the DML fails.

impl SqliteTypedConnection<InTx>

pub async fn execute_batch( &mut self, sql: &str, ) -> Result<(), SqlMiddlewareDbError>

Execute batch inside the open transaction.

Errors

Returns SqlMiddlewareDbError if executing the batch fails.

pub async fn dml( &mut self, query: &str, params: &[RowValues], ) -> Result<usize, SqlMiddlewareDbError>

Execute DML inside the open transaction.

Errors

Returns SqlMiddlewareDbError if executing the DML fails.

impl SqliteTypedConnection<Idle>

pub async fn select( &mut self, query: &str, params: &[RowValues], ) -> Result<ResultSet, SqlMiddlewareDbError>

Auto-commit SELECT.

Errors

Returns SqlMiddlewareDbError if executing the select fails.

pub fn query<'a>(&'a mut self, sql: &'a str) -> QueryBuilder<'a, 'a>

Start a query builder (auto-commit per operation).

impl SqliteTypedConnection<InTx>

pub async fn select( &mut self, query: &str, params: &[RowValues], ) -> Result<ResultSet, SqlMiddlewareDbError>

Execute SELECT inside the open transaction.

Errors

Returns SqlMiddlewareDbError if executing the select fails.

pub fn query<'a>(&'a mut self, sql: &'a str) -> QueryBuilder<'a, 'a>

Start a query builder within the open transaction.

impl SqliteTypedConnection<Idle>

pub async fn begin( self, ) -> Result<SqliteTypedConnection<InTx>, SqlMiddlewareDbError>

Begin an explicit transaction.

Errors

Returns SqlMiddlewareDbError if transitioning into a transaction fails.

impl SqliteTypedConnection<InTx>

pub async fn commit( self, ) -> Result<SqliteTypedConnection<Idle>, SqlMiddlewareDbError>

Commit and return to idle.

Errors

Returns SqlMiddlewareDbError if committing the transaction fails.

pub async fn rollback( self, ) -> Result<SqliteTypedConnection<Idle>, SqlMiddlewareDbError>

Rollback and return to idle.

Errors

Returns SqlMiddlewareDbError if rolling back the transaction fails.

Trait Implementations

impl BeginTx for SqliteTypedConnection<Idle>

type Tx = SqliteTypedConnection<InTx>

fn begin(self) -> impl Future<Output = Result<Self::Tx, SqlMiddlewareDbError>>

impl<State> Drop for SqliteTypedConnection<State>

fn drop(&mut self)

Executes the destructor for this type.

impl Queryable for SqliteTypedConnection<Idle>

fn query<'a>(&'a mut self, sql: &'a str) -> QueryBuilder<'a, 'a>

impl Queryable for SqliteTypedConnection<InTx>

fn query<'a>(&'a mut self, sql: &'a str) -> QueryBuilder<'a, 'a>

impl TxConn for SqliteTypedConnection<InTx>

type Idle = SqliteTypedConnection<Idle>

fn commit( self, ) -> impl Future<Output = Result<Self::Idle, SqlMiddlewareDbError>>

fn rollback( self, ) -> impl Future<Output = Result<Self::Idle, SqlMiddlewareDbError>>

impl TypedConnOps for SqliteTypedConnection<Idle>

fn execute_batch( &mut self, sql: &str, ) -> impl Future<Output = Result<(), SqlMiddlewareDbError>>

fn dml( &mut self, query: &str, params: &[RowValues], ) -> impl Future<Output = Result<usize, SqlMiddlewareDbError>>

fn select( &mut self, query: &str, params: &[RowValues], ) -> impl Future<Output = Result<ResultSet, SqlMiddlewareDbError>>

impl TypedConnOps for SqliteTypedConnection<InTx>

fn execute_batch( &mut self, sql: &str, ) -> impl Future<Output = Result<(), SqlMiddlewareDbError>>

fn dml( &mut self, query: &str, params: &[RowValues], ) -> impl Future<Output = Result<usize, SqlMiddlewareDbError>>

fn select( &mut self, query: &str, params: &[RowValues], ) -> impl Future<Output = Result<ResultSet, SqlMiddlewareDbError>>