query

type PagingResult[T any] struct {
	Page      int
	PageSize  int
	TotalPage int64
	Total     int64
	Error     error `json:",omitempty"`
	Data      []T   `json:",omitempty"`
}

type RawQuery struct {
	Connection string // which connection should be used for query.
	Sql        string
	SumRef     string // reference to another RawQuery define, not used yet.
	SumEnabled bool
	Preset     map[string]any
	Params     []string
	Where      map[string]string // key: where condition, value: param key, e.g. "id = ?", "id"
	Orderby    string
	Groupby    string
}

type RawQuerySerice struct {
	Source      string
	EnabledAuth bool
	Base        string
	Items       []SerivceItem
	// contains filtered or unexported fields
}

type RawQueryWhere struct {
	Cond  string
	Param string
	Empty string // optional settings, where condition for params is empty
}

type SerivceItem struct {
	Uri     string
	Query   RawQuery  // header
	Details *RawQuery // details
}