Struct SqliteSerialRepository 

pub struct SqliteSerialRepository { /* private fields */ }

Available on crate feature sqlite only.

SQLite implementation of SerialRepository

Implementations

impl SqliteSerialRepository

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

Trait Implementations

impl Debug for SqliteSerialRepository

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

Formats the value using the given formatter.

impl SerialRepository for SqliteSerialRepository

fn create(&self, input: CreateSerialNumber) -> Result<SerialNumber>

Create a serial number

fn create_bulk( &self, input: CreateSerialNumbersBulk, ) -> Result<Vec<SerialNumber>>

Create multiple serial numbers in bulk

fn get(&self, id: Uuid) -> Result<Option<SerialNumber>>

Get serial by ID

fn get_by_serial(&self, serial: &str) -> Result<Option<SerialNumber>>

Get serial by serial number string

fn update(&self, id: Uuid, input: UpdateSerialNumber) -> Result<SerialNumber>

Update a serial number

fn list(&self, filter: SerialFilter) -> Result<Vec<SerialNumber>>

List serials with filter

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

Delete a serial (only if never used)

fn change_status(&self, input: ChangeSerialStatus) -> Result<SerialNumber>

Change serial status with history tracking

fn reserve(&self, input: ReserveSerialNumber) -> Result<SerialReservation>

Reserve a serial

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

Release reservation

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

Confirm reservation

fn move_serial(&self, input: MoveSerial) -> Result<SerialNumber>

Move serial to new location

fn transfer_ownership( &self, input: TransferSerialOwnership, ) -> Result<SerialNumber>

Transfer ownership

fn mark_sold( &self, id: Uuid, customer_id: Uuid, order_id: Option<Uuid>, ) -> Result<SerialNumber>

Mark as sold

fn mark_shipped(&self, id: Uuid, shipment_id: Uuid) -> Result<SerialNumber>

Mark as shipped

fn mark_returned(&self, id: Uuid, return_id: Uuid) -> Result<SerialNumber>

Mark as returned

fn activate(&self, id: Uuid) -> Result<SerialNumber>

Activate serial (e.g., for warranty)

fn quarantine(&self, id: Uuid, reason: &str) -> Result<SerialNumber>

Quarantine serial

fn release_quarantine(&self, id: Uuid) -> Result<SerialNumber>

Release from quarantine

fn scrap(&self, id: Uuid, reason: &str) -> Result<SerialNumber>

Scrap serial

fn get_history( &self, serial_id: Uuid, filter: SerialHistoryFilter, ) -> Result<Vec<SerialHistory>>

Get serial history

fn lookup(&self, serial: &str) -> Result<Option<SerialLookupResult>>

Get full serial lookup with related data

fn validate(&self, serial: &str) -> Result<SerialValidation>

Validate serial number

fn get_available_for_sku( &self, sku: &str, limit: u32, ) -> Result<Vec<SerialNumber>>

Get available serials for SKU

fn get_for_lot(&self, lot_id: Uuid) -> Result<Vec<SerialNumber>>

Get serials for lot

fn get_for_customer(&self, customer_id: Uuid) -> Result<Vec<SerialNumber>>

Get serials for customer

fn count(&self, filter: SerialFilter) -> Result<u64>

Count serials

fn create_batch( &self, inputs: Vec<CreateSerialNumber>, ) -> Result<BatchResult<SerialNumber>>

Create multiple serials

fn get_batch(&self, ids: Vec<Uuid>) -> Result<Vec<SerialNumber>>

Get multiple serials by ID

fn get_batch_by_serial(&self, serials: Vec<String>) -> Result<Vec<SerialNumber>>

Get multiple serials by serial string