query

type Builder interface {
	Where(field string, op Operator, value any) Builder
	WhereEq(field string, value any) Builder
	WhereLike(field string, value any) Builder
	WhereIn(field string, value any) Builder
	WhereLt(field string, value any) Builder
	WhereLtEq(field string, value any) Builder
	WhereGt(field string, value any) Builder
	WhereGtEq(field string, value any) Builder
	WhereNotEq(field string, value any) Builder
	WhereNotLike(field string, value any) Builder
	WhereNotIn(field string, value any) Builder

	And(field string, op Operator, value any) Builder
	AndEq(field string, value any) Builder
	AndLike(field string, value any) Builder
	AndIn(field string, value any) Builder
	AndLt(field string, value any) Builder
	AndLtEq(field string, value any) Builder
	AndGt(field string, value any) Builder
	AndGtEq(field string, value any) Builder
	AndNotEq(field string, value any) Builder
	AndNotLike(field string, value any) Builder
	AndNotIn(field string, value any) Builder

	Or(field string, op Operator, value any) Builder
	OrEq(field string, value any) Builder
	OrLike(field string, value any) Builder
	OrIn(field string, value any) Builder
	OrLt(field string, value any) Builder
	OrLtEq(field string, value any) Builder
	OrGt(field string, value any) Builder
	OrGtEq(field string, value any) Builder
	OrNotEq(field string, value any) Builder
	OrNotLike(field string, value any) Builder
	OrNotIn(field string, value any) Builder

	AndGroup(conditions Filter) Builder
	OrGroup(conditions Filter) Builder

	GetWhere() (string, []any)

	Order(field string, dir ...Direction) Builder
	GetOrderBy() string
	GetOrder() *Order

	Limit(int) Builder
	GetLimit() int
	Offset(int) Builder
	GetOffset() int
	Pagination(p *Pagination) Builder
	GetPagination() *Pagination

	Join(query string, args ...any) Builder
	GetJoins() []Join

	Build() Template
}

type Direction string

type Filter interface {
	girraph.Tree[Filter]

	Generate() (string, []any)

	And(field string, op Operator, value any) Filter
	AndEq(field string, value any) Filter
	AndLike(field string, value any) Filter
	AndIn(field string, value any) Filter
	AndLt(field string, value any) Filter
	AndLtEq(field string, value any) Filter
	AndGt(field string, value any) Filter
	AndGtEq(field string, value any) Filter
	AndNotEq(field string, value any) Filter
	AndNotLike(field string, value any) Filter
	AndNotIn(field string, value any) Filter

	Or(field string, op Operator, value any) Filter
	OrEq(field string, value any) Filter
	OrLike(field string, value any) Filter
	OrIn(field string, value any) Filter
	OrLt(field string, value any) Filter
	OrLtEq(field string, value any) Filter
	OrGt(field string, value any) Filter
	OrGtEq(field string, value any) Filter
	OrNotEq(field string, value any) Filter
	OrNotLike(field string, value any) Filter
	OrNotIn(field string, value any) Filter

	AndGroup(conditions Filter) Filter
	OrGroup(conditions Filter) Filter
	// contains filtered or unexported methods
}

type Join struct {
	Query string
	Args  []any
}

type Logic string

type Operator string

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

type Pagination struct {
	Page       int `json:"page,omitempty"`
	PageSize   int `json:"size,omitempty"`
	Total      int `json:"total,omitempty"`
	TotalPages int `json:"pages,omitempty"`
}

type Template struct {
	Where   string
	Params  []any
	OrderBy string
	Joins   []Join
	Limit   int
	Offset  int
}