Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

jet

package module

Go to main page

Versions in this module

v1

v1.0.0

Jul 23, 2019

Changes in this version

+ const DEFAULT

+ 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

+ var KEY_SHARE = newLock("KEY SHARE")

+ var NO_KEY_UPDATE = newLock("NO KEY UPDATE")

+ var NULL = newNullLiteral()

+ var SHARE = newLock("SHARE")

+ var STAR = newStarLiteral()

+ var UPDATE = newLock("UPDATE")

+ func CAST(expression Expression) cast

+ 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_AND(boolExpression BoolExpression) BoolExpression

+ func BOOL_OR(boolExpression BoolExpression) BoolExpression

+ func Bool(value bool) BoolExpression

+ func BoolExp(expression Expression) BoolExpression

+ func EVERY(boolExpression BoolExpression) BoolExpression

+ func EXISTS(subQuery SelectStatement) BoolExpression

+ func NOT(exp BoolExpression) 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 Column interface

+ type ColumnBool interface

+ From func(subQuery SelectTable) ColumnBool

+ func BoolColumn(name string) ColumnBool

+ type ColumnDate interface

+ From func(subQuery SelectTable) ColumnDate

+ func DateColumn(name string) ColumnDate

+ type ColumnFloat interface

+ From func(subQuery SelectTable) ColumnFloat

+ func FloatColumn(name string) ColumnFloat

+ type ColumnInteger interface

+ From func(subQuery SelectTable) ColumnInteger

+ func IntegerColumn(name string) ColumnInteger

+ type ColumnList []Column

+ func (cl ColumnList) Name() string

+ func (cl ColumnList) TableName() string

+ type ColumnString interface

+ From func(subQuery SelectTable) ColumnString

+ func StringColumn(name string) ColumnString

+ type ColumnTime interface

+ From func(subQuery SelectTable) ColumnTime

+ func TimeColumn(name string) ColumnTime

+ type ColumnTimestamp interface

+ From func(subQuery SelectTable) ColumnTimestamp

+ func TimestampColumn(name string) ColumnTimestamp

+ type ColumnTimestampz interface

+ From func(subQuery SelectTable) ColumnTimestampz

+ func TimestampzColumn(name string) ColumnTimestampz

+ type ColumnTimez interface

+ From func(subQuery SelectTable) ColumnTimez

+ func TimezColumn(name string) ColumnTimez

+ type DateExpression interface

+ 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

+ func CURRENT_DATE() DateExpression

+ func Date(year, month, day int) DateExpression

+ func DateExp(expression Expression) DateExpression

+ func TO_DATE(dateStr, format StringExpression) DateExpression

+ type DeleteStatement interface

+ RETURNING func(projections ...projection) DeleteStatement

+ WHERE func(expression BoolExpression) DeleteStatement

+ 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 COALESCE(value Expression, values ...Expression) Expression

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

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

+ func NULLIF(value1, value2 Expression) Expression

+ func RAW(raw string) Expression

+ func ROW(expressions ...Expression) Expression

+ func WRAP(expression ...Expression) Expression

+ 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 AVG(numericExpression NumericExpression) 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 MAXf(floatExpression FloatExpression) FloatExpression

+ func MINf(floatExpression FloatExpression) FloatExpression

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

+ func SIGN(floatExpression FloatExpression) FloatExpression

+ func SQRT(numericExpression NumericExpression) FloatExpression

+ func SUMf(floatExpression FloatExpression) FloatExpression

+ func TO_NUMBER(floatStr, format StringExpression) FloatExpression

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

+ type InsertStatement interface

+ MODEL func(data interface{}) InsertStatement

+ MODELS func(data interface{}) InsertStatement

+ QUERY func(selectStatement SelectStatement) InsertStatement

+ RETURNING func(projections ...projection) InsertStatement

+ VALUES func(value interface{}, values ...interface{}) InsertStatement

+ 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_AND(integerExpression IntegerExpression) IntegerExpression

+ func BIT_LENGTH(stringExpression StringExpression) IntegerExpression

+ func BIT_NOT(expr IntegerExpression) IntegerExpression

+ func BIT_OR(integerExpression IntegerExpression) IntegerExpression

+ func CHAR_LENGTH(stringExpression StringExpression) IntegerExpression

+ func COUNT(expression Expression) IntegerExpression

+ func Int(value int64) IntegerExpression

+ func IntExp(expression Expression) IntegerExpression

+ func MAXi(integerExpression IntegerExpression) IntegerExpression

+ func MINi(integerExpression IntegerExpression) IntegerExpression

+ func OCTET_LENGTH(stringExpression StringExpression) IntegerExpression

+ func STRPOS(str, substring StringExpression) IntegerExpression

+ func SUMi(integerExpression IntegerExpression) IntegerExpression

+ type LockStatement interface

+ IN func(lockMode TableLockMode) LockStatement

+ NOWAIT func() LockStatement

+ func LOCK(tables ...WritableTable) LockStatement

+ type NumericExpression interface

+ type ProjectionList []projection

+ type ReadableTable interface

+ type SelectLock interface

+ NOWAIT func() SelectLock

+ SKIP_LOCKED func() SelectLock

+ type SelectStatement interface

+ AsTable func(alias string) SelectTable

+ DISTINCT func() SelectStatement

+ EXCEPT func(rhs SelectStatement) SelectStatement

+ EXCEPT_ALL func(rhs SelectStatement) SelectStatement

+ FOR func(lock SelectLock) SelectStatement

+ FROM func(table ReadableTable) SelectStatement

+ GROUP_BY func(groupByClauses ...groupByClause) SelectStatement

+ HAVING func(boolExpression BoolExpression) SelectStatement

+ INTERSECT func(rhs SelectStatement) SelectStatement

+ INTERSECT_ALL func(rhs SelectStatement) SelectStatement

+ LIMIT func(limit int64) SelectStatement

+ OFFSET func(offset int64) SelectStatement

+ ORDER_BY func(orderByClauses ...orderByClause) SelectStatement

+ UNION func(rhs SelectStatement) SelectStatement

+ UNION_ALL func(rhs SelectStatement) SelectStatement

+ WHERE func(expression BoolExpression) SelectStatement

+ func EXCEPT(lhs, rhs SelectStatement) SelectStatement

+ func EXCEPT_ALL(lhs, rhs SelectStatement) SelectStatement

+ func INTERSECT(lhs, rhs SelectStatement, selects ...SelectStatement) SelectStatement

+ func INTERSECT_ALL(lhs, rhs SelectStatement, selects ...SelectStatement) SelectStatement

+ func SELECT(projection1 projection, projections ...projection) SelectStatement

+ func UNION(lhs, rhs SelectStatement, selects ...SelectStatement) SelectStatement

+ func UNION_ALL(lhs, rhs SelectStatement, selects ...SelectStatement) SelectStatement

+ type SelectTable interface

+ Alias func() string

+ AllColumns func() ProjectionList

+ type Statement interface

+ DebugSql func() (query string, err error)

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

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

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

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

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

+ 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_SIMILAR_TO func(pattern StringExpression) BoolExpression

+ SIMILAR_TO func(pattern StringExpression) BoolExpression

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

+ func CHR(integerExpression IntegerExpression) 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 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

+ func NewTable(schemaName, name string, columns ...Column) Table

+ type TableLockMode string

+ type TimeExpression interface

+ 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

+ func LOCALTIME(precision ...int) TimeExpression

+ func Time(hour, minute, second, milliseconds int) TimeExpression

+ func TimeExp(expression Expression) TimeExpression

+ type TimestampExpression interface

+ 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

+ func LOCALTIMESTAMP(precision ...int) TimestampExpression

+ func Timestamp(year, month, day, hour, minute, second, milliseconds int) TimestampExpression

+ func TimestampExp(expression Expression) TimestampExpression

+ type TimestampzExpression interface

+ 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

+ func CURRENT_TIMESTAMP(precision ...int) TimestampzExpression

+ func NOW() TimestampzExpression

+ func TO_TIMESTAMP(timestampzStr, format StringExpression) TimestampzExpression

+ func Timestampz(year, month, day, hour, minute, second, milliseconds, timezone int) TimestampzExpression

+ func TimestampzExp(expression Expression) TimestampzExpression

+ type TimezExpression interface

+ 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

+ func CURRENT_TIME(precision ...int) TimezExpression

+ func Timez(hour, minute, second, milliseconds, timezone int) TimezExpression

+ func TimezExp(expression Expression) TimezExpression

+ type UpdateStatement interface

+ 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

Incompatible versions in this module

v2.3.0+incompatible

Jun 3, 2020

v2.2.0+incompatible

Feb 17, 2020

v2.1.2+incompatible

Oct 18, 2019

v2.1.1+incompatible

Oct 4, 2019

v2.1.0+incompatible

Sep 28, 2019

v2.0.0+incompatible

Sep 21, 2019

Other modules containing this package

github.com/goranbjelanovic/jet/v2