Versions in this module Expand all Collapse all v2 v2.10.3 Feb 9, 2024 Changes in this version + var ABSf = jet.ABSf + var ABSi = jet.ABSi + var AND = jet.AND + var AVG = jet.AVG + var BIT_NOT = jet.BIT_NOT + var Bool = jet.Bool + var BoolColumn = jet.BoolColumn + var BoolExp = jet.BoolExp + var CASE = jet.CASE + var CEIL = jet.CEIL + var COALESCE = jet.COALESCE + var COUNT = jet.COUNT + var CUME_DIST = jet.CUME_DIST + var CURRENT_DATE = jet.CURRENT_DATE + var CURRENT_ROW = jet.CURRENT_ROW + var DAYS = modifier("DAYS") + var DENSE_RANK = jet.DENSE_RANK + var DISTINCT = jet.DISTINCT + var DateColumn = jet.DateColumn + var DateExp = jet.DateExp + var DateTimeColumn = jet.TimestampColumn + var DateTimeExp = jet.TimestampExp + var Decimal = jet.Decimal + var Dialect = newDialect() + var EXISTS = jet.EXISTS + var FIRST_VALUE = jet.FIRST_VALUE + var FLOOR = jet.FLOOR + var Float = jet.Float + var FloatColumn = jet.FloatColumn + var FloatExp = jet.FloatExp + var Func = jet.Func + var HOURS = modifier("HOURS") + var Int = jet.Int + var Int16 = jet.Int16 + var Int32 = jet.Int32 + var Int64 = jet.Int + var Int8 = jet.Int8 + var IntExp = jet.IntExp + var IntegerColumn = jet.IntegerColumn + var LAG = jet.LAG + var LAST_VALUE = jet.LAST_VALUE + var LEAD = jet.LEAD + var LN = jet.LN + var LOCALTIME = String("localtime") + var LOG = jet.LOG + var LOWER = jet.LOWER + var LTRIM = jet.LTRIM + var MAX = jet.MAX + var MAXf = jet.MAXf + var MAXi = jet.MAXi + var MIN = jet.MIN + var MINUTES = modifier("MINUTES") + var MINf = jet.MINf + var MINi = jet.MINi + var MONTHS = modifier("MONTHS") + var NOT = jet.NOT + var NTH_VALUE = jet.NTH_VALUE + var NTILE = jet.NTILE + var NULL = jet.NULL + var NULLIF = jet.NULLIF + var NewEnumValue = jet.NewEnumValue + var OR = jet.OR + var ORDER_BY = jet.ORDER_BY + var PARTITION_BY = jet.PARTITION_BY + var PERCENT_RANK = jet.PERCENT_RANK + var POW = jet.POW + var POWER = jet.POWER + var RANK = jet.RANK + var REGEXP_LIKE = jet.REGEXP_LIKE + var REPLACE = jet.REPLACE + var REVERSE = jet.REVERSE + var ROUND = jet.ROUND + var ROW_NUMBER = jet.ROW_NUMBER + var RTRIM = jet.RTRIM + var Raw = jet.Raw + var RawBool = jet.RawBool + var RawDate = jet.RawDate + var RawFloat = jet.RawFloat + var RawInt = jet.RawInt + var RawString = jet.RawString + var RawTime = jet.RawTime + var RawTimestamp = jet.RawTimestamp + var SECONDS = modifier("SECONDS") + var SHARE = jet.NewRowLock("SHARE") + var SIGN = jet.SIGN + var SQRT = jet.SQRT + var STAR = jet.STAR + var START_OF_MONTH = String("start of month") + var START_OF_YEAR = String("start of year") + var SUBSTR = jet.SUBSTR + var SUM = jet.SUM + var SUMf = jet.SUMf + var SUMi = jet.SUMi + var SetLogger = jet.SetLoggerFunc + var SetQueryLogger = jet.SetQueryLogger + var String = jet.String + var StringColumn = jet.StringColumn + var StringExp = jet.StringExp + var TRUNC = TRUNCATE + var TRUNCATE = func(floatExpression jet.FloatExpression, precision jet.IntegerExpression) jet.FloatExpression + var TimeColumn = jet.TimeColumn + var TimeExp = jet.TimeExp + var TimestampColumn = jet.TimestampColumn + var TimestampExp = jet.TimestampExp + var UNBOUNDED = jet.UNBOUNDED + var UNIXEPOCH = String("unixepoch") + var UPDATE = jet.NewRowLock("UPDATE") + var UPPER = jet.UPPER + var UTC = String("UTC") + var UUID = jet.UUID + var Uint16 = jet.Uint16 + var Uint32 = jet.Uint32 + var Uint64 = jet.Uint64 + var Uint8 = jet.Uint8 + var WEEKDAY = func(value int) Expression + var Window = jet.WindowName + var YEARS = modifier("YEARS") + func CAST(expr Expression) cast + func CBRT(number jet.NumericExpression) jet.FloatExpression + func FOLLOWING(offset interface{}) jet.FrameExtent + func LENGTH(str jet.StringExpression) jet.StringExpression + func PRECEDING(offset interface{}) jet.FrameExtent + func SET(assigments ...ColumnAssigment) conflictAction + func UNION(lhs, rhs jet.SerializerStatement, selects ...jet.SerializerStatement) setStatement + func UNION_ALL(lhs, rhs jet.SerializerStatement, selects ...jet.SerializerStatement) setStatement + func WITH(cte ...CommonTableExpression) func(statement jet.Statement) Statement + func WITH_RECURSIVE(cte ...CommonTableExpression) func(statement jet.Statement) Statement + type BoolExpression = jet.BoolExpression + type Column = jet.ColumnExpression + type ColumnAssigment = jet.ColumnAssigment + type ColumnBool = jet.ColumnBool + type ColumnDate = jet.ColumnDate + type ColumnDateTime = jet.ColumnTimestamp + type ColumnFloat = jet.ColumnFloat + type ColumnInteger = jet.ColumnInteger + type ColumnList = jet.ColumnList + type ColumnString = jet.ColumnString + type ColumnTime = jet.ColumnTime + type ColumnTimestamp = jet.ColumnTimestamp + type CommonTableExpression interface + ALIAS func(alias string) SelectTable + AS func(statement jet.SerializerStatement) CommonTableExpression + AS_NOT_MATERIALIZED func(statement jet.SerializerStatement) CommonTableExpression + func CTE(name string, columns ...jet.ColumnExpression) CommonTableExpression + type DateExpression = jet.DateExpression + func DATE(timeValue interface{}, modifiers ...Expression) DateExpression + func Date(year int, month time.Month, day int) DateExpression + type DateTimeExpression = jet.TimestampExpression + func DATETIME(timeValue interface{}, modifiers ...Expression) DateTimeExpression + func DateTime(year int, month time.Month, day, hour, minute, second int, ...) DateTimeExpression + type DeleteStatement interface + LIMIT func(limit int64) DeleteStatement + ORDER_BY func(orderByClauses ...OrderByClause) DeleteStatement + RETURNING func(projections ...Projection) DeleteStatement + WHERE func(expression BoolExpression) DeleteStatement + type Expression = jet.Expression + func ROW(expressions ...Expression) Expression + type FloatExpression = jet.FloatExpression + func JULIANDAY(timeValue interface{}, modifiers ...Expression) FloatExpression + type GroupByClause = jet.GroupByClause + type InsertStatement interface + DEFAULT_VALUES func() InsertStatement + MODEL func(data interface{}) InsertStatement + MODELS func(data interface{}) InsertStatement + ON_CONFLICT func(indexExpressions ...jet.ColumnExpression) onConflict + QUERY func(selectStatement SelectStatement) InsertStatement + RETURNING func(projections ...Projection) InsertStatement + VALUES func(value interface{}, values ...interface{}) InsertStatement + type IntegerExpression = jet.IntegerExpression + type NumericExpression = jet.NumericExpression + type OrderByClause = jet.OrderByClause + type PrintableStatement = jet.PrintableStatement + type Projection = jet.Projection + type ProjectionList = jet.ProjectionList + type QueryInfo = jet.QueryInfo + type RawArgs = map[string]interface + type ReadableTable interface + type RowLock = jet.RowLock + type Rows = jet.Rows + type SelectStatement interface + AsTable func(alias string) SelectTable + DISTINCT func() SelectStatement + FOR func(lock RowLock) SelectStatement + FROM func(tables ...ReadableTable) SelectStatement + GROUP_BY func(groupByClauses ...GroupByClause) SelectStatement + HAVING func(boolExpression BoolExpression) SelectStatement + LIMIT func(limit int64) SelectStatement + LOCK_IN_SHARE_MODE func() SelectStatement + OFFSET func(offset int64) SelectStatement + ORDER_BY func(orderByClauses ...OrderByClause) SelectStatement + UNION func(rhs SelectStatement) setStatement + UNION_ALL func(rhs SelectStatement) setStatement + WHERE func(expression BoolExpression) SelectStatement + WINDOW func(name string) windowExpand + func SELECT(projection Projection, projections ...Projection) SelectStatement + type SelectTable interface + type Statement = jet.Statement + func RawStatement(rawQuery string, namedArguments ...RawArgs) Statement + type StringExpression = jet.StringExpression + func STRFTIME(format StringExpression, timeValue interface{}, modifiers ...Expression) StringExpression + type Table interface + DELETE func() DeleteStatement + INSERT func(columns ...jet.Column) InsertStatement + UPDATE func(columns ...jet.Column) UpdateStatement + func NewTable(schemaName, name, alias string, columns ...jet.ColumnExpression) Table + type TimeExpression = jet.TimeExpression + func CURRENT_TIME() TimeExpression + func TIME(timeValue interface{}, modifiers ...Expression) TimeExpression + func Time(hour, minute, second int, nanoseconds ...time.Duration) TimeExpression + type TimestampExpression = jet.TimestampExpression + func CURRENT_TIMESTAMP() TimestampExpression + func TIMESTAMP(str StringExpression) TimestampExpression + func UNIX_TIMESTAMP(str StringExpression) TimestampExpression + type UpdateStatement interface + FROM func(tables ...ReadableTable) UpdateStatement + MODEL func(data interface{}) UpdateStatement + RETURNING func(projections ...Projection) UpdateStatement + SET func(value interface{}, values ...interface{}) UpdateStatement + WHERE func(expression BoolExpression) UpdateStatement
Go to main page