products

Documentation

Index

• type CreateProductParams
• type DBTX
• type Product
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateProduct(ctx context.Context, arg CreateProductParams) (Product, error)
  • func (q *Queries) DeleteProduct(ctx context.Context, id int32) error
  • func (q *Queries) GetProduct(ctx context.Context, id int32) (Product, error)
  • func (q *Queries) ListProducts(ctx context.Context) ([]Product, error)
  • func (q *Queries) TotalPrice(ctx context.Context) (float64, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries

Types

type CreateProductParams

type CreateProductParams struct {
	Name      string
	Price     string
	Available sql.NullBool
}

type DBTX

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type Product

type Product struct {
	ID        int32
	Name      string
	Price     string
	Available sql.NullBool
	Created   sql.NullTime
}

type Queries

type Queries struct {
	// contains filtered or unexported fields
}

func New

func New(db DBTX) *Queries

func (*Queries) CreateProduct

func (q *Queries) CreateProduct(ctx context.Context, arg CreateProductParams) (Product, error)

func (*Queries) DeleteProduct

func (q *Queries) DeleteProduct(ctx context.Context, id int32) error

func (*Queries) GetProduct

func (q *Queries) GetProduct(ctx context.Context, id int32) (Product, error)

func (*Queries) ListProducts

func (q *Queries) ListProducts(ctx context.Context) ([]Product, error)

func (*Queries) TotalPrice

func (q *Queries) TotalPrice(ctx context.Context) (float64, error)

func (*Queries) WithTx

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