category

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

type CreateChildCategoryIfNotExistsRow 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 GetCategoryRow struct {
	ID             int32
	Category       string
	Slug           string
	ParentID       *int32
	IsLeafCategory bool
}

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

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  []byte
	Specs      []byte
	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 Querier interface {
	CreateChildCategoryIfNotExists(ctx context.Context, category string, slug string, parentID *int32) (*CreateChildCategoryIfNotExistsRow, error)
	CreateTopCategory(ctx context.Context, category string, slug string) (*Category, error)
	GetCategory(ctx context.Context, id int32) (*GetCategoryRow, error)
	GetCategoryByName(ctx context.Context, category string) (*Category, error)
	GetCategoryWithAncestors(ctx context.Context, id int32) ([]*GetCategoryWithAncestorsRow, error)
	GetCategoryWithSiblings(ctx context.Context, id int32) ([]*Category, error)
	GetChildCategories(ctx context.Context, parentID *int32) ([]*Category, error)
	GetLeafCategoryIDs(ctx context.Context, id int32) ([][]int32, 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 Store interface {
	Querier
}

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