Struct SqliteInventoryRepository 

pub struct SqliteInventoryRepository { /* private fields */ }

Available on crate feature sqlite only.

SQLite implementation of InventoryRepository

Implementations

impl SqliteInventoryRepository

pub const fn new(pool: Pool<SqliteConnectionManager>) -> Self

Trait Implementations

impl Debug for SqliteInventoryRepository

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

Formats the value using the given formatter.

impl InventoryRepository for SqliteInventoryRepository

fn create_item(&self, input: CreateInventoryItem) -> Result<InventoryItem>

Create a new inventory item

fn get_item(&self, id: i64) -> Result<Option<InventoryItem>>

Get inventory item by ID

fn get_item_by_sku(&self, sku: &str) -> Result<Option<InventoryItem>>

Get inventory item by SKU

fn get_stock(&self, sku: &str) -> Result<Option<StockLevel>>

Get stock level for SKU (aggregated across locations)

fn get_balance( &self, item_id: i64, location_id: i32, ) -> Result<Option<InventoryBalance>>

Get balance at specific location

fn adjust(&self, input: AdjustInventory) -> Result<InventoryTransaction>

Adjust inventory quantity

fn reserve(&self, input: ReserveInventory) -> Result<InventoryReservation>

Reserve inventory

fn get_reservation( &self, reservation_id: Uuid, ) -> Result<Option<InventoryReservation>>

Get a reservation by ID

fn release_reservation(&self, reservation_id: Uuid) -> Result<()>

Release reservation

fn confirm_reservation(&self, reservation_id: Uuid) -> Result<()>

Confirm reservation (convert to allocation)

fn list_reservations_by_reference( &self, reference_type: &str, reference_id: &str, ) -> Result<Vec<InventoryReservation>>

List reservations by reference (e.g., order id)

fn list(&self, filter: InventoryFilter) -> Result<Vec<InventoryItem>>

List inventory items with filter

fn get_reorder_needed(&self) -> Result<Vec<StockLevel>>

Get items below reorder point

fn record_transaction( &self, transaction: InventoryTransaction, ) -> Result<InventoryTransaction>

Record transaction

fn get_transactions( &self, item_id: i64, limit: u32, ) -> Result<Vec<InventoryTransaction>>

Get transaction history

fn create_item_batch( &self, inputs: Vec<CreateInventoryItem>, ) -> Result<BatchResult<InventoryItem>>

Create multiple inventory items - partial success allowed

fn create_item_batch_atomic( &self, inputs: Vec<CreateInventoryItem>, ) -> Result<Vec<InventoryItem>>

Create multiple inventory items - atomic (all-or-nothing)

fn adjust_batch( &self, adjustments: Vec<AdjustInventory>, ) -> Result<BatchResult<InventoryTransaction>>

Adjust multiple inventory quantities - partial success allowed

fn adjust_batch_atomic( &self, adjustments: Vec<AdjustInventory>, ) -> Result<Vec<InventoryTransaction>>

Adjust multiple inventory quantities - atomic (all-or-nothing)

fn get_item_batch(&self, ids: Vec<i64>) -> Result<Vec<InventoryItem>>

Get multiple inventory items by ID

fn get_stock_batch(&self, skus: Vec<String>) -> Result<Vec<StockLevel>>

Get stock levels for multiple SKUs