UnshieldedUtxoDao
DAO for unshielded UTXO operations.
Provides methods to:
Insert UTXOs (created by transactions)
Update UTXO state (AVAILABLE → PENDING → SPENT)
Query available UTXOs (for balance calculation)
Handle transaction failures (PENDING → AVAILABLE)
Functions
Count ALL UTXOs for an address (any state).
Count available UTXOs for an address (for debugging).
Delete all UTXOs for an address.
Get ALL UTXOs for an address (any state).
Get all available UTXOs for an address.
Get available UTXOs for a specific token type.
Get available UTXOs for a specific token, sorted by value (smallest first).
Get UTXO by ID (transactionHash:outputIndex).
Get UTXO by intentHash and outputIndex.
Insert UTXOs into database.
Mark UTXO as available (unlock).
Mark multiple UTXOs as available.
Mark UTXO as pending (locked for transaction).
Mark multiple UTXOs as pending.
Mark UTXO as spent (from sync - not local transaction).
Mark multiple UTXOs as spent (from sync - not local transaction).
Mark UTXO as spent by LOCAL transaction.
Mark multiple UTXOs as spent by LOCAL transaction.
Get all pending UTXOs for an address (locked in pending transactions).
Get all available UTXOs for an address, grouped by token type.
Reset ALL SPENT UTXOs to AVAILABLE for healing during full resync.