advanceddb

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

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

type CreateUserRow struct {
	Id        any
	Email     any
	CreatedAt int32
}

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   int32
	UpdatedAt   *int32
}

type GetOrderStatisticsRow struct {
	TotalOrders  int64
	TotalRevenue *any
}

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

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

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

type GetUserByEmailRow struct {
	Id        any
	Email     any
	CreatedAt int32
}

type GetUserRow struct {
	Id        any
	Email     any
	CreatedAt int32
}

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

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

type ListUsersRow struct {
	Id        any
	Email     any
	CreatedAt int32
}

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   int32         `json:"created_at"`
	UpdatedAt   *int32        `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 int32           `json:"created_at"`
}

type Querier interface {
	CreateOrder(ctx context.Context, arg1 any, arg2 any, arg3 any) (CreateOrderRow, error)
	CreateProduct(ctx context.Context, arg1 any, arg2 string, arg3 any) (CreateProductRow, error)
	CreateUser(ctx context.Context, arg1 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, status any, arg2 any) (UpdateOrderStatusRow, error)
	UpdateProductPrice(ctx context.Context, price any, arg2 any) (UpdateProductPriceRow, error)
}

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

type QueryResult struct {
	LastInsertID int64
	RowsAffected int64
}

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

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

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