query

Documentation

Index

• type Base
• type Criteria
  • func C() Criteria
  • func (c Criteria) And(cri Base) Where
  • func (c Criteria) Append(cri Base) Where
  • func (c Criteria) Col(col string) Criteria
  • func (c Criteria) Eq(val Val) Criteria
  • func (c Criteria) Gt(val Val) Criteria
  • func (c Criteria) Gte(val Val) Criteria
  • func (c Criteria) In(val Val) Criteria
  • func (c Criteria) IsNotNull() Criteria
  • func (c Criteria) IsNull() Criteria
  • func (c Criteria) Lt(val Val) Criteria
  • func (c Criteria) Lte(val Val) Criteria
  • func (c Criteria) Ne(val Val) Criteria
  • func (c Criteria) Or(cri Base) Where
  • func (c Criteria) Sql() string
• type Order
• type Page
  • func P() Page
  • func (p Page) Limit(offset, size int) Page
  • func (p Page) Order(o Order) Page
  • func (p Page) Sql() string
• type PageRet
  • func NewPageRet(page Page) PageRet
• type Q
• type Val
  • func Func(data string) Val
  • func Literal(data interface{}) Val
• type Where
  • func (w Where) And(whe Base) Where
  • func (w Where) Append(whe Base) Where
  • func (w Where) Or(whe Base) Where
  • func (w Where) Sql() string

Examples

• Criteria

Types

type Base

type Base interface {
	Sql() string
}

type Criteria

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

Example

query := C().Col("name").Eq(Literal("wubin")).Or(C().Col("school").Eq(Literal("havard"))).And(C().Col("age").Eq(Literal(18)))
fmt.Println(query.Sql())

query = C().Col("name").Eq(Literal("wubin")).Or(C().Col("school").Eq(Literal("havard"))).And(C().Col("delete_at").IsNotNull())
fmt.Println(query.Sql())

query = C().Col("name").Eq(Literal("wubin")).Or(C().Col("school").In(Literal("havard"))).And(C().Col("delete_at").IsNotNull())
fmt.Println(query.Sql())

query = C().Col("name").Eq(Literal("wubin")).Or(C().Col("school").In(Literal([]string{"havard", "beijing unv"}))).And(C().Col("delete_at").IsNotNull())
fmt.Println(query.Sql())

var d int
var e int
d = 10
e = 5

query = C().Col("name").Eq(Literal("wubin")).Or(C().Col("age").In(Literal([]*int{&d, &e}))).And(C().Col("delete_at").IsNotNull())
fmt.Println(query.Sql())

query = C().Col("name").Ne(Literal("wubin")).Or(C().Col("create_at").Lt(Func("now()")))
fmt.Println(query.Sql())

query = C().Col("name").Ne(Literal("wubin")).Or(C().Col("create_at").Lte(Func("now()")))
fmt.Println(query.Sql())

query = C().Col("name").Ne(Literal("wubin")).Or(C().Col("create_at").Gt(Func("now()")))
fmt.Println(query.Sql())

query = C().Col("name").Ne(Literal("wubin")).Or(C().Col("create_at").Gte(Func("now()")))
fmt.Println(query.Sql())

page := Page{
	Orders: []Order{
		{
			Col:  "create_at",
			Sort: sortenum.Desc,
		},
	},
	Offset: 20,
	Size:   10,
}
page = page.Order(Order{
	Col:  "score",
	Sort: sortenum.Asc,
})
page = page.Limit(30, 5)
fmt.Println(page.Sql())
pageRet := NewPageRet(page)
fmt.Println(pageRet.PageNo)

fmt.Println(P().Order(Order{
	Col:  "score",
	Sort: sortenum.Asc,
}).Limit(20, 10).Sql())

query = C().Col("name").Eq(Literal("wubin")).Or(C().Col("school").Eq(Literal("havard"))).
	And(C().Col("age").Eq(Literal(18))).
	Or(C().Col("score").Gte(Literal(90)))
fmt.Println(query.Sql())

page = P().Order(Order{
	Col:  "create_at",
	Sort: sortenum.Desc,
}).Limit(0, 1)
var where Q
where = C().Col("project_id").Eq(Literal(1))
where = where.And(C().Col("delete_at").IsNull())
where = where.Append(page)
fmt.Println(where.Sql())

Output:

((`name` = 'wubin' or `school` = 'havard') and `age` = '18')
((`name` = 'wubin' or `school` = 'havard') and `delete_at` is not null)
((`name` = 'wubin' or `school` in ('havard')) and `delete_at` is not null)
((`name` = 'wubin' or `school` in ('havard','beijing unv')) and `delete_at` is not null)
((`name` = 'wubin' or `age` in ('10','5')) and `delete_at` is not null)
(`name` != 'wubin' or `create_at` < now())
(`name` != 'wubin' or `create_at` <= now())
(`name` != 'wubin' or `create_at` > now())
(`name` != 'wubin' or `create_at` >= now())
order by create_at desc,score asc limit 30,5
7
order by score asc limit 20,10
(((`name` = 'wubin' or `school` = 'havard') and `age` = '18') or `score` >= '90')
(`project_id` = '1' and `delete_at` is null) order by create_at desc limit 0,1

func C

func C() Criteria

func (Criteria) And

func (c Criteria) And(cri Base) Where

func (Criteria) Append

func (c Criteria) Append(cri Base) Where

func (Criteria) Col

func (c Criteria) Col(col string) Criteria

func (Criteria) Eq

func (c Criteria) Eq(val Val) Criteria

func (Criteria) Gt

func (c Criteria) Gt(val Val) Criteria

func (Criteria) Gte

func (c Criteria) Gte(val Val) Criteria

func (Criteria) In

func (c Criteria) In(val Val) Criteria

func (Criteria) IsNotNull

func (c Criteria) IsNotNull() Criteria

func (Criteria) IsNull

func (c Criteria) IsNull() Criteria

func (Criteria) Lt

func (c Criteria) Lt(val Val) Criteria

func (Criteria) Lte

func (c Criteria) Lte(val Val) Criteria

func (Criteria) Ne

func (c Criteria) Ne(val Val) Criteria

func (Criteria) Or

func (c Criteria) Or(cri Base) Where

func (Criteria) Sql

func (c Criteria) Sql() string

type Order

type Order struct {
	Col  string
	Sort sortenum.Sort
}

type Page

type Page struct {
	Orders []Order
	Offset int
	Size   int
}

func P

func P() Page

func (Page) Limit

func (p Page) Limit(offset, size int) Page

func (Page) Order

func (p Page) Order(o Order) Page

func (Page) Sql

func (p Page) Sql() string

Sql order by age desc limit 2,1

type PageRet

type PageRet struct {
	Items    interface{}
	PageNo   int
	PageSize int
	Total    int
	HasNext  bool
}

func NewPageRet

func NewPageRet(page Page) PageRet

type Q

type Q interface {
	Base
	And(q Base) Where
	Or(q Base) Where
	Append(q Base) Where
}

type Val

type Val struct {
	Data interface{}
	Type valtypeenum.ValType
}

func Func

func Func(data string) Val

func Literal

func Literal(data interface{}) Val

type Where

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

func (Where) And

func (w Where) And(whe Base) Where

func (Where) Append

func (w Where) Append(whe Base) Where

func (Where) Or

func (w Where) Or(whe Base) Where

func (Where) Sql

func (w Where) Sql() string