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 interface{}) Criteria
  • func (c Criteria) Gt(val interface{}) Criteria
  • func (c Criteria) Gte(val interface{}) Criteria
  • func (c Criteria) In(val interface{}) Criteria
  • func (c Criteria) IsNotNull() Criteria
  • func (c Criteria) IsNull() Criteria
  • func (c Criteria) Lt(val interface{}) Criteria
  • func (c Criteria) Lte(val interface{}) Criteria
  • func (c Criteria) Ne(val interface{}) Criteria
  • func (c Criteria) Or(cri Base) Where
  • func (c Criteria) Sql() (string, []interface{})
• 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, []interface{})
• type PageRet
  • func NewPageRet(page Page) PageRet
• type Q
• type String
  • func (s String) Sql() (string, []interface{})
• 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, []interface{})

Examples

• Criteria

Types

type Base

type Base interface {
	Sql() (string, []interface{})
}

Base sql expression

type Criteria

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

Criteria wrap a group of column, value and operator such as name = 20

Example

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

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

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

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

query = C().Col("name").Eq("wubin").Or(C().Col("age").In([]int{5, 10})).And(C().Col("delete_at").IsNotNull())
fmt.Println(query.Sql())

query = C().Col("name").Ne("wubin").Or(C().Col("create_at").Lt("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("wubin").Or(C().Col("school").Eq("havard")).
	And(C().Col("age").Eq(18)).
	Or(C().Col("score").Gte(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(1)
where = where.And(C().Col("delete_at").IsNull())
where = where.Append(page)
fmt.Println(where.Sql())

where = C().Col("project_id").Eq(1)
where = where.And(C().Col("delete_at").IsNull())
where = where.Append(String("for update"))
fmt.Println(where.Sql())

where = C().Col("cc.project_id").Eq(1)
where = where.And(C().Col("cc.delete_at").IsNull())
where = where.Append(String("for update"))
fmt.Println(where.Sql())

where = C().Col("cc.survey_id").Eq("abc").
	And(C().Col("cc.year").Eq(2021)).
	And(C().Col("cc.month").Eq(10)).
	And(C().Col("cc.stat_type").Eq(2)).Append(String("for update"))
fmt.Println(where.Sql())

Output:

((`name` = ? or `school` = ?) and `age` = ?) [wubin havard 18]
((`name` = ? or `school` = ?) and `delete_at` is not null) [wubin havard]
((`name` = ? or `school` in (?)) and `delete_at` is not null) [wubin havard]
((`name` = ? or `school` in (?,?)) and `delete_at` is not null) [wubin havard beijing unv]
((`name` = ? or `age` in (?,?)) and `delete_at` is not null) [wubin 5 10]
(`name` != ? or `create_at` < ?) [wubin now()]
order by `create_at` desc,`score` asc limit ?,? [30 5]
7
order by `score` asc limit ?,? [20 10]
(((`name` = ? or `school` = ?) and `age` = ?) or `score` >= ?) [wubin havard 18 90]
(`project_id` = ? and `delete_at` is null) order by `create_at` desc limit ?,? [1 0 1]
(`project_id` = ? and `delete_at` is null) for update [1]
(cc.`project_id` = ? and cc.`delete_at` is null) for update [1]
(((cc.`survey_id` = ? and cc.`year` = ?) and cc.`month` = ?) and cc.`stat_type` = ?) for update [abc 2021 10 2]

func C

func C() Criteria

C new a Criteria

func (Criteria) And

func (c Criteria) And(cri Base) Where

And concat another sql expression builder with And

func (Criteria) Append

func (c Criteria) Append(cri Base) Where

Append concat another sql expression builder with Append

func (Criteria) Col

func (c Criteria) Col(col string) Criteria

Col set column name

func (Criteria) Eq

func (c Criteria) Eq(val interface{}) Criteria

Eq set = operator and column value

func (Criteria) Gt

func (c Criteria) Gt(val interface{}) Criteria

Gt set > operator and column value

func (Criteria) Gte

func (c Criteria) Gte(val interface{}) Criteria

Gte set >= operator and column value

func (Criteria) In

func (c Criteria) In(val interface{}) Criteria

In set in operator and column value, val should be a slice type value

func (Criteria) IsNotNull

func (c Criteria) IsNotNull() Criteria

IsNotNull set is not null

func (Criteria) IsNull

func (c Criteria) IsNull() Criteria

IsNull set is null

func (Criteria) Lt

func (c Criteria) Lt(val interface{}) Criteria

Lt set < operator and column value

func (Criteria) Lte

func (c Criteria) Lte(val interface{}) Criteria

Lte set <= operator and column value

func (Criteria) Ne

func (c Criteria) Ne(val interface{}) Criteria

Ne set != operator and column value

func (Criteria) Or

func (c Criteria) Or(cri Base) Where

Or concat another sql expression builder with Or

func (Criteria) Sql

func (c Criteria) Sql() (string, []interface{})

Sql implement Base interface, return sql expression

type Order

type Order struct {
	Col  string
	Sort sortenum.Sort
}

Order by Col Sort

type Page

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

Page a sql expression builder for order by clause

func P

func P() Page

P new a Page

func (Page) Limit

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

Limit set Offset and Size

func (Page) Order

func (p Page) Order(o Order) Page

Order append an Order

func (Page) Sql

func (p Page) Sql() (string, []interface{})

Sql implement Base interface, order by age desc limit 2,1

type PageRet

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

PageRet wrap page query result

func NewPageRet

func NewPageRet(page Page) PageRet

NewPageRet new a PageRet

type Q

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

Q used for building sql expression

type String

type String string

String is an alias of string

func (String) Sql

func (s String) Sql() (string, []interface{})

Sql implements Base

type Where

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

Where concat children clauses with one of logic operators And, Or, Append

func (Where) And

func (w Where) And(whe Base) Where

And concat another sql expression builder with And

func (Where) Append

func (w Where) Append(whe Base) Where

Append concat another sql expression builder with Append

func (Where) Or

func (w Where) Or(whe Base) Where

Or concat another sql expression builder with Or

func (Where) Sql

func (w Where) Sql() (string, []interface{})

Sql implement Base interface, return string sql expression