sqlite

package

Go to main page

Versions in this module

v2

v2.12.0

Nov 3, 2024

Changes in this version

+ var BinaryOperator = jet.BinaryOperator

+ var CustomExpression = jet.CustomExpression

+ var RowExp = jet.RowExp

+ func VALUES(rows ...RowExpression) values

+ type RowExpression = jet.RowExpression

+ type Token = jet.Token

v2.11.1

Mar 24, 2024

v2.11.0

Feb 27, 2024

v2.10.1

Jul 24, 2023

Changes in this version

+ var RawBool = jet.RawBool

+ type Rows = jet.Rows

v2.10.0

Apr 17, 2023

v2.9.0

Sep 30, 2022

Changes in this version

+ var COALESCE = jet.COALESCE

+ var NULLIF = jet.NULLIF

v2.8.0

May 17, 2022

v2.7.1

Feb 14, 2022

Changes in this version

+ var AND = jet.AND

+ var OR = jet.OR

v2.7.0

Jan 20, 2022

Changes in this version

+ var DISTINCT = jet.DISTINCT

+ var SetQueryLogger = jet.SetQueryLogger

+ func WITH_RECURSIVE(cte ...CommonTableExpression) func(statement jet.Statement) Statement

type CommonTableExpression

+ ALIAS func(alias string) SelectTable

+ AS func(statement jet.SerializerStatement) CommonTableExpression

+ AS_NOT_MATERIALIZED func(statement jet.SerializerStatement) CommonTableExpression

+ type QueryInfo = jet.QueryInfo

type UpdateStatement

+ FROM func(tables ...ReadableTable) UpdateStatement

v2.6.0

Oct 25, 2021

Changes in this version

+ var ABSf = jet.ABSf

+ var ABSi = jet.ABSi

+ 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 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 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 NewEnumValue = jet.NewEnumValue

+ 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 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 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 ...jet.CommonTableExpressionDefinition) 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 struct

+ func CTE(name string) CommonTableExpression

+ func (r CommonTableExpression) CROSS_JOIN(table ReadableTable) joinSelectUpdateTable

+ func (r CommonTableExpression) FULL_JOIN(table ReadableTable, onCondition BoolExpression) joinSelectUpdateTable

+ func (r CommonTableExpression) INNER_JOIN(table ReadableTable, onCondition BoolExpression) joinSelectUpdateTable

+ func (r CommonTableExpression) LEFT_JOIN(table ReadableTable, onCondition BoolExpression) joinSelectUpdateTable

+ func (r CommonTableExpression) RIGHT_JOIN(table ReadableTable, onCondition BoolExpression) joinSelectUpdateTable

+ func (r CommonTableExpression) SELECT(projection1 Projection, projections ...Projection) SelectStatement

+ 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 ...jet.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 RawArgs = map[string]interface

+ type ReadableTable interface

+ type RowLock = jet.RowLock

+ 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

+ MODEL func(data interface{}) UpdateStatement

+ RETURNING func(projections ...jet.Projection) UpdateStatement

+ SET func(value interface{}, values ...interface{}) UpdateStatement

+ WHERE func(expression BoolExpression) UpdateStatement

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