query

README

Query

Performance

# https://graphviz.org/download/#mac
brew install graphviz

go test -bench=. ./core/lib/utils/query/testgen/. -cpuprofile cpu.prof
go tool pprof -svg cpu.prof > cpu.svg

go test -bench=. -trace trace.out ./core/lib/utils/query/testgen/.
go tool trace trace.out

# Data Race: Two goroutines access the same variable concurrently 
# and at least one of the accesses is a write 
# https://golang.org/doc/articles/race_detector
go test -race

Documentation

Index

• func Union(queries ...*Q) (string, error)
• type IModel
• type Q
  • func Delete(model IModel) *Q
  • func Insert(model IModel) *Q
  • func Query(model IModel) *Q
  • func Select(model IModel) *Q
  • func Update(model IModel) *Q
  • func (q *Q) Alias(alias string) *Q
  • func (q *Q) Count(name, as string) *Q
  • func (q *Q) Field(name string) *Q
  • func (q *Q) FieldAs(name, as string) *Q
  • func (q *Q) FieldRaw(fieldStr, as string) *Q
  • func (q *Q) Fields(fields ...string) *Q
  • func (q *Q) Limit(limit, offset int64) *Q
  • func (q *Q) OrderBy(col, dir string) *Q
  • func (q *Q) Set(fieldName string, value interface{}) *Q
  • func (q *Q) String() (string, error)
  • func (q *Q) Sum(name, as string) *Q
  • func (q *Q) Where(args ...WherePart) *Q
• type QueryType
• type Where
• type WherePart
  • func And(args ...WherePart) WherePart
  • func Between(fieldName string, from, to interface{}) WherePart
  • func EQ(fieldName string, value interface{}) WherePart
  • func EQF(fieldName1, fieldName2 string) WherePart
  • func Exists(clause *Q) WherePart
  • func GT(fieldName string, value interface{}) WherePart
  • func GTOE(fieldName string, value interface{}) WherePart
  • func IN(fieldName string, values ...interface{}) WherePart
  • func INInt64(fieldName string, values []int64) WherePart
  • func INString(fieldName string, values []string) WherePart
  • func LT(fieldName string, value interface{}) WherePart
  • func LTOE(fieldName string, value interface{}) WherePart
  • func Like(fieldName string, value string) WherePart
  • func NE(fieldName string, value interface{}) WherePart
  • func NewWherePart(whereType WhereType, fieldName string, values []interface{}) WherePart
  • func NotLike(fieldName string, value string) WherePart
  • func Or(args ...WherePart) WherePart
  • func PE() WherePart
  • func PS() WherePart
  • func WhereAll() WherePart
• type WhereType

Functions

func Union

func Union(queries ...*Q) (string, error)

Types

type IModel

type IModel interface {
	Table_Name() string
	Table_Columns() []string
	Table_PrimaryKey() string
	Table_PrimaryKey_Value() int64
	Table_InsertColumns() []string
	Table_UpdateColumns() []string
	Table_Column_Types() map[string]string
	String() string
	Update() string
	Create() string
	Destroy() string
	FromID(id int64) string
}

type Q

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

func Delete

func Delete(model IModel) *Q

func Insert

func Insert(model IModel) *Q

func Query

func Query(model IModel) *Q

func Select

func Select(model IModel) *Q

func Update

func Update(model IModel) *Q

func (*Q) Alias

func (q *Q) Alias(alias string) *Q

func (*Q) Count

func (q *Q) Count(name, as string) *Q

func (*Q) Field

func (q *Q) Field(name string) *Q

func (*Q) FieldAs

func (q *Q) FieldAs(name, as string) *Q

func (*Q) FieldRaw

func (q *Q) FieldRaw(fieldStr, as string) *Q

func (*Q) Fields

func (q *Q) Fields(fields ...string) *Q

func (*Q) Limit

func (q *Q) Limit(limit, offset int64) *Q

func (*Q) OrderBy

func (q *Q) OrderBy(col, dir string) *Q

func (*Q) Set

func (q *Q) Set(fieldName string, value interface{}) *Q

func (*Q) String

func (q *Q) String() (string, error)

func (*Q) Sum

func (q *Q) Sum(name, as string) *Q

func (*Q) Where

func (q *Q) Where(args ...WherePart) *Q

Where().Equals("a", "b")

type QueryType

type QueryType int

const (
	QueryTypeNotSet QueryType = iota
	QueryTypeSelect
	QueryTypeUpdate
	QueryTypeDelete
	QueryTypeInsert
)

type Where

type Where struct {
	WhereParts []WherePart
	// contains filtered or unexported fields
}

type WherePart

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

func And

func And(args ...WherePart) WherePart

func Between

func Between(fieldName string, from, to interface{}) WherePart

func EQ

func EQ(fieldName string, value interface{}) WherePart

func EQF

func EQF(fieldName1, fieldName2 string) WherePart

func Exists

func Exists(clause *Q) WherePart

func GT

func GT(fieldName string, value interface{}) WherePart

func GTOE

func GTOE(fieldName string, value interface{}) WherePart

func IN

func IN(fieldName string, values ...interface{}) WherePart

IN is an IN clause

func INInt64

func INInt64(fieldName string, values []int64) WherePart

INInt64 is a helper function for converting a slice of string arguments into a slice of interface arguments, passed into an IN clause and returned

func INString

func INString(fieldName string, values []string) WherePart

INString is a helper function for converting a slice of string arguments into a slice of interface arguments, passed into an IN clause and returned

func LT

func LT(fieldName string, value interface{}) WherePart

func LTOE

func LTOE(fieldName string, value interface{}) WherePart

func Like

func Like(fieldName string, value string) WherePart

func NE

func NE(fieldName string, value interface{}) WherePart

func NewWherePart

func NewWherePart(whereType WhereType, fieldName string, values []interface{}) WherePart

func NotLike

func NotLike(fieldName string, value string) WherePart

func Or

func Or(args ...WherePart) WherePart

func PE

func PE() WherePart

Parenthesis End

func PS

func PS() WherePart

Parenthesis Start

func WhereAll

func WhereAll() WherePart

type WhereType

type WhereType int

const (
	WhereTypeEquals WhereType = iota
	WhereTypeEqualsField
	WhereTypeNotEquals
	WhereTypeGreaterThan
	WhereTypeLessThan
	WhereTypeGreaterThanOrEqualTo
	WhereTypeLessThanOrEqualTo
	WhereTypeBetween
	WhereTypeLike
	WhereTypeNotLike
	WhereTypeIN
	WhereTypeExists
	WhereTypeAnd
	WhereTypeOr
	WhereTypeParenthesisEnd
	WhereTypeParenthesisStart
	// WhereTypeAll is a WHERE clause of `1=1` used for convenience
	// when conditionally adding WHERE clauses starting with a conjunction (AND/OR,etc)
	// separating them.
	// e.g. SELECT * FROM `Foo` WHERE 1=1
	//      SELECT * FROM `Foo` WHERE 1=1 AND FooID = 123;
	WhereTypeAll
)