builder

Documentation

Index

• Constants
• func ResolveColumnName(column string) string
• func ResolveColumnNameCollections(columns []string) []string
• func ResolveColumnNameMap(column map[string]interface{}) map[string]interface{}
• func ResolveColumnNameMapInTime(column map[string][]time.Time) map[string][]time.Time
• func ResolveColumnNameMaps(columns []map[string]interface{}) []map[string]interface{}
• type Builder
  • func New() Builder
• type Condition
• type Merge
• type MergeOperation
• type QueryParams
  • func (q *QueryParams) Clone() QueryParams
• type Scanner

Constants

const DateTimeFormat = "2006-01-02 15:04:05"

Functions

func ResolveColumnName

func ResolveColumnName(column string) string

func ResolveColumnNameCollections

func ResolveColumnNameCollections(columns []string) []string

func ResolveColumnNameMap

func ResolveColumnNameMap(column map[string]interface{}) map[string]interface{}

func ResolveColumnNameMapInTime

func ResolveColumnNameMapInTime(column map[string][]time.Time) map[string][]time.Time

func ResolveColumnNameMaps

func ResolveColumnNameMaps(columns []map[string]interface{}) []map[string]interface{}

Types

type Builder

type Builder interface {
	Insert(data map[string]interface{}) Builder
	Update(data map[string]interface{}) Builder
	Upsert(data map[string]interface{}) Builder
	Delete() Builder
	Explain() Builder
	Select(field string) Builder
	Table(table string, alias ...string) Builder
	From(table string, alias ...string) Builder
	Join(table string, on string, alias ...string) Builder
	LeftJoin(table string, on string, alias ...string) Builder
	RightJoin(table string, on string, alias ...string) Builder
	Statement(stmt string, values []interface{}) Builder
	In(in map[string]interface{}) Builder
	InSingleProp(prop string, data interface{}) Builder
	Exists(other Builder, condition Condition) Builder
	Alias(name string) string
	Compare(conditions []Condition) Builder
	CompareSingleProp(condition Condition) Builder
	NotEqual(column string, value interface{}) Builder
	Equal(column string, value interface{}) Builder
	BetweenTime(column string, from, to time.Time) Builder
	Next(id int64) Builder
	Page(index int) Builder
	Size(n int) Builder
	Order(column, direction string) Builder
	Orders(orders map[string]interface{}) Builder
	Group(column string) Builder
	Groups(column []string) Builder
	And() Builder
	Or() Builder
	Not(Builder) Builder
	Status() (int, int, int)
	Reset(section string) Builder
	Build() (string, []interface{})
}

func New

func New() Builder

type Condition

type Condition struct {
	Operator string
	Key      string
	Value    interface{}
}

type Merge

type Merge struct {
	Type      transformer.Type
	Track     string //identifier to check duplicates - or condition
	Operation MergeOperation
}

type MergeOperation

type MergeOperation int

const (
	Identifier MergeOperation = iota
	Statement
)

type QueryParams

type QueryParams struct {
	Object       interface{}
	In           map[string]interface{}
	Notin        map[string]interface{}
	Conditions   []Condition
	Next         int64
	Page         int
	Size         int
	Orderby      map[string]interface{}
	Groupby      []string
	ColumnFilter []string
	Priority     []string
	Merge        *Merge
	BetweenTime  map[string][]time.Time
	IsDistinct   bool
}

func (*QueryParams) Clone

func (q *QueryParams) Clone() QueryParams

type Scanner

type Scanner func(args ...interface{}) error