product

type Category struct {
	ID       int32
	Category string
	Slug     string
	ParentID *int32
}

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 GetProductAttributesByProductIDRow struct {
	AttributeName   string
	AttributeValues []string
}

type GetProductByIDRow struct {
	Product        Product
	SellerStore    SellerStore
	ProductPricing ProductPricing
}

type GetSKUsByProductIDRow struct {
	SkuID           int64
	ProductID       int64
	Sku             string
	QuantityInStock int32
	HasSepPricing   bool
	ImageRefs       []int16
	SkuCreatedAt    pgtype.Timestamptz
	SkuUpdatedAt    pgtype.Timestamptz
	Attributes      []byte
}

type ImageUrls map[int]string

type NullProductStatus struct {
	ProductStatus ProductStatus
	Valid         bool // Valid is true if ProductStatus is not NULL
}

type NullUserStatus struct {
	UserStatus UserStatus
	Valid      bool // Valid is true if UserStatus is not NULL
}

type Product struct {
	ID         int64
	StoreID    int32
	CategoryID int32
	Name       string
	Brand      *string
	Slug       string
	ShortInfo  []string
	ImageUrls  ImageUrls
	Specs      Specs
	Status     ProductStatus
	CreatedAt  pgtype.Timestamptz
	UpdatedAt  pgtype.Timestamptz
}

type ProductAttribute struct {
	ID        int64
	ProductID int64
	Attribute string
}

type ProductPricing struct {
	ProductID        int64
	BasePrice        decimal.Decimal
	CurrencyCode     string
	DiscountLevel    decimal.Decimal
	DiscountedAmount decimal.Decimal
	IsOnSale         bool
}

type ProductRating struct {
	ID        int64
	ProductID int64
	UserID    *int64
	Rating    int16
	Review    *string
	ImageUrls []string
	CreatedAt pgtype.Timestamptz
}

type ProductStatus string

type ProductsByCategoryRow struct {
	ID               int64
	Name             string
	Slug             string
	ThumbImg         string
	BasePrice        decimal.Decimal
	DiscountedAmount decimal.Decimal
	CurrencyCode     string
	Count            int64
}

type Querier interface {
	CreateProduct(ctx context.Context, storeID int32, categoryID int32, name string, brand *string, slug string, shortInfo []string, imageUrls ImageUrls, specs Specs, status ProductStatus) (*Product, error)
	CreateProductAttribute(ctx context.Context, productID int64, attribute string) (int64, error)
	CreateProductPricing(ctx context.Context, productID int64, basePrice decimal.Decimal, currencyCode string, discountLevel decimal.Decimal, discountedAmount decimal.Decimal, isOnSale bool) error
	CreateSKU(ctx context.Context, productID int64, sku string, quantityInStock int32, hasSepPricing bool, imageRefs []int16) (int64, error)
	CreateSKUPricing(ctx context.Context, skuID int64, basePrice decimal.Decimal, currencyCode string, discountLevel decimal.Decimal, discountedAmount decimal.Decimal, isOnSale bool) (int64, error)
	CreateSKUProductAttributeValues(ctx context.Context, skuID int64, productAttributeID int64, attributeValue string) error
	GetProductAttributesByProductID(ctx context.Context, productID int64) ([]*GetProductAttributesByProductIDRow, error)
	GetProductByID(ctx context.Context, id int64) (*GetProductByIDRow, error)
	GetProductsByCategoryIDs(ctx context.Context, offset int32, limit int32, leafCategoryIds []int32) ([]*Product, error)
	GetSKUsByProductID(ctx context.Context, productID int64) ([]*GetSKUsByProductIDRow, error)
}

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

type Role struct {
	ID   int16
	Role string
}

type SellerStore struct {
	ID          int32
	PublicID    string
	SellerID    int64
	Name        string
	Description string
	CreatedAt   pgtype.Timestamptz
	UpdatedAt   pgtype.Timestamptz
}

type Session struct {
	Token  string
	Data   []byte
	Expiry pgtype.Timestamptz
}

type Sku struct {
	ID              int64
	ProductID       int64
	Sku             string
	QuantityInStock int32
	HasSepPricing   bool
	ImageRefs       []int16
	CreatedAt       pgtype.Timestamptz
	UpdatedAt       pgtype.Timestamptz
}

type SkuPricing struct {
	SkuID            int64
	BasePrice        decimal.Decimal
	CurrencyCode     string
	DiscountLevel    decimal.Decimal
	DiscountedAmount decimal.Decimal
	IsOnSale         bool
}

type SkuProductAttributeValue struct {
	SkuID              int64
	ProductAttributeID int64
	AttributeValue     string
}

type Specs map[string]string

type Store interface {
	Querier
	GetProductsByLeafCategoryID(ctx context.Context, categoryID int32, p anor.GetProductsByCategoryParams) ([]ProductsByCategoryRow, error)
	GetProductsByLeafCategoryIDs(ctx context.Context, categoryID []int32, p anor.GetProductsByCategoryParams) ([]ProductsByCategoryRow, error)
	WithTx(ctx context.Context, fn func(tx pgx.Tx) error) error
}

type User struct {
	ID          int64
	Email       string
	Password    string
	PhoneNumber *string
	FullName    string
	Status      UserStatus
	Otp         *string
	OtpExpiry   *int64
	CreatedAt   pgtype.Timestamptz
	UpdatedAt   pgtype.Timestamptz
}

type UserRole struct {
	UserID int64
	RoleID int16
}

type UserStatus string