data

type CategoriesQ interface {
	New() CategoriesQ

	Get() (*Category, error)
	Select() ([]Category, error)

	Transaction(fn func(q CategoriesQ) error) error

	Insert(category Category) (Category, error)
	Update(category Category) (Category, error)
	Delete(id int64) error

	Page(pageParams pgdb.OffsetPageParams) CategoriesQ

	FilterById(ids ...int64) CategoriesQ
	FilterByNames(names ...string) CategoriesQ
	FilterByUnits(units ...string) CategoriesQ
}

type Category struct {
	Id           int64  `db:"id" structs:"-"`
	CategoryName string `db:"category_name" structs:"category_name"`
	Unit         string `db:"unit" structs:"unit"`
}

type Meal struct {
	Id         int64   `db:"id" structs:"-"`
	MealName   string  `db:"meal_name" structs:"meal_name"`
	CategoryId int64   `db:"category_id" structs:"category_id"`
	Price      float64 `db:"price" structs:"price"`
	Amount     float64 `db:"amount" structs:"amount"`
}

type MealMenu struct {
	Id     int64 `db:"id" structs:"-"`
	MealId int64 `db:"meal_id" structs:"meal_id"`
	MenuId int64 `db:"menu_id" structs:"menu_id"`
}

type MealMenusQ interface {
	New() MealMenusQ

	Get() (*MealMenu, error)
	Select() ([]MealMenu, error)

	Transaction(fn func(q MealMenusQ) error) error

	Insert(mealMenu MealMenu) (MealMenu, error)
	Update(mealMenu MealMenu) (MealMenu, error)
	Delete(id int64) error

	Page(pageParams pgdb.OffsetPageParams) MealMenusQ

	FilterById(ids ...int64) MealMenusQ
	FilterByMealId(ids ...int64) MealMenusQ
	FilterByMenuId(ids ...int64) MealMenusQ

	JoinMeal() MealMenusQ
	JoinMenu() MealMenusQ
}

type MealsQ interface {
	New() MealsQ

	Get() (*Meal, error)
	Select() ([]Meal, error)

	Transaction(fn func(q MealsQ) error) error

	Insert(meal Meal) (Meal, error)
	Update(meal Meal) (Meal, error)
	Delete(id int64) error

	Page(pageParams pgdb.OffsetPageParams) MealsQ

	FilterById(ids ...int64) MealsQ
	FilterByNames(names ...string) MealsQ
	FilterByPriceFrom(prices ...float64) MealsQ
	FilterByPriceTo(prices ...float64) MealsQ
	FilterByAmount(amounts ...float64) MealsQ
	FilterByCategoryId(ids ...int64) MealsQ

	JoinCategory() MealsQ
}

type Menu struct {
	Id     int64 `db:"id" structs:"-"`
	CafeId int64 `db:"cafe_id" structs:"cafe_id"`
}

type MenusQ interface {
	New() MenusQ

	Get() (*Menu, error)
	Select() ([]Menu, error)

	Transaction(fn func(q MenusQ) error) error

	Insert(menu Menu) (Menu, error)
	Update(menu Menu) (Menu, error)
	Delete(id int64) error

	Page(pageParams pgdb.OffsetPageParams) MenusQ

	FilterById(ids ...int64) MenusQ
	FilterByCafeId(ids ...int64) MenusQ
}

type Receipt struct {
	Id           int64 `db:"id" structs:"-"`
	MealId       int64 `db:"meal_id" structs:"meal_id"`
	IngredientId int64 `db:"ingredient_id" structs:"ingredient_id"`
	Quantity     int64 `db:"quantity" structs:"quantity"`
}

type ReceiptsQ interface {
	New() ReceiptsQ

	Get() (*Receipt, error)
	Select() ([]Receipt, error)

	Transaction(fn func(q ReceiptsQ) error) error

	Insert(receipt Receipt) (Receipt, error)
	Update(receipt Receipt) (Receipt, error)
	Delete(id int64) error

	Page(pageParams pgdb.OffsetPageParams) ReceiptsQ

	FilterById(ids ...int64) ReceiptsQ
	FilterByMealId(ids ...int64) ReceiptsQ
	FilterByIngredientId(ids ...int64) ReceiptsQ
	FilterByQuantityFrom(quantities ...int64) ReceiptsQ
	FilterByQuantityTo(quantities ...int64) ReceiptsQ

	JoinMeal() ReceiptsQ
}