sqlite3

package

Go to main page

Versions in this module

v1

v1.0.51

Oct 12, 2021

Changes in this version

type Statement

+ func (s *Statement) IsExplain() bool

v1.0.50

Oct 9, 2021

v1.0.49

Oct 8, 2021

v1.0.48

Oct 5, 2021

Changes in this version

type ConnEx

+ func (c *ConnEx) PrepareCached(q string, cached bool) (*StatementEx, error)

type StatementEx

+ func (s *StatementEx) Cached() bool

v1.0.47

Oct 5, 2021

v1.0.46

Oct 4, 2021

v1.0.45

Oct 3, 2021

v1.0.44

Oct 3, 2021

v1.0.43

Oct 3, 2021

v1.0.42

Oct 3, 2021

v1.0.41

Oct 3, 2021

v1.0.40

Oct 3, 2021

v1.0.39

Oct 3, 2021

v1.0.38

Oct 3, 2021

v1.0.37

Oct 3, 2021

v1.0.36

Oct 1, 2021

Changes in this version

+ const DefaultFlags

+ const DefaultMemory

+ const DefaultSchema

+ func GetMemoryUsed() (int64, int64)

+ func IsComplete(v string) bool

+ func KeywordCheck(v string) bool

+ func KeywordCount() int

+ func KeywordName(index int) string

+ func ResetMemoryUsed()

+ func Sleep(d time.Duration)

+ func Version() (string, int, string)

+ type AuthorizerHookFunc func(SQAction, [4]string) SQAuth

+ type Backup C.sqlite3_backup

+ func (b *Backup) Finish() error

+ func (b *Backup) PageCount() int

+ func (b *Backup) Remaining() int

+ func (b *Backup) Step(n int) error

+ func (b *Backup) String() string

+ type Blob C.sqlite3_blob

+ func (b *Blob) Bytes() int

+ func (b *Blob) Close() error

+ func (b *Blob) ReadAt(data []byte, offset int64) error

+ func (b *Blob) Reopen(rowid int64) error

+ func (b *Blob) String() string

+ func (b *Blob) WriteAt(data []byte, offset int64) error

+ type BlobEx struct

+ func (b *BlobEx) Close() error

+ func (b *BlobEx) Read(data []byte) (int, error)

+ func (b *BlobEx) ReadAt(data []byte, offset int64) (int, error)

+ func (b *BlobEx) Reopen(rowid int64) error

+ func (b *BlobEx) Seek(offset int64, whence int) (int64, error)

+ func (b *BlobEx) String() string

+ func (b *BlobEx) Write(data []byte) (int, error)

+ func (b *BlobEx) WriteAt(data []byte, offset int64) (int, error)

+ type BusyHandlerFunc func(int) bool

+ type CommitHookFunc func() bool

+ type Conn C.sqlite3

+ func OpenPath(path string, flags OpenFlags, vfs string) (*Conn, error)

+ func OpenUrl(url string, flags OpenFlags, vfs string) (*Conn, error)

+ func (c *Conn) Autocommit() bool

+ func (c *Conn) CacheFlush() error

+ func (c *Conn) Changes() int

+ func (c *Conn) Close() error

+ func (c *Conn) Filename(schema string) string

+ func (c *Conn) GetLimit(key SQLimit) int

+ func (c *Conn) GetStatus(v StatusType) (int, int, error)

+ func (c *Conn) Interrupt()

+ func (c *Conn) LastInsertId() int64

+ func (c *Conn) NextStatement(s *Statement) *Statement

+ func (c *Conn) OpenBackup(dest *Conn, destSchema, sourceSchema string) (*Backup, error)

+ func (c *Conn) OpenBlob(schema, table, column string, rowid int64, flags OpenFlags) (*Blob, error)

+ func (c *Conn) OpenBlobEx(schema, table, column string, rowid int64, flags OpenFlags) (*BlobEx, error)

+ func (c *Conn) Prepare(query string) (*Statement, string, error)

+ func (c *Conn) Readonly(schema string) bool

+ func (c *Conn) ReleaseMemory() error

+ func (c *Conn) ResetStatus(v StatusType) error

+ func (c *Conn) SetExtendedResultCodes(v bool) error

+ func (c *Conn) SetLastInsertId(v int64)

+ func (c *Conn) SetLimit(key SQLimit, v int) int

+ func (c *Conn) String() string

+ type ConnEx struct

+ func OpenPathEx(path string, flags OpenFlags, vfs string) (*ConnEx, error)

+ func OpenUrlEx(url string, flags OpenFlags, vfs string) (*ConnEx, error)

+ func (c *ConnEx) Begin(t SQTransaction) error

+ func (c *ConnEx) Close() error

+ func (c *ConnEx) Commit() error

+ func (c *ConnEx) CreateScalarFunction(name string, nargs int, deterministic bool, fn StepFunc) error

+ func (c *ConnEx) Exec(q string, fn ExecFunc) error

+ func (c *ConnEx) ExecEx(q string, fn ExecFunc, v ...interface{}) error

+ func (c *ConnEx) Prepare(q string) (*StatementEx, error)

+ func (c *ConnEx) Rollback() error

+ func (c *ConnEx) SetAuthorizerHook(fn AuthorizerHookFunc) error

+ func (c *ConnEx) SetBusyHandler(fn BusyHandlerFunc) error

+ func (c *ConnEx) SetBusyTimeout(t time.Duration) error

+ func (c *ConnEx) SetCommitHook(fn CommitHookFunc) error

+ func (c *ConnEx) SetProgressHandler(n uint, fn ProgressHandlerFunc) error

+ func (c *ConnEx) SetRollbackHook(fn RollbackHookFunc) error

+ func (c *ConnEx) SetTraceHook(fn TraceFunc, flags TraceType) error

+ func (c *ConnEx) SetUpdateHook(fn UpdateHookFunc) error

+ type Context C.sqlite3_context

+ func (ctx *Context) Err(v string)

+ func (ctx *Context) ErrCode(e SQError)

+ func (ctx *Context) ErrNoMem()

+ func (ctx *Context) ErrTooBig()

+ func (ctx *Context) ResultBlob(data []byte)

+ func (ctx *Context) ResultDouble(v float64)

+ func (ctx *Context) ResultInt32(v int32)

+ func (ctx *Context) ResultInt64(v int64)

+ func (ctx *Context) ResultInterface(v interface{}) error

+ func (ctx *Context) ResultNull()

+ func (ctx *Context) ResultText(v string)

+ func (ctx *Context) ResultValue(v *Value)

+ func (ctx *Context) String() string

+ func (ctx *Context) UserData() unsafe.Pointer

+ type ExecFunc func(row, cols []string) bool

+ type FinalFunc func(*Context)

+ type OpenFlags C.int

+ const SQLITE_OPEN_CREATE

+ const SQLITE_OPEN_FULLMUTEX

+ const SQLITE_OPEN_MAX

+ const SQLITE_OPEN_MEMORY

+ const SQLITE_OPEN_MIN

+ const SQLITE_OPEN_NOMUTEX

+ const SQLITE_OPEN_NONE

+ const SQLITE_OPEN_PRIVATECACHE

+ const SQLITE_OPEN_READONLY

+ const SQLITE_OPEN_READWRITE

+ const SQLITE_OPEN_SHAREDCACHE

+ const SQLITE_OPEN_URI

+ func (v OpenFlags) String() string

+ func (v OpenFlags) StringFlag() string

+ type ProgressHandlerFunc func() bool

+ type Results struct

+ func (r *Results) ColumnCount() int

+ func (r *Results) ColumnDatabaseName(i int) string

+ func (r *Results) ColumnDeclType(i int) string

+ func (r *Results) ColumnName(i int) string

+ func (r *Results) ColumnOriginName(i int) string

+ func (r *Results) ColumnTableName(i int) string

+ func (r *Results) ColumnType(i int) Type

+ func (r *Results) ExpandedSQL() string

+ func (r *Results) LastInsertId() int64

+ func (r *Results) Next(t ...reflect.Type) ([]interface{}, error)

+ func (r *Results) RowsAffected() int

+ func (r *Results) String() string

+ type RollbackHookFunc func()

+ type SQAction C.int

+ const SQLITE_ACTION_MAX

+ const SQLITE_ACTION_MIN

+ const SQLITE_ALTER_TABLE

+ const SQLITE_ANALYZE

+ const SQLITE_ATTACH

+ const SQLITE_COPY

+ const SQLITE_CREATE_INDEX

+ const SQLITE_CREATE_TABLE

+ const SQLITE_CREATE_TEMP_INDEX

+ const SQLITE_CREATE_TEMP_TABLE

+ const SQLITE_CREATE_TEMP_TRIGGER

+ const SQLITE_CREATE_TEMP_VIEW

+ const SQLITE_CREATE_TRIGGER

+ const SQLITE_CREATE_VIEW

+ const SQLITE_CREATE_VTABLE

+ const SQLITE_DELETE

+ const SQLITE_DETACH

+ const SQLITE_DROP_INDEX

+ const SQLITE_DROP_TABLE

+ const SQLITE_DROP_TEMP_INDEX

+ const SQLITE_DROP_TEMP_TABLE

+ const SQLITE_DROP_TEMP_TRIGGER

+ const SQLITE_DROP_TEMP_VIEW

+ const SQLITE_DROP_TRIGGER

+ const SQLITE_DROP_VIEW

+ const SQLITE_DROP_VTABLE

+ const SQLITE_FUNCTION

+ const SQLITE_INSERT

+ const SQLITE_PRAGMA

+ const SQLITE_READ

+ const SQLITE_RECURSIVE

+ const SQLITE_REINDEX

+ const SQLITE_SAVEPOINT

+ const SQLITE_SELECT

+ const SQLITE_TRANSACTION

+ const SQLITE_UPDATE

+ func (v SQAction) String() string

+ type SQAuth C.int

+ const SQLITE_ALLOW

+ const SQLITE_DENY

+ const SQLITE_IGNORE

+ func (v SQAuth) String() string

+ type SQError C.int

+ const SQLITE_ABORT

+ const SQLITE_AUTH

+ const SQLITE_BUSY

+ const SQLITE_CANTOPEN

+ const SQLITE_CONSTRAINT

+ const SQLITE_CORRUPT

+ const SQLITE_DONE

+ const SQLITE_EMPTY

+ const SQLITE_ERROR

+ const SQLITE_FORMAT

+ const SQLITE_FULL

+ const SQLITE_INTERNAL

+ const SQLITE_INTERRUPT

+ const SQLITE_IOERR

+ const SQLITE_LOCKED

+ const SQLITE_MISMATCH

+ const SQLITE_MISUSE

+ const SQLITE_NOLFS

+ const SQLITE_NOMEM

+ const SQLITE_NOTADB

+ const SQLITE_NOTFOUND

+ const SQLITE_NOTICE

+ const SQLITE_OK

+ const SQLITE_PERM

+ const SQLITE_PROTOCOL

+ const SQLITE_RANGE

+ const SQLITE_READONLY

+ const SQLITE_ROW

+ const SQLITE_SCHEMA

+ const SQLITE_TOOBIG

+ const SQLITE_WARNING

+ func (e SQError) Error() string

+ func (e SQError) With(suffix string) error

+ type SQLimit C.int

+ const SQLITE_LIMIT_ATTACHED

+ const SQLITE_LIMIT_COLUMN

+ const SQLITE_LIMIT_COMPOUND_SELECT

+ const SQLITE_LIMIT_EXPR_DEPTH

+ const SQLITE_LIMIT_FUNCTION_ARG

+ const SQLITE_LIMIT_LENGTH

+ const SQLITE_LIMIT_LIKE_PATTERN_LENGTH

+ const SQLITE_LIMIT_MAX

+ const SQLITE_LIMIT_MIN

+ const SQLITE_LIMIT_SQL_LENGTH

+ const SQLITE_LIMIT_TRIGGER_DEPTH

+ const SQLITE_LIMIT_VARIABLE_NUMBER

+ const SQLITE_LIMIT_VDBE_OP

+ const SQLITE_LIMIT_WORKER_THREADS

+ func (l SQLimit) String() string

+ type SQTransaction string

+ const SQLITE_TXN_DEFAULT

+ const SQLITE_TXN_EXCLUSIVE

+ const SQLITE_TXN_IMMEDIATE

+ type Statement C.sqlite3_stmt

+ func (s *Statement) Bind(v ...interface{}) error

+ func (s *Statement) BindBlob(index int, v []byte) error

+ func (s *Statement) BindDouble(index int, v float64) error

+ func (s *Statement) BindInt32(index int, v int32) error

+ func (s *Statement) BindInt64(index int, v int64) error

+ func (s *Statement) BindInterface(index int, value interface{}) error

+ func (s *Statement) BindNamedInterface(name string, value interface{}) error

+ func (s *Statement) BindNull(index int) error

+ func (s *Statement) BindPointer(index int, p unsafe.Pointer, t string) error

+ func (s *Statement) BindText(index int, v string) error

+ func (s *Statement) BindZeroBlob(index int, len int) error

+ func (s *Statement) BindZeroBlob64(index int, len uint64) error

+ func (s *Statement) ClearBindings() error

+ func (s *Statement) ColumnBlob(index int) []byte

+ func (s *Statement) ColumnBytes(index int) int

+ func (s *Statement) ColumnCount() int

+ func (s *Statement) ColumnDatabaseName(index int) string

+ func (s *Statement) ColumnDeclType(index int) string

+ func (s *Statement) ColumnDouble(index int) float64

+ func (s *Statement) ColumnInt32(index int) int32

+ func (s *Statement) ColumnInt64(index int) int64

+ func (s *Statement) ColumnInterface(index int) interface{}

+ func (s *Statement) ColumnName(index int) string

+ func (s *Statement) ColumnOriginName(index int) string

+ func (s *Statement) ColumnTableName(index int) string

+ func (s *Statement) ColumnText(index int) string

+ func (s *Statement) ColumnType(index int) Type

+ func (s *Statement) Conn() *Conn

+ func (s *Statement) DataCount() int

+ func (s *Statement) ExpandedSQL() string

+ func (s *Statement) Finalize() error

+ func (s *Statement) IsBusy() bool

+ func (s *Statement) IsReadonly() bool

+ func (s *Statement) NumParams() int

+ func (s *Statement) ParamIndex(name string) int

+ func (s *Statement) ParamName(index int) string

+ func (s *Statement) Reset() error

+ func (s *Statement) SQL() string

+ func (s *Statement) Step() error

+ func (s *Statement) String() string

+ type StatementEx struct

+ func (s *StatementEx) Close() error

+ func (s *StatementEx) Count() uint32

+ func (s *StatementEx) Exec(n uint, v ...interface{}) (*Results, error)

+ func (s *StatementEx) Inc(n uint32)

+ func (s *StatementEx) String() string

+ func (s *StatementEx) Timestamp() int64

+ type StatusType int

+ const SQLITE_DBSTATUS_CACHE_HIT

+ const SQLITE_DBSTATUS_CACHE_MISS

+ const SQLITE_DBSTATUS_CACHE_SPILL

+ const SQLITE_DBSTATUS_CACHE_USED

+ const SQLITE_DBSTATUS_CACHE_USED_SHARED

+ const SQLITE_DBSTATUS_CACHE_WRITE

+ const SQLITE_DBSTATUS_DEFERRED_FKS

+ const SQLITE_DBSTATUS_LOOKASIDE_HIT

+ const SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL

+ const SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE

+ const SQLITE_DBSTATUS_LOOKASIDE_USED

+ const SQLITE_DBSTATUS_MAX

+ const SQLITE_DBSTATUS_MIN

+ const SQLITE_DBSTATUS_SCHEMA_USED

+ const SQLITE_DBSTATUS_STMT_USED

+ func (s StatusType) String() string

+ type StepFunc func(*Context, []*Value)

+ type TraceFunc func(TraceType, unsafe.Pointer, unsafe.Pointer) int

+ type TraceType uint

+ const SQLITE_TRACE_CLOSE

+ const SQLITE_TRACE_MAX

+ const SQLITE_TRACE_MIN

+ const SQLITE_TRACE_NONE

+ const SQLITE_TRACE_PROFILE

+ const SQLITE_TRACE_ROW

+ const SQLITE_TRACE_STMT

+ func (v TraceType) String() string

+ func (v TraceType) StringFlag() string

+ type Type int

+ const SQLITE_BLOB

+ const SQLITE_FLOAT

+ const SQLITE_INTEGER

+ const SQLITE_NULL

+ const SQLITE_TEXT

+ func (t Type) String() string

+ type UpdateHookFunc func(SQAction, string, string, int64)

+ type Value C.sqlite3_value

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

+ func (v *Value) Bytes() int

+ func (v *Value) Copy() *Value

+ func (v *Value) Double() float64

+ func (v *Value) Free()

+ func (v *Value) Int32() int32

+ func (v *Value) Int64() int64

+ func (v *Value) Interface() interface{}

+ func (v *Value) NoChange() bool

+ func (v *Value) String() string

+ func (v *Value) Text() string

+ func (v *Value) Type() Type

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