Struct SqliteOutboxStore 

pub struct SqliteOutboxStore { /* private fields */ }

SQLite implementation of OutboxStore backed by sqlx::SqlitePool.

See the module documentation for the single-worker concurrency model. Cheap to clone (the pool and the cached SQL strings are reference-counted).

Implementations

impl SqliteOutboxStore

pub fn new( pool: SqlitePool, table_name: impl Into<String>, ) -> Result<Self, OutboxError>

Build a store for the given pool and table.

Errors

Returns OutboxError::Internal if table_name is not a valid identifier matching ^[a-zA-Z_][a-zA-Z0-9_]*$.

pub fn pool(&self) -> &SqlitePool

Underlying pool.

pub fn table_name(&self) -> &str

Configured table name.

pub fn with_dead_letter( self, dlq_table: impl Into<String>, ) -> Result<Self, OutboxError>

Activate dead-letter persistence for poison messages.

Errors

Returns OutboxError::Internal if dlq_table is not a valid identifier.

Trait Implementations

impl Clone for SqliteOutboxStore

fn clone(&self) -> SqliteOutboxStore

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SqliteOutboxStore

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

Formats the value using the given formatter.

impl OutboxStore for SqliteOutboxStore

fn claim<'a, 'life0, 'life1, 'life2, 'async_trait>( &'life0 self, tx: &'life1 mut Self::Tx<'a>, event_ids: &'life2 [Uuid], lease_for: Duration, ) -> Pin<Box<dyn Future<Output = Result<(), OutboxError>> + Send + 'async_trait>>

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

Set the soft lease and consume one retry slot on the claimed batch.

SQLite has no FOR UPDATE SKIP LOCKED, so this does not provide a competing-consumer claim: the store remains single-writer (see the module documentation). The override exists so that attempts is incremented at claim time on SQLite too. Without it, a worker that crashed between claim and acknowledgement would never advance attempts and would redeliver a poison row forever (#213).

type Client = PoolConnection<Sqlite>

Pooled connection guard owned by the worker for one polling cycle.

type Tx<'tx> = Transaction<'tx, Sqlite>

Transaction borrowed from a Self::Client.

fn acquire<'life0, 'async_trait>( &'life0 self, ) -> Pin<Box<dyn Future<Output = Result<Self::Client, OutboxError>> + Send + 'async_trait>>

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

Acquire a connection from the underlying pool.

fn begin<'a, 'life0, 'async_trait>( &'life0 self, client: &'a mut Self::Client, ) -> Pin<Box<dyn Future<Output = Result<Self::Tx<'a>, OutboxError>> + Send + 'async_trait>>

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

Open a transaction borrowing from the given connection.

fn poll<'a, 'life0, 'life1, 'async_trait>( &'life0 self, tx: &'life1 mut Self::Tx<'a>, batch_size: usize, max_attempts: u32, ) -> Pin<Box<dyn Future<Output = Result<Vec<OutboxEnvelope>, OutboxError>> + Send + 'async_trait>>

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

Poll a batch of pending envelopes, locking them via FOR UPDATE SKIP LOCKED.

fn mark_delivered<'a, 'life0, 'life1, 'async_trait>( &'life0 self, tx: &'life1 mut Self::Tx<'a>, event_id: Uuid, ) -> Pin<Box<dyn Future<Output = Result<(), OutboxError>> + Send + 'async_trait>>

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

Mark an envelope as successfully delivered.

fn mark_failed<'a, 'life0, 'life1, 'life2, 'async_trait>( &'life0 self, tx: &'life1 mut Self::Tx<'a>, event_id: Uuid, error: &'life2 str, retry_in: Duration, ) -> Pin<Box<dyn Future<Output = Result<(), OutboxError>> + Send + 'async_trait>>

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

Mark an envelope as failed, recording the error and the backoff delay before the next retry.

fn commit<'a, 'life0, 'async_trait>( &'life0 self, tx: Self::Tx<'a>, ) -> Pin<Box<dyn Future<Output = Result<(), OutboxError>> + Send + 'async_trait>>

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

Commit the transaction.

fn mark_dead_lettered<'a, 'life0, 'life1, 'life2, 'async_trait>( &'life0 self, tx: &'life1 mut Self::Tx<'a>, event_id: Uuid, _error: &'life2 str, ) -> Pin<Box<dyn Future<Output = Result<(), OutboxError>> + Send + 'async_trait>>

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

Move an envelope that has exhausted its retry budget to the dead-letter store.