query

package

v1.3.0 Latest Latest Go to latest Published: Aug 21, 2022 License: MIT Imports: 3 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/zhufuyi/pkg

Links

Open Source Insights

Documentation ¶

Index ¶

Constants
Variables
func SetMaxSize(max int)
type Column
type Page
- func DefaultPage(page int) *Page
- func NewPage(page int, size int, columnNames string) *Page
type Params
- func (p *Params) ConvertToGormConditions() (string, []interface{}, error)
- func (p *Params) ConvertToPage() (order string, limit int, offset int)

Constants ¶

View Source

const (
	Eq   = "eq"
	Neq  = "neq"
	Gt   = "gt"
	Gte  = "gte"
	Lt   = "lt"
	Lte  = "lte"
	Like = "like"
)

View Source

const (
	AND string = "and"
	OR  string = "or"
)

Variables ¶

View Source

var (
	// ErrNotFound 空记录
	ErrNotFound = gorm.ErrRecordNotFound
)

View Source

var ExpMap = map[string]string{
	Eq:   " = ",
	Neq:  " <> ",
	Gt:   " > ",
	Gte:  " >= ",
	Lt:   " < ",
	Lte:  " <= ",
	Like: " LIKE ",

	"=":  " = ",
	"!=": " <> ",
	">":  " > ",
	">=": " >= ",
	"<":  " < ",
	"<=": " <= ",
}

Functions ¶

func SetMaxSize ¶

func SetMaxSize(max int)

SetMaxSize 修改默认每页数量最大值

Types ¶

type Column ¶

type Column struct {
	Name  string      `json:"name"`  // 列名
	Exp   string      `json:"exp"`   // 表达式，值为空时默认为=，有=、!=、>、>=、<、<=、like七种类型
	Value interface{} `json:"value"` // 列值
	Logic string      `json:"logic"` // 逻辑类型，值为空时默认为and，有&(and)、||(or)两种类型
}

Column 表的列查询信息

type Page ¶

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

Page 页

func DefaultPage ¶

func DefaultPage(page int) *Page

DefaultPage 默认page，每页数量20，按id倒叙排序

func NewPage ¶

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

NewPage 自定义page，从第0页开始，参数columnNames表示排序字段，如果为空表示id降序，如果有多个列名，用逗号分隔，每一个列名称前面有'-'号，表示降序，否则升序

func (*Page) Offset ¶

func (p *Page) Offset() int

Offset 偏移量

func (*Page) Page ¶

func (p *Page) Page() int

Page 页码

func (*Page) Size ¶

func (p *Page) Size() int

Size 每一页数量

func (*Page) Sort ¶

func (p *Page) Sort() string

Sort 排序

type Params ¶

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

	Columns []Column `json:"columns,omitempty"` // 非必须
}

Params 查询原始参数

func (*Params) ConvertToGormConditions ¶

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

ConvertToGormConditions 根据参数Columns转换成符合gorm规则参数无论是一列还是多列查询，忽略最后一列的逻辑类型

func (*Params) ConvertToPage ¶

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

ConvertToPage 根据参数page size sort转换成符合gorm规则参数

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL