Struct SqliteWarehouseRepository 

pub struct SqliteWarehouseRepository { /* private fields */ }

Available on crate feature sqlite only.

SQLite warehouse repository

Implementations

impl SqliteWarehouseRepository

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

Trait Implementations

impl Debug for SqliteWarehouseRepository

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

Formats the value using the given formatter.

impl WarehouseRepository for SqliteWarehouseRepository

fn create_warehouse(&self, input: CreateWarehouse) -> Result<Warehouse>

Create a new warehouse

fn get_warehouse(&self, id: i32) -> Result<Option<Warehouse>>

Get warehouse by ID

fn get_warehouse_by_code(&self, code: &str) -> Result<Option<Warehouse>>

Get warehouse by code

fn update_warehouse(&self, id: i32, input: UpdateWarehouse) -> Result<Warehouse>

Update a warehouse

fn list_warehouses(&self, filter: WarehouseFilter) -> Result<Vec<Warehouse>>

List warehouses with filter

fn delete_warehouse(&self, id: i32) -> Result<()>

Delete a warehouse (only if empty)

fn count_warehouses(&self, filter: WarehouseFilter) -> Result<u64>

Count warehouses

fn create_zone(&self, input: CreateZone) -> Result<Zone>

Create a zone

fn get_zone(&self, id: i32) -> Result<Option<Zone>>

Get zone by ID

fn get_zones(&self, warehouse_id: i32) -> Result<Vec<Zone>>

Get zones for warehouse

fn update_zone(&self, id: i32, input: UpdateZone) -> Result<Zone>

Update a zone

fn delete_zone(&self, id: i32) -> Result<()>

Delete a zone

fn create_location(&self, input: CreateLocation) -> Result<Location>

Create a location

fn get_location(&self, id: i32) -> Result<Option<Location>>

Get location by ID

fn get_location_by_code( &self, warehouse_id: i32, code: &str, ) -> Result<Option<Location>>

Get location by code

fn update_location(&self, id: i32, input: UpdateLocation) -> Result<Location>

Update a location

fn list_locations(&self, filter: LocationFilter) -> Result<Vec<Location>>

List locations with filter

fn delete_location(&self, id: i32) -> Result<()>

Delete a location (only if empty)

fn count_locations(&self, filter: LocationFilter) -> Result<u64>

Count locations

fn get_locations_for_warehouse( &self, warehouse_id: i32, ) -> Result<Vec<Location>>

Get locations for warehouse

fn get_pickable_locations( &self, warehouse_id: i32, sku: &str, ) -> Result<Vec<Location>>

Get pickable locations for SKU

fn get_receivable_locations(&self, warehouse_id: i32) -> Result<Vec<Location>>

Get receivable locations

fn get_location_inventory( &self, location_id: i32, ) -> Result<Vec<LocationInventory>>

Get inventory at location

fn get_inventory_for_sku( &self, warehouse_id: i32, sku: &str, ) -> Result<Vec<LocationInventory>>

Get inventory for SKU across locations

fn adjust_inventory( &self, input: AdjustLocationInventory, ) -> Result<LocationInventory>

Adjust inventory at location

fn move_inventory(&self, input: MoveInventory) -> Result<LocationMovement>

Move inventory between locations

fn list_location_inventory( &self, filter: LocationInventoryFilter, ) -> Result<Vec<LocationInventory>>

Get location inventory by filter

fn get_movements(&self, filter: MovementFilter) -> Result<Vec<LocationMovement>>

Get inventory movements

fn count_movements(&self, filter: MovementFilter) -> Result<u64>

Count movements

fn create_locations_batch( &self, inputs: Vec<CreateLocation>, ) -> Result<BatchResult<Location>>

Create multiple locations

fn get_locations_batch(&self, ids: Vec<i32>) -> Result<Vec<Location>>

Get multiple locations by ID

fn create_cycle_count(&self, input: CreateCycleCount) -> Result<CycleCount>

Create a cycle count (draft) with its expected lines

fn get_cycle_count(&self, id: Uuid) -> Result<Option<CycleCount>>

Get a cycle count (with lines) by ID

fn list_cycle_counts(&self, filter: CycleCountFilter) -> Result<Vec<CycleCount>>

List cycle counts (with lines) matching the filter

fn start_cycle_count(&self, id: Uuid) -> Result<CycleCount>

Start a draft cycle count (draft → in_progress)

fn record_cycle_counts( &self, id: Uuid, counts: Vec<RecordCycleCountLine>, ) -> Result<CycleCount>

Record physical counts against an in-progress cycle count

fn complete_cycle_count(&self, id: Uuid) -> Result<CycleCount>

Complete an in-progress cycle count: computes variances and applies inventory adjustments (recorded as cycle_count movements)

fn cancel_cycle_count(&self, id: Uuid) -> Result<CycleCount>

Cancel a draft or in-progress cycle count