ichain

Documentation

Index

• Constants
• type FromChain
  • func (f *FromChain[T]) Apply(a litsql.QueryBuilder)
  • func (f *FromChain[T]) As(alias string, columns ...string) chain.From[T]
  • func (f *FromChain[T]) Lateral() chain.From[T]
  • func (f *FromChain[T]) Only() chain.From[T]
  • func (f *FromChain[T]) WithOrdinality() chain.From[T]
• type GroupByChain
  • func (c *GroupByChain[T]) Apply(a litsql.QueryBuilder)
  • func (c *GroupByChain[T]) Distinct() chain.GroupBy[T]
  • func (c *GroupByChain[T]) With(with string) chain.GroupBy[T]
• type InsertConflictChain
  • func (f *InsertConflictChain[T]) Apply(a litsql.QueryBuilder)
  • func (f *InsertConflictChain[T]) DoNothing() chain.InsertConflict[T, imod.InsertConflictUpdateModUM]
  • func (f *InsertConflictChain[T]) DoUpdate(mods ...mod.InsertConflictUpdateMod[T, imod.InsertConflictUpdateModUM]) chain.InsertConflict[T, imod.InsertConflictUpdateModUM]
  • func (f *InsertConflictChain[T]) Where(condition string) chain.InsertConflict[T, imod.InsertConflictUpdateModUM]
  • func (f *InsertConflictChain[T]) WhereClause(query string, args ...any) chain.InsertConflict[T, imod.InsertConflictUpdateModUM]
  • func (f *InsertConflictChain[T]) WhereExpr(condition litsql.Expression) chain.InsertConflict[T, imod.InsertConflictUpdateModUM]
• type JoinChain
  • func (c *JoinChain[T]) Apply(a litsql.QueryBuilder)
  • func (c *JoinChain[T]) As(alias string, columns ...string) chain.Join[T]
  • func (c *JoinChain[T]) Lateral() chain.Join[T]
  • func (c *JoinChain[T]) Natural() sq.QueryMod[T]
  • func (c *JoinChain[T]) On(on string) chain.Join[T]
  • func (c *JoinChain[T]) OnClause(query string, args ...any) chain.Join[T]
  • func (c *JoinChain[T]) OnExpr(on litsql.Expression) chain.Join[T]
  • func (c *JoinChain[T]) Only() chain.Join[T]
  • func (c *JoinChain[T]) Using(using ...string) chain.Join[T]
  • func (c *JoinChain[T]) WithOrdinality() chain.Join[T]
• type WindowChain
  • func (f *WindowChain[T]) Apply(a litsql.QueryBuilder)
  • func (f *WindowChain[T]) ExcludeCurrentRow() chain.Window[T]
  • func (f *WindowChain[T]) ExcludeGroup() chain.Window[T]
  • func (f *WindowChain[T]) ExcludeNoOthers() chain.Window[T]
  • func (f *WindowChain[T]) ExcludeTies() chain.Window[T]
  • func (f *WindowChain[T]) From(name string) chain.Window[T]
  • func (f *WindowChain[T]) FromCurrentRow() chain.Window[T]
  • func (f *WindowChain[T]) FromFollowing(exp litsql.Expression) chain.Window[T]
  • func (f *WindowChain[T]) FromPreceding(exp litsql.Expression) chain.Window[T]
  • func (f *WindowChain[T]) FromUnboundedPreceding() chain.Window[T]
  • func (f *WindowChain[T]) Groups() chain.Window[T]
  • func (f *WindowChain[T]) OrderBy(order ...string) chain.Window[T]
  • func (f *WindowChain[T]) OrderByExpr(order ...litsql.Expression) chain.Window[T]
  • func (f *WindowChain[T]) PartitionBy(condition ...string) chain.Window[T]
  • func (f *WindowChain[T]) PartitionByExpr(condition ...litsql.Expression) chain.Window[T]
  • func (f *WindowChain[T]) Range() chain.Window[T]
  • func (f *WindowChain[T]) Rows() chain.Window[T]
  • func (f *WindowChain[T]) ToCurrentRow(count int) chain.Window[T]
  • func (f *WindowChain[T]) ToFollowing(exp litsql.Expression) chain.Window[T]
  • func (f *WindowChain[T]) ToPreceding(exp litsql.Expression) chain.Window[T]
  • func (f *WindowChain[T]) ToUnboundedFollowing() chain.Window[T]
• type WithChain
  • func (c *WithChain[T]) Apply(a litsql.QueryBuilder)
  • func (c *WithChain[T]) As(q litsql.Query) chain.With[T]
  • func (c *WithChain[T]) Cycle(set, using string, cols ...string) chain.With[T]
  • func (c *WithChain[T]) CycleValue(value, defaultVal any) chain.With[T]
  • func (c *WithChain[T]) Materialized() chain.With[T]
  • func (c *WithChain[T]) NotMaterialized() chain.With[T]
  • func (c *WithChain[T]) Recursive() chain.With[T]
  • func (c *WithChain[T]) SearchBreadth(setCol string, searchCols ...string) chain.With[T]
  • func (c *WithChain[T]) SearchDepth(setCol string, searchCols ...string) chain.With[T]

Constants

const (
	JoinInnerJoin    = "INNER JOIN"
	JoinLeftJoin     = "LEFT JOIN"
	JoinRightJoin    = "RIGHT JOIN"
	JoinFullJoin     = "FULL JOIN"
	JoinCrossJoin    = "CROSS JOIN"
	JoinStraightJoin = "STRAIGHT_JOIN"
)

Types

type FromChain

type FromChain[T any] struct {
	sq.ModTagImpl[T]
	*iclause.From
}

func (*FromChain[T]) Apply

func (f *FromChain[T]) Apply(a litsql.QueryBuilder)

func (*FromChain[T]) As

func (f *FromChain[T]) As(alias string, columns ...string) chain.From[T]

func (*FromChain[T]) Lateral

func (f *FromChain[T]) Lateral() chain.From[T]

func (*FromChain[T]) Only

func (f *FromChain[T]) Only() chain.From[T]

func (*FromChain[T]) WithOrdinality

func (f *FromChain[T]) WithOrdinality() chain.From[T]

type GroupByChain

type GroupByChain[T any] struct {
	sq.ModTagImpl[T]
	*iclause.GroupBy
}

func (*GroupByChain[T]) Apply

func (c *GroupByChain[T]) Apply(a litsql.QueryBuilder)

func (*GroupByChain[T]) Distinct

func (c *GroupByChain[T]) Distinct() chain.GroupBy[T]

func (*GroupByChain[T]) With

func (c *GroupByChain[T]) With(with string) chain.GroupBy[T]

type InsertConflictChain

type InsertConflictChain[T any] struct {
	sq.ModTagImpl[T]
	*iclause.InsertConflict
}

func (*InsertConflictChain[T]) Apply

func (f *InsertConflictChain[T]) Apply(a litsql.QueryBuilder)

func (*InsertConflictChain[T]) DoNothing

func (f *InsertConflictChain[T]) DoNothing() chain.InsertConflict[T, imod.InsertConflictUpdateModUM]

func (*InsertConflictChain[T]) DoUpdate

func (f *InsertConflictChain[T]) DoUpdate(mods ...mod.InsertConflictUpdateMod[T, imod.InsertConflictUpdateModUM]) chain.InsertConflict[T, imod.InsertConflictUpdateModUM]

func (*InsertConflictChain[T]) Where

func (f *InsertConflictChain[T]) Where(condition string) chain.InsertConflict[T, imod.InsertConflictUpdateModUM]

func (*InsertConflictChain[T]) WhereClause

func (f *InsertConflictChain[T]) WhereClause(query string, args ...any) chain.InsertConflict[T, imod.InsertConflictUpdateModUM]

func (*InsertConflictChain[T]) WhereExpr

func (f *InsertConflictChain[T]) WhereExpr(condition litsql.Expression) chain.InsertConflict[T, imod.InsertConflictUpdateModUM]

type JoinChain

type JoinChain[T any] struct {
	sq.ModTagImpl[T]
	*iclause.Join
}

func (*JoinChain[T]) Apply

func (c *JoinChain[T]) Apply(a litsql.QueryBuilder)

func (*JoinChain[T]) As

func (c *JoinChain[T]) As(alias string, columns ...string) chain.Join[T]

func (*JoinChain[T]) Lateral

func (c *JoinChain[T]) Lateral() chain.Join[T]

func (*JoinChain[T]) Natural

func (c *JoinChain[T]) Natural() sq.QueryMod[T]

func (*JoinChain[T]) On

func (c *JoinChain[T]) On(on string) chain.Join[T]

func (*JoinChain[T]) OnClause

func (c *JoinChain[T]) OnClause(query string, args ...any) chain.Join[T]

func (*JoinChain[T]) OnExpr

func (c *JoinChain[T]) OnExpr(on litsql.Expression) chain.Join[T]

func (*JoinChain[T]) Only

func (c *JoinChain[T]) Only() chain.Join[T]

func (*JoinChain[T]) Using

func (c *JoinChain[T]) Using(using ...string) chain.Join[T]

func (*JoinChain[T]) WithOrdinality

func (c *JoinChain[T]) WithOrdinality() chain.Join[T]

type WindowChain

type WindowChain[T any] struct {
	sq.ModTagImpl[T]
	*iclause.Windows
	NamedWindow *iclause.NamedWindow
}

func (*WindowChain[T]) Apply

func (f *WindowChain[T]) Apply(a litsql.QueryBuilder)

func (*WindowChain[T]) ExcludeCurrentRow

func (f *WindowChain[T]) ExcludeCurrentRow() chain.Window[T]

func (*WindowChain[T]) ExcludeGroup

func (f *WindowChain[T]) ExcludeGroup() chain.Window[T]

func (*WindowChain[T]) ExcludeNoOthers

func (f *WindowChain[T]) ExcludeNoOthers() chain.Window[T]

func (*WindowChain[T]) ExcludeTies

func (f *WindowChain[T]) ExcludeTies() chain.Window[T]

func (*WindowChain[T]) From

func (f *WindowChain[T]) From(name string) chain.Window[T]

func (*WindowChain[T]) FromCurrentRow

func (f *WindowChain[T]) FromCurrentRow() chain.Window[T]

func (*WindowChain[T]) FromFollowing

func (f *WindowChain[T]) FromFollowing(exp litsql.Expression) chain.Window[T]

func (*WindowChain[T]) FromPreceding

func (f *WindowChain[T]) FromPreceding(exp litsql.Expression) chain.Window[T]

func (*WindowChain[T]) FromUnboundedPreceding

func (f *WindowChain[T]) FromUnboundedPreceding() chain.Window[T]

func (*WindowChain[T]) Groups

func (f *WindowChain[T]) Groups() chain.Window[T]

func (*WindowChain[T]) OrderBy

func (f *WindowChain[T]) OrderBy(order ...string) chain.Window[T]

func (*WindowChain[T]) OrderByExpr

func (f *WindowChain[T]) OrderByExpr(order ...litsql.Expression) chain.Window[T]

func (*WindowChain[T]) PartitionBy

func (f *WindowChain[T]) PartitionBy(condition ...string) chain.Window[T]

func (*WindowChain[T]) PartitionByExpr

func (f *WindowChain[T]) PartitionByExpr(condition ...litsql.Expression) chain.Window[T]

func (*WindowChain[T]) Range

func (f *WindowChain[T]) Range() chain.Window[T]

func (*WindowChain[T]) Rows

func (f *WindowChain[T]) Rows() chain.Window[T]

func (*WindowChain[T]) ToCurrentRow

func (f *WindowChain[T]) ToCurrentRow(count int) chain.Window[T]

func (*WindowChain[T]) ToFollowing

func (f *WindowChain[T]) ToFollowing(exp litsql.Expression) chain.Window[T]

func (*WindowChain[T]) ToPreceding

func (f *WindowChain[T]) ToPreceding(exp litsql.Expression) chain.Window[T]

func (*WindowChain[T]) ToUnboundedFollowing

func (f *WindowChain[T]) ToUnboundedFollowing() chain.Window[T]

type WithChain

type WithChain[T any] struct {
	sq.ModTagImpl[T]
	*iclause.With
	CTE *iclause.CTE
}

func (*WithChain[T]) Apply

func (c *WithChain[T]) Apply(a litsql.QueryBuilder)

func (*WithChain[T]) As

func (c *WithChain[T]) As(q litsql.Query) chain.With[T]

func (*WithChain[T]) Cycle

func (c *WithChain[T]) Cycle(set, using string, cols ...string) chain.With[T]

func (*WithChain[T]) CycleValue

func (c *WithChain[T]) CycleValue(value, defaultVal any) chain.With[T]

func (*WithChain[T]) Materialized

func (c *WithChain[T]) Materialized() chain.With[T]

func (*WithChain[T]) NotMaterialized

func (c *WithChain[T]) NotMaterialized() chain.With[T]

func (*WithChain[T]) Recursive

func (c *WithChain[T]) Recursive() chain.With[T]

func (*WithChain[T]) SearchBreadth

func (c *WithChain[T]) SearchBreadth(setCol string, searchCols ...string) chain.With[T]

func (*WithChain[T]) SearchDepth

func (c *WithChain[T]) SearchDepth(setCol string, searchCols ...string) chain.With[T]