queries

Documentation

Index

• type AddItemToCartParams
• type Cart
• type CartItem
• type DBTX
• type DeleteItemFromCartParams
• type GetCartItemsByCartIdRow
• type Product
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) AddItemToCart(ctx context.Context, arg AddItemToCartParams) error
  • func (q *Queries) CreateCart(ctx context.Context) (int64, error)
  • func (q *Queries) DeleteItemFromCart(ctx context.Context, arg DeleteItemFromCartParams) error
  • func (q *Queries) GetCartById(ctx context.Context, id int64) (Cart, error)
  • func (q *Queries) GetCartItemsByCartId(ctx context.Context, cartID int64) ([]GetCartItemsByCartIdRow, error)
  • func (q *Queries) ListProductVariants(ctx context.Context) ([]Product, error)
  • func (q *Queries) ListProducts(ctx context.Context) ([]Product, error)
  • func (q *Queries) UpdateItemInCart(ctx context.Context, arg UpdateItemInCartParams) error
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type UpdateItemInCartParams

Types

type AddItemToCartParams

type AddItemToCartParams struct {
	CartID    int64
	ProductID *int64
}

type Cart

type Cart struct {
	ID         int64
	InsertedAt pgtype.Timestamp
	UpdatedAt  pgtype.Timestamp
}

type CartItem

type CartItem struct {
	ID         int64
	CartID     int64
	ProductID  *int64
	Quantity   decimal.Decimal
	InsertedAt pgtype.Timestamp
	UpdatedAt  pgtype.Timestamp
}

type DBTX

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type DeleteItemFromCartParams

type DeleteItemFromCartParams struct {
	CartID int64
	ID     int64
}

type GetCartItemsByCartIdRow

type GetCartItemsByCartIdRow struct {
	ID         int64
	CartID     int64
	ProductID  *int64
	Quantity   decimal.Decimal
	InsertedAt pgtype.Timestamp
	UpdatedAt  pgtype.Timestamp
	BasePrice  decimal.Decimal
	TitlePl    string
	Subtotal   decimal.Decimal
}

type Product

type Product struct {
	ID            int64
	ParentID      *int64
	TitlePl       string
	TitleEn       *string
	Sku           *string
	Slug          string
	DescriptionPl *string
	DescriptionEn *string
	BasePrice     decimal.Decimal
	MainPicture   *string
	InsertedAt    pgtype.Timestamp
	UpdatedAt     pgtype.Timestamp
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) AddItemToCart

func (q *Queries) AddItemToCart(ctx context.Context, arg AddItemToCartParams) error

func (*Queries) CreateCart

func (q *Queries) CreateCart(ctx context.Context) (int64, error)

func (*Queries) DeleteItemFromCart

func (q *Queries) DeleteItemFromCart(ctx context.Context, arg DeleteItemFromCartParams) error

func (*Queries) GetCartById

func (q *Queries) GetCartById(ctx context.Context, id int64) (Cart, error)

func (*Queries) GetCartItemsByCartId

func (q *Queries) GetCartItemsByCartId(ctx context.Context, cartID int64) ([]GetCartItemsByCartIdRow, error)

func (*Queries) ListProductVariants

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

func (*Queries) ListProducts

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

func (*Queries) UpdateItemInCart

func (q *Queries) UpdateItemInCart(ctx context.Context, arg UpdateItemInCartParams) error

func (*Queries) WithTx

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

type UpdateItemInCartParams

type UpdateItemInCartParams struct {
	Quantity decimal.Decimal
	CartID   int64
	ID       int64
}