Struct SqlStore 

pub struct SqlStore { /* private fields */ }

Implementations

impl SqlStore

pub async fn new(connection_string: &str) -> Result<Self, StorageError>

Create a new SQL store with startup-mode retry (fails fast if config is wrong).

pub fn pool(&self) -> AnyPool

Get a clone of the connection pool for sharing with other stores.

impl SqlStore

pub async fn scan_batch( &self, limit: usize, ) -> Result<Vec<SyncItem>, StorageError>

Scan a batch of items (for WAL drain).

pub async fn delete_batch(&self, ids: &[String]) -> Result<usize, StorageError>

Delete multiple items by ID in a single query.

pub async fn get_dirty_merkle_ids( &self, limit: usize, ) -> Result<Vec<String>, StorageError>

Get IDs of items with merkle_dirty = 1 (need merkle recalculation).

Used by background merkle processor to batch recalculate affected trees.

pub async fn count_dirty_merkle(&self) -> Result<u64, StorageError>

Count items with merkle_dirty = 1.

pub async fn mark_merkle_clean( &self, ids: &[String], ) -> Result<usize, StorageError>

Mark items as merkle-clean after recalculation.

pub async fn has_dirty_merkle(&self) -> Result<bool, StorageError>

Check if there are any dirty merkle items.

pub async fn get_dirty_merkle_items( &self, limit: usize, ) -> Result<Vec<SyncItem>, StorageError>

Get full SyncItems with merkle_dirty = 1 (need merkle recalculation).

Returns the items themselves so merkle can be calculated. Use mark_merkle_clean() after processing to clear the flag.

Trait Implementations

impl ArchiveStore for SqlStore

fn put_batch<'life0, 'life1, 'async_trait>( &'life0 self, items: &'life1 mut [SyncItem], ) -> Pin<Box<dyn Future<Output = Result<BatchWriteResult, StorageError>> + Send + 'async_trait>>

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

Write a batch of items in a single multi-row INSERT with verification.

fn get<'life0, 'life1, 'async_trait>( &'life0 self, id: &'life1 str, ) -> Pin<Box<dyn Future<Output = Result<Option<SyncItem>, StorageError>> + Send + 'async_trait>>

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

fn put<'life0, 'life1, 'async_trait>( &'life0 self, item: &'life1 SyncItem, ) -> Pin<Box<dyn Future<Output = Result<(), StorageError>> + Send + 'async_trait>>

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

fn delete<'life0, 'life1, 'async_trait>( &'life0 self, id: &'life1 str, ) -> Pin<Box<dyn Future<Output = Result<(), StorageError>> + Send + 'async_trait>>

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

fn exists<'life0, 'life1, 'async_trait>( &'life0 self, id: &'life1 str, ) -> Pin<Box<dyn Future<Output = Result<bool, StorageError>> + Send + 'async_trait>>

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

Check if an item exists (SQL EXISTS query - fast, no data transfer).

fn scan_keys<'life0, 'async_trait>( &'life0 self, offset: u64, limit: usize, ) -> Pin<Box<dyn Future<Output = Result<Vec<String>, StorageError>> + Send + 'async_trait>>

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

Scan keys for cuckoo filter warmup (paginated). Returns empty vec when offset exceeds total count.

fn count_all<'life0, 'async_trait>( &'life0 self, ) -> Pin<Box<dyn Future<Output = Result<u64, StorageError>> + Send + 'async_trait>>

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

Count total items in store.