Documentation
¶
Index ¶
- Variables
- func CrossJoin[Q Joinable](e any) bob.Mod[Q]
- type CTEChain
- func (c CTEChain[Q]) Apply(q Q)
- func (c CTEChain[Q]) As(q bob.Query) CTEChain[Q]
- func (c CTEChain[Q]) Cycle(set, using string, cols ...string) CTEChain[Q]
- func (c CTEChain[Q]) CycleValue(value, defaultVal any) CTEChain[Q]
- func (c CTEChain[Q]) Materialized() CTEChain[Q]
- func (c CTEChain[Q]) NotMaterialized() CTEChain[Q]
- func (c CTEChain[Q]) SearchBreadth(setCol string, searchCols ...string) CTEChain[Q]
- func (c CTEChain[Q]) SearchDepth(setCol string, searchCols ...string) CTEChain[Q]
- type DeleteQuery
- type Distinct
- type Expression
- type FromChain
- type Function
- type Functions
- type InsertQuery
- type JoinChain
- func (j JoinChain[Q]) Apply(q Q)
- func (j JoinChain[Q]) As(alias string, columns ...string) JoinChain[Q]
- func (f JoinChain[Q]) Lateral() JoinChain[Q]
- func (j JoinChain[Q]) Natural() bob.Mod[Q]
- func (j JoinChain[Q]) On(on ...bob.Expression) bob.Mod[Q]
- func (j JoinChain[Q]) OnEQ(a, b bob.Expression) bob.Mod[Q]
- func (f JoinChain[Q]) Only() JoinChain[Q]
- func (j JoinChain[Q]) Using(using ...string) bob.Mod[Q]
- func (f JoinChain[Q]) WithOrdinality() JoinChain[Q]
- type Joinable
- type LockChain
- type OrderBy
- func (s OrderBy[Q]) Apply(q Q)
- func (o OrderBy[Q]) Asc() OrderBy[Q]
- func (o OrderBy[Q]) Collate(collation string) OrderBy[Q]
- func (o OrderBy[Q]) Desc() OrderBy[Q]
- func (o OrderBy[Q]) NullsFirst() OrderBy[Q]
- func (o OrderBy[Q]) NullsLast() OrderBy[Q]
- func (o OrderBy[Q]) Using(operator string) OrderBy[Q]
- type SelectQuery
- type UpdateQuery
- type WindowChain
- func (w *WindowChain[T]) ExcludeCurrentRow() T
- func (w *WindowChain[T]) ExcludeGroup() T
- func (w *WindowChain[T]) ExcludeNoOthers() T
- func (w *WindowChain[T]) ExcludeTies() T
- func (w *WindowChain[T]) From(name string) T
- func (w *WindowChain[T]) FromCurrentRow() T
- func (w *WindowChain[T]) FromFollowing(exp any) T
- func (w *WindowChain[T]) FromPreceding(exp any) T
- func (w *WindowChain[T]) FromUnboundedPreceding() T
- func (w *WindowChain[T]) Groups() T
- func (w *WindowChain[T]) OrderBy(order ...any) T
- func (w *WindowChain[T]) PartitionBy(condition ...any) T
- func (w *WindowChain[T]) Range() T
- func (w *WindowChain[T]) Rows() T
- func (w *WindowChain[T]) ToCurrentRow(count int) T
- func (w *WindowChain[T]) ToFollowing(exp any) T
- func (w *WindowChain[T]) ToPreceding(exp any) T
- func (w *WindowChain[T]) ToUnboundedFollowing() T
- type WindowMod
Constants ¶
This section is empty.
Variables ¶
View Source
var (
Dialect dialect
)
Functions ¶
Types ¶
type CTEChain ¶
func (CTEChain[Q]) CycleValue ¶
func (CTEChain[Q]) Materialized ¶
func (CTEChain[Q]) NotMaterialized ¶
func (CTEChain[Q]) SearchBreadth ¶
type DeleteQuery ¶ added in v0.13.0
type DeleteQuery struct {
clause.With
Only bool
clause.Table
clause.From
clause.Where
clause.Returning
}
Trying to represent the select query structure as documented in https://www.postgresql.org/docs/current/sql-delete.html
type Expression ¶
type Expression struct {
expr.Chain[Expression, Expression]
}
func (Expression) BetweenSymmetric ¶
func (x Expression) BetweenSymmetric(a, b bob.Expression) Expression
BETWEEN SYMMETRIC a AND b
func (Expression) ILike ¶ added in v0.19.0
func (x Expression) ILike(val bob.Expression) Expression
ILIKE val
func (Expression) New ¶
func (Expression) New(exp bob.Expression) Expression
func (Expression) NotBetweenSymmetric ¶
func (x Expression) NotBetweenSymmetric(a, b bob.Expression) Expression
NOT BETWEEN SYMMETRIC a AND b
type FromChain ¶ added in v0.7.0
func (FromChain[Q]) WithOrdinality ¶ added in v0.7.0
type Function ¶
type Function struct {
// For chain methods
expr.Chain[Expression, Expression]
// contains filtered or unexported fields
}
func NewFunction ¶
func (*Function) FilterWhere ¶
type InsertQuery ¶ added in v0.13.0
type InsertQuery struct {
clause.With
Overriding string
clause.Table
clause.Values
clause.Conflict
clause.Returning
}
Trying to represent the select query structure as documented in https://www.postgresql.org/docs/current/sql-insert.html
type JoinChain ¶
func (JoinChain[Q]) WithOrdinality ¶ added in v0.20.0
type LockChain ¶
func (LockChain[Q]) SkipLocked ¶
type OrderBy ¶
func (OrderBy[Q]) NullsFirst ¶
type SelectQuery ¶ added in v0.13.0
type SelectQuery struct {
clause.With
clause.SelectList
Distinct
clause.From
clause.Where
clause.GroupBy
clause.Having
clause.Windows
clause.Combine
clause.OrderBy
clause.Limit
clause.Offset
clause.Fetch
clause.For
bob.Load[*SelectQuery]
}
Trying to represent the select query structure as documented in https://www.postgresql.org/docs/current/sql-select.html
type UpdateQuery ¶ added in v0.13.0
type UpdateQuery struct {
clause.With
Only bool
clause.Table
clause.Set
clause.From
clause.Where
clause.Returning
}
Trying to represent the select query structure as documented in https://www.postgresql.org/docs/current/sql-update.html
type WindowChain ¶
type WindowChain[T any] struct { Wrap T // contains filtered or unexported fields }
func (*WindowChain[T]) ExcludeCurrentRow ¶
func (w *WindowChain[T]) ExcludeCurrentRow() T
func (*WindowChain[T]) ExcludeGroup ¶
func (w *WindowChain[T]) ExcludeGroup() T
func (*WindowChain[T]) ExcludeNoOthers ¶
func (w *WindowChain[T]) ExcludeNoOthers() T
func (*WindowChain[T]) ExcludeTies ¶
func (w *WindowChain[T]) ExcludeTies() T
func (*WindowChain[T]) From ¶
func (w *WindowChain[T]) From(name string) T
func (*WindowChain[T]) FromCurrentRow ¶
func (w *WindowChain[T]) FromCurrentRow() T
func (*WindowChain[T]) FromFollowing ¶
func (w *WindowChain[T]) FromFollowing(exp any) T
func (*WindowChain[T]) FromPreceding ¶
func (w *WindowChain[T]) FromPreceding(exp any) T
func (*WindowChain[T]) FromUnboundedPreceding ¶
func (w *WindowChain[T]) FromUnboundedPreceding() T
func (*WindowChain[T]) Groups ¶
func (w *WindowChain[T]) Groups() T
func (*WindowChain[T]) OrderBy ¶
func (w *WindowChain[T]) OrderBy(order ...any) T
func (*WindowChain[T]) PartitionBy ¶
func (w *WindowChain[T]) PartitionBy(condition ...any) T
func (*WindowChain[T]) Range ¶
func (w *WindowChain[T]) Range() T
func (*WindowChain[T]) Rows ¶
func (w *WindowChain[T]) Rows() T
func (*WindowChain[T]) ToCurrentRow ¶
func (w *WindowChain[T]) ToCurrentRow(count int) T
func (*WindowChain[T]) ToFollowing ¶
func (w *WindowChain[T]) ToFollowing(exp any) T
func (*WindowChain[T]) ToPreceding ¶
func (w *WindowChain[T]) ToPreceding(exp any) T
func (*WindowChain[T]) ToUnboundedFollowing ¶
func (w *WindowChain[T]) ToUnboundedFollowing() T
type WindowMod ¶
type WindowMod[Q interface{ AppendWindow(clause.NamedWindow) }] struct {
Name string
*WindowChain[*WindowMod[Q]]
}
Source Files
Click to show internal directories.
Click to hide internal directories.