util

type Error struct {
	Id     string `json:"Id,omitempty"`
	Title  string `json:"Title,omitempty"`
	Detail string `json:"Detail,omitempty"`
	Status string `json:"Status,omitempty"`
}

type Filter struct {
	Column  string      `json:"column"`
	Compare string      `json:"compare"`
	Value   interface{} `json:"value"`
}

type Meta struct {
	TotalCount int `json:"total_count"`
}

type Output struct {
	Payload interface{} `json:"data,omitempty"`
	*Error  `json:"error,omitempty"`
	*Meta   `json:"meta,omitempty"`
}

type Pagination struct {
	PageLimit  int `json:"page_limit"`
	PageNumber int `json:"page_number"`
}

type Param struct {
	Search           Search `json:"search"`
	Limit            int    // holds the calculated limit
	Offset           int    // holds the offset number
	PaginationString string // holds the limit/offset tring
	Sort             string // holds the calculated sort string
	ColumnMapping    map[string]string
}

type Search struct {
	Filters    []Filter   `json:"filters"`
	Pagination Pagination `json:"pagination"`
	Sort       string     `json:"sort"` // comma separated string, use a '-' before column name to sort DESC i.e.: id,-name => "SORT BY id ASC, name DESC"
}

type SearchBuilder struct {
	Params       []string
	Values       []interface{}
	ExcludeWhere bool
}