jet

package

Go to main page

Versions in this module

v2

v2.11.1

Mar 24, 2024

v2.11.0

Feb 27, 2024

Changes in this version

+ var DateRangeExp = RangeExp[DateExpression]

+ var Int4RangeExp = RangeExp[Int4Expression]

+ var Int8RangeExp = RangeExp[Int8Expression]

+ var MINUS_INFINITY = String("-infinity")

+ var NumRangeExp = RangeExp[NumericExpression]

+ var PLUS_INFINITY = String("infinity")

+ var TsRangeExp = RangeExp[TimestampExpression]

+ var TstzRangeExp = RangeExp[TimestampzExpression]

+ func LOWER_BOUND[T Expression](rangeExpression Range[T]) T

+ func SerializeForOrderBy(exp Expression, statementType StatementType, out *SQLBuilder)

+ func UPPER_BOUND[T Expression](rangeExpression Range[T]) T

type BoolExpression

+ func Contains(lhs Expression, rhs Expression) BoolExpression

+ func IS_EMPTY[T Expression](rangeExpression Range[T]) BoolExpression

+ func LOWER_INC[T Expression](rangeExpression Range[T]) BoolExpression

+ func LOWER_INF[T Expression](rangeExpression Range[T]) BoolExpression

+ func Overlap(lhs, rhs Expression) BoolExpression

+ func UPPER_INC[T Expression](rangeExpression Range[T]) BoolExpression

+ func UPPER_INF[T Expression](rangeExpression Range[T]) BoolExpression

+ type ClauseFetch struct

+ Count IntegerExpression

+ WithTies bool

+ func (o *ClauseFetch) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ColumnRange interface

+ From func(subQuery SelectTable) ColumnRange[T]

+ SET func(rangeExp Range[T]) ColumnAssigment

+ func RangeColumn[T Expression](name string) ColumnRange[T]

type Dialect

+ SerializeOrderBy func() func(expression Expression, ascending, nullsFirst *bool) SerializerFunc

type DialectParams

+ SerializeOrderBy func(expression Expression, ascending, nullsFirst *bool) SerializerFunc

type ExpressionInterfaceImpl

+ func (e *ExpressionInterfaceImpl) NULLS_FIRST() OrderByClause

+ func (e *ExpressionInterfaceImpl) NULLS_LAST() OrderByClause

+ type Int4Expression IntegerExpression

+ type Int8Expression IntegerExpression

type OrderByClause

+ NULLS_FIRST func() OrderByClause

+ NULLS_LAST func() OrderByClause

+ type Range interface

+ CONTAINS func(rhs T) BoolExpression

+ CONTAINS_RANGE func(rhs Range[T]) BoolExpression

+ DIFFERENCE func(rhs Range[T]) Range[T]

+ EQ func(rhs Range[T]) BoolExpression

+ GT func(rhs Range[T]) BoolExpression

+ GT_EQ func(rhs Range[T]) BoolExpression

+ INTERSECTION func(rhs Range[T]) Range[T]

+ IS_EMPTY func() BoolExpression

+ LOWER_BOUND func() T

+ LOWER_INC func() BoolExpression

+ LOWER_INF func() BoolExpression

+ LT func(rhs Range[T]) BoolExpression

+ LT_EQ func(rhs Range[T]) BoolExpression

+ NOT_EQ func(rhs Range[T]) BoolExpression

+ OVERLAP func(rhs Range[T]) BoolExpression

+ UNION func(rhs Range[T]) Range[T]

+ UPPER_BOUND func() T

+ UPPER_INC func() BoolExpression

+ UPPER_INF func() BoolExpression

+ func DateRange(lowTs, highTs DateExpression, bounds ...StringExpression) Range[DateExpression]

+ func Int4Range(lowNum, highNum IntegerExpression, bounds ...StringExpression) Range[Int4Expression]

+ func Int8Range(lowNum, highNum Int8Expression, bounds ...StringExpression) Range[Int8Expression]

+ func NumRange(lowNum, highNum NumericExpression, bounds ...StringExpression) Range[NumericExpression]

+ func RangeExp[T Expression](expression Expression) Range[T]

+ func RawRange[T Expression](raw string, namedArgs ...map[string]interface{}) Range[T]

+ func TsRange(lowTs, highTs TimestampExpression, bounds ...StringExpression) Range[TimestampExpression]

+ func TstzRange(lowTs, highTs TimestampzExpression, bounds ...StringExpression) Range[TimestampzExpression]

type RowLock

+ OF func(...Table) RowLock

v2.10.1

Jul 24, 2023

Changes in this version

type BoolExpression

+ func RawBool(raw string, namedArgs ...map[string]interface{}) BoolExpression

v2.10.0

Apr 17, 2023

Changes in this version

type GroupByClause

+ func CUBE(expressions ...Expression) GroupByClause

+ func GROUPING_SETS(expressions ...Expression) GroupByClause

+ func ROLLUP(expressions ...Expression) GroupByClause

+ func WITH_ROLLUP(expressions ...Expression) GroupByClause

type IntegerExpression

+ func GROUPING(expressions ...Expression) IntegerExpression

v2.9.0

Sep 30, 2022

Changes in this version

type ClauseDelete

+ OptimizerHints optimizerHints

type ClauseInsert

+ OptimizerHints optimizerHints

type ClauseSelect

+ OptimizerHints optimizerHints

type ClauseUpdate

+ OptimizerHints optimizerHints

type ClauseValues

+ As string

type ColumnTimez

+ SET func(timeExp TimezExpression) ColumnAssigment

+ type OptimizerHint string

v2.8.0

May 17, 2022

Changes in this version

type Expression

+ func EXTRACT(field string, from Expression) Expression

+ type Token string

v2.7.1

Feb 14, 2022

Changes in this version

type BoolExpression

+ func AND(expressions ...BoolExpression) BoolExpression

+ func OR(expressions ...BoolExpression) BoolExpression

type Expression

+ func BoolExpressionListToExpressionList(expressions []BoolExpression) []Expression

v2.7.0

Jan 20, 2022

Changes in this version

+ func SerializeColumnExpressions(columns []ColumnExpression, statementType StatementType, out *SQLBuilder, ...)

+ func SetQueryLogger(loggerFunc QueryLoggerFunc)

type BoolExpression

+ func NewBetweenOperatorExpression(expression, min, max Expression, notBetween bool) BoolExpression

type ClauseFrom

+ Name string

type ClauseSelect

+ DistinctOnColumns []ColumnExpression

type CommonTableExpression

+ Columns []ColumnExpression

+ NotMaterialized bool

type DateExpression

+ BETWEEN func(min, max DateExpression) BoolExpression

+ NOT_BETWEEN func(min, max DateExpression) BoolExpression

type Expression

+ func DISTINCT(expr Expression) Expression

type FloatExpression

+ BETWEEN func(min, max FloatExpression) BoolExpression

+ NOT_BETWEEN func(min, max FloatExpression) BoolExpression

type IntegerExpression

+ BETWEEN func(min, max IntegerExpression) BoolExpression

+ NOT_BETWEEN func(min, max IntegerExpression) BoolExpression

+ type OrderSetAggregateFunc struct

+ func MODE() *OrderSetAggregateFunc

+ func PERCENTILE_CONT(fraction FloatExpression) *OrderSetAggregateFunc

+ func PERCENTILE_DISC(fraction FloatExpression) *OrderSetAggregateFunc

+ func (p *OrderSetAggregateFunc) WITHIN_GROUP_ORDER_BY(orderBy OrderByClause) Expression

type ProjectionList

+ func (pl ProjectionList) As(tableAlias string) ProjectionList

+ func (pl ProjectionList) Except(toExclude ...Column) ProjectionList

+ type QueryInfo struct

+ Duration time.Duration

+ Err error

+ RowsProcessed int64

+ Statement PrintableStatement

+ func (q QueryInfo) Caller() (file string, line int, function string)

+ type QueryLoggerFunc func(ctx context.Context, info QueryInfo)

+ type SerializerHasProjections interface

type StringExpression

+ BETWEEN func(min, max StringExpression) BoolExpression

+ NOT_BETWEEN func(min, max StringExpression) BoolExpression

type TimeExpression

+ BETWEEN func(min, max TimeExpression) BoolExpression

+ NOT_BETWEEN func(min, max TimeExpression) BoolExpression

type TimestampExpression

+ BETWEEN func(min, max TimestampExpression) BoolExpression

+ NOT_BETWEEN func(min, max TimestampExpression) BoolExpression

type TimestampzExpression

+ BETWEEN func(min, max TimestampzExpression) BoolExpression

+ NOT_BETWEEN func(min, max TimestampzExpression) BoolExpression

type TimezExpression

+ BETWEEN func(min, max TimezExpression) BoolExpression

+ NOT_BETWEEN func(min, max TimezExpression) BoolExpression

v2.6.0

Oct 25, 2021

Changes in this version

+ func NewDateFunc(name string, expressions ...Expression) *dateFunc

+ func NewFunc(name string, expressions []Expression, parent Expression) *funcExpressionImpl

+ func NewTimeFunc(name string, expressions ...Expression) *timeFunc

type ClauseQuery

+ SkipSelectWrap bool

+ type ClauseReturning struct

+ ProjectionList []Projection

+ func (r *ClauseReturning) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ func (r ClauseReturning) Projections() ProjectionList

type ClauseSetStmtOperator

+ SkipSelectWrap bool

type ColumnList

+ func (cl ColumnList) Except(excludedColumns ...Column) ColumnList

type IntervalImpl

+ Value Serializer

type SerializeOption

+ const Ident

type StringExpression

+ func NewStringFunc(name string, expressions ...Expression) StringExpression

v2.5.0

May 21, 2021

Changes in this version

type ClauseFrom

+ Tables []Serializer

type DateExpression

+ func RawDate(raw string, namedArgs ...map[string]interface{}) DateExpression

type Expression

+ func Func(name string, expressions ...Expression) Expression

+ func RawWithParent(raw string, parent ...Expression) Expression

type FloatExpression

+ func Decimal(value string) FloatExpression

+ func RawFloat(raw string, namedArgs ...map[string]interface{}) FloatExpression

type IntegerExpression

+ func Int16(value int16) IntegerExpression

+ func Int32(value int32) IntegerExpression

+ func Int8(value int8) IntegerExpression

+ func RawInt(raw string, namedArgs ...map[string]interface{}) IntegerExpression

+ func Uint16(value uint16) IntegerExpression

+ func Uint32(value uint32) IntegerExpression

+ func Uint64(value uint64) IntegerExpression

+ func Uint8(value uint8) IntegerExpression

+ type Rows struct

+ func (r *Rows) Scan(destination interface{}) error

type SelectTable

+ func NewLateral(selectStmt SerializerStatement, alias string) SelectTable

type Statement

+ func RawStatement(dialect Dialect, rawQuery string, namedArgument ...map[string]interface{}) Statement

+ Rows func(ctx context.Context, db qrm.DB) (*Rows, error)

type StringExpression

+ func RawString(raw string, namedArgs ...map[string]interface{}) StringExpression

+ func UUID(value fmt.Stringer) StringExpression

type Table

+ Alias func() string

type TimeExpression

+ func RawTime(raw string, namedArgs ...map[string]interface{}) TimeExpression

type TimestampExpression

+ func RawTimestamp(raw string, namedArgs ...map[string]interface{}) TimestampExpression

type TimestampzExpression

+ func RawTimestampz(raw string, namedArgs ...map[string]interface{}) TimestampzExpression

type TimezExpression

+ func RawTimez(raw string, namedArgs ...map[string]interface{}) TimezExpression

v2.4.0

Jun 28, 2020

Changes in this version

+ const StringConcatOperator

+ const StringNotRegexpLikeOperator

+ const StringRegexpLikeOperator

+ var CURRENT_ROW = frameExtentKeyword

+ var NULL = newNullLiteral()

+ var STAR = newStarLiteral()

+ var UNBOUNDED = Keyword("UNBOUNDED")

+ func AVG(numericExpression NumericExpression) floatWindowExpression

+ func BIT_AND(integerExpression IntegerExpression) integerWindowExpression

+ func BIT_OR(integerExpression IntegerExpression) integerWindowExpression

+ func BOOL_AND(boolExpression BoolExpression) boolWindowExpression

+ func BOOL_OR(boolExpression BoolExpression) boolWindowExpression

+ func COUNT(expression Expression) integerWindowExpression

+ func CUME_DIST() floatWindowExpression

+ func DENSE_RANK() integerWindowExpression

+ func EVERY(boolExpression BoolExpression) boolWindowExpression

+ func FIRST_VALUE(value Expression) windowExpression

+ func FixedLiteral(value interface{}) *literalExpressionImpl

+ func LAG(expr Expression, offsetAndDefault ...interface{}) windowExpression

+ func LAST_VALUE(value Expression) windowExpression

+ func LEAD(expr Expression, offsetAndDefault ...interface{}) windowExpression

+ func Literal(value interface{}) *literalExpressionImpl

+ func MAXf(floatExpression FloatExpression) floatWindowExpression

+ func MAXi(integerExpression IntegerExpression) integerWindowExpression

+ func MINf(floatExpression FloatExpression) floatWindowExpression

+ func MINi(integerExpression IntegerExpression) integerWindowExpression

+ func NTH_VALUE(value Expression, nth int64) windowExpression

+ func NTILE(numOfBuckets int64) integerWindowExpression

+ func NewBinaryOperatorExpression(lhs, rhs Serializer, operator string, additionalParam ...Expression) *binaryOperatorExpression

+ func NewFloatWindowFunc(name string, expressions ...Expression) floatWindowExpression

+ func NewRowLock(name string) func() RowLock

+ func NewTimestampFunc(name string, expressions ...Expression) *timestampFunc

+ func OptionalOrDefaultString(defaultStr string, str ...string) string

+ func PERCENT_RANK() floatWindowExpression

+ func RANK() integerWindowExpression

+ func ROW_NUMBER() integerWindowExpression

+ func SUMf(floatExpression FloatExpression) floatWindowExpression

+ func SUMi(integerExpression IntegerExpression) integerWindowExpression

+ func Serialize(exp Serializer, statementType StatementType, out *SQLBuilder, ...)

+ func SerializeClauseList(statement StatementType, clauses []Serializer, out *SQLBuilder)

+ func SerializeColumnExpressionNames(columns []ColumnExpression, statementType StatementType, out *SQLBuilder, ...)

+ func SerializeColumnNames(columns []Column, out *SQLBuilder)

+ func SerializeForProjection(projection Projection, statementType StatementType, out *SQLBuilder)

+ func SerializeProjectionList(statement StatementType, projections []Projection, out *SQLBuilder)

+ func SetLoggerFunc(loggerFunc LoggerFunc)

+ func SetSubQuery(columnExpression ColumnExpression, subQuery SelectTable)

+ func SetTableName(columnExpression ColumnExpression, tableName string)

+ func UnwindRowsFromModels(columns []Column, data interface{}) [][]Serializer

+ func WITH(dialect Dialect, cte ...CommonTableExpressionDefinition) func(statement Statement) Statement

+ type BoolExpression interface

+ AND func(rhs BoolExpression) BoolExpression

+ EQ func(rhs BoolExpression) BoolExpression

+ IS_DISTINCT_FROM func(rhs BoolExpression) BoolExpression

+ IS_FALSE func() BoolExpression

+ IS_NOT_DISTINCT_FROM func(rhs BoolExpression) BoolExpression

+ IS_NOT_FALSE func() BoolExpression

+ IS_NOT_TRUE func() BoolExpression

+ IS_NOT_UNKNOWN func() BoolExpression

+ IS_TRUE func() BoolExpression

+ IS_UNKNOWN func() BoolExpression

+ NOT_EQ func(rhs BoolExpression) BoolExpression

+ OR func(rhs BoolExpression) BoolExpression

+ func Bool(value bool) BoolExpression

+ func BoolExp(expression Expression) BoolExpression

+ func EXISTS(subQuery Expression) BoolExpression

+ func Eq(lhs, rhs Expression) BoolExpression

+ func Gt(lhs, rhs Expression) BoolExpression

+ func GtEq(lhs, rhs Expression) BoolExpression

+ func IsDistinctFrom(lhs, rhs Expression) BoolExpression

+ func IsNotDistinctFrom(lhs, rhs Expression) BoolExpression

+ func Lt(lhs Expression, rhs Expression) BoolExpression

+ func LtEq(lhs, rhs Expression) BoolExpression

+ func NOT(exp BoolExpression) BoolExpression

+ func NotEq(lhs, rhs Expression) BoolExpression

+ func REGEXP_LIKE(stringExp StringExpression, pattern StringExpression, matchType ...string) BoolExpression

+ type CaseOperator interface

+ ELSE func(els Expression) CaseOperator

+ THEN func(then Expression) CaseOperator

+ WHEN func(condition Expression) CaseOperator

+ func CASE(expression ...Expression) CaseOperator

+ type Cast interface

+ AS func(castType string) Expression

+ func NewCastImpl(expression Expression) Cast

+ type Clause interface

+ Serialize func(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseDelete struct

+ Table SerializerTable

+ func (d *ClauseDelete) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseFor struct

+ Lock RowLock

+ func (f *ClauseFor) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseFrom struct

+ Table Serializer

+ func (f *ClauseFrom) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseGroupBy struct

+ List []GroupByClause

+ func (c *ClauseGroupBy) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseHaving struct

+ Condition BoolExpression

+ func (c *ClauseHaving) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseIn struct

+ LockMode string

+ func (i *ClauseIn) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseInsert struct

+ Columns []Column

+ Table SerializerTable

+ func (i *ClauseInsert) GetColumns() []Column

+ func (i *ClauseInsert) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseLimit struct

+ Count int64

+ func (l *ClauseLimit) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseOffset struct

+ Count int64

+ func (o *ClauseOffset) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseOptional struct

+ InNewLine bool

+ Name string

+ Show bool

+ func (d *ClauseOptional) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseOrderBy struct

+ List []OrderByClause

+ SkipNewLine bool

+ func (o *ClauseOrderBy) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseQuery struct

+ Query SerializerStatement

+ func (v *ClauseQuery) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseSelect struct

+ Distinct bool

+ ProjectionList []Projection

+ func (s *ClauseSelect) Projections() ProjectionList

+ func (s *ClauseSelect) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseSetStmtOperator struct

+ All bool

+ Limit ClauseLimit

+ Offset ClauseOffset

+ Operator string

+ OrderBy ClauseOrderBy

+ Selects []SerializerStatement

+ func (s *ClauseSetStmtOperator) Projections() ProjectionList

+ func (s *ClauseSetStmtOperator) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseStatementBegin struct

+ Name string

+ Tables []SerializerTable

+ func (d *ClauseStatementBegin) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseUpdate struct

+ Table SerializerTable

+ func (u *ClauseUpdate) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseValues struct

+ Rows [][]Serializer

+ func (v *ClauseValues) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseValuesQuery struct

+ func (v *ClauseValuesQuery) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseWhere struct

+ Condition BoolExpression

+ Mandatory bool

+ func (c *ClauseWhere) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseWindow struct

+ Definitions []WindowDefinition

+ func (i *ClauseWindow) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ClauseWithProjections interface

+ Projections func() ProjectionList

+ type Column interface

+ Name func() string

+ TableName func() string

+ func UnwidColumnList(columns []Column) []Column

+ func UnwindColumns(column1 Column, columns ...Column) []Column

+ type ColumnAssigment interface

+ type ColumnBool interface

+ From func(subQuery SelectTable) ColumnBool

+ SET func(boolExp BoolExpression) ColumnAssigment

+ func BoolColumn(name string) ColumnBool

+ type ColumnDate interface

+ From func(subQuery SelectTable) ColumnDate

+ SET func(dateExp DateExpression) ColumnAssigment

+ func DateColumn(name string) ColumnDate

+ type ColumnExpression interface

+ type ColumnExpressionImpl struct

+ func NewColumnImpl(name string, tableName string, parent ColumnExpression) ColumnExpressionImpl

+ func (c *ColumnExpressionImpl) Name() string

+ func (c *ColumnExpressionImpl) TableName() string

+ type ColumnFloat interface

+ From func(subQuery SelectTable) ColumnFloat

+ SET func(floatExp FloatExpression) ColumnAssigment

+ func FloatColumn(name string) ColumnFloat

+ type ColumnInteger interface

+ From func(subQuery SelectTable) ColumnInteger

+ SET func(intExp IntegerExpression) ColumnAssigment

+ func IntegerColumn(name string) ColumnInteger

+ type ColumnList []ColumnExpression

+ func (cl ColumnList) Name() string

+ func (cl ColumnList) SET(expression Expression) ColumnAssigment

+ func (cl ColumnList) TableName() string

+ type ColumnSerializer interface

+ type ColumnString interface

+ From func(subQuery SelectTable) ColumnString

+ SET func(stringExp StringExpression) ColumnAssigment

+ func StringColumn(name string) ColumnString

+ type ColumnTime interface

+ From func(subQuery SelectTable) ColumnTime

+ SET func(timeExp TimeExpression) ColumnAssigment

+ func TimeColumn(name string) ColumnTime

+ type ColumnTimestamp interface

+ From func(subQuery SelectTable) ColumnTimestamp

+ SET func(timestampExp TimestampExpression) ColumnAssigment

+ func TimestampColumn(name string) ColumnTimestamp

+ type ColumnTimestampz interface

+ From func(subQuery SelectTable) ColumnTimestampz

+ SET func(timestampzExp TimestampzExpression) ColumnAssigment

+ func TimestampzColumn(name string) ColumnTimestampz

+ type ColumnTimez interface

+ From func(subQuery SelectTable) ColumnTimez

+ func TimezColumn(name string) ColumnTimez

+ type CommonTableExpression struct

+ func CTE(name string) CommonTableExpression

+ func (c *CommonTableExpression) AS(statement SerializerStatement) CommonTableExpressionDefinition

+ func (s CommonTableExpression) Alias() string

+ func (s CommonTableExpression) AllColumns() ProjectionList

+ type CommonTableExpressionDefinition struct

+ type DateExpression interface

+ ADD func(rhs Interval) TimestampExpression

+ EQ func(rhs DateExpression) BoolExpression

+ GT func(rhs DateExpression) BoolExpression

+ GT_EQ func(rhs DateExpression) BoolExpression

+ IS_DISTINCT_FROM func(rhs DateExpression) BoolExpression

+ IS_NOT_DISTINCT_FROM func(rhs DateExpression) BoolExpression

+ LT func(rhs DateExpression) BoolExpression

+ LT_EQ func(rhs DateExpression) BoolExpression

+ NOT_EQ func(rhs DateExpression) BoolExpression

+ SUB func(rhs Interval) TimestampExpression

+ func CURRENT_DATE() DateExpression

+ func Date(year int, month time.Month, day int) DateExpression

+ func DateExp(expression Expression) DateExpression

+ func DateT(t time.Time) DateExpression

+ func TO_DATE(dateStr, format StringExpression) DateExpression

+ type Dialect interface

+ AliasQuoteChar func() byte

+ ArgumentPlaceholder func() QueryPlaceholderFunc

+ FunctionSerializeOverride func(function string) SerializeOverride

+ IdentifierQuoteChar func() byte

+ IsReservedWord func(name string) bool

+ Name func() string

+ OperatorSerializeOverride func(operator string) SerializeOverride

+ PackageName func() string

+ func NewDialect(params DialectParams) Dialect

+ type DialectParams struct

+ AliasQuoteChar byte

+ ArgumentPlaceholder QueryPlaceholderFunc

+ FunctionSerializeOverrides map[string]SerializeOverride

+ IdentifierQuoteChar byte

+ Name string

+ OperatorSerializeOverrides map[string]SerializeOverride

+ PackageName string

+ ReservedWords []string

+ type Expression interface

+ AS func(alias string) Projection

+ ASC func() OrderByClause

+ DESC func() OrderByClause

+ IN func(expressions ...Expression) BoolExpression

+ IS_NOT_NULL func() BoolExpression

+ IS_NULL func() BoolExpression

+ NOT_IN func(expressions ...Expression) BoolExpression

+ func Add(lhs, rhs Serializer) Expression

+ func COALESCE(value Expression, values ...Expression) Expression

+ func Div(lhs, rhs Serializer) Expression

+ func GREATEST(value Expression, values ...Expression) Expression

+ func LEAST(value Expression, values ...Expression) Expression

+ func MAX(expression Expression) Expression

+ func MIN(expression Expression) Expression

+ func Mod(lhs, rhs Serializer) Expression

+ func Mul(lhs, rhs Serializer) Expression

+ func NULLIF(value1, value2 Expression) Expression

+ func OptionalOrDefaultExpression(defaultExpression Expression, expression ...Expression) Expression

+ func ROW(expressions ...Expression) Expression

+ func Raw(raw string, parent ...Expression) Expression

+ func SUM(expression Expression) Expression

+ func Sub(lhs, rhs Serializer) Expression

+ func WRAP(expression ...Expression) Expression

+ type ExpressionInterfaceImpl struct

+ Parent Expression

+ func (e *ExpressionInterfaceImpl) AS(alias string) Projection

+ func (e *ExpressionInterfaceImpl) ASC() OrderByClause

+ func (e *ExpressionInterfaceImpl) DESC() OrderByClause

+ func (e *ExpressionInterfaceImpl) IN(expressions ...Expression) BoolExpression

+ func (e *ExpressionInterfaceImpl) IS_NOT_NULL() BoolExpression

+ func (e *ExpressionInterfaceImpl) IS_NULL() BoolExpression

+ func (e *ExpressionInterfaceImpl) NOT_IN(expressions ...Expression) BoolExpression

+ type ExpressionStatement interface

+ func NewExpressionStatementImpl(Dialect Dialect, statementType StatementType, parent ExpressionStatement, ...) ExpressionStatement

+ type FloatExpression interface

+ ADD func(rhs NumericExpression) FloatExpression

+ DIV func(rhs NumericExpression) FloatExpression

+ EQ func(rhs FloatExpression) BoolExpression

+ GT func(rhs FloatExpression) BoolExpression

+ GT_EQ func(rhs FloatExpression) BoolExpression

+ IS_DISTINCT_FROM func(rhs FloatExpression) BoolExpression

+ IS_NOT_DISTINCT_FROM func(rhs FloatExpression) BoolExpression

+ LT func(rhs FloatExpression) BoolExpression

+ LT_EQ func(rhs FloatExpression) BoolExpression

+ MOD func(rhs NumericExpression) FloatExpression

+ MUL func(rhs NumericExpression) FloatExpression

+ NOT_EQ func(rhs FloatExpression) BoolExpression

+ POW func(rhs NumericExpression) FloatExpression

+ SUB func(rhs NumericExpression) FloatExpression

+ func ABSf(floatExpression FloatExpression) FloatExpression

+ func CBRT(numericExpression NumericExpression) FloatExpression

+ func CEIL(floatExpression FloatExpression) FloatExpression

+ func FLOOR(floatExpression FloatExpression) FloatExpression

+ func Float(value float64) FloatExpression

+ func FloatExp(expression Expression) FloatExpression

+ func LN(floatExpression FloatExpression) FloatExpression

+ func LOG(floatExpression FloatExpression) FloatExpression

+ func NewFloatFunc(name string, expressions ...Expression) FloatExpression

+ func POW(base, exponent NumericExpression) FloatExpression

+ func POWER(base, exponent NumericExpression) FloatExpression

+ func ROUND(floatExpression FloatExpression, precision ...IntegerExpression) FloatExpression

+ func SIGN(floatExpression FloatExpression) FloatExpression

+ func SQRT(numericExpression NumericExpression) FloatExpression

+ func TO_NUMBER(floatStr, format StringExpression) FloatExpression

+ func TRUNC(floatExpression FloatExpression, precision ...IntegerExpression) FloatExpression

+ type FrameExtent interface

+ func FOLLOWING(offset Serializer) FrameExtent

+ func PRECEDING(offset Serializer) FrameExtent

+ type GroupByClause interface

+ type HasProjections interface

+ type IntegerExpression interface

+ ADD func(rhs IntegerExpression) IntegerExpression

+ BIT_AND func(rhs IntegerExpression) IntegerExpression

+ BIT_OR func(rhs IntegerExpression) IntegerExpression

+ BIT_SHIFT_LEFT func(shift IntegerExpression) IntegerExpression

+ BIT_SHIFT_RIGHT func(shift IntegerExpression) IntegerExpression

+ BIT_XOR func(rhs IntegerExpression) IntegerExpression

+ DIV func(rhs IntegerExpression) IntegerExpression

+ EQ func(rhs IntegerExpression) BoolExpression

+ GT func(rhs IntegerExpression) BoolExpression

+ GT_EQ func(rhs IntegerExpression) BoolExpression

+ IS_DISTINCT_FROM func(rhs IntegerExpression) BoolExpression

+ IS_NOT_DISTINCT_FROM func(rhs IntegerExpression) BoolExpression

+ LT func(rhs IntegerExpression) BoolExpression

+ LT_EQ func(rhs IntegerExpression) BoolExpression

+ MOD func(rhs IntegerExpression) IntegerExpression

+ MUL func(rhs IntegerExpression) IntegerExpression

+ NOT_EQ func(rhs IntegerExpression) BoolExpression

+ POW func(rhs IntegerExpression) IntegerExpression

+ SUB func(rhs IntegerExpression) IntegerExpression

+ func ABSi(integerExpression IntegerExpression) IntegerExpression

+ func BIT_LENGTH(stringExpression StringExpression) IntegerExpression

+ func BIT_NOT(expr IntegerExpression) IntegerExpression

+ func CHAR_LENGTH(stringExpression StringExpression) IntegerExpression

+ func Int(value int64) IntegerExpression

+ func IntExp(expression Expression) IntegerExpression

+ func OCTET_LENGTH(stringExpression StringExpression) IntegerExpression

+ func STRPOS(str, substring StringExpression) IntegerExpression

+ type Interval interface

+ type IntervalImpl struct

+ func NewInterval(s Serializer) *IntervalImpl

+ type IsInterval interface

+ type IsIntervalImpl struct

+ type JoinTable SerializerTable

+ func NewJoinTable(lhs Serializer, rhs Serializer, joinType JoinType, onCondition BoolExpression) JoinTable

+ type JoinType int

+ const CrossJoin

+ const FullJoin

+ const InnerJoin

+ const LeftJoin

+ const RightJoin

+ type Keyword string

+ const DEFAULT

+ type KeywordClause struct

+ func (k KeywordClause) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type ListSerializer struct

+ Separator string

+ Serializers []Serializer

+ type LiteralExpression interface

+ SetConstant func(constant bool)

+ Value func() interface{}

+ type LoggerFunc func(ctx context.Context, statement PrintableStatement)

+ type NumericExpression interface

+ type OrderByClause interface

+ type PrintableStatement interface

+ DebugSql func() (query string)

+ Sql func() (query string, args []interface{})

+ type Projection interface

+ func ColumnListToProjectionList(columns []ColumnExpression) []Projection

+ type ProjectionList []Projection

+ type QueryPlaceholderFunc func(ord int) string

+ type RowLock interface

+ NOWAIT func() RowLock

+ SKIP_LOCKED func() RowLock

+ type SQLBuilder struct

+ Args []interface{}

+ Buff bytes.Buffer

+ Debug bool

+ Dialect Dialect

+ func (s *SQLBuilder) DecreaseIdent(ident ...int)

+ func (s *SQLBuilder) IncreaseIdent(ident ...int)

+ func (s *SQLBuilder) NewLine()

+ func (s *SQLBuilder) WriteAlias(str string)

+ func (s *SQLBuilder) WriteByte(b byte)

+ func (s *SQLBuilder) WriteIdentifier(name string, alwaysQuote ...bool)

+ func (s *SQLBuilder) WriteProjections(statement StatementType, projections []Projection)

+ func (s *SQLBuilder) WriteString(str string)

+ type SelectTable interface

+ Alias func() string

+ AllColumns func() ProjectionList

+ func NewSelectTable(selectStmt SerializerStatement, alias string) SelectTable

+ type SerializeOption int

+ const NoWrap

+ const ShortName

+ const SkipNewLine

+ func FallTrough(options []SerializeOption) []SerializeOption

+ func (s SerializeOption) WithFallTrough(options []SerializeOption) []SerializeOption

+ type SerializeOverride func(expressions ...Serializer) SerializerFunc

+ type Serializer interface

+ func ExpressionListToSerializerList(expressions []Expression) []Serializer

+ func NewSerializerClauseImpl(clauses ...Clause) Serializer

+ func ToSerializerValue(value interface{}) Serializer

+ func UnwindRowFromModel(columns []Column, data interface{}) []Serializer

+ func UnwindRowFromValues(value interface{}, values []interface{}) []Serializer

+ type SerializerFunc func(statement StatementType, out *SQLBuilder, options ...SerializeOption)

+ type SerializerStatement interface

+ func NewStatementImpl(Dialect Dialect, statementType StatementType, parent SerializerStatement, ...) SerializerStatement

+ type SerializerTable interface

+ func NewTable(schemaName, name string, columns ...ColumnExpression) SerializerTable

+ type SetClause struct

+ Columns []Column

+ Values []Serializer

+ func (s *SetClause) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type SetClauseNew []ColumnAssigment

+ func (s SetClauseNew) Serialize(statementType StatementType, out *SQLBuilder, options ...SerializeOption)

+ type SetPair struct

+ Column ColumnSerializer

+ Value Serializer

+ type Statement interface

+ DebugSql func() (query string)

+ Exec func(db qrm.DB) (sql.Result, error)

+ ExecContext func(ctx context.Context, db qrm.DB) (sql.Result, error)

+ Query func(db qrm.DB, destination interface{}) error

+ QueryContext func(ctx context.Context, db qrm.DB, destination interface{}) error

+ Sql func() (query string, args []interface{})

+ type StatementType string

+ const DeleteStatementType

+ const InsertStatementType

+ const LockStatementType

+ const SelectStatementType

+ const SetStatementType

+ const UnLockStatementType

+ const UpdateStatementType

+ const WithStatementType

+ type StringExpression interface

+ CONCAT func(rhs Expression) StringExpression

+ EQ func(rhs StringExpression) BoolExpression

+ GT func(rhs StringExpression) BoolExpression

+ GT_EQ func(rhs StringExpression) BoolExpression

+ IS_DISTINCT_FROM func(rhs StringExpression) BoolExpression

+ IS_NOT_DISTINCT_FROM func(rhs StringExpression) BoolExpression

+ LIKE func(pattern StringExpression) BoolExpression

+ LT func(rhs StringExpression) BoolExpression

+ LT_EQ func(rhs StringExpression) BoolExpression

+ NOT_EQ func(rhs StringExpression) BoolExpression

+ NOT_LIKE func(pattern StringExpression) BoolExpression

+ NOT_REGEXP_LIKE func(pattern StringExpression, caseSensitive ...bool) BoolExpression

+ REGEXP_LIKE func(pattern StringExpression, caseSensitive ...bool) BoolExpression

+ func BTRIM(stringExpression StringExpression, trimChars ...StringExpression) StringExpression

+ func CHR(integerExpression IntegerExpression) StringExpression

+ func CONCAT(expressions ...Expression) StringExpression

+ func CONCAT_WS(separator Expression, expressions ...Expression) StringExpression

+ func CONVERT(str StringExpression, srcEncoding StringExpression, ...) StringExpression

+ func CONVERT_FROM(str StringExpression, srcEncoding StringExpression) StringExpression

+ func CONVERT_TO(str StringExpression, toEncoding StringExpression) StringExpression

+ func DECODE(data StringExpression, format StringExpression) StringExpression

+ func ENCODE(data StringExpression, format StringExpression) StringExpression

+ func FORMAT(formatStr StringExpression, formatArgs ...Expression) StringExpression

+ func INITCAP(str StringExpression) StringExpression

+ func LEFT(str StringExpression, n IntegerExpression) StringExpression

+ func LENGTH(str StringExpression, encoding ...StringExpression) StringExpression

+ func LOWER(stringExpression StringExpression) StringExpression

+ func LPAD(str StringExpression, length IntegerExpression, text ...StringExpression) StringExpression

+ func LTRIM(str StringExpression, trimChars ...StringExpression) StringExpression

+ func MD5(stringExpression StringExpression) StringExpression

+ func NewEnumValue(name string) StringExpression

+ func REPEAT(str StringExpression, n IntegerExpression) StringExpression

+ func REPLACE(text, from, to StringExpression) StringExpression

+ func REVERSE(stringExpression StringExpression) StringExpression

+ func RIGHT(str StringExpression, n IntegerExpression) StringExpression

+ func RPAD(str StringExpression, length IntegerExpression, text ...StringExpression) StringExpression

+ func RTRIM(str StringExpression, trimChars ...StringExpression) StringExpression

+ func SUBSTR(str StringExpression, from IntegerExpression, count ...IntegerExpression) StringExpression

+ func String(value string) StringExpression

+ func StringExp(expression Expression) StringExpression

+ func TO_ASCII(str StringExpression, encoding ...StringExpression) StringExpression

+ func TO_CHAR(expression Expression, format StringExpression) StringExpression

+ func TO_HEX(number IntegerExpression) StringExpression

+ func UPPER(stringExpression StringExpression) StringExpression

+ type Table interface

+ AS func(alias string)

+ SchemaName func() string

+ TableName func() string

+ type TimeExpression interface

+ ADD func(rhs Interval) TimeExpression

+ EQ func(rhs TimeExpression) BoolExpression

+ GT func(rhs TimeExpression) BoolExpression

+ GT_EQ func(rhs TimeExpression) BoolExpression

+ IS_DISTINCT_FROM func(rhs TimeExpression) BoolExpression

+ IS_NOT_DISTINCT_FROM func(rhs TimeExpression) BoolExpression

+ LT func(rhs TimeExpression) BoolExpression

+ LT_EQ func(rhs TimeExpression) BoolExpression

+ NOT_EQ func(rhs TimeExpression) BoolExpression

+ SUB func(rhs Interval) TimeExpression

+ func LOCALTIME(precision ...int) TimeExpression

+ func Time(hour, minute, second int, nanoseconds ...time.Duration) TimeExpression

+ func TimeExp(expression Expression) TimeExpression

+ func TimeT(t time.Time) TimeExpression

+ type TimestampExpression interface

+ ADD func(rhs Interval) TimestampExpression

+ EQ func(rhs TimestampExpression) BoolExpression

+ GT func(rhs TimestampExpression) BoolExpression

+ GT_EQ func(rhs TimestampExpression) BoolExpression

+ IS_DISTINCT_FROM func(rhs TimestampExpression) BoolExpression

+ IS_NOT_DISTINCT_FROM func(rhs TimestampExpression) BoolExpression

+ LT func(rhs TimestampExpression) BoolExpression

+ LT_EQ func(rhs TimestampExpression) BoolExpression

+ NOT_EQ func(rhs TimestampExpression) BoolExpression

+ SUB func(rhs Interval) TimestampExpression

+ func LOCALTIMESTAMP(precision ...int) TimestampExpression

+ func Timestamp(year int, month time.Month, day, hour, minute, second int, ...) TimestampExpression

+ func TimestampExp(expression Expression) TimestampExpression

+ func TimestampT(t time.Time) TimestampExpression

+ type TimestampzExpression interface

+ ADD func(rhs Interval) TimestampzExpression

+ EQ func(rhs TimestampzExpression) BoolExpression

+ GT func(rhs TimestampzExpression) BoolExpression

+ GT_EQ func(rhs TimestampzExpression) BoolExpression

+ IS_DISTINCT_FROM func(rhs TimestampzExpression) BoolExpression

+ IS_NOT_DISTINCT_FROM func(rhs TimestampzExpression) BoolExpression

+ LT func(rhs TimestampzExpression) BoolExpression

+ LT_EQ func(rhs TimestampzExpression) BoolExpression

+ NOT_EQ func(rhs TimestampzExpression) BoolExpression

+ SUB func(rhs Interval) TimestampzExpression

+ func CURRENT_TIMESTAMP(precision ...int) TimestampzExpression

+ func NOW() TimestampzExpression

+ func TO_TIMESTAMP(timestampzStr, format StringExpression) TimestampzExpression

+ func Timestampz(year int, month time.Month, day, hour, minute, second int, ...) TimestampzExpression

+ func TimestampzExp(expression Expression) TimestampzExpression

+ func TimestampzT(t time.Time) TimestampzExpression

+ type TimezExpression interface

+ ADD func(rhs Interval) TimezExpression

+ EQ func(rhs TimezExpression) BoolExpression

+ GT func(rhs TimezExpression) BoolExpression

+ GT_EQ func(rhs TimezExpression) BoolExpression

+ IS_DISTINCT_FROM func(rhs TimezExpression) BoolExpression

+ IS_NOT_DISTINCT_FROM func(rhs TimezExpression) BoolExpression

+ LT func(rhs TimezExpression) BoolExpression

+ LT_EQ func(rhs TimezExpression) BoolExpression

+ NOT_EQ func(rhs TimezExpression) BoolExpression

+ SUB func(rhs Interval) TimezExpression

+ func CURRENT_TIME(precision ...int) TimezExpression

+ func Timez(hour, minute, second int, nanoseconds time.Duration, timezone string) TimezExpression

+ func TimezExp(expression Expression) TimezExpression

+ func TimezT(t time.Time) TimezExpression

+ type Window interface

+ GROUPS func(start FrameExtent, end ...FrameExtent) Window

+ ORDER_BY func(expr ...OrderByClause) Window

+ RANGE func(start FrameExtent, end ...FrameExtent) Window

+ ROWS func(start FrameExtent, end ...FrameExtent) Window

+ func ORDER_BY(expr ...OrderByClause) Window

+ func PARTITION_BY(exp Expression, exprs ...Expression) Window

+ func WindowName(name string) Window

+ type WindowDefinition struct

+ Name string

+ Window Window

Other modules containing this package

github.com/go-jet/jet

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