advanceddb

type CreateOrderParams struct {
	UserId      any
	Status      any
	TotalAmount any
}

type CreateOrderRow struct {
	Id          any
	UserId      any
	Status      any
	TotalAmount any
	CreatedAt   any
	UpdatedAt   any
}

type CreateProductParams struct {
	Sku   any
	Name  any
	Price any
}

type CreateProductRow struct {
	Id        any
	Sku       any
	Name      any
	Price     any
	CreatedAt any
}

type CreateUserRow struct {
	Id        any
	Email     any
	CreatedAt any
}

type DBTX interface {
	ExecContext(ctx context.Context, query string, args ...any) (sql.Result, error)
	QueryContext(ctx context.Context, query string, args ...any) (*sql.Rows, error)
	QueryRowContext(ctx context.Context, query string, args ...any) *sql.Row
}

type GetOrderRow struct {
	Id          any
	UserId      any
	Status      any
	TotalAmount any
	CreatedAt   any
	UpdatedAt   any
}

type GetOrderStatisticsRow struct {
	TotalOrders  int64
	TotalRevenue int64
}

type GetOrdersByStatusRow struct {
	Id          any
	UserId      any
	Status      any
	TotalAmount any
	CreatedAt   any
}

type GetProductBySkuRow struct {
	Id        any
	Sku       any
	Name      any
	Price     any
	CreatedAt any
}

type GetProductRow struct {
	Id        any
	Sku       any
	Name      any
	Price     any
	CreatedAt any
}

type GetUserByEmailRow struct {
	Id        any
	Email     any
	CreatedAt any
}

type GetUserRow struct {
	Id        any
	Email     any
	CreatedAt any
}

type ListOrdersByUserRow struct {
	Id          any
	Status      any
	TotalAmount any
	CreatedAt   any
}

type ListProductsRow struct {
	Id        any
	Sku       any
	Name      any
	Price     any
	CreatedAt any
}

type ListUsersRow struct {
	Id        any
	Email     any
	CreatedAt any
}

type Orders struct {
	Id          types.OrderID `json:"id"`
	UserId      types.UserID  `json:"user_id"`
	Status      types.Status  `json:"status"`
	TotalAmount types.Money   `json:"total_amount"`
	CreatedAt   int64         `json:"created_at"`
	UpdatedAt   sql.NullInt64 `json:"updated_at"`
}

type Products struct {
	Id        types.ProductID `json:"id"`
	Sku       types.SKU       `json:"sku"`
	Name      string          `json:"name"`
	Price     types.Money     `json:"price"`
	CreatedAt int64           `json:"created_at"`
}

type Querier interface {
	CreateOrder(ctx context.Context, arg CreateOrderParams) (CreateOrderRow, error)
	CreateProduct(ctx context.Context, arg CreateProductParams) (CreateProductRow, error)
	CreateUser(ctx context.Context, email any) (CreateUserRow, error)
	GetOrder(ctx context.Context, id any) (GetOrderRow, error)
	GetOrderStatistics(ctx context.Context, userId any) (GetOrderStatisticsRow, error)
	GetOrdersByStatus(ctx context.Context, status any) ([]GetOrdersByStatusRow, error)
	GetProduct(ctx context.Context, id any) (GetProductRow, error)
	GetProductBySku(ctx context.Context, sku any) (GetProductBySkuRow, error)
	GetUser(ctx context.Context, id any) (GetUserRow, error)
	GetUserByEmail(ctx context.Context, email any) (GetUserByEmailRow, error)
	ListOrdersByUser(ctx context.Context, userId any) ([]ListOrdersByUserRow, error)
	ListProducts(ctx context.Context) ([]ListProductsRow, error)
	ListUsers(ctx context.Context) ([]ListUsersRow, error)
	UpdateOrderStatus(ctx context.Context, arg UpdateOrderStatusParams) (UpdateOrderStatusRow, error)
	UpdateProductPrice(ctx context.Context, arg UpdateProductPriceParams) (UpdateProductPriceRow, error)
	WithTx(tx DBTX) *Queries
}

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

type QueryResult struct {
	LastInsertID int64
	RowsAffected int64
}

type UpdateOrderStatusParams struct {
	Status any
	Id     any
}

type UpdateOrderStatusRow struct {
	Id          any
	UserId      any
	Status      any
	TotalAmount any
	CreatedAt   any
	UpdatedAt   any
}

type UpdateProductPriceParams struct {
	Price any
	Id    any
}

type UpdateProductPriceRow struct {
	Id        any
	Sku       any
	Name      any
	Price     any
	CreatedAt any
}

type Users struct {
	Id        types.UserID `json:"id"`
	Email     types.Email  `json:"email"`
	CreatedAt int64        `json:"created_at"`
}