iclause

package
v0.21.0 Latest Latest
Warning

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

 Go to latest Published: Jun 13, 2024 License: MIT Imports: 5 Imported by: 0

Documentation

Index

Constants

View Source 
const (
	Union     = "UNION"
	Intersect = "INTERSECT"
	Except    = "EXCEPT"
)
View Source 
const (
	SearchBreadth = "BREADTH"
	SearchDepth   = "DEPTH"
)

Variables

View Source 
var ErrNoCombinationStrategy = internal.NewClauseError("Combination strategy must be set")

Functions

This section is empty.

Types

type CTE 

type CTE struct {
	Query        litsql.Query // SQL standard says only select, postgres allows insert/update/delete
	Name         string
	Columns      []litsql.Expression
	Materialized *bool
	Search       CTESearch
	Cycle        CTECycle
}

func (*CTE) SetMaterialized 

func (c *CTE) SetMaterialized()

func (*CTE) SetNotMaterialized 

func (c *CTE) SetNotMaterialized()

func (*CTE) SetQuery 

func (c *CTE) SetQuery(q litsql.Query)

func (*CTE) WriteSQL 

func (c *CTE) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type CTECycle 

type CTECycle struct {
	Columns    []string
	Set        string
	Using      string
	SetVal     litsql.Expression
	DefaultVal litsql.Expression
}

func (*CTECycle) WriteSQL 

func (c *CTECycle) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type CTESearch 

type CTESearch struct {
	Order   string
	Columns []string
	Set     string
}

func (*CTESearch) WriteSQL 

func (c *CTESearch) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Columns 

type Columns struct {
	Columns []litsql.Expression
}

func (*Columns) ClauseID added in v0.2.0 

func (c *Columns) ClauseID() string

func (*Columns) ClauseMerge 

func (c *Columns) ClauseMerge(other litsql.QueryClause) error

func (*Columns) ClauseOrder 

func (c *Columns) ClauseOrder() int

func (*Columns) WriteSQL 

func (c *Columns) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Combine 

type Combine struct {
	Strategy string
	Query    litsql.Query
	All      bool
}

func (*Combine) ClauseID added in v0.2.0 

func (c *Combine) ClauseID() string

func (*Combine) ClauseMultiple 

func (c *Combine) ClauseMultiple()

func (*Combine) ClauseOrder 

func (c *Combine) ClauseOrder() int

func (*Combine) WriteSQL 

func (c *Combine) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type DeleteFrom 

type DeleteFrom struct {
	Table string
}

func (*DeleteFrom) ClauseID added in v0.2.0 

func (c *DeleteFrom) ClauseID() string

func (*DeleteFrom) ClauseOrder 

func (c *DeleteFrom) ClauseOrder() int

func (*DeleteFrom) WriteSQL 

func (c *DeleteFrom) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type DeleteOnly 

type DeleteOnly struct {
	Only bool
}

func (*DeleteOnly) ClauseID added in v0.2.0 

func (c *DeleteOnly) ClauseID() string

func (*DeleteOnly) ClauseOrder 

func (c *DeleteOnly) ClauseOrder() int

func (*DeleteOnly) WriteSQL 

func (c *DeleteOnly) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Distinct 

type Distinct struct {
	On []litsql.Expression
}

func (*Distinct) ClauseID added in v0.2.0 

func (c *Distinct) ClauseID() string

func (*Distinct) ClauseMerge 

func (c *Distinct) ClauseMerge(other litsql.QueryClause) error

func (*Distinct) ClauseOrder 

func (c *Distinct) ClauseOrder() int

func (*Distinct) WriteSQL 

func (c *Distinct) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type From 

type From struct {
	Table   litsql.Expression
	Starter bool
	Clause  string

	// Aliases
	Alias        string
	AliasColumns []string

	// Dialect specific modifiers
	Only           bool // Postgres
	Lateral        bool // Postgres & MySQL
	WithOrdinality bool // Postgres
}

func (*From) ClauseID added in v0.2.0 

func (c *From) ClauseID() string

func (*From) ClauseOrder 

func (c *From) ClauseOrder() int

func (*From) SetAs 

func (f *From) SetAs(alias string, columns ...string)

func (*From) SetLateral 

func (f *From) SetLateral()

func (*From) SetOnly 

func (f *From) SetOnly()

func (*From) SetWithOrdinality 

func (f *From) SetWithOrdinality()

func (*From) WriteSQL 

func (c *From) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type GroupBy 

type GroupBy struct {
	Groups   []litsql.Expression
	Distinct bool
	With     string // ROLLUP | CUBE
}

func (*GroupBy) ClauseID added in v0.2.0 

func (c *GroupBy) ClauseID() string

func (*GroupBy) ClauseMerge 

func (c *GroupBy) ClauseMerge(other litsql.QueryClause) error

func (*GroupBy) ClauseOrder 

func (c *GroupBy) ClauseOrder() int

func (*GroupBy) SetGroupByDistinct 

func (g *GroupBy) SetGroupByDistinct(distinct bool)

func (*GroupBy) SetGroupWith 

func (g *GroupBy) SetGroupWith(with string)

func (*GroupBy) WriteSQL 

func (g *GroupBy) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Having 

type Having struct {
	Conditions []litsql.Expression
}

func (*Having) ClauseID added in v0.2.0 

func (c *Having) ClauseID() string

func (*Having) ClauseMerge 

func (c *Having) ClauseMerge(other litsql.QueryClause) error

func (*Having) ClauseOrder 

func (c *Having) ClauseOrder() int

func (*Having) WriteSQL 

func (c *Having) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type InsertConflictTarget 

type InsertConflictTarget struct {
	Constraint string
	Columns    []string
	Where      []litsql.Expression
}

func (*InsertConflictTarget) WriteSQL 

func (c *InsertConflictTarget) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type InsertConflictUpdate added in v0.9.1 

type InsertConflictUpdate struct {
	Do     string // DO NOTHING | DO UPDATE
	Target InsertConflictTarget
	Set    Set
	Where  Where
}

func (*InsertConflictUpdate) ClauseID added in v0.9.1 

func (c *InsertConflictUpdate) ClauseID() string

func (*InsertConflictUpdate) ClauseOrder added in v0.9.1 

func (c *InsertConflictUpdate) ClauseOrder() int

func (*InsertConflictUpdate) SetDoNothing added in v0.9.1 

func (c *InsertConflictUpdate) SetDoNothing()

func (*InsertConflictUpdate) SetDoUpdate added in v0.9.1 

func (c *InsertConflictUpdate) SetDoUpdate()

func (*InsertConflictUpdate) SetSet added in v0.11.0 

func (c *InsertConflictUpdate) SetSet(assignment litsql.Expression)

func (*InsertConflictUpdate) SetWhere added in v0.9.1 

func (c *InsertConflictUpdate) SetWhere(condition litsql.Expression)

func (*InsertConflictUpdate) WriteSQL added in v0.9.1 

func (c *InsertConflictUpdate) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type InsertDuplicateKey added in v0.11.0 

type InsertDuplicateKey struct {
	Set Set
}

func (*InsertDuplicateKey) ClauseID added in v0.11.0 

func (c *InsertDuplicateKey) ClauseID() string

func (*InsertDuplicateKey) ClauseMerge added in v0.11.0 

func (c *InsertDuplicateKey) ClauseMerge(other litsql.QueryClause) error

func (*InsertDuplicateKey) ClauseOrder added in v0.11.0 

func (c *InsertDuplicateKey) ClauseOrder() int

func (*InsertDuplicateKey) SetSet added in v0.11.0 

func (c *InsertDuplicateKey) SetSet(assignment litsql.Expression)

func (*InsertDuplicateKey) WriteSQL added in v0.11.0 

func (c *InsertDuplicateKey) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type InsertOverriding 

type InsertOverriding struct {
	Overriding string
}

func (*InsertOverriding) ClauseID added in v0.2.0 

func (c *InsertOverriding) ClauseID() string

func (*InsertOverriding) ClauseOrder 

func (c *InsertOverriding) ClauseOrder() int

func (*InsertOverriding) WriteSQL 

func (c *InsertOverriding) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Join 

type Join struct {
	Type string
	To   *From // the expression for the table

	// Join methods
	Natural bool
	On      []litsql.Expression
	Using   []string
}

func (*Join) ClauseID added in v0.2.0 

func (c *Join) ClauseID() string

func (*Join) ClauseMultiple 

func (c *Join) ClauseMultiple()

func (*Join) ClauseOrder 

func (c *Join) ClauseOrder() int

func (*Join) SetNatural 

func (c *Join) SetNatural()

func (*Join) SetOn 

func (c *Join) SetOn(on string)

func (*Join) SetOnClause added in v0.8.0 

func (c *Join) SetOnClause(query string, args ...any)

func (*Join) SetOnExpr added in v0.8.0 

func (c *Join) SetOnExpr(on litsql.Expression)

func (*Join) SetUsing 

func (c *Join) SetUsing(using ...string)

func (*Join) WriteSQL 

func (c *Join) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Limit 

type Limit struct {
	Count litsql.Expression
}

func (*Limit) ClauseID added in v0.2.0 

func (c *Limit) ClauseID() string

func (*Limit) ClauseOrder 

func (c *Limit) ClauseOrder() int

func (*Limit) WriteSQL 

func (c *Limit) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type NamedWindow 

type NamedWindow struct {
	Name       string
	Definition WindowDef
}

func (*NamedWindow) WriteSQL 

func (n *NamedWindow) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Offset 

type Offset struct {
	Count litsql.Expression
}

func (*Offset) ClauseID added in v0.2.0 

func (c *Offset) ClauseID() string

func (*Offset) ClauseOrder 

func (c *Offset) ClauseOrder() int

func (*Offset) WriteSQL 

func (c *Offset) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type OrderBy 

type OrderBy struct {
	Expressions []litsql.Expression
}

func (*OrderBy) ClauseID added in v0.2.0 

func (c *OrderBy) ClauseID() string

func (*OrderBy) ClauseMerge 

func (c *OrderBy) ClauseMerge(other litsql.QueryClause) error

func (*OrderBy) ClauseOrder 

func (c *OrderBy) ClauseOrder() int

func (*OrderBy) WriteSQL 

func (c *OrderBy) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type RawQuery added in v0.8.1 

type RawQuery struct {
	Query litsql.Expression
	Args  []any
}

func (*RawQuery) ClauseID added in v0.8.1 

func (c *RawQuery) ClauseID() string

func (*RawQuery) ClauseOrder added in v0.8.1 

func (c *RawQuery) ClauseOrder() int

func (*RawQuery) WriteSQL added in v0.8.1 

func (c *RawQuery) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Returning 

type Returning struct {
	Expressions []litsql.Expression
}

func (*Returning) ClauseID added in v0.2.0 

func (c *Returning) ClauseID() string

func (*Returning) ClauseMerge 

func (c *Returning) ClauseMerge(other litsql.QueryClause) error

func (*Returning) ClauseOrder 

func (c *Returning) ClauseOrder() int

func (*Returning) WriteSQL 

func (c *Returning) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Set 

type Set struct {
	Set        []litsql.Expression
	Starter    bool
	SkipClause bool
}

func (*Set) ClauseID added in v0.2.0 

func (c *Set) ClauseID() string

func (*Set) ClauseMerge 

func (c *Set) ClauseMerge(other litsql.QueryClause) error

func (*Set) ClauseOrder 

func (c *Set) ClauseOrder() int

func (*Set) WriteSQL 

func (c *Set) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Table 

type Table struct {
	Expression litsql.Expression
	Alias      string
	Columns    []string
}

func (*Table) ClauseID added in v0.2.0 

func (c *Table) ClauseID() string

func (*Table) ClauseOrder 

func (c *Table) ClauseOrder() int

func (*Table) WriteSQL 

func (t *Table) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type UpdateOnly 

type UpdateOnly struct {
	Only bool
}

func (*UpdateOnly) ClauseID added in v0.2.0 

func (c *UpdateOnly) ClauseID() string

func (*UpdateOnly) ClauseOrder 

func (c *UpdateOnly) ClauseOrder() int

func (*UpdateOnly) WriteSQL 

func (c *UpdateOnly) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Value 

type Value []litsql.Expression

func (Value) WriteSQL 

func (v Value) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Values 

type Values struct {
	// Query takes the highest priority
	// If present, will attempt to insert from this query
	Query litsql.Query

	// for multiple inserts
	// each sub-slice is one set of values
	Vals []Value
}

func (*Values) ClauseID added in v0.2.0 

func (c *Values) ClauseID() string

func (*Values) ClauseMerge 

func (c *Values) ClauseMerge(other litsql.QueryClause) error

func (*Values) ClauseOrder 

func (c *Values) ClauseOrder() int

func (*Values) WriteSQL 

func (c *Values) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Where 

type Where struct {
	Conditions []litsql.Expression
}

func (*Where) ClauseID added in v0.2.0 

func (c *Where) ClauseID() string

func (*Where) ClauseMerge 

func (c *Where) ClauseMerge(other litsql.QueryClause) error

func (*Where) ClauseOrder 

func (c *Where) ClauseOrder() int

func (*Where) WriteSQL 

func (c *Where) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type WindowDef 

type WindowDef struct {
	From        string // an existing window name
	OrderBy     []litsql.Expression
	PartitionBy []litsql.Expression
	Frame       litsql.Expression
}

func (*WindowDef) AddOrderBy 

func (wd *WindowDef) AddOrderBy(order ...litsql.Expression)

func (*WindowDef) AddPartitionBy 

func (wd *WindowDef) AddPartitionBy(condition ...litsql.Expression)

func (*WindowDef) SetFrame added in v0.11.8 

func (wd *WindowDef) SetFrame(frame litsql.Expression)

func (*WindowDef) SetFrom 

func (wd *WindowDef) SetFrom(from string)

func (*WindowDef) WriteSQL 

func (wd *WindowDef) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Windows 

type Windows struct {
	Windows []*NamedWindow
}

func (*Windows) ClauseID added in v0.2.0 

func (c *Windows) ClauseID() string

func (*Windows) ClauseMerge 

func (c *Windows) ClauseMerge(other litsql.QueryClause) error

func (*Windows) ClauseOrder 

func (c *Windows) ClauseOrder() int

func (*Windows) WriteSQL 

func (c *Windows) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type With 

type With struct {
	Recursive *bool
	CTEs      []*CTE
}

func (*With) ClauseID added in v0.2.0 

func (c *With) ClauseID() string

func (*With) ClauseMerge 

func (c *With) ClauseMerge(other litsql.QueryClause) error

func (*With) ClauseOrder 

func (c *With) ClauseOrder() int

func (*With) SetRecursive 

func (c *With) SetRecursive(r bool)

func (*With) WriteSQL 

func (c *With) WriteSQL(wr litsql.Writer, d litsql.Dialect, start int) ([]any, 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.