repository

type Cart struct {
	ID        uuid.UUID          `db:"id" json:"id"`
	UserID    uuid.UUID          `db:"user_id" json:"user_id"`
	CreatedAt pgtype.Timestamptz `db:"created_at" json:"created_at"`
	UpdatedAt pgtype.Timestamptz `db:"updated_at" json:"updated_at"`
}

type CartItem struct {
	ID        uuid.UUID          `db:"id" json:"id"`
	CartID    uuid.UUID          `db:"cart_id" json:"cart_id"`
	ProductID uuid.UUID          `db:"product_id" json:"product_id"`
	Quantity  int32              `db:"quantity" json:"quantity"`
	Price     pgtype.Numeric     `db:"price" json:"price"`
	CreatedAt pgtype.Timestamptz `db:"created_at" json:"created_at"`
	UpdatedAt pgtype.Timestamptz `db:"updated_at" json:"updated_at"`
}

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
	CopyFrom(ctx context.Context, tableName pgx.Identifier, columnNames []string, rowSrc pgx.CopyFromSource) (int64, error)
}

type DeleteCartByIdAndUserIdParams struct {
	ID     uuid.UUID `db:"id" json:"id"`
	UserID uuid.UUID `db:"user_id" json:"user_id"`
}

type DeleteCartItemFromCartsByIdParams struct {
	ID     uuid.UUID `db:"id" json:"id"`
	CartID uuid.UUID `db:"cart_id" json:"cart_id"`
}

type FindCartByIdParams struct {
	ID   uuid.UUID `db:"id" json:"id"`
	ID_2 uuid.UUID `db:"id_2" json:"id_2"`
}

type FindCartByIdRow struct {
	ID        uuid.UUID          `db:"id" json:"id"`
	UserID    uuid.UUID          `db:"user_id" json:"user_id"`
	CreatedAt pgtype.Timestamptz `db:"created_at" json:"created_at"`
	UpdatedAt pgtype.Timestamptz `db:"updated_at" json:"updated_at"`
	CartItems []byte             `db:"cart_items" json:"cart_items"`
}

type FindCartByUserIdRow struct {
	ID        uuid.UUID          `db:"id" json:"id"`
	UserID    uuid.UUID          `db:"user_id" json:"user_id"`
	CreatedAt pgtype.Timestamptz `db:"created_at" json:"created_at"`
	UpdatedAt pgtype.Timestamptz `db:"updated_at" json:"updated_at"`
	CartItems []byte             `db:"cart_items" json:"cart_items"`
}

type FindOrderByIdParams struct {
	ID   uuid.UUID `db:"id" json:"id"`
	ID_2 uuid.UUID `db:"id_2" json:"id_2"`
}

type FindOrderByIdRow struct {
	ID         uuid.UUID          `db:"id" json:"id"`
	UserID     uuid.UUID          `db:"user_id" json:"user_id"`
	Status     OrderStatus        `db:"status" json:"status"`
	CreatedAt  pgtype.Timestamptz `db:"created_at" json:"created_at"`
	UpdatedAt  pgtype.Timestamptz `db:"updated_at" json:"updated_at"`
	OrderItems []byte             `db:"order_items" json:"order_items"`
}

type FindOrderItemByIdAndUserIdParams struct {
	Column1 interface{} `db:"column_1" json:"column_1"`
	Column2 interface{} `db:"column_2" json:"column_2"`
}

type GetOrdersRow struct {
	ID         uuid.UUID          `db:"id" json:"id"`
	UserID     uuid.UUID          `db:"user_id" json:"user_id"`
	Status     OrderStatus        `db:"status" json:"status"`
	CreatedAt  pgtype.Timestamptz `db:"created_at" json:"created_at"`
	UpdatedAt  pgtype.Timestamptz `db:"updated_at" json:"updated_at"`
	OrderItems []byte             `db:"order_items" json:"order_items"`
}

type InsertCartItemParams struct {
	ID        uuid.UUID      `db:"id" json:"id"`
	CartID    uuid.UUID      `db:"cart_id" json:"cart_id"`
	ProductID uuid.UUID      `db:"product_id" json:"product_id"`
	Quantity  int32          `db:"quantity" json:"quantity"`
	Price     pgtype.Numeric `db:"price" json:"price"`
}

type InsertCartItemsParams struct {
	ID        uuid.UUID      `db:"id" json:"id"`
	CartID    uuid.UUID      `db:"cart_id" json:"cart_id"`
	ProductID uuid.UUID      `db:"product_id" json:"product_id"`
	Quantity  int32          `db:"quantity" json:"quantity"`
	Price     pgtype.Numeric `db:"price" json:"price"`
}

type InsertOrderItemParams struct {
	ID        uuid.UUID          `db:"id" json:"id"`
	OrderID   uuid.UUID          `db:"order_id" json:"order_id"`
	ProductID uuid.UUID          `db:"product_id" json:"product_id"`
	Quantity  int32              `db:"quantity" json:"quantity"`
	Price     pgtype.Numeric     `db:"price" json:"price"`
	CreatedAt pgtype.Timestamptz `db:"created_at" json:"created_at"`
	UpdatedAt pgtype.Timestamptz `db:"updated_at" json:"updated_at"`
}

type InsertOrderParams struct {
	ID     uuid.UUID `db:"id" json:"id"`
	UserID uuid.UUID `db:"user_id" json:"user_id"`
}

type InsertOrdersParams struct {
	ID        uuid.UUID          `db:"id" json:"id"`
	UserID    uuid.UUID          `db:"user_id" json:"user_id"`
	CreatedAt pgtype.Timestamptz `db:"created_at" json:"created_at"`
	UpdatedAt pgtype.Timestamptz `db:"updated_at" json:"updated_at"`
}

type InsertProductParams struct {
	Name     string         `db:"name" json:"name"`
	Price    pgtype.Numeric `db:"price" json:"price"`
	Quantity int32          `db:"quantity" json:"quantity"`
}

type InsertUserParams struct {
	Username  string             `db:"username" json:"username"`
	Email     string             `db:"email" json:"email"`
	Password  string             `db:"password" json:"password"`
	CreatedAt pgtype.Timestamptz `db:"created_at" json:"created_at"`
	UpdatedAt pgtype.Timestamptz `db:"updated_at" json:"updated_at"`
}

type NullOrderStatus struct {
	OrderStatus OrderStatus `json:"order_status"`
	Valid       bool        `json:"valid"` // Valid is true if OrderStatus is not NULL
}

type Order struct {
	ID        uuid.UUID          `db:"id" json:"id"`
	UserID    uuid.UUID          `db:"user_id" json:"user_id"`
	Status    OrderStatus        `db:"status" json:"status"`
	CreatedAt pgtype.Timestamptz `db:"created_at" json:"created_at"`
	UpdatedAt pgtype.Timestamptz `db:"updated_at" json:"updated_at"`
}

type OrderItem struct {
	ID        uuid.UUID          `db:"id" json:"id"`
	OrderID   uuid.UUID          `db:"order_id" json:"order_id"`
	ProductID uuid.UUID          `db:"product_id" json:"product_id"`
	Quantity  int32              `db:"quantity" json:"quantity"`
	Price     pgtype.Numeric     `db:"price" json:"price"`
	CreatedAt pgtype.Timestamptz `db:"created_at" json:"created_at"`
	UpdatedAt pgtype.Timestamptz `db:"updated_at" json:"updated_at"`
}

type OrderStatus string

type Product struct {
	ID        uuid.UUID          `db:"id" json:"id"`
	Name      string             `db:"name" json:"name"`
	Price     pgtype.Numeric     `db:"price" json:"price"`
	Quantity  int32              `db:"quantity" json:"quantity"`
	CreatedAt pgtype.Timestamptz `db:"created_at" json:"created_at"`
	UpdatedAt pgtype.Timestamptz `db:"updated_at" json:"updated_at"`
}

type Querier interface {
	DeleteCartByIdAndUserId(ctx context.Context, arg DeleteCartByIdAndUserIdParams) (Cart, error)
	DeleteCartItemFromCartsById(ctx context.Context, arg DeleteCartItemFromCartsByIdParams) (CartItem, error)
	DeleteOrderItemFromOrdersById(ctx context.Context, id uuid.UUID) (OrderItem, error)
	DeleteProduct(ctx context.Context, id uuid.UUID) (Product, error)
	FindByEmail(ctx context.Context, email string) (User, error)
	FindById(ctx context.Context, id uuid.UUID) (User, error)
	FindCartById(ctx context.Context, arg FindCartByIdParams) (FindCartByIdRow, error)
	FindCartByUserId(ctx context.Context, id uuid.UUID) ([]FindCartByUserIdRow, error)
	FindCartItemByCartId(ctx context.Context, cartID uuid.UUID) ([]CartItem, error)
	FindCartItemById(ctx context.Context, id uuid.UUID) (CartItem, error)
	FindOrderById(ctx context.Context, arg FindOrderByIdParams) (FindOrderByIdRow, error)
	FindOrderByUserId(ctx context.Context, userID uuid.UUID) ([]Order, error)
	FindOrderItemById(ctx context.Context, id uuid.UUID) ([]OrderItem, error)
	FindOrderItemByIdAndUserId(ctx context.Context, arg FindOrderItemByIdAndUserIdParams) ([]OrderItem, error)
	FindOrderUserId(ctx context.Context, id uuid.UUID) ([]Order, error)
	FindProductById(ctx context.Context, id uuid.UUID) (Product, error)
	FindProductByIdLock(ctx context.Context, id uuid.UUID) (Product, error)
	FindProductByName(ctx context.Context, name string) (Product, error)
	FindProducts(ctx context.Context) ([]Product, error)
	FindProductsByIds(ctx context.Context, dollar_1 []uuid.UUID) ([]Product, error)
	FindProductsByIdsLock(ctx context.Context, dollar_1 []uuid.UUID) ([]Product, error)
	GetOrders(ctx context.Context, dollar_1 []uuid.UUID) ([]GetOrdersRow, error)
	GetProducts(ctx context.Context) ([]Product, error)
	InsertCart(ctx context.Context, userID uuid.UUID) (Cart, error)
	InsertCartItem(ctx context.Context, arg InsertCartItemParams) (CartItem, error)
	InsertCartItems(ctx context.Context, arg []InsertCartItemsParams) (int64, error)
	InsertOrder(ctx context.Context, arg InsertOrderParams) (Order, error)
	InsertOrderItem(ctx context.Context, arg []InsertOrderItemParams) (int64, error)
	InsertOrders(ctx context.Context, arg []InsertOrdersParams) (int64, error)
	InsertProduct(ctx context.Context, arg InsertProductParams) (Product, error)
	InsertUser(ctx context.Context, arg InsertUserParams) (User, error)
	UpdateProduct(ctx context.Context, arg UpdateProductParams) (Product, error)
	UpdateProductQuantity(ctx context.Context, arg UpdateProductQuantityParams) (Product, error)
}

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

type UpdateProductParams struct {
	Name     string         `db:"name" json:"name"`
	Price    pgtype.Numeric `db:"price" json:"price"`
	Quantity int32          `db:"quantity" json:"quantity"`
	ID       uuid.UUID      `db:"id" json:"id"`
}

type UpdateProductQuantityParams struct {
	ID       uuid.UUID `db:"id" json:"id"`
	Quantity int32     `db:"quantity" json:"quantity"`
}

type User struct {
	ID        uuid.UUID          `db:"id" json:"id"`
	Username  string             `db:"username" json:"username"`
	Email     string             `db:"email" json:"email"`
	Password  string             `db:"password" json:"password"`
	CreatedAt pgtype.Timestamptz `db:"created_at" json:"created_at"`
	UpdatedAt pgtype.Timestamptz `db:"updated_at" json:"updated_at"`
}