db

type CreateOrdersDetailParams struct {
	OrderID  int32          `json:"order_id"`
	Name     string         `json:"name"`
	Quantity int32          `json:"quantity"`
	Price    pgtype.Numeric `json:"price"`
}

type CreateOrdersParams struct {
	TrxID           string      `json:"trx_id"`
	PaymentTrxID    string      `json:"payment_trx_id"`
	LockItems       pgtype.JSON `json:"lock_items"`
	Status          string      `json:"status"`
	CustomerName    string      `json:"customer_name"`
	CustomerAddress string      `json:"customer_address"`
}

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 Order struct {
	ID              int32       `json:"id"`
	TrxID           string      `json:"trx_id"`
	PaymentTrxID    string      `json:"payment_trx_id"`
	LockItems       pgtype.JSON `json:"lock_items"`
	Status          string      `json:"status"`
	CustomerName    string      `json:"customer_name"`
	CustomerAddress string      `json:"customer_address"`
}

type OrderDetail struct {
	ID       int32          `json:"id"`
	OrderID  int32          `json:"order_id"`
	Name     string         `json:"name"`
	Quantity int32          `json:"quantity"`
	Price    pgtype.Numeric `json:"price"`
}

type OrderPlacedParams struct {
	Status       string `json:"status"`
	PaymentTrxID string `json:"payment_trx_id"`
}

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

type SelectPayloadsRow struct {
	ID        int32       `json:"id"`
	LockItems pgtype.JSON `json:"lock_items"`
}