internal

type CreateSaleParams struct {
	Region        string         `json:"region"`
	Country       string         `json:"country"`
	ItemType      string         `json:"item_type"`
	SalesChannel  ESalesChannel  `json:"sales_channel"`
	OrderPriority EOrderPriority `json:"order_priority"`
	OrderDate     time.Time      `json:"order_date"`
	OrderID       int64          `json:"order_id"`
	ShipDate      time.Time      `json:"ship_date"`
	UnitsSold     int32          `json:"units_sold"`
	UnitPrice     float32        `json:"unit_price"`
	UnitCost      float32        `json:"unit_cost"`
	TotalRevenue  pgtype.Numeric `json:"total_revenue"`
	TotalCost     pgtype.Numeric `json:"total_cost"`
	TotalProfit   pgtype.Numeric `json:"total_profit"`
}

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 EOrderPriority string

type ESalesChannel string

type ListSalesParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
}

type NullEOrderPriority struct {
	EOrderPriority EOrderPriority `json:"e_order_priority"`
	Valid          bool           `json:"valid"` // Valid is true if EOrderPriority is not NULL
}

type NullESalesChannel struct {
	ESalesChannel ESalesChannel `json:"e_sales_channel"`
	Valid         bool          `json:"valid"` // Valid is true if ESalesChannel is not NULL
}

type Querier interface {
	CreateSale(ctx context.Context, arg CreateSaleParams) (Sale, error)
	GetSale(ctx context.Context, id int64) (Sale, error)
	GetSaleForUpdate(ctx context.Context, id int64) (Sale, error)
	ListSales(ctx context.Context, arg ListSalesParams) ([]Sale, error)
}

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

type Sale struct {
	ID            int64          `json:"id"`
	Region        string         `json:"region"`
	Country       string         `json:"country"`
	ItemType      string         `json:"item_type"`
	SalesChannel  ESalesChannel  `json:"sales_channel"`
	OrderPriority EOrderPriority `json:"order_priority"`
	OrderDate     time.Time      `json:"order_date"`
	OrderID       int64          `json:"order_id"`
	ShipDate      time.Time      `json:"ship_date"`
	UnitsSold     int32          `json:"units_sold"`
	UnitPrice     float32        `json:"unit_price"`
	UnitCost      float32        `json:"unit_cost"`
	TotalRevenue  pgtype.Numeric `json:"total_revenue"`
	TotalCost     pgtype.Numeric `json:"total_cost"`
	TotalProfit   pgtype.Numeric `json:"total_profit"`
	CreatedAt     time.Time      `json:"created_at"`
}

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

type TxStore interface {
	Querier
}