Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

chain

package

Go to main page

Versions in this module

v2

v2.1.8

Oct 17, 2023

v2.1.7

Dec 23, 2022

v2.1.6

Jan 18, 2022

v2.1.5

Jan 17, 2022

v2.1.4

Jun 30, 2021

v2.1.3

Jun 28, 2021

v2.1.2

Jun 28, 2021

Changes in this version

+ const CurrentTimestampPGFn

+ const NullValue

+ const SQLAll

+ const SQLAnd

+ const SQLAndNot

+ const SQLForUpdate

+ const SQLNot

+ const SQLNothing

+ const SQLOr

+ const SQLOrNot

+ func AVG(column string) string

+ func AndConditions(conditions ...string) string

+ func As(field, alias string) string

+ func COUNT(column string) string

+ func ColumnGroup(columns ...string) string

+ func CompareExpressions(operator CompOperator, columnLeft, columnRight string) string

+ func Constraint(constraint string) string

+ func Distinct(field string) string

+ func Equals(field string) string

+ func ExpandArgs(args []interface{}, querySegment string) (string, []interface{})

+ func GreaterOrEqualThan(field string) string

+ func GreaterThan(field string) string

+ func In(field string, value ...interface{}) (string, []interface{})

+ func InSlice(field string, value interface{}) (string, interface{})

+ func IsNoRows(err error) bool

+ func LesserOrEqualThan(field string) string

+ func LesserThan(field string) string

+ func Like(field string) string

+ func MAX(column string) string

+ func MIN(column string) string

+ func MarksToPlaceholders(q string, args []interface{}) (string, []interface{}, error)

+ func NillableInt64(i *int64) int64

+ func NillableString(s *string) string

+ func NotEquals(field string) string

+ func NotLike(field string) string

+ func NotNull(field string) string

+ func Null(field string) string

+ func OrConditions(conditions ...string) string

+ func PlaceholdersToPositional(q *strings.Builder, argCount int) (*strings.Builder, int, error)

+ func SUM(column string) string

+ func SetToCurrentTimestamp(field string) string

+ func SimpleFunction(fName, params string) string

+ func TablePrefix(n string) func(string) string

+ type CompOperator string

+ var Eq CompOperator = "="

+ var Gt CompOperator = ">"

+ var GtE CompOperator = ">="

+ var Lk CompOperator = "LIKE"

+ var Lt CompOperator = "<"

+ var LtE CompOperator = "<="

+ var NLk CompOperator = "NOT LIKE"

+ var Neq CompOperator = "!="

+ type ExpressionChain struct

+ func New(db connection.DB) *ExpressionChain

+ func NewExpressionChain(db connection.DB) *ExpressionChain

+ func NewNoDB() *ExpressionChain

+ func (ec *ExpressionChain) AddUnionFromChain(union *ExpressionChain, all bool) (*ExpressionChain, error)

+ func (ec *ExpressionChain) AndHaving(expr string, args ...interface{}) *ExpressionChain

+ func (ec *ExpressionChain) AndWhere(expr string, args ...interface{}) *ExpressionChain

+ func (ec *ExpressionChain) AndWhereGroup(c *ExpressionChain) *ExpressionChain

+ func (ec *ExpressionChain) Clone() *ExpressionChain

+ func (ec *ExpressionChain) DB() connection.DB

+ func (ec *ExpressionChain) Delete() *ExpressionChain

+ func (ec *ExpressionChain) Exec(ctx context.Context) (execError error)

+ func (ec *ExpressionChain) ExecResult(ctx context.Context) (rowsAffected int64, execError error)

+ func (ec *ExpressionChain) Fetch(ctx context.Context, receiver interface{}) error

+ func (ec *ExpressionChain) FetchIntoPrimitive(ctx context.Context, receiver interface{}) error

+ func (ec *ExpressionChain) ForUpdate() *ExpressionChain

+ func (ec *ExpressionChain) From(table string) *ExpressionChain

+ func (ec *ExpressionChain) FromUpdate(expr string, args ...interface{}) *ExpressionChain

+ func (ec *ExpressionChain) FullJoin(expr, on string, args ...interface{}) *ExpressionChain

+ func (ec *ExpressionChain) GroupBy(expr string, args ...interface{}) *ExpressionChain

+ func (ec *ExpressionChain) GroupByReplace(expr string, args ...interface{}) *ExpressionChain

+ func (ec *ExpressionChain) InnerJoin(expr, on string, args ...interface{}) *ExpressionChain

+ func (ec *ExpressionChain) Insert(insertPairs map[string]interface{}) *ExpressionChain

+ func (ec *ExpressionChain) InsertMulti(insertPairs map[string][]interface{}) (*ExpressionChain, error)

+ func (ec *ExpressionChain) Join(expr, on string, args ...interface{}) *ExpressionChain

+ func (ec *ExpressionChain) LeftJoin(expr, on string, args ...interface{}) *ExpressionChain

+ func (ec *ExpressionChain) Limit(limit int64) *ExpressionChain

+ func (ec *ExpressionChain) NewDB(db connection.DB) *ExpressionChain

+ func (ec *ExpressionChain) Offset(offset int64) *ExpressionChain

+ func (ec *ExpressionChain) OnConflict(clause func(*OnConflict)) *ExpressionChain

+ func (ec *ExpressionChain) OrHaving(expr string, args ...interface{}) *ExpressionChain

+ func (ec *ExpressionChain) OrWhere(expr string, args ...interface{}) *ExpressionChain

+ func (ec *ExpressionChain) OrWhereGroup(c *ExpressionChain) *ExpressionChain

+ func (ec *ExpressionChain) OrderBy(order *OrderByOperator) *ExpressionChain

+ func (ec *ExpressionChain) Query(ctx context.Context) (connection.ResultFetch, error)

+ func (ec *ExpressionChain) QueryIter(ctx context.Context) (connection.ResultFetchIter, error)

+ func (ec *ExpressionChain) QueryPrimitive(ctx context.Context) (connection.ResultFetch, error)

+ func (ec *ExpressionChain) Raw(ctx context.Context, fields ...interface{}) error

+ func (ec *ExpressionChain) Render() (string, []interface{}, error)

+ func (ec *ExpressionChain) RenderRaw() (string, []interface{}, error)

+ func (ec *ExpressionChain) Returning(args ...string) *ExpressionChain

+ func (ec *ExpressionChain) RightJoin(expr, on string, args ...interface{}) *ExpressionChain

+ func (ec *ExpressionChain) Select(fields ...string) *ExpressionChain

+ func (ec *ExpressionChain) SelectWithArgs(fields ...SelectArgument) *ExpressionChain

+ func (ec *ExpressionChain) Set(set string) *ExpressionChain

+ func (ec *ExpressionChain) SetMinQuerySize(size uint64)

+ func (ec *ExpressionChain) String() string

+ func (ec *ExpressionChain) Table(table string) *ExpressionChain

+ func (ec *ExpressionChain) TablePrefixes() *Formatter

+ func (ec *ExpressionChain) Union(unionExpr string, all bool, args ...interface{}) *ExpressionChain

+ func (ec *ExpressionChain) Update(expr string, args ...interface{}) *ExpressionChain

+ func (ec *ExpressionChain) UpdateMap(exprMap map[string]interface{}) *ExpressionChain

+ func (ec *ExpressionChain) With(name string, cte *ExpressionChain) *ExpressionChain

+ type Formatter struct

+ FormatTable map[string]string

+ func (f *Formatter) Add(key, prefix string) bool

+ func (f *Formatter) Del(key string)

+ func (f *Formatter) List() []string

+ type Function interface

+ Fn func() (string, []interface{})

+ FnSelect func() SelectArgument

+ Parametric func(interface{}) Function

+ Static func(string) Function

+ func ComplexFunction(name string) Function

+ type Group struct

+ func (cg *Group) Add(ec *ExpressionChain)

+ func (cg *Group) Run(ctx context.Context) (execError error)

+ func (cg *Group) Set(set string)

+ type OnConflict struct

+ func (o *OnConflict) DoNothing()

+ func (o *OnConflict) OnColumn(args ...string) *OnConflictAction

+ func (o *OnConflict) OnConstraint(arg string) *OnConflictAction

+ type OnConflictAction struct

+ func (o *OnConflictAction) DoNothing()

+ func (o *OnConflictAction) DoUpdate() *OnUpdate

+ type OnUpdate struct

+ func (o *OnUpdate) Set(args ...interface{}) *OnUpdate

+ func (o *OnUpdate) SetDefault(column string) *OnUpdate

+ func (o *OnUpdate) SetNow(column string) *OnUpdate

+ func (o *OnUpdate) SetSQL(args ...string) *OnUpdate

+ func (o *OnUpdate) SetSQLNoParens(args ...string) *OnUpdate

+ func (o *OnUpdate) SetSQLRow(args ...string) *OnUpdate

+ func (o *OnUpdate) SetSQLWithArgs(column, sql string, args ...interface{}) *OnUpdate

+ func (o *OnUpdate) Where(ec *ExpressionChain)

+ type OrderByOperator struct

+ func Asc(columns ...string) *OrderByOperator

+ func Desc(columns ...string) *OrderByOperator

+ func (o *OrderByOperator) Asc(columns ...string) *OrderByOperator

+ func (o *OrderByOperator) Desc(columns ...string) *OrderByOperator

+ func (o *OrderByOperator) String() string

+ type SelectArgument struct

+ Args []interface{}

+ Field string

+ func (s SelectArgument) As(alias string) SelectArgument

Other modules containing this package

github.com/ShiftLeftSecurity/gaum