Struct DbWriteConnection 

pub struct DbWriteConnection(/* private fields */);

Write pool. Single connection; serialises in-process writes so the SQLite writer lock is never contested from within one process.

Cross-process contention with other writers (e.g. the in-VM runtime) still exists and is absorbed by the busy_timeout PRAGMA + the retry-on-busy transaction helpers (added in a follow-up step).

Clone is cheap: the inner DatabaseConnection holds an Arc over the underlying sqlx pool, so clones share the same single connection.

Implementations

impl DbWriteConnection

pub fn new(inner: DatabaseConnection) -> Self

Wrap a sea-orm connection as a write pool.

pub async fn open( db_path: &Path, connect_timeout: Duration, busy_timeout: Duration, ) -> Result<Self, Error>

Open a stand-alone single-connection write pool at db_path.

Used by callers that don’t need a paired read pool (e.g. the in-VM runtime, which only writes run records).

pub fn inner(&self) -> &DatabaseConnection

Borrow the underlying sea-orm connection.

pub async fn transaction<F, Fut, T, E>(&self, f: F) -> Result<T, E>

where F: Fn(DatabaseTransaction) -> Fut, Fut: Future<Output = Result<(DatabaseTransaction, T), E>> + Send, T: Send, E: From<DbErr> + IsSqliteBusy,

Run a multi-statement atomic write inside a transaction with automatic retry on SQLITE_BUSY / SQLITE_BUSY_SNAPSHOT. Use this when you need several writes to commit (or roll back) as a unit. Single-statement writes don’t need this — auto-commit .exec(db) already retries via the ConnectionTrait impl below.

f is invoked once per attempt with a freshly opened transaction. Return Ok((txn, value)) to commit, or any Err to roll back (the helper drops the transaction on failure, which sea-orm rolls back). The closure must be callable multiple times: clone owned data inside the body so retries see fresh values.

Generic over the closure’s error type E so callers can return app-level errors directly (e.g. MicrosandboxError) provided E: From<DbErr> + IsSqliteBusy.

Trait Implementations

impl Clone for DbWriteConnection

fn clone(&self) -> DbWriteConnection

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl ConnectionTrait for DbWriteConnection

fn get_database_backend(&self) -> DbBackend

Fetch the database backend as specified in DbBackend. This depends on feature flags enabled.

fn execute<'life0, 'async_trait>( &'life0 self, stmt: Statement, ) -> Pin<Box<dyn Future<Output = Result<ExecResult, DbErr>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Execute a Statement

fn execute_unprepared<'life0, 'life1, 'async_trait>( &'life0 self, sql: &'life1 str, ) -> Pin<Box<dyn Future<Output = Result<ExecResult, DbErr>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

Execute a unprepared Statement

fn query_one<'life0, 'async_trait>( &'life0 self, stmt: Statement, ) -> Pin<Box<dyn Future<Output = Result<Option<QueryResult>, DbErr>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Execute a Statement and return a query

fn query_all<'life0, 'async_trait>( &'life0 self, stmt: Statement, ) -> Pin<Box<dyn Future<Output = Result<Vec<QueryResult>, DbErr>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Execute a Statement and return a collection Vec<QueryResult> on success

fn support_returning(&self) -> bool

Check if the connection supports RETURNING syntax on insert and update

fn is_mock_connection(&self) -> bool

Check if the connection is a test connection for the Mock database

impl Debug for DbWriteConnection

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.