Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

queries

package

Go to main page

Versions in this module

v0

v0.9.1

Apr 3, 2026

Changes in this version

+ type Asset struct

+ AssetID string

+ ControlAssetID sql.NullString

+ Metadata sql.NullString

+ type AssetVtxo struct

+ Amount int64

+ AssetID string

+ VtxoTxid string

+ VtxoVout int64

+ type AssetVtxoVw struct

+ Amount int64

+ ArkTxid sql.NullString

+ AssetAmount sql.NullInt64

+ AssetID sql.NullString

+ CommitmentTxids string

+ CreatedAt int64

+ ExpiresAt int64

+ Preconfirmed bool

+ Script string

+ SettledBy sql.NullString

+ Spent bool

+ SpentBy sql.NullString

+ Swept bool

+ Txid string

+ Unrolled bool

+ Vout int64

+ type DBTX interface

+ ExecContext func(context.Context, string, ...interface{}) (sql.Result, error)

+ PrepareContext func(context.Context, string) (*sql.Stmt, error)

+ QueryContext func(context.Context, string, ...interface{}) (*sql.Rows, error)

+ QueryRowContext func(context.Context, string, ...interface{}) *sql.Row

+ type DeleteUtxoParams struct

+ Txid string

+ Vout int64

+ type InsertAssetVtxoParams struct

+ Amount int64

+ AssetID string

+ VtxoTxid string

+ VtxoVout int64

+ type InsertTxParams struct

+ Amount int64

+ AssetPacket sql.NullString

+ CreatedAt int64

+ Hex sql.NullString

+ Settled bool

+ SettledBy sql.NullString

+ Txid string

+ TxidType string

+ Type string

+ type InsertUtxoParams struct

+ Amount int64

+ CreatedAt sql.NullInt64

+ DelayType sql.NullString

+ DelayValue sql.NullInt64

+ Script string

+ SpendableAt sql.NullInt64

+ Spent bool

+ SpentBy sql.NullString

+ Tapscripts sql.NullString

+ Tx sql.NullString

+ Txid string

+ Vout int64

+ type InsertVtxoParams struct

+ Amount int64

+ ArkTxid sql.NullString

+ CommitmentTxids string

+ CreatedAt int64

+ ExpiresAt int64

+ Preconfirmed bool

+ Script string

+ SettledBy sql.NullString

+ Spent bool

+ SpentBy sql.NullString

+ Swept bool

+ Txid string

+ Unrolled bool

+ Vout int64

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) CleanAssetVtxos(ctx context.Context) error

+ func (q *Queries) CleanAssets(ctx context.Context) error

+ func (q *Queries) CleanTxs(ctx context.Context) error

+ func (q *Queries) CleanUtxos(ctx context.Context) error

+ func (q *Queries) CleanVtxos(ctx context.Context) error

+ func (q *Queries) DeleteUtxo(ctx context.Context, arg DeleteUtxoParams) error

+ func (q *Queries) InsertAssetVtxo(ctx context.Context, arg InsertAssetVtxoParams) error

+ func (q *Queries) InsertTx(ctx context.Context, arg InsertTxParams) error

+ func (q *Queries) InsertUtxo(ctx context.Context, arg InsertUtxoParams) error

+ func (q *Queries) InsertVtxo(ctx context.Context, arg InsertVtxoParams) error

+ func (q *Queries) ReplaceTx(ctx context.Context, arg ReplaceTxParams) error

+ func (q *Queries) SelectAllTxs(ctx context.Context) ([]Tx, error)

+ func (q *Queries) SelectAllUtxos(ctx context.Context) ([]Utxo, error)

+ func (q *Queries) SelectAllVtxos(ctx context.Context) ([]AssetVtxoVw, error)

+ func (q *Queries) SelectAsset(ctx context.Context, assetID string) (Asset, error)

+ func (q *Queries) SelectSpendableVtxos(ctx context.Context) ([]AssetVtxoVw, error)

+ func (q *Queries) SelectTxs(ctx context.Context, txids []string) ([]Tx, error)

+ func (q *Queries) SelectUtxo(ctx context.Context, arg SelectUtxoParams) (Utxo, error)

+ func (q *Queries) SelectVtxo(ctx context.Context, arg SelectVtxoParams) ([]AssetVtxoVw, error)

+ func (q *Queries) SettleVtxo(ctx context.Context, arg SettleVtxoParams) error

+ func (q *Queries) SpendVtxo(ctx context.Context, arg SpendVtxoParams) error

+ func (q *Queries) SweepVtxo(ctx context.Context, arg SweepVtxoParams) error

+ func (q *Queries) UnrollVtxo(ctx context.Context, arg UnrollVtxoParams) error

+ func (q *Queries) UpdateTx(ctx context.Context, arg UpdateTxParams) error

+ func (q *Queries) UpdateUtxo(ctx context.Context, arg UpdateUtxoParams) error

+ func (q *Queries) UpsertAsset(ctx context.Context, arg UpsertAssetParams) error

+ func (q *Queries) WithTx(tx *sql.Tx) *Queries

+ type ReplaceTxParams struct

+ Amount int64

+ CreatedAt int64

+ Hex sql.NullString

+ NewTxid string

+ OldTxid string

+ SettledBy sql.NullString

+ TxidType string

+ Type string

+ type SelectUtxoParams struct

+ Txid string

+ Vout int64

+ type SelectVtxoParams struct

+ Txid string

+ Vout int64

+ type SettleVtxoParams struct

+ SettledBy sql.NullString

+ SpentBy sql.NullString

+ Txid string

+ Vout int64

+ type SpendVtxoParams struct

+ ArkTxid sql.NullString

+ SpentBy sql.NullString

+ Txid string

+ Vout int64

+ type SweepVtxoParams struct

+ Txid string

+ Vout int64

+ type Tx struct

+ Amount int64

+ AssetPacket sql.NullString

+ CreatedAt int64

+ Hex sql.NullString

+ Settled bool

+ SettledBy sql.NullString

+ Txid string

+ TxidType string

+ Type string

+ type UnrollVtxoParams struct

+ Txid string

+ Vout int64

+ type UpdateTxParams struct

+ CreatedAt sql.NullInt64

+ SettledBy interface{}

+ Txid string

+ type UpdateUtxoParams struct

+ CreatedAt sql.NullInt64

+ SpendableAt sql.NullInt64

+ Spent interface{}

+ SpentBy sql.NullString

+ Txid string

+ Vout int64

+ type UpsertAssetParams struct

+ AssetID string

+ ControlAssetID sql.NullString

+ Metadata sql.NullString

+ type Utxo struct

+ Amount int64

+ CreatedAt sql.NullInt64

+ DelayType sql.NullString

+ DelayValue sql.NullInt64

+ Script string

+ SpendableAt sql.NullInt64

+ Spent bool

+ SpentBy sql.NullString

+ Tapscripts sql.NullString

+ Tx sql.NullString

+ Txid string

+ Vout int64

+ type Vtxo struct

+ Amount int64

+ ArkTxid sql.NullString

+ CommitmentTxids string

+ CreatedAt int64

+ ExpiresAt int64

+ Preconfirmed bool

+ Script string

+ SettledBy sql.NullString

+ Spent bool

+ SpentBy sql.NullString

+ Swept bool

+ Txid string

+ Unrolled bool

+ Vout int64

v0.9.0

Apr 3, 2026

v0.8.1

Oct 23, 2025

v0.8.0

Oct 20, 2025

v0.7.1

Sep 9, 2025

v0.7.0

Jul 8, 2025