builder

package
v1.6.4 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Nov 2, 2023 License: Apache-2.0 Imports: 19 Imported by: 0

Documentation

Index

Constants

View Source 
const (
	ToggleNeedAutoAlias = "NeedAlias"
	ToggleMultiTable    = "MultiTable"
	ToggleUseValues     = "UseValues"
)

Variables

View Source 
var (
	RtModel        = reflect.TypeOf((*Model)(nil)).Elem()
	RtDriverValuer = reflect.TypeOf((*driver.Valuer)(nil)).Elem()
)

Functions

func Alias 

func Alias(e SqlExpr, name string) *alias

func AsAddition 

func AsAddition(e SqlExpr) *addition

func Comment 

func Comment(text string) *comment

func ContextWithToggleMultiTable 

func ContextWithToggleMultiTable(ctx context.Context, v bool) context.Context

func ContextWithToggleNeedAutoAlias 

func ContextWithToggleNeedAutoAlias(ctx context.Context, v bool) context.Context

func ContextWithToggleUseValues 

func ContextWithToggleUseValues(ctx context.Context, v bool) context.Context

func ContextWithToggles 

func ContextWithToggles(ctx context.Context, toggles Toggles) context.Context

func CrossJoin 

func CrossJoin(tar SqlExpr) *join

func EachField 

func EachField(ctx context.Context, t typesx.Type, each func(*StructField) bool)

func ForEachFieldValue 

func ForEachFieldValue(ctx context.Context, v interface{}, fn func(*FieldValue))

func ForUpdate 

func ForUpdate() *addition

func FullJoin 

func FullJoin(tar SqlExpr) *join

func GetColumnName 

func GetColumnName(name, tag string) string

func GroupBy 

func GroupBy(grps ...SqlExpr) *groupby

func InnerJoin 

func InnerJoin(tar SqlExpr) *join

func IsNilExpr 

func IsNilExpr(e SqlExpr) bool

func Join 

func Join(tar SqlExpr, prefixes ...string) *join

func LeftJoin 

func LeftJoin(tar SqlExpr) *join

func Limit 

func Limit(count int64) *limit

func OnConflict 

func OnConflict(cols *Columns) *onconflict

func OrderBy 

func OrderBy(orders ...*Order) *orderby

func RightJoin 

func RightJoin(tar SqlExpr) *join

func ScanDefToTable 

func ScanDefToTable(tbl *Table, i interface{})

func SplitIndexNameAndMethod 

func SplitIndexNameAndMethod(v string) (string, string)

SplitIndexNameAndMethod @def index name/method

func TableAliasFromContext 

func TableAliasFromContext(ctx context.Context) (string, bool)

func TableNameFromContext 

func TableNameFromContext(ctx context.Context) (string, bool)

func ToMap 

func ToMap(lst []string) map[string]bool

func Where 

func Where(c SqlCondition) *where

func WithTabelAlias 

func WithTabelAlias(tbl string) func(ctx context.Context) context.Context

func WithTableName 

func WithTableName(tbl string) func(ctx context.Context) context.Context

func WriteAdditions 

func WriteAdditions(e *Ex, adds ...Addition)

func WriteAssignments 

func WriteAssignments(e *Ex, assignments ...*Assignment)

Types

type Addition 

type Addition interface {
	SqlExpr
	AdditionKind() AdditionType
}

type AdditionType 

type AdditionType int
const (
	AdditionJoin AdditionType = iota
	AdditionWhere
	AdditionGroupBy
	AdditionCombination
	AdditionOrderBy
	AdditionLimit
	AdditionOnConflict
	AdditionOther
	AdditionComment
)

func (AdditionType) AdditionKind 

func (t AdditionType) AdditionKind() AdditionType

type Additions 

type Additions []Addition

func (Additions) Len 

func (adds Additions) Len() int

func (Additions) Less 

func (adds Additions) Less(i, j int) bool

func (Additions) Swap 

func (adds Additions) Swap(i, j int)

type Assignment 

type Assignment struct {
	AssignmentMarker
	// contains filtered or unexported fields
}

func ColumnsAndValues 

func ColumnsAndValues(columns SqlExpr, values ...interface{}) *Assignment

func (*Assignment) Ex 

func (a *Assignment) Ex(ctx context.Context) *Ex

func (*Assignment) IsNil 

func (a *Assignment) IsNil() bool

type AssignmentMarker 

type AssignmentMarker interface {
	// contains filtered or unexported methods
}

type Assignments 

type Assignments []*Assignment

type Column 

type Column struct {
	Name      string
	FieldName string
	Table     *Table

	*ColumnType
	// contains filtered or unexported fields
}

func Col 

func Col(name string) *Column

func (*Column) Between 

func (c *Column) Between(l, r interface{}) SqlCondition

func (*Column) Dec 

func (c *Column) Dec(d int) SqlExpr

func (*Column) Eq 

func (c *Column) Eq(v interface{}) SqlCondition

func (*Column) Ex 

func (c *Column) Ex(ctx context.Context) *Ex

func (*Column) Expr 

func (c *Column) Expr(query string, args ...interface{}) *Ex

func (Column) Field 

func (c Column) Field(name string) *Column

func (*Column) Gt 

func (c *Column) Gt(v interface{}) SqlCondition

func (*Column) Gte 

func (c *Column) Gte(v interface{}) SqlCondition

func (*Column) In 

func (c *Column) In(args ...interface{}) SqlCondition

func (*Column) Inc 

func (c *Column) Inc(d int) SqlExpr

func (*Column) IsNil 

func (c *Column) IsNil() bool

func (*Column) IsNotNull 

func (c *Column) IsNotNull() SqlCondition

func (*Column) IsNull 

func (c *Column) IsNull() SqlCondition

func (*Column) LLike 

func (c *Column) LLike(v string) SqlCondition

func (*Column) Like 

func (c *Column) Like(v string) SqlCondition

func (*Column) Lt 

func (c *Column) Lt(v interface{}) SqlCondition

func (*Column) Lte 

func (c *Column) Lte(v interface{}) SqlCondition

func (*Column) Neq 

func (c *Column) Neq(v interface{}) SqlCondition

func (*Column) NotBetween 

func (c *Column) NotBetween(l, r interface{}) SqlCondition

func (*Column) NotIn 

func (c *Column) NotIn(args ...interface{}) SqlCondition

func (*Column) NotLike 

func (c *Column) NotLike(v string) SqlCondition

func (Column) Of 

func (c Column) Of(t *Table) *Column

func (Column) On 

func (c Column) On(t *Table) *Column

func (*Column) RLike 

func (c *Column) RLike(v string) SqlCondition

func (*Column) T 

func (c *Column) T() *Table

func (Column) Type 

func (c Column) Type(v interface{}, tag string) *Column

func (*Column) ValueBy 

func (c *Column) ValueBy(v interface{}) *Assignment

type ColumnType 

type ColumnType struct {
	Type           typesx.Type
	DataType       string
	Length         uint64
	Decimal        uint64
	Default        *string
	OnUpdate       *string
	Null           bool
	AutoIncrement  bool
	Comment        string
	Desc           []string
	Rel            []string
	DeprecatedActs *DeprecatedActs
}

func AnalyzeColumnType 

func AnalyzeColumnType(t typesx.Type, tag string) *ColumnType

type Columns 

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

func Cols 

func Cols(names ...string) *Columns

func (*Columns) Add 

func (c *Columns) Add(cols ...*Column)

func (*Columns) AutoIncrement 

func (c *Columns) AutoIncrement() *Column

func (*Columns) Clone 

func (c *Columns) Clone() *Columns

func (*Columns) Col 

func (c *Columns) Col(name string) *Column

func (*Columns) ColByFieldName 

func (c *Columns) ColByFieldName(name string) *Column

func (*Columns) ColNames 

func (c *Columns) ColNames() []string

func (*Columns) Cols 

func (c *Columns) Cols(names ...string) (*Columns, error)

func (*Columns) ColsByFieldNames 

func (c *Columns) ColsByFieldNames(names ...string) (*Columns, error)

func (*Columns) Ex 

func (c *Columns) Ex(ctx context.Context) *Ex

func (*Columns) FieldNames 

func (c *Columns) FieldNames() []string

func (*Columns) IsNil 

func (c *Columns) IsNil() bool

func (*Columns) Len 

func (c *Columns) Len() int

func (*Columns) List 

func (c *Columns) List() []*Column

func (*Columns) MustCols 

func (c *Columns) MustCols(names ...string) *Columns

func (*Columns) MustColsByFieldNames 

func (c *Columns) MustColsByFieldNames(names ...string) *Columns

func (*Columns) Range 

func (c *Columns) Range(f func(*Column, int))

type CondCompose 

type CondCompose struct {
	SqlConditionMarker
	// contains filtered or unexported fields
}

func ComposeConditions 

func ComposeConditions(op string, conds ...SqlCondition) *CondCompose

func (*CondCompose) And 

func (c *CondCompose) And(cond SqlCondition) SqlCondition

func (*CondCompose) Ex 

func (c *CondCompose) Ex(ctx context.Context) *Ex

func (*CondCompose) IsNil 

func (c *CondCompose) IsNil() bool

func (*CondCompose) Or 

func (c *CondCompose) Or(cond SqlCondition) SqlCondition

func (*CondCompose) Xor 

func (c *CondCompose) Xor(cond SqlCondition) SqlCondition

type Condition 

type Condition struct {
	SqlConditionMarker
	// contains filtered or unexported fields
}

func AsCond 

func AsCond(e SqlExpr) *Condition

func (*Condition) And 

func (c *Condition) And(cond SqlCondition) SqlCondition

func (*Condition) Ex 

func (c *Condition) Ex(ctx context.Context) *Ex

func (*Condition) IsNil 

func (c *Condition) IsNil() bool

func (*Condition) Or 

func (c *Condition) Or(cond SqlCondition) SqlCondition

func (*Condition) Xor 

func (c *Condition) Xor(cond SqlCondition) SqlCondition

type DataTypeDescriber 

type DataTypeDescriber interface {
	DataType(driver string) string
}

type DeprecatedActs 

type DeprecatedActs struct {
	RenameTo string `name:"rename"`
}

type Dialect 

type Dialect interface {
	DriverName() string
	PrimaryKeyName() string
	IsErrorUnknownDatabase(error) bool
	IsErrorConflict(error) bool
	CreateDatabase(string) SqlExpr
	CreateSchema(string) SqlExpr
	DropDatabase(string) SqlExpr
	CreateTableIsNotExists(t *Table) []SqlExpr
	DropTable(*Table) SqlExpr
	TruncateTable(*Table) SqlExpr
	AddColumn(*Column) SqlExpr
	RenameColumn(*Column, *Column) SqlExpr
	ModifyColumn(*Column, *Column) SqlExpr
	DropColumn(*Column) SqlExpr
	AddIndex(*Key) SqlExpr
	DropIndex(*Key) SqlExpr
	DataType(*ColumnType) SqlExpr
}

type Ex 

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

func ColumnsByStruct 

func ColumnsByStruct(v interface{}) *Ex

func ExactlyExpr 

func ExactlyExpr(query string, args ...interface{}) *Ex

func Expr 

func Expr(query string, args ...interface{}) *Ex

func ResolveExpr 

func ResolveExpr(v interface{}) *Ex

func ResolveExprContext 

func ResolveExprContext(ctx context.Context, v interface{}) *Ex

func (*Ex) AppendArgs 

func (e *Ex) AppendArgs(args ...interface{})

func (*Ex) Args 

func (e *Ex) Args() []interface{}

func (*Ex) ArgsLen 

func (e *Ex) ArgsLen() int

func (*Ex) Err 

func (e *Ex) Err() error

func (*Ex) Ex 

func (e *Ex) Ex(ctx context.Context) *Ex

func (*Ex) Grow 

func (e *Ex) Grow(n int)

func (*Ex) IsNil 

func (e *Ex) IsNil() bool

func (*Ex) Query 

func (e *Ex) Query() string

func (*Ex) SetExactly 

func (e *Ex) SetExactly(exactly bool)

func (*Ex) WriteComments 

func (e *Ex) WriteComments(comments []byte)

func (*Ex) WriteEnd 

func (e *Ex) WriteEnd()

func (*Ex) WriteExpr 

func (e *Ex) WriteExpr(expr SqlExpr)

func (*Ex) WriteGroup 

func (e *Ex) WriteGroup(f func(e *Ex))

func (*Ex) WriteHolder 

func (e *Ex) WriteHolder(idx int)

func (*Ex) WriteQuery 

func (e *Ex) WriteQuery(query string)

func (*Ex) WriteQueryByte 

func (e *Ex) WriteQueryByte(b byte)

func (*Ex) WriteQueryRune 

func (e *Ex) WriteQueryRune(r rune)

type FieldValue 

type FieldValue struct {
	Field     StructField
	TableName string
	Value     reflect.Value
}

type FieldValues 

type FieldValues map[string]interface{}

func FieldValueFromStruct 

func FieldValueFromStruct(v interface{}, names []string) FieldValues

func FieldValueFromStructByNoneZero 

func FieldValueFromStructByNoneZero(v interface{}, excludes ...string) FieldValues

type FieldsFactory 

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

func (*FieldsFactory) TableFieldsFor 

func (ft *FieldsFactory) TableFieldsFor(ctx context.Context, t typesx.Type) []*StructField

type Function 

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

func Avg 

func Avg(es ...SqlExpr) *Function

func Count 

func Count(es ...SqlExpr) *Function

func Distinct 

func Distinct(es ...SqlExpr) *Function

func First 

func First(es ...SqlExpr) *Function

func Func 

func Func(name string, es ...SqlExpr) *Function

func Last 

func Last(es ...SqlExpr) *Function

func Max 

func Max(es ...SqlExpr) *Function

func Min 

func Min(es ...SqlExpr) *Function

func Sum 

func Sum(es ...SqlExpr) *Function

func (*Function) Ex 

func (f *Function) Ex(ctx context.Context) *Ex

func (*Function) IsNil 

func (f *Function) IsNil() bool

type IndexDef 

type IndexDef struct {
	FieldNames []string
	ColNames   []string
	Expr       string
}

IndexDef @def index xxx/BTREE FieldA FieldB ...

func ParseIndexDef 

func ParseIndexDef(names ...string) *IndexDef

func (IndexDef) TableExpr 

func (i IndexDef) TableExpr(t *Table) *Ex

func (IndexDef) ToDefs 

func (i IndexDef) ToDefs() []string

type IndexDefine 

type IndexDefine struct {
	Kind   string
	Name   string
	Method string
	IndexDef
}

func ParseIndexDefine 

func ParseIndexDefine(def string) *IndexDefine

func (IndexDefine) ID 

func (i IndexDefine) ID() string

type Indexes 

type Indexes map[string][]string

type Key 

type Key struct {
	Table    *Table
	Name     string
	IsUnique bool
	Method   string
	Def      IndexDef
}

func Index 

func Index(name string, cols *Columns, exprs ...string) *Key

func PrimaryKey 

func PrimaryKey(cols *Columns) *Key

func UniqueIndex 

func UniqueIndex(name string, cols *Columns, exprs ...string) *Key

func (Key) IsPrimary 

func (k Key) IsPrimary() bool

func (Key) On 

func (k Key) On(t *Table) *Key

func (*Key) T 

func (k *Key) T() *Table

func (Key) Using 

func (k Key) Using(method string) *Key

type Keys 

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

func (*Keys) Add 

func (ks *Keys) Add(keys ...*Key)

func (*Keys) Clone 

func (ks *Keys) Clone() *Keys

func (*Keys) Key 

func (ks *Keys) Key(name string) *Key

func (*Keys) Len 

func (ks *Keys) Len() int

func (*Keys) Range 

func (ks *Keys) Range(f func(k *Key, idx int))

type Model 

type Model interface {
	TableName() string
}

type Order 

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

func AscOrder 

func AscOrder(target SqlExpr) *Order

func DescOrder 

func DescOrder(target SqlExpr) *Order

func (*Order) Ex 

func (o *Order) Ex(ctx context.Context) *Ex

func (*Order) IsNil 

func (o *Order) IsNil() bool

type SelectStatement 

type SelectStatement interface {
	SqlExpr
	// contains filtered or unexported methods
}

type SqlAssignment 

type SqlAssignment interface {
	SqlExpr
	AssignmentMarker
}

type SqlCondition 

type SqlCondition interface {
	SqlExpr
	SqlConditionMarker

	And(SqlCondition) SqlCondition
	Or(SqlCondition) SqlCondition
	Xor(SqlCondition) SqlCondition
}
var EmptyCondition SqlCondition = (*Condition)(nil)

func And 

func And(conds ...SqlCondition) SqlCondition

func Or 

func Or(conds ...SqlCondition) SqlCondition

func Xor 

func Xor(conds ...SqlCondition) SqlCondition

type SqlConditionMarker 

type SqlConditionMarker interface {
	// contains filtered or unexported methods
}

type SqlExpr 

type SqlExpr interface {
	IsNil() bool
	Ex(ctx context.Context) *Ex
}

func ExprBy 

func ExprBy(build func(context.Context) *Ex) SqlExpr

func Multi 

func Multi(es ...SqlExpr) SqlExpr

func MultiWith 

func MultiWith(connector string, es ...SqlExpr) SqlExpr

type StmtDelete 

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

func Delete 

func Delete() *StmtDelete

func (*StmtDelete) Ex 

func (s *StmtDelete) Ex(ctx context.Context) *Ex

func (StmtDelete) From 

func (s StmtDelete) From(tbl *Table, adds ...Addition) *StmtDelete

func (*StmtDelete) IsNil 

func (s *StmtDelete) IsNil() bool

type StmtInsert 

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

func Insert 

func Insert(modifiers ...string) *StmtInsert

func (*StmtInsert) Ex 

func (s *StmtInsert) Ex(ctx context.Context) *Ex

func (StmtInsert) Into 

func (s StmtInsert) Into(tbl *Table, adds ...Addition) *StmtInsert

func (*StmtInsert) IsNil 

func (s *StmtInsert) IsNil() bool

func (StmtInsert) Values 

func (s StmtInsert) Values(cols *Columns, values ...interface{}) *StmtInsert

type StmtSelect 

type StmtSelect struct {
	SelectStatement
	// contains filtered or unexported fields
}

func Select 

func Select(e SqlExpr, modifiers ...string) *StmtSelect

func (*StmtSelect) Ex 

func (s *StmtSelect) Ex(ctx context.Context) *Ex

func (StmtSelect) From 

func (s StmtSelect) From(tbl *Table, adds ...Addition) *StmtSelect

func (*StmtSelect) IsNil 

func (s *StmtSelect) IsNil() bool

type StmtUpdate 

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

func Update 

func Update(tbl *Table, modifiers ...string) *StmtUpdate

func (*StmtUpdate) Ex 

func (s *StmtUpdate) Ex(ctx context.Context) *Ex

func (*StmtUpdate) IsNil 

func (s *StmtUpdate) IsNil() bool

func (StmtUpdate) Set 

func (s StmtUpdate) Set(assignments ...*Assignment) *StmtUpdate

func (StmtUpdate) Where 

func (s StmtUpdate) Where(c SqlCondition, adds ...Addition) *StmtUpdate

type StructField 

type StructField struct {
	Name       string
	FieldName  string
	Type       typesx.Type
	Field      typesx.StructField
	Tags       map[string]reflectx.StructTag
	Loc        []int
	ModelLoc   []int
	ColumnType ColumnType
}

func StructFieldsFor 

func StructFieldsFor(ctx context.Context, t typesx.Type) []*StructField

func (*StructField) FieldModelValue 

func (sf *StructField) FieldModelValue(v reflect.Value) reflect.Value

func (*StructField) FieldValue 

func (sf *StructField) FieldValue(v reflect.Value) reflect.Value

type Table 

type Table struct {
	Name      string
	Desc      []string
	Schema    string
	ModelName string
	Model     Model

	Columns
	Keys
}

func T 

func T(tblName string, defs ...TableDefinition) *Table

func TableFromModel 

func TableFromModel(m Model) *Table

func (*Table) AddCol 

func (t *Table) AddCol(c *Column)

func (*Table) AddKey 

func (t *Table) AddKey(k *Key)

func (*Table) AssignmentsByFieldValues 

func (t *Table) AssignmentsByFieldValues(fvs FieldValues) Assignments

func (*Table) ColumnsAndValuesByFieldValues 

func (t *Table) ColumnsAndValuesByFieldValues(fvs FieldValues) (*Columns, []interface{})

func (*Table) Diff 

func (t *Table) Diff(prevT *Table, d Dialect) (exprList []SqlExpr)

func (*Table) Ex 

func (t *Table) Ex(ctx context.Context) *Ex

func (*Table) Expr 

func (t *Table) Expr(query string, args ...interface{}) *Ex

func (*Table) IsNil 

func (t *Table) IsNil() bool

func (*Table) TableName 

func (t *Table) TableName() string

func (Table) WithSchema 

func (t Table) WithSchema(schema string) *Table

type TableDefinition 

type TableDefinition interface{ T() *Table }

type Tables 

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

func (*Tables) Add 

func (t *Tables) Add(tables ...*Table)

func (*Tables) Model 

func (t *Tables) Model(typename string) *Table

func (*Tables) Range 

func (t *Tables) Range(f func(*Table, int))

func (*Tables) Remove 

func (t *Tables) Remove(name string)

func (*Tables) Table 

func (t *Tables) Table(name string) *Table

func (*Tables) TableNames 

func (t *Tables) TableNames() []string

type Toggles 

type Toggles map[string]bool

func TogglesFromContext 

func TogglesFromContext(ctx context.Context) Toggles

func (Toggles) Is 

func (toggles Toggles) Is(k string) bool

func (Toggles) Merge 

func (toggles Toggles) Merge(follows Toggles) Toggles

type ValueExpr 

type ValueExpr interface {
	ValueEx() string
}

type WithColDesc 

type WithColDesc interface {
	ColDesc() map[string][]string
}

type WithColRel 

type WithColRel interface {
	ColRel() map[string][]string
}

type WithComments 

type WithComments interface {
	Comments() map[string]string
}

type WithIndexes 

type WithIndexes interface {
	Indexes() Indexes
}

type WithPrimaryKey 

type WithPrimaryKey interface {
	PrimaryKey() []string
}

type WithTableDesc 

type WithTableDesc interface {
	TableDesc() []string
}

type WithUniqueIndexes 

type WithUniqueIndexes interface {
	UniqueIndexes() Indexes
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.