sqlite

package module

Go to main page

Versions in this module

v1

v1.2.0

Mar 27, 2024

Changes in this version

+ func ErrorOffset(err error) (offset int, ok bool)

v1.1.2

Feb 14, 2024

v1.1.1

Feb 2, 2024

v1.1.0

Jan 14, 2024

v1.0.0

Dec 7, 2023

Changes in this version

type Stmt

+ func (stmt *Stmt) ColumnIsNull(col int) bool

+ func (stmt *Stmt) IsNull(colName string) bool

v0

v0.13.1

Aug 15, 2023

v0.13.0

Mar 28, 2023

Changes in this version

+ type CollatingFunc func(a, b string) int

type Conn

+ func (c *Conn) Deserialize(dbName string, data []byte) error

+ func (c *Conn) Serialize(dbName string) ([]byte, error)

+ func (c *Conn) SetCollation(name string, compare CollatingFunc) error

+ func (c *Conn) SetModule(name string, module *Module) error

+ type IndexConstraint struct

+ Collation string

+ Column int

+ Op IndexConstraintOp

+ RValue Value

+ RValueKnown bool

+ Usable bool

+ type IndexConstraintOp uint8

+ const IndexConstraintEq

+ const IndexConstraintGE

+ const IndexConstraintGT

+ const IndexConstraintGlob

+ const IndexConstraintIs

+ const IndexConstraintIsNot

+ const IndexConstraintIsNotNull

+ const IndexConstraintIsNull

+ const IndexConstraintLE

+ const IndexConstraintLT

+ const IndexConstraintLike

+ const IndexConstraintLimit

+ const IndexConstraintMatch

+ const IndexConstraintNE

+ const IndexConstraintOffset

+ const IndexConstraintRegexp

+ func (op IndexConstraintOp) String() string

+ type IndexConstraintUsage struct

+ ArgvIndex int

+ Omit bool

+ type IndexFlags uint32

+ const IndexScanUnique

+ type IndexID struct

+ Num int32

+ String string

+ type IndexInputs struct

+ ColumnsUsed uint64

+ Constraints []IndexConstraint

+ OrderBy []IndexOrderBy

+ type IndexOrderBy struct

+ Column int

+ Desc bool

+ type IndexOutputs struct

+ ConstraintUsage []IndexConstraintUsage

+ EstimatedCost float64

+ EstimatedRows int64

+ ID IndexID

+ IndexFlags IndexFlags

+ OrderByConsumed bool

+ UseZeroEstimates bool

+ type Module struct

+ Connect VTableConnectFunc

+ Create VTableConnectFunc

+ UseConnectAsCreate bool

+ type RenameVTable interface

+ Rename func(new string) error

+ type SavepointVTable interface

+ Release func(n int) error

+ RollbackTo func(n int) error

+ Savepoint func(n int) error

+ type TransactionVTable interface

+ Begin func() error

+ Commit func() error

+ Rollback func() error

+ Sync func() error

+ type VTable interface

+ BestIndex func(*IndexInputs) (*IndexOutputs, error)

+ Destroy func() error

+ Disconnect func() error

+ Open func() (VTableCursor, error)

+ type VTableConfig struct

+ AllowIndirect bool

+ ConstraintSupport bool

+ Declaration string

+ type VTableConnectFunc func(*Conn, *VTableConnectOptions) (VTable, *VTableConfig, error)

+ type VTableConnectOptions struct

+ Args []string

+ DatabaseName string

+ ModuleName string

+ VTableName string

+ type VTableCursor interface

+ Close func() error

+ Column func(i int, noChange bool) (Value, error)

+ EOF func() bool

+ Filter func(id IndexID, argv []Value) error

+ Next func() error

+ RowID func() (int64, error)

+ type VTableUpdateParams struct

+ Columns []Value

+ NewRowID Value

+ OldRowID Value

+ func (p VTableUpdateParams) IsInsert() bool

type Value

+ func Unchanged() Value

+ func (v Value) NoChange() bool

+ type WritableVTable interface

+ DeleteRow func(rowID Value) error

+ Update func(params VTableUpdateParams) (rowID int64, err error)

v0.12.0

Feb 9, 2023

Changes in this version

+ type Backup struct

+ func NewBackup(dst *Conn, dstName string, src *Conn, srcName string) (*Backup, error)

+ func (b *Backup) Close() error

+ func (b *Backup) PageCount() int

+ func (b *Backup) Remaining() int

+ func (b *Backup) Step(n int) (more bool, err error)

v0.11.0

Dec 12, 2022

Changes in this version

+ type AggregateFunction interface

+ Finalize func(ctx Context)

+ Step func(ctx Context, rowArgs []Value) error

+ WindowInverse func(ctx Context, rowArgs []Value) error

+ WindowValue func(ctx Context) (Value, error)

type FunctionImpl

+ MakeAggregate func(ctx Context) (AggregateFunction, error)

v0.11.0-beta1

Jul 19, 2022

v0.10.1

Jul 17, 2022

v0.10.0

Jul 10, 2022

Changes in this version

type FunctionImpl

+ WindowInverse func(ctx Context, rowArgs []Value) error

+ WindowValue func(ctx Context) (Value, error)

v0.9.3

May 30, 2022

v0.9.2

Jan 25, 2022

v0.9.1

Jan 23, 2022

retracted

v0.9.0

Jan 23, 2022

retracted

Changes in this version

type Conn

+ func (c *Conn) SetBlockOnBusy()

type ResultCode

+ func (code ResultCode) ToError() error

type Stmt

+ func (stmt *Stmt) ColumnBool(col int) bool

+ func (stmt *Stmt) GetBool(colName string) bool

v0.9.0-beta1

Nov 29, 2021

v0.8.0

Nov 7, 2021

v0.7.2

Sep 11, 2021

v0.7.1

Sep 10, 2021

v0.7.0

Aug 27, 2021

v0.6.2

Aug 17, 2021

v0.6.1

Aug 17, 2021

v0.6.0

Aug 15, 2021

Changes in this version

+ const ChangesetAbort

+ const ChangesetConflict

+ const ChangesetConstraint

+ const ChangesetData

+ const ChangesetForeignKey

+ const ChangesetNotFound

+ const ChangesetOmit

+ const ChangesetReplace

+ func ConcatChangesets(w io.Writer, changeset1, changeset2 io.Reader) error

+ func InvertChangeset(w io.Writer, r io.Reader) error

+ type Changegroup struct

+ func NewChangegroup() (*Changegroup, error)

+ func (cg *Changegroup) Add(r io.Reader) error

+ func (cg *Changegroup) Clear()

+ func (cg *Changegroup) WriteTo(w io.Writer) (n int64, err error)

+ type ChangesetIterator struct

+ func NewChangesetIterator(r io.Reader) (*ChangesetIterator, error)

+ func (iter *ChangesetIterator) Close() error

+ func (iter *ChangesetIterator) ConflictValue(col int) (Value, error)

+ func (iter *ChangesetIterator) ForeignKeyConflicts() (int, error)

+ func (iter *ChangesetIterator) New(col int) (Value, error)

+ func (iter *ChangesetIterator) Next() (rowReturned bool, err error)

+ func (iter *ChangesetIterator) Old(col int) (Value, error)

+ func (iter *ChangesetIterator) Operation() (*ChangesetOperation, error)

+ func (iter *ChangesetIterator) PrimaryKey() ([]bool, error)

+ type ChangesetOperation struct

+ Indirect bool

+ NumColumns int

+ TableName string

+ Type OpType

+ type ConflictAction int32

+ func (code ConflictAction) String() string

+ type ConflictHandler func(ConflictType, *ChangesetIterator) ConflictAction

+ type ConflictType int32

+ func (code ConflictType) String() string

type Conn

+ func (c *Conn) ApplyChangeset(r io.Reader, filterFn func(tableName string) bool, conflictFn ConflictHandler) error

+ func (c *Conn) ApplyInverseChangeset(r io.Reader, filterFn func(tableName string) bool, conflictFn ConflictHandler) error

+ func (c *Conn) CreateSession(db string) (*Session, error)

+ type Session struct

+ func (s *Session) Attach(tableName string) error

+ func (s *Session) Delete()

+ func (s *Session) Diff(srcDB, tableName string) error

+ func (s *Session) Disable()

+ func (s *Session) Enable()

+ func (s *Session) WriteChangeset(w io.Writer) error

+ func (s *Session) WritePatchset(w io.Writer) error

v0.5.0

May 22, 2021

Changes in this version

+ const Version

+ const VersionNumber

+ type Action struct

+ func (action Action) Accessor() string

+ func (action Action) Column() string

+ func (action Action) Database() string

+ func (action Action) File() string

+ func (action Action) Index() string

+ func (action Action) Module() string

+ func (action Action) Operation() string

+ func (action Action) Pragma() string

+ func (action Action) PragmaArg() string

+ func (action Action) Savepoint() string

+ func (action Action) String() string

+ func (action Action) Table() string

+ func (action Action) Trigger() string

+ func (action Action) Type() OpType

+ func (action Action) View() string

+ type AuthResult int32

+ const AuthResultDeny

+ const AuthResultIgnore

+ const AuthResultOK

+ func (result AuthResult) String() string

+ type AuthorizeFunc func(Action) AuthResult

+ func (f AuthorizeFunc) Authorize(action Action) AuthResult

+ type Authorizer interface

+ Authorize func(Action) AuthResult

type Conn

+ func (c *Conn) Limit(id Limit, value int32) int32

+ func (c *Conn) SetAuthorizer(auth Authorizer) error

+ func (c *Conn) SetDefensive(enabled bool) error

+ type Limit int32

+ const LimitAttached

+ const LimitColumn

+ const LimitCompoundSelect

+ const LimitExprDepth

+ const LimitFunctionArg

+ const LimitLength

+ const LimitLikePatternLength

+ const LimitSQLLength

+ const LimitTriggerDepth

+ const LimitVDBEOp

+ const LimitVariableNumber

+ const LimitWorkerThreads

+ func (limit Limit) String() string

+ type OpType int32

+ const OpAlterTable

+ const OpAnalyze

+ const OpAttach

+ const OpCopy

+ const OpCreateIndex

+ const OpCreateTable

+ const OpCreateTempIndex

+ const OpCreateTempTable

+ const OpCreateTempTrigger

+ const OpCreateTempView

+ const OpCreateTrigger

+ const OpCreateVTable

+ const OpCreateView

+ const OpDelete

+ const OpDetach

+ const OpDropIndex

+ const OpDropTable

+ const OpDropTempIndex

+ const OpDropTempTable

+ const OpDropTempTrigger

+ const OpDropTempView

+ const OpDropTrigger

+ const OpDropVTable

+ const OpDropView

+ const OpFunction

+ const OpInsert

+ const OpPragma

+ const OpRead

+ const OpRecursive

+ const OpReindex

+ const OpSavepoint

+ const OpSelect

+ const OpTransaction

+ const OpUpdate

+ func (op OpType) String() string

v0.4.0

May 14, 2021

Changes in this version

type Context

+ func (ctx Context) AuxData(arg int) interface{}

+ func (ctx Context) Conn() *Conn

+ func (ctx Context) SetAuxData(arg int, data interface{})

v0.3.1

May 4, 2021

v0.3.0

Apr 27, 2021

Changes in this version

type Blob

+ func (blob *Blob) ReadFrom(r io.Reader) (n int64, err error)

+ func (blob *Blob) WriteString(s string) (int, error)

+ func (blob *Blob) WriteTo(w io.Writer) (n int64, err error)

v0.2.2

Apr 24, 2021

v0.2.1

Apr 17, 2021

v0.2.0

Apr 3, 2021

Changes in this version

+ type FunctionImpl struct

+ AggregateFinal func(ctx Context) (Value, error)

+ AggregateStep func(ctx Context, rowArgs []Value)

+ AllowIndirect bool

+ Deterministic bool

+ NArgs int

+ Scalar func(ctx Context, args []Value) (Value, error)

type Value

+ func BlobValue(b []byte) Value

+ func FloatValue(f float64) Value

+ func IntegerValue(i int64) Value

+ func TextValue(s string) Value

v0.1.0

Apr 1, 2021

Changes in this version

+ type Blob struct

+ func (blob *Blob) Close() error

+ func (blob *Blob) Read(p []byte) (int, error)

+ func (blob *Blob) Seek(offset int64, whence int) (int64, error)

+ func (blob *Blob) Size() int64

+ func (blob *Blob) Write(p []byte) (int, error)

+ type ColumnType int

+ const TypeBlob

+ const TypeFloat

+ const TypeInteger

+ const TypeNull

+ const TypeText

+ func (t ColumnType) String() string

+ type Conn struct

+ func OpenConn(path string, flags ...OpenFlags) (*Conn, error)

+ func (c *Conn) Changes() int

+ func (c *Conn) Close() error

+ func (c *Conn) CreateFunction(name string, deterministic bool, numArgs int, ...) error

+ func (c *Conn) LastInsertRowID() int64

+ func (c *Conn) PrepareTransient(query string) (stmt *Stmt, trailingBytes int, err error)

+ func (c *Conn) SetBusyTimeout(d time.Duration)

+ func (conn *Conn) AutocommitEnabled() bool

+ func (conn *Conn) CheckReset() string

+ func (conn *Conn) OpenBlob(dbn, table, column string, row int64, write bool) (*Blob, error)

+ func (conn *Conn) Prep(query string) *Stmt

+ func (conn *Conn) Prepare(query string) (*Stmt, error)

+ func (conn *Conn) SetInterrupt(doneCh <-chan struct{}) (oldDoneCh <-chan struct{})

+ type Context struct

+ func (ctx Context) ResultError(err error)

+ func (ctx Context) ResultFloat(v float64)

+ func (ctx Context) ResultInt(v int)

+ func (ctx Context) ResultInt64(v int64)

+ func (ctx Context) ResultNull()

+ func (ctx Context) ResultText(v string)

+ func (ctx Context) ResultValue(v Value)

+ func (ctx Context) ResultZeroBlob(n int64)

+ func (ctx Context) SetUserData(data interface{})

+ func (ctx Context) UserData() interface{}

+ type OpenFlags uint

+ const OpenCreate

+ const OpenFullMutex

+ const OpenMainDB

+ const OpenMainJournal

+ const OpenMasterJournal

+ const OpenMemory

+ const OpenNoMutex

+ const OpenPrivateCache

+ const OpenReadOnly

+ const OpenReadWrite

+ const OpenSharedCache

+ const OpenSubjournal

+ const OpenTempDB

+ const OpenTempJournal

+ const OpenTransientDB

+ const OpenURI

+ const OpenWAL

+ func (flags OpenFlags) String() string

+ type ResultCode int32

+ const ResultAbort

+ const ResultAbortRollback

+ const ResultAuth

+ const ResultAuthUser

+ const ResultBusy

+ const ResultBusyRecovery

+ const ResultBusySnapshot

+ const ResultCantOpen

+ const ResultCantOpenConvPath

+ const ResultCantOpenFullPath

+ const ResultCantOpenIsDir

+ const ResultCantOpenNoTempDir

+ const ResultConstraint

+ const ResultConstraintCheck

+ const ResultConstraintCommitHook

+ const ResultConstraintForeignKey

+ const ResultConstraintFunction

+ const ResultConstraintNotNull

+ const ResultConstraintPrimaryKey

+ const ResultConstraintRowID

+ const ResultConstraintTrigger

+ const ResultConstraintUnique

+ const ResultConstraintVTab

+ const ResultCorrupt

+ const ResultCorruptVTab

+ const ResultDone

+ const ResultEmpty

+ const ResultError

+ const ResultErrorMissingCollSeq

+ const ResultErrorRetry

+ const ResultErrorSnapshot

+ const ResultFormat

+ const ResultFull

+ const ResultIOErr

+ const ResultIOErrAccess

+ const ResultIOErrAuth

+ const ResultIOErrBeginAtomic

+ const ResultIOErrBlocked

+ const ResultIOErrCheckReservedLock

+ const ResultIOErrClose

+ const ResultIOErrCommitAtomic

+ const ResultIOErrConvPath

+ const ResultIOErrDelete

+ const ResultIOErrDeleteNoEnt

+ const ResultIOErrDirClose

+ const ResultIOErrDirFsync

+ const ResultIOErrFstat

+ const ResultIOErrFsync

+ const ResultIOErrGetTempPath

+ const ResultIOErrLock

+ const ResultIOErrMMap

+ const ResultIOErrNoMem

+ const ResultIOErrRead

+ const ResultIOErrReadLock

+ const ResultIOErrRollbackAtomic

+ const ResultIOErrSHMLock

+ const ResultIOErrSHMMap

+ const ResultIOErrSHMOpen

+ const ResultIOErrSHMSize

+ const ResultIOErrSeek

+ const ResultIOErrShortRead

+ const ResultIOErrTruncate

+ const ResultIOErrUnlock

+ const ResultIOErrVNode

+ const ResultIOErrWrite

+ const ResultInternal

+ const ResultInterrupt

+ const ResultLocked

+ const ResultLockedSharedCache

+ const ResultMismatch

+ const ResultMisuse

+ const ResultNoLFS

+ const ResultNoMem

+ const ResultNotADB

+ const ResultNotFound

+ const ResultNotice

+ const ResultNoticeRecoverRollback

+ const ResultNoticeRecoverWAL

+ const ResultOK

+ const ResultPerm

+ const ResultProtocol

+ const ResultRange

+ const ResultReadOnly

+ const ResultReadOnlyCantInit

+ const ResultReadOnlyCantLock

+ const ResultReadOnlyDBMoved

+ const ResultReadOnlyDirectory

+ const ResultReadOnlyRecovery

+ const ResultReadOnlyRollback

+ const ResultRow

+ const ResultSchema

+ const ResultTooBig

+ const ResultWarning

+ const ResultWarningAutoIndex

+ func ErrCode(err error) ResultCode

+ func (code ResultCode) IsSuccess() bool

+ func (code ResultCode) Message() string

+ func (code ResultCode) String() string

+ func (code ResultCode) ToPrimary() ResultCode

+ type Stmt struct

+ func (stmt *Stmt) BindBool(param int, value bool)

+ func (stmt *Stmt) BindBytes(param int, value []byte)

+ func (stmt *Stmt) BindFloat(param int, value float64)

+ func (stmt *Stmt) BindInt64(param int, value int64)

+ func (stmt *Stmt) BindNull(param int)

+ func (stmt *Stmt) BindParamCount() int

+ func (stmt *Stmt) BindParamName(i int) string

+ func (stmt *Stmt) BindText(param int, value string)

+ func (stmt *Stmt) BindZeroBlob(param int, len int64)

+ func (stmt *Stmt) ClearBindings() error

+ func (stmt *Stmt) ColumnBytes(col int, buf []byte) int

+ func (stmt *Stmt) ColumnCount() int

+ func (stmt *Stmt) ColumnDatabaseName(col int) string

+ func (stmt *Stmt) ColumnFloat(col int) float64

+ func (stmt *Stmt) ColumnIndex(colName string) int

+ func (stmt *Stmt) ColumnInt(col int) int

+ func (stmt *Stmt) ColumnInt32(col int) int32

+ func (stmt *Stmt) ColumnInt64(col int) int64

+ func (stmt *Stmt) ColumnLen(col int) int

+ func (stmt *Stmt) ColumnName(col int) string

+ func (stmt *Stmt) ColumnReader(col int) *bytes.Reader

+ func (stmt *Stmt) ColumnTableName(col int) string

+ func (stmt *Stmt) ColumnText(col int) string

+ func (stmt *Stmt) ColumnType(col int) ColumnType

+ func (stmt *Stmt) DataCount() int

+ func (stmt *Stmt) Finalize() error

+ func (stmt *Stmt) GetBytes(colName string, buf []byte) int

+ func (stmt *Stmt) GetFloat(colName string) float64

+ func (stmt *Stmt) GetInt64(colName string) int64

+ func (stmt *Stmt) GetLen(colName string) int

+ func (stmt *Stmt) GetReader(colName string) *bytes.Reader

+ func (stmt *Stmt) GetText(colName string) string

+ func (stmt *Stmt) Reset() error

+ func (stmt *Stmt) SetBool(param string, value bool)

+ func (stmt *Stmt) SetBytes(param string, value []byte)

+ func (stmt *Stmt) SetFloat(param string, value float64)

+ func (stmt *Stmt) SetInt64(param string, value int64)

+ func (stmt *Stmt) SetNull(param string)

+ func (stmt *Stmt) SetText(param string, value string)

+ func (stmt *Stmt) SetZeroBlob(param string, len int64)

+ func (stmt *Stmt) Step() (rowReturned bool, err error)

+ type Value struct

+ func (v Value) Blob() []byte

+ func (v Value) Float() float64

+ func (v Value) Int() int

+ func (v Value) Int64() int64

+ func (v Value) IsNil() bool

+ func (v Value) Len() int

+ func (v Value) Text() string

+ func (v Value) Type() ColumnType

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