dialect

package

v0.9.0 Latest Latest Go to latest Published: Dec 7, 2022 License: MIT Imports: 7 Imported by: 7

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/stephenafamo/bob

Links

Documentation ¶

Index ¶

Variables
func CrossJoin[Q joinable](e any) bob.Mod[Q]
func OrAbort[Q interface{ ... }]() bob.Mod[Q]
func OrFail[Q interface{ ... }]() bob.Mod[Q]
func OrIgnore[Q interface{ ... }]() bob.Mod[Q]
func OrReplace[Q interface{ ... }]() bob.Mod[Q]
func OrRollback[Q interface{ ... }]() bob.Mod[Q]
type CTEChain
- func With[Q interface{ ... }](name string, columns ...string) CTEChain[Q]
- func (c CTEChain[Q]) Apply(q Q)
- func (c CTEChain[Q]) As(q bob.Query) CTEChain[Q]
- func (c CTEChain[Q]) Materialized() CTEChain[Q]
- func (c CTEChain[Q]) NotMaterialized() CTEChain[Q]
type Expression
- func (Expression) New(exp any) Expression
- func (x Expression) String() string
type FromChain
- func From[Q fromable](table any) FromChain[Q]
- func (f FromChain[Q]) Apply(q Q)
- func (f FromChain[Q]) As(alias string, columns ...string) FromChain[Q]
- func (f FromChain[Q]) IndexedBy(indexName string) bob.Mod[Q]
- func (f FromChain[Q]) NotIndexed() bob.Mod[Q]
type Function
- func NewFunction(name string, args ...any) Function
- func (f *Function) Apply(q *clause.From)
- func (f *Function) Filter(e ...any) *Function
- func (f *Function) Over(window string) *functionOver
- func (f Function) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)
type JoinChain
- func FullJoin[Q joinable](e any) JoinChain[Q]
- func InnerJoin[Q joinable](e any) JoinChain[Q]
- func LeftJoin[Q joinable](e any) JoinChain[Q]
- func RightJoin[Q joinable](e any) JoinChain[Q]
- func (j JoinChain[Q]) Apply(q Q)
- func (j JoinChain[Q]) As(alias string) JoinChain[Q]
- func (j JoinChain[Q]) Natural() bob.Mod[Q]
- func (j JoinChain[Q]) On(on ...any) bob.Mod[Q]
- func (j JoinChain[Q]) OnEQ(a, b any) bob.Mod[Q]
- func (j JoinChain[Q]) Using(using ...any) bob.Mod[Q]
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]
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
- func (w *WindowMod[Q]) Apply(q Q)

Constants ¶

This section is empty.

Variables ¶

View Source

var Dialect dialect

Functions ¶

func CrossJoin ¶

func CrossJoin[Q joinable](e any) bob.Mod[Q]

func OrAbort ¶

func OrAbort[Q interface{ SetOr(string) }]() bob.Mod[Q]

func OrFail ¶

func OrFail[Q interface{ SetOr(string) }]() bob.Mod[Q]

func OrIgnore ¶

func OrIgnore[Q interface{ SetOr(string) }]() bob.Mod[Q]

func OrReplace ¶

func OrReplace[Q interface{ SetOr(string) }]() bob.Mod[Q]

func OrRollback ¶

func OrRollback[Q interface{ SetOr(string) }]() bob.Mod[Q]

Types ¶

type CTEChain ¶

type CTEChain[Q interface{ AppendWith(clause.CTE) }] func() clause.CTE

func With ¶

func With[Q interface{ AppendWith(clause.CTE) }](name string, columns ...string) CTEChain[Q]

func (CTEChain[Q]) Apply ¶

func (c CTEChain[Q]) Apply(q Q)

func (CTEChain[Q]) As ¶

func (c CTEChain[Q]) As(q bob.Query) CTEChain[Q]

func (CTEChain[Q]) Materialized ¶

func (c CTEChain[Q]) Materialized() CTEChain[Q]

func (CTEChain[Q]) NotMaterialized ¶

func (c CTEChain[Q]) NotMaterialized() CTEChain[Q]

type Expression ¶

type Expression struct {
	expr.Chain[Expression, Expression]
}

func (Expression) New ¶

func (Expression) New(exp any) Expression

func (Expression) String ¶

func (x Expression) String() string

Implements fmt.Stringer()

type FromChain ¶ added in v0.7.0

type FromChain[Q fromable] func() clause.From

func From ¶ added in v0.7.0

func From[Q fromable](table any) FromChain[Q]

func (FromChain[Q]) Apply ¶ added in v0.7.0

func (f FromChain[Q]) Apply(q Q)

func (FromChain[Q]) As ¶ added in v0.7.0

func (f FromChain[Q]) As(alias string, columns ...string) FromChain[Q]

func (FromChain[Q]) IndexedBy ¶ added in v0.7.0

func (f FromChain[Q]) IndexedBy(indexName string) bob.Mod[Q]

func (FromChain[Q]) NotIndexed ¶ added in v0.7.0

func (f FromChain[Q]) NotIndexed() bob.Mod[Q]

type Function ¶

type Function struct {

	// For chain methods
	expr.Chain[Expression, Expression]
	// contains filtered or unexported fields
}

func NewFunction ¶

func NewFunction(name string, args ...any) Function

func (*Function) Apply ¶

func (f *Function) Apply(q *clause.From)

A function can be a target for a query

func (*Function) Filter ¶

func (f *Function) Filter(e ...any) *Function

func (*Function) Over ¶

func (f *Function) Over(window string) *functionOver

func (Function) WriteSQL ¶

func (f Function) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)

type JoinChain ¶

type JoinChain[Q interface{ AppendJoin(clause.Join) }] func() clause.Join

func FullJoin ¶

func FullJoin[Q joinable](e any) JoinChain[Q]

func InnerJoin ¶

func InnerJoin[Q joinable](e any) JoinChain[Q]

func LeftJoin ¶

func LeftJoin[Q joinable](e any) JoinChain[Q]

func RightJoin ¶

func RightJoin[Q joinable](e any) JoinChain[Q]

func (JoinChain[Q]) Apply ¶

func (j JoinChain[Q]) Apply(q Q)

func (JoinChain[Q]) As ¶

func (j JoinChain[Q]) As(alias string) JoinChain[Q]

func (JoinChain[Q]) Natural ¶

func (j JoinChain[Q]) Natural() bob.Mod[Q]

func (JoinChain[Q]) On ¶

func (j JoinChain[Q]) On(on ...any) bob.Mod[Q]

func (JoinChain[Q]) OnEQ ¶

func (j JoinChain[Q]) OnEQ(a, b any) bob.Mod[Q]

func (JoinChain[Q]) Using ¶

func (j JoinChain[Q]) Using(using ...any) bob.Mod[Q]

type OrderBy ¶

type OrderBy[Q interface{ AppendOrder(clause.OrderDef) }] func() clause.OrderDef

func (OrderBy[Q]) Apply ¶

func (s OrderBy[Q]) Apply(q Q)

func (OrderBy[Q]) Asc ¶

func (o OrderBy[Q]) Asc() OrderBy[Q]

func (OrderBy[Q]) Collate ¶

func (o OrderBy[Q]) Collate(collation string) OrderBy[Q]

func (OrderBy[Q]) Desc ¶

func (o OrderBy[Q]) Desc() OrderBy[Q]

func (OrderBy[Q]) NullsFirst ¶

func (o OrderBy[Q]) NullsFirst() OrderBy[Q]

func (OrderBy[Q]) NullsLast ¶

func (o OrderBy[Q]) NullsLast() OrderBy[Q]

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]]
}

func (*WindowMod[Q]) Apply ¶

func (w *WindowMod[Q]) Apply(q Q)

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL