query

Documentation

Index

• Constants
• Variables
• func Query[T any](db *gorm.DB, r *RawQuery, data map[string]any) ([]T, error)
• type PagingResult
• type RawQuery
  • func (r *RawQuery) PagingResult(db *gorm.DB, result []map[string]any, req map[string]any) (*PagingResult[map[string]any], error)
  • func (r *RawQuery) Query(db *gorm.DB, data map[string]any) ([]map[string]any, error)
  • func (r *RawQuery) ShouldPagingResult(req map[string]any) bool
• type RawQuerySerice
• type RawQueryWhere
• type SerivceItem

Constants

const (
	KeyWhere    = "{{.where}}"
	KeyPageSize = "page_size"
	KeyPage     = "page"
)

Variables

var (
	PageSize = 100 // default page size
)

Functions

func Query

func Query[T any](db *gorm.DB, r *RawQuery, data map[string]any) ([]T, error)

Types

type PagingResult

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

type RawQuery

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
}

func (*RawQuery) PagingResult

func (r *RawQuery) PagingResult(db *gorm.DB, result []map[string]any, req map[string]any) (*PagingResult[map[string]any], error)

func (*RawQuery) Query

func (r *RawQuery) Query(db *gorm.DB, data map[string]any) ([]map[string]any, error)

func (*RawQuery) ShouldPagingResult

func (r *RawQuery) ShouldPagingResult(req map[string]any) bool

check should return Paging Result

type RawQuerySerice

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

type RawQueryWhere

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

it's not enabled yet.

type SerivceItem

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