pkg.gl

Categorygithub.com/xwc1125/xwc1125-pkgdatabasesearch

package

0.1.3

Repository: https://github.com/xwc1125/xwc1125-pkg.git

Documentation: pkg.go.dev

Search库

type	描述	query示例
exact/iexact	等于	status=1
contains/icontanins	包含	name=n
gt/gte	大于/大于等于	age=18
lt/lte	小于/小于等于	age=18
startswith/istartswith	以…起始	content=hell
endswith/iendswith	以…结束	content=world
in	in查询	status[]=0&status[]=1
isnull	isnull查询	startTime=1
order	排序	sort=asc/sort=desc

e.g.

type ApplicationQuery struct {
	Id       string    `search:"type:icontains;column:id;table:receipt" form:"id"`
	Domain   string    `search:"type:icontains;column:domain;table:receipt" form:"domain"`
	Version  string    `search:"type:exact;column:version;table:receipt" form:"version"`
	Status   []int     `search:"type:in;column:status;table:receipt" form:"status"`
	Start    time.Time `search:"type:gte;column:created_at;table:receipt" form:"start"`
	End      time.Time `search:"type:lte;column:created_at;table:receipt" form:"end"`
	TestJoin `search:"type:left;on:id:receipt_id;table:receipt_goods;join:receipts"`
	ApplicationOrder
}
type ApplicationOrder struct {
	IdOrder string `search:"type:order;column:id;table:receipt" form"id_order"`
}

type TestJoin struct {
	PaymentAccount string `search:"type:icontains;column:payment_account;table:receipts" form:"payment_account"`
}

# Functions

NewOrmCondition

No description provided by the author

ResolveSearchQuery

ResolveSearchQuery 解析* * exact / iexact 等于 * contains / icontains 包含 * gt / gte 大于 / 大于等于 * lt / lte 小于 / 小于等于 * startswith / istartswith 以…起始 * endswith / iendswith 以…结束 * in * isnull * order 排序 e.g.