statements

package
v1.3.5 Latest Latest
Warning

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

 Go to latest Published: Sep 17, 2023 License: BSD-3-Clause Imports: 18 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source 
var (
	// ErrConditionType condition type unsupported
	ErrConditionType = errors.New("Unsupported condition type")
	// ErrUnSupportedSQLType parameter of SQL is not supported
	ErrUnSupportedSQLType = errors.New("Unsupported sql type")
	// ErrUnSupportedType unsupported error
	ErrUnSupportedType = errors.New("Unsupported type error")
	// ErrTableNotFound table not found error
	ErrTableNotFound = errors.New("Table not found")
)
View Source 
var ErrNoColumnName = errors.New("no column name")
View Source 
var ErrNoColumnsTobeUpdated = errors.New("no columns found to be updated")
View Source 
var ErrNotImplemented = errors.New("Not implemented")

ErrNotImplemented not implemented

Functions

func IsIDConditionWithNoTableErr 

func IsIDConditionWithNoTableErr(err error) bool

IsIDConditionWithNoTableErr return true if the err is ErrIDConditionWithNoTable

Types

type ErrIDConditionWithNoTable 

type ErrIDConditionWithNoTable struct {
	ID schemas.PK
}

ErrIDConditionWithNoTable represents an error there is no reference table with an ID condition

func (ErrIDConditionWithNoTable) Error 

func (err ErrIDConditionWithNoTable) Error() string

type ErrUnsupportedExprType 

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

ErrUnsupportedExprType represents an error with unsupported express type

func (ErrUnsupportedExprType) Error 

func (err ErrUnsupportedExprType) Error() string

type Expr 

type Expr struct {
	ColName string
	Arg     interface{}
}

Expr represents an SQL express

func (*Expr) WriteArgs 

func (expr *Expr) WriteArgs(w *builder.BytesWriter) error

WriteArgs writes args to the writer

type QuoteReplacer 

type QuoteReplacer struct {
	*builder.BytesWriter
	// contains filtered or unexported fields
}

func (*QuoteReplacer) Write 

func (q *QuoteReplacer) Write(p []byte) (n int, err error)

type Statement 

type Statement struct {
	RefTable *schemas.Table

	Start  int
	LimitN *int

	GroupByStr string
	HavingStr  string
	SelectStr  string

	AltTableName string

	RawSQL          string
	RawParams       []interface{}
	UseCascade      bool
	UseAutoJoin     bool
	StoreEngine     string
	Charset         string
	UseCache        bool
	UseAutoTime     bool
	NoAutoCondition bool
	IsDistinct      bool
	IsForUpdate     bool
	TableAlias      string

	CheckVersion bool

	ColumnMap      columnMap
	CountColumnMap columnMap
	OmitColumnMap  columnMap
	MustColumnMap  map[string]bool
	NullableMap    map[string]bool
	IncrColumns    exprParams
	DecrColumns    exprParams
	ExprColumns    exprParams

	BufferSize int
	Context    contexts.ContextCache
	LastError  error
	// contains filtered or unexported fields
}

Statement save all the sql info for executing SQL

func NewStatement 

func NewStatement(dialect dialects.Dialect, tagParser *tags.Parser, defaultTimeZone *time.Location) *Statement

NewStatement creates a new statement

func (*Statement) Alias 

func (statement *Statement) Alias(alias string) *Statement

Alias set the table alias

func (*Statement) AllCols 

func (statement *Statement) AllCols() *Statement

AllCols update use only: update all columns

func (*Statement) And 

func (statement *Statement) And(query interface{}, args ...interface{}) *Statement

And add Where & and statement

func (*Statement) Asc 

func (statement *Statement) Asc(colNames ...string) *Statement

Asc provide asc order by query condition, the input parameters are columns.

func (*Statement) BuildConds 

func (statement *Statement) BuildConds(table *schemas.Table, bean interface{}, includeVersion bool, includeUpdated bool, includeNil bool, includeAutoIncr bool, addedTableName bool) (builder.Cond, error)

BuildConds builds condition

func (*Statement) BuildUpdates 

func (statement *Statement) BuildUpdates(tableValue reflect.Value,
	includeVersion, includeUpdated, includeNil,
	includeAutoIncr, update bool,
) ([]string, []interface{}, error)

BuildUpdates auto generating update columnes and values according a struct

func (*Statement) Cols 

func (statement *Statement) Cols(columns ...string) *Statement

Cols generate "col1, col2" statement

func (*Statement) ColumnStr 

func (statement *Statement) ColumnStr() string

ColumnStr returns column string

func (*Statement) CondDeleted 

func (statement *Statement) CondDeleted(col *schemas.Column) builder.Cond

CondDeleted returns the conditions whether a record is soft deleted.

func (*Statement) Conds 

func (statement *Statement) Conds() builder.Cond

Conds returns condtions

func (*Statement) ConvertIDSQL 

func (statement *Statement) ConvertIDSQL(sqlStr string) string

ConvertIDSQL converts SQL with id

func (*Statement) ConvertSQLOrArgs 

func (statement *Statement) ConvertSQLOrArgs(sqlOrArgs ...interface{}) (string, []interface{}, error)

ConvertSQLOrArgs converts sql or args

func (*Statement) ConvertUpdateSQL 

func (statement *Statement) ConvertUpdateSQL(sqlStr string) (string, string)

ConvertUpdateSQL converts update SQL

func (*Statement) CountCols 

func (statement *Statement) CountCols(columns ...string) *Statement

CountColumnMap generate "col1, col2" statement

func (*Statement) CountColumnStr 

func (statement *Statement) CountColumnStr() string

CountColumnStr returns count column string

func (*Statement) Decr 

func (statement *Statement) Decr(column string, arg ...interface{}) *Statement

Decr Generate "Update ... Set column = column - arg" statement

func (*Statement) Desc 

func (statement *Statement) Desc(colNames ...string) *Statement

Desc generate `ORDER BY xx DESC`

func (*Statement) Distinct 

func (statement *Statement) Distinct(columns ...string) *Statement

Distinct generates "DISTINCT col1, col2 " statement

func (*Statement) ForUpdate 

func (statement *Statement) ForUpdate() *Statement

ForUpdate generates "SELECT ... FOR UPDATE" statement

func (*Statement) GenConditionsFromMap 

func (statement *Statement) GenConditionsFromMap(m interface{}) ([]builder.Cond, error)

func (*Statement) GenCountSQL 

func (statement *Statement) GenCountSQL(beans ...interface{}) (string, []interface{}, error)

GenCountSQL generates the SQL for counting

func (*Statement) GenDelIndexSQL 

func (statement *Statement) GenDelIndexSQL() []string

GenDelIndexSQL generate delete index SQL

func (*Statement) GenExistSQL 

func (statement *Statement) GenExistSQL(bean ...interface{}) (string, []interface{}, error)

GenExistSQL generates Exist SQL

func (*Statement) GenFindSQL 

func (statement *Statement) GenFindSQL(autoCond builder.Cond) (string, []interface{}, error)

GenFindSQL generates Find SQL

func (*Statement) GenGetSQL 

func (statement *Statement) GenGetSQL(bean interface{}) (string, []interface{}, error)

GenGetSQL generates Get SQL

func (*Statement) GenIndexSQL 

func (statement *Statement) GenIndexSQL() []string

GenIndexSQL generated create index SQL

func (*Statement) GenInsertMapSQL 

func (statement *Statement) GenInsertMapSQL(columns []string, args []interface{}) (string, []interface{}, error)

GenInsertMapSQL generates insert map SQL

func (*Statement) GenInsertMultipleMapSQL 

func (statement *Statement) GenInsertMultipleMapSQL(columns []string, argss [][]interface{}) (string, []interface{}, error)

func (*Statement) GenInsertSQL 

func (statement *Statement) GenInsertSQL(colNames []string, args []interface{}) (string, []interface{}, error)

GenInsertSQL generates insert beans SQL

func (*Statement) GenQuerySQL 

func (statement *Statement) GenQuerySQL(sqlOrArgs ...interface{}) (string, []interface{}, error)

GenQuerySQL generate query SQL

func (*Statement) GenRawSQL 

func (statement *Statement) GenRawSQL() string

GenRawSQL generates correct raw sql

func (*Statement) GenSumSQL 

func (statement *Statement) GenSumSQL(bean interface{}, columns ...string) (string, []interface{}, error)

GenSumSQL generates sum SQL

func (*Statement) GenUniqueSQL 

func (statement *Statement) GenUniqueSQL() []string

GenUniqueSQL generates unique SQL

func (*Statement) GetUnscoped 

func (statement *Statement) GetUnscoped() bool

GetUnscoped return true if it's unscoped

func (*Statement) GroupBy 

func (statement *Statement) GroupBy(keys string) *Statement

GroupBy generate "Group By keys" statement

func (*Statement) HasOrderBy 

func (statement *Statement) HasOrderBy() bool

func (*Statement) Having 

func (statement *Statement) Having(conditions string) *Statement

Having generate "Having conditions" statement

func (*Statement) ID 

func (statement *Statement) ID(id interface{}) *Statement

ID generate "where id = ? " statement or for composite key "where key1 = ? and key2 = ?"

func (*Statement) In 

func (statement *Statement) In(column string, args ...interface{}) *Statement

In generate "Where column IN (?) " statement

func (*Statement) Incr 

func (statement *Statement) Incr(column string, arg ...interface{}) *Statement

Incr Generate "Update ... Set column = column + arg" statement

func (*Statement) Join 

func (statement *Statement) Join(joinOP string, joinTable interface{}, condition interface{}, args ...interface{}) *Statement

Join The joinOP should be one of INNER, LEFT OUTER, CROSS etc - this will be prepended to JOIN

func (*Statement) Limit 

func (statement *Statement) Limit(limit int, start ...int) *Statement

Limit generate LIMIT start, limit statement

func (*Statement) MergeConds 

func (statement *Statement) MergeConds(bean interface{}) error

MergeConds merge conditions from bean and id

func (*Statement) MustCols 

func (statement *Statement) MustCols(columns ...string) *Statement

MustCols update use only: must update columns

func (*Statement) NeedTableName 

func (statement *Statement) NeedTableName() bool

func (*Statement) NotIn 

func (statement *Statement) NotIn(column string, args ...interface{}) *Statement

NotIn generate "Where column NOT IN (?) " statement

func (*Statement) Nullable 

func (statement *Statement) Nullable(columns ...string)

Nullable Update use only: update columns to null when value is nullable and zero-value

func (*Statement) Omit 

func (statement *Statement) Omit(columns ...string)

Omit do not use the columns

func (*Statement) Or 

func (statement *Statement) Or(query interface{}, args ...interface{}) *Statement

Or add Where & Or statement

func (*Statement) OrderBy 

func (statement *Statement) OrderBy(order interface{}, args ...interface{}) *Statement

OrderBy generate "Order By order" statement

func (*Statement) ProcessIDParam 

func (statement *Statement) ProcessIDParam() error

ProcessIDParam handles the process of id condition

func (*Statement) QuoteReplacer 

func (statement *Statement) QuoteReplacer(w *builder.BytesWriter) *QuoteReplacer

func (*Statement) ReplaceQuote 

func (statement *Statement) ReplaceQuote(sql string) string

ReplaceQuote replace sql key words with quote

func (*Statement) Reset 

func (statement *Statement) Reset()

Reset reset all the statement's fields

func (*Statement) ResetOrderBy 

func (statement *Statement) ResetOrderBy()

ResetOrderBy reset ordery conditions

func (*Statement) SQL 

func (statement *Statement) SQL(query interface{}, args ...interface{}) *Statement

SQL adds raw sql statement

func (*Statement) Select 

func (statement *Statement) Select(str string) *Statement

Select replace select

func (*Statement) SetContextCache 

func (statement *Statement) SetContextCache(ctxCache contexts.ContextCache)

SetContextCache sets context cache

func (*Statement) SetExpr 

func (statement *Statement) SetExpr(column string, expression interface{}) *Statement

SetExpr Generate "Update ... Set column = {expression}" statement

func (*Statement) SetNoAutoCondition 

func (statement *Statement) SetNoAutoCondition(no ...bool) *Statement

SetNoAutoCondition if you do not want convert bean's field as query condition, then use this function

func (*Statement) SetRefBean 

func (statement *Statement) SetRefBean(bean interface{}) error

SetRefBean set ref bean

func (*Statement) SetRefValue 

func (statement *Statement) SetRefValue(v reflect.Value) error

SetRefValue set ref value

func (*Statement) SetTable 

func (statement *Statement) SetTable(tableNameOrBean interface{}) error

SetTable tempororily set table name, the parameter could be a string or a pointer of struct

func (*Statement) SetTableName 

func (statement *Statement) SetTableName(tableName string)

SetTableName set table name

func (*Statement) SetUnscoped 

func (statement *Statement) SetUnscoped() *Statement

SetUnscoped always disable struct tag "deleted"

func (*Statement) TableName 

func (statement *Statement) TableName() string

TableName return current tableName

func (*Statement) Top 

func (statement *Statement) Top(limit int) *Statement

Top generate LIMIT limit statement

func (*Statement) UseBool 

func (statement *Statement) UseBool(columns ...string) *Statement

UseBool indicates that use bool fields as update contents and query contiditions

func (*Statement) Value2Interface 

func (statement *Statement) Value2Interface(col *schemas.Column, fieldValue reflect.Value) (interface{}, error)

Value2Interface convert a field value of a struct to interface for putting into database

func (*Statement) Where 

func (statement *Statement) Where(query interface{}, args ...interface{}) *Statement

Where add Where statement

func (*Statement) WriteArg 

func (statement *Statement) WriteArg(w *builder.BytesWriter, arg interface{}) error

WriteArg writes an arg

func (*Statement) WriteArgs 

func (statement *Statement) WriteArgs(w *builder.BytesWriter, args []interface{}) error

WriteArgs writes args

func (*Statement) WriteDelete 

func (statement *Statement) WriteDelete(realSQLWriter, deleteSQLWriter *builder.BytesWriter, nowTime func(*schemas.Column) (interface{}, time.Time, error)) error

func (*Statement) WriteInsertMultiple 

func (statement *Statement) WriteInsertMultiple(w *builder.BytesWriter, tableName string, colNames []string, colMultiPlaces []string) error

func (*Statement) WriteUpdate 

func (statement *Statement) WriteUpdate(updateWriter *builder.BytesWriter, cond builder.Cond, v reflect.Value, colNames []string, args []interface{}) error

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.