query

Documentation

Overview

Package query is a library for mysql query, support for complex conditional paging queries.

Index

• Constants
• Variables
• func SetMaxSize(max int)
• type Column
• type Conditions
  • func (c *Conditions) CheckValid() error
  • func (c *Conditions) ConvertToGorm() (string, []interface{}, error)
• type Page
  • func DefaultPage(page int) *Page
  • func NewPage(page int, size int, columnNames string) *Page
  • func (p *Page) Offset() int
  • func (p *Page) Page() int
  • func (p *Page) Size() int
  • func (p *Page) Sort() string
• type Params
  • func (p *Params) ConvertToGormConditions() (string, []interface{}, error)
  • func (p *Params) ConvertToPage() (order string, limit int, offset int)

Constants

const (
	// Eq equal
	Eq = "eq"
	// Neq not equal
	Neq = "neq"
	// Gt greater than
	Gt = "gt"
	// Gte greater than or equal
	Gte = "gte"
	// Lt less than
	Lt = "lt"
	// Lte less than or equal
	Lte = "lte"
	// Like fuzzy lookup
	Like = "like"

	// AND logic and
	AND string = "and"
	// OR logic or
	OR string = "or"
)

Variables

var (
	// ErrNotFound record
	ErrNotFound = gorm.ErrRecordNotFound
)

Functions

func SetMaxSize

func SetMaxSize(max int)

SetMaxSize change the default maximum number of pages per page

Types

type Column

type Column struct {
	Name  string      `json:"name" form:"columns"`  // column name
	Exp   string      `json:"exp" form:"columns"`   // expressions, which default to = when the value is null, have =, !=, >, >=, <, <=, like
	Value interface{} `json:"value" form:"columns"` // column value
	Logic string      `json:"logic" form:"columns"` // logical type, defaults to and when the value is null, with &(and), ||(or)
}

Column query info

type Conditions

type Conditions struct {
	Columns []Column `json:"columns" form:"columns" binding:"min=1"` // columns info
}

Conditions query conditions

func (*Conditions) CheckValid

func (c *Conditions) CheckValid() error

CheckValid check valid

func (*Conditions) ConvertToGorm

func (c *Conditions) ConvertToGorm() (string, []interface{}, error)

ConvertToGorm conversion to gorm-compliant parameters based on the Columns parameter ignore the logical type of the last column, whether it is a one-column or multi-column query

type Page

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

Page info

func DefaultPage

func DefaultPage(page int) *Page

DefaultPage default page, number 20 per page, sorted by id backwards

func NewPage

func NewPage(page int, size int, columnNames string) *Page

NewPage custom page, starting from page 0. the parameter columnNames indicates a sort field, if empty means id descending, if there are multiple column names, separated by a comma, a '-' sign in front of each column name indicates descending order, otherwise ascending order.

func (*Page) Offset

func (p *Page) Offset() int

Offset get offset value

func (*Page) Page

func (p *Page) Page() int

Page get page value

func (*Page) Size

func (p *Page) Size() int

Size number per page

func (*Page) Sort

func (p *Page) Sort() string

Sort get sort field

type Params

type Params struct {
	Page int    `json:"page" form:"page" binding:"gte=0"`
	Size int    `json:"size" form:"size" binding:"gt=0"`
	Sort string `json:"sort,omitempty" form:"sort" binding:""`

	Columns []Column `json:"columns,omitempty" form:"columns"` // not required
}

Params query parameters

func (*Params) ConvertToGormConditions

func (p *Params) ConvertToGormConditions() (string, []interface{}, error)

ConvertToGormConditions conversion to gorm-compliant parameters based on the Columns parameter ignore the logical type of the last column, whether it is a one-column or multi-column query

func (*Params) ConvertToPage

func (p *Params) ConvertToPage() (order string, limit int, offset int)

ConvertToPage converted to conform to gorm rules based on the page size sort parameter