Versions in this module Expand all Collapse all v2 v2.10.3 Feb 9, 2024 Changes in this version + const CENTURY + const DAY + const DECADE + const DEFAULT + const DOW + const DOY + const EPOCH + const HOUR + const ISODOW + const ISOYEAR + const JULIAN + const MICROSECOND + const MILLENNIUM + const MILLISECOND + const MINUTE + const MONTH + const QUARTER + const SECOND + const TIMEZONE + const TIMEZONE_HOUR + const TIMEZONE_MINUTE + const WEEK + const YEAR + var ABSf = jet.ABSf + var ABSi = jet.ABSi + var AND = jet.AND + var AVG = jet.AVG + var BIT_AND = jet.BIT_AND + var BIT_LENGTH = jet.BIT_LENGTH + var BIT_NOT = jet.BIT_NOT + var BIT_OR = jet.BIT_OR + var BOOL_AND = jet.BOOL_AND + var BOOL_OR = jet.BOOL_OR + var BTRIM = jet.BTRIM + var BoolColumn = jet.BoolColumn + var BoolExp = jet.BoolExp + var CASE = jet.CASE + var CBRT = jet.CBRT + var CEIL = jet.CEIL + var CHAR_LENGTH = jet.CHAR_LENGTH + var CHR = jet.CHR + var COALESCE = jet.COALESCE + var CONCAT = func(expressions ...Expression) StringExpression + var CONVERT = jet.CONVERT + var CONVERT_FROM = jet.CONVERT_FROM + var CONVERT_TO = jet.CONVERT_TO + var COUNT = jet.COUNT + var CUBE = jet.CUBE + var CUME_DIST = jet.CUME_DIST + var CURRENT_DATE = jet.CURRENT_DATE + var CURRENT_ROW = jet.CURRENT_ROW + var CURRENT_TIME = jet.CURRENT_TIME + var CURRENT_TIMESTAMP = jet.CURRENT_TIMESTAMP + var DECODE = jet.DECODE + var DENSE_RANK = jet.DENSE_RANK + var DISTINCT = jet.DISTINCT + var DateColumn = jet.DateColumn + var DateExp = jet.DateExp + var Decimal = jet.Decimal + var Dialect = newDialect() + var ENCODE = jet.ENCODE + var EVERY = jet.EVERY + 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 GREATEST = jet.GREATEST + var GROUPING = jet.GROUPING + var GROUPING_SETS = jet.GROUPING_SETS + var INITCAP = jet.INITCAP + var Int = jet.Int + var IntExp = jet.IntExp + var IntegerColumn = jet.IntegerColumn + var KEY_SHARE = jet.NewRowLock("KEY SHARE") + var LAG = jet.LAG + var LAST_VALUE = jet.LAST_VALUE + var LEAD = jet.LEAD + var LEAST = jet.LEAST + var LEFT = jet.LEFT + var LENGTH = jet.LENGTH + var LN = jet.LN + var LOCALTIME = jet.LOCALTIME + var LOCALTIMESTAMP = jet.LOCALTIMESTAMP + var LOG = jet.LOG + var LOWER = jet.LOWER + var LPAD = jet.LPAD + var LTRIM = jet.LTRIM + var MAX = jet.MAX + var MAXf = jet.MAXf + var MAXi = jet.MAXi + var MD5 = jet.MD5 + var MIN = jet.MIN + var MINf = jet.MINf + var MINi = jet.MINi + var MODE = jet.MODE + var NOT = jet.NOT + var NOW = jet.NOW + var NO_KEY_UPDATE = jet.NewRowLock("NO KEY UPDATE") + var NTH_VALUE = jet.NTH_VALUE + var NTILE = jet.NTILE + var NULL = jet.NULL + var NULLIF = jet.NULLIF + var NewEnumValue = jet.NewEnumValue + var OCTET_LENGTH = jet.OCTET_LENGTH + 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 RANGE_LOWER = jet.RANGE_LOWER + var RANGE_UPPER = jet.RANGE_UPPER + var RANK = jet.RANK + var REPEAT = jet.REPEAT + var REPLACE = jet.REPLACE + var REVERSE = jet.REVERSE + var RIGHT = jet.RIGHT + var ROLLUP = jet.ROLLUP + var ROUND = jet.ROUND + var ROW = jet.ROW + var ROW_NUMBER = jet.ROW_NUMBER + var RPAD = jet.RPAD + var RTRIM = jet.RTRIM + var RangeColumn = jet.RangeColumn + var RangeExp = jet.RangeExp + 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 RawTimestampz = jet.RawTimestampz + var RawTimez = jet.RawTimez + var SHARE = jet.NewRowLock("SHARE") + var SIGN = jet.SIGN + var SQRT = jet.SQRT + var STAR = jet.STAR + var STRPOS = jet.STRPOS + 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 StringColumn = jet.StringColumn + var StringExp = jet.StringExp + var TO_ASCII = jet.TO_ASCII + var TO_CHAR = jet.TO_CHAR + var TO_DATE = jet.TO_DATE + var TO_HEX = jet.TO_HEX + var TO_NUMBER = jet.TO_NUMBER + var TO_TIMESTAMP = jet.TO_TIMESTAMP + var TRUNC = jet.TRUNC + var TimeColumn = jet.TimeColumn + var TimeExp = jet.TimeExp + var TimestampColumn = jet.TimestampColumn + var TimestampExp = jet.TimestampExp + var TimestampzColumn = jet.TimestampzColumn + var TimestampzExp = jet.TimestampzExp + var TimezColumn = jet.TimezColumn + var TimezExp = jet.TimezExp + var UNBOUNDED = int64(math.MaxInt64) + var UPDATE = jet.NewRowLock("UPDATE") + var UPPER = jet.UPPER + var UUID = jet.UUID + var WRAP = jet.WRAP + var Window = jet.WindowName + func CAST(expr Expression) cast + func EXCEPT(lhs, rhs jet.SerializerStatement) setStatement + func EXCEPT_ALL(lhs, rhs jet.SerializerStatement) setStatement + func FOLLOWING(offset int64) jet.FrameExtent + func INTERSECT(lhs, rhs jet.SerializerStatement, selects ...jet.SerializerStatement) setStatement + func INTERSECT_ALL(lhs, rhs jet.SerializerStatement, selects ...jet.SerializerStatement) setStatement + func LATERAL(selectStmt SelectStatement) lateralImpl + func PERCENTILE_CONT(fraction FloatExpression) *jet.OrderSetAggregateFunc + func PERCENTILE_DISC(fraction FloatExpression) *jet.OrderSetAggregateFunc + func PRECEDING(offset int64) 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 + func Bool(value bool) BoolExpression + type Column = jet.ColumnExpression + type ColumnAssigment = jet.ColumnAssigment + type ColumnBool = jet.ColumnBool + type ColumnDate = jet.ColumnDate + type ColumnFloat = jet.ColumnFloat + type ColumnInteger = jet.ColumnInteger + type ColumnInterval interface + From func(subQuery SelectTable) ColumnInterval + func IntervalColumn(name string) ColumnInterval + type ColumnList = jet.ColumnList + type ColumnRange = jet.ColumnRange + type ColumnString = jet.ColumnString + type ColumnTime = jet.ColumnTime + type ColumnTimestamp = jet.ColumnTimestamp + type ColumnTimestampz = jet.ColumnTimestampz + type ColumnTimez = jet.ColumnTimez + 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(year int, month time.Month, day int) DateExpression + func DateT(t time.Time) DateExpression + type DeleteStatement interface + RETURNING func(projections ...jet.Projection) DeleteStatement + USING func(tables ...ReadableTable) DeleteStatement + WHERE func(expression BoolExpression) DeleteStatement + type Expression = jet.Expression + type FloatExpression = jet.FloatExpression + func EXTRACT(field unit, from Expression) FloatExpression + type GroupByClause = jet.GroupByClause + type InsertStatement interface + 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 + func Int16(value int16) IntegerExpression + func Int32(value int32) IntegerExpression + func Int64(value int64) IntegerExpression + func Int8(value int8) IntegerExpression + func Uint16(value uint16) IntegerExpression + func Uint32(value uint32) IntegerExpression + func Uint64(value uint64) IntegerExpression + func Uint8(value uint8) IntegerExpression + type IntervalExpression interface + ADD func(rhs IntervalExpression) IntervalExpression + BETWEEN func(min, max IntervalExpression) BoolExpression + DIV func(rhs NumericExpression) IntervalExpression + EQ func(rhs IntervalExpression) BoolExpression + GT func(rhs IntervalExpression) BoolExpression + GT_EQ func(rhs IntervalExpression) BoolExpression + IS_DISTINCT_FROM func(rhs IntervalExpression) BoolExpression + IS_NOT_DISTINCT_FROM func(rhs IntervalExpression) BoolExpression + LT func(rhs IntervalExpression) BoolExpression + LT_EQ func(rhs IntervalExpression) BoolExpression + MUL func(rhs NumericExpression) IntervalExpression + NOT_BETWEEN func(min, max IntervalExpression) BoolExpression + NOT_EQ func(rhs IntervalExpression) BoolExpression + SUB func(rhs IntervalExpression) IntervalExpression + func INTERVAL(quantityAndUnit ...quantityAndUnit) IntervalExpression + func INTERVALd(duration time.Duration) IntervalExpression + func IntervalExp(expression Expression) IntervalExpression + type LockStatement interface + IN func(lockMode TableLockMode) LockStatement + NOWAIT func() LockStatement + func LOCK(tables ...jet.SerializerTable) LockStatement + 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 RangeExpression = jet.RangeExpression + func DateRange(lowDate, highDate time.Time, bounds string) RangeExpression + func NumRange(lowNum, highNum *int, bounds string) RangeExpression + func TimestampRange(lowTs, highTs time.Time, bounds string) RangeExpression + func TimestampTzRange(lowTs, highTs time.Time, bounds string) RangeExpression + 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(on ...jet.ColumnExpression) SelectStatement + EXCEPT func(rhs SelectStatement) setStatement + EXCEPT_ALL func(rhs SelectStatement) setStatement + FETCH_FIRST func(count IntegerExpression) fetchExpand + FOR func(lock RowLock) SelectStatement + FROM func(tables ...ReadableTable) SelectStatement + GROUP_BY func(groupByClauses ...GroupByClause) SelectStatement + HAVING func(boolExpression BoolExpression) SelectStatement + INTERSECT func(rhs SelectStatement) setStatement + INTERSECT_ALL func(rhs SelectStatement) setStatement + LIMIT func(limit int64) 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 Bytea(value interface{}) StringExpression + func CONCAT_WS(separator Expression, expressions ...Expression) StringExpression + func FORMAT(formatStr StringExpression, formatArgs ...Expression) StringExpression + func Json(value interface{}) StringExpression + func String(value string) StringExpression + type Table interface + func NewTable(schemaName, name, alias string, columns ...jet.ColumnExpression) Table + type TableLockMode string + const LOCK_ACCESS_EXCLUSIVE + const LOCK_ACCESS_SHARE + const LOCK_EXCLUSIVE + const LOCK_ROW_EXCLUSIVE + const LOCK_ROW_SHARE + const LOCK_SHARE + const LOCK_SHARE_ROW_EXCLUSIVE + const LOCK_SHARE_UPDATE_EXCLUSIVE + type TimeExpression = jet.TimeExpression + func Time(hour, minute, second int, nanoseconds ...time.Duration) TimeExpression + func TimeT(t time.Time) TimeExpression + type TimestampExpression = jet.TimestampExpression + func Timestamp(year int, month time.Month, day, hour, minute, second int, ...) TimestampExpression + func TimestampT(t time.Time) TimestampExpression + type TimestampzExpression = jet.TimestampzExpression + func Timestampz(year int, month time.Month, day, hour, minute, second int, ...) TimestampzExpression + func TimestampzT(t time.Time) TimestampzExpression + type TimezExpression = jet.TimezExpression + func Timez(hour, minute, second int, milliseconds time.Duration, timezone string) TimezExpression + func TimezT(t time.Time) TimezExpression + 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 + type WritableTable interface
Go to main page