sqlite

Dec 30, 2024

Changes in this version

+ var ZombieTimeout = 30 * time.Second

type Conn

+ func (ctn *Conn) EndTx(ctx context.Context) error

+ func (ctn *Conn) RollbackTx(ctx context.Context) error

type Connections

+ func (p *Connections) BeginTx(ctx context.Context) (context.Context, *Conn, func())

Sep 30, 2024

Changes in this version

+ func Backup(ctn *Conn, dest string) error

Sep 30, 2024

Changes in this version

type Conn

+ func ReadOnly(name string, exts ...func(SQLITE3)) (*Conn, error)

Aug 28, 2024

Changes in this version

type Rows

+ func NewErroredRows(ctn *Conn, err error) *Rows

Aug 21, 2024

Changes in this version

type Conn

+ func (ctn *Conn) RollbackTo(ctx context.Context) error

type Connections

+ func (p *Connections) RollbackTo(ctx context.Context) error

Mar 5, 2024

Changes in this version

type Connections

+ func (c *Connections) FreeCount() int

Nov 19, 2023

Changes in this version

+ const MemoryPath

+ const NoMoreRow

+ var BusyTransaction = errText[C.SQLITE_BUSY]

+ var DBName = "main"

+ var DuplicateRecords = errors.New("duplicate records in scanone")

+ var ErrNull = errors.New("null SQL value")

+ var HashSeed = maphash.MakeSeed()

+ var NumThreads = 32

+ var ObsLastQueries = RegisterTable("obs_lastqueries", queryRecord{})

+ func BackupDB(pool *Connections, dest string) error

+ func GetBuffer() *bytes.Buffer

+ func HashString(s string) int64

+ func IsComplete(st string) bool

+ func LoadExtensions(db SQLITE3)

+ func Register(f ...func(SQLITE3))

+ func RegisterConstant(name string, value any) func(SQLITE3)

+ func RegisterFunc(name string, t any) func(SQLITE3)

+ func RegisterTable[T Filtrer[T]](name string, vt T, opts ...VirtualTableOption) func(SQLITE3)

+ func RememberQuery(q string)

+ func ReturnBuffer(b *bytes.Buffer)

+ type ColStrings map[string]*string

+ type Conn struct

+ func Open(name string, exts ...func(SQLITE3)) (*Conn, error)

+ func (c *Conn) Close() error

+ func (c *Conn) Exec(ctx context.Context, cmd string, args ...any) *Rows

+ func (cn *Conn) CreateBLOB(database, table, column string, size int) (*DirectBLOB, error)

+ func (cn *Conn) OpenBLOB(database, table, column string, rownum int) (*DirectBLOB, error)

+ func (ctn *Conn) Release(ctx context.Context) error

+ func (ctn *Conn) Rollback(ctx context.Context) error

+ func (ctn *Conn) Savepoint(ctx context.Context) (context.Context, error)

+ type Connections struct

+ func OpenPool(name string, exts ...func(SQLITE3)) (*Connections, error)

+ func (p *Connections) Close() error

+ func (p *Connections) Exec(ctx context.Context, cmd string, args ...any) *Rows

+ func (p *Connections) Release(ctx context.Context) error

+ func (p *Connections) Rollback(ctx context.Context) error

+ func (p *Connections) Savepoint(ctx context.Context) (context.Context, error)

+ type Constraint struct

+ Column string

+ Operation Op

+ Value any

+ func (v Constraint) ValueBool() bool

+ func (v Constraint) ValueBytes() []byte

+ func (v Constraint) ValueInt() int

+ func (v Constraint) ValueString() string

+ type Constraints []Constraint

+ type DirectBLOB struct

+ RowNumber int

+ func (r *DirectBLOB) Close() error

+ func (r *DirectBLOB) ReadAt(p []byte, off int64) (n int, err error)

+ func (r *DirectBLOB) Size() int

+ func (r *DirectBLOB) WriteAt(p []byte, off int64) (n int, err error)

+ type Filtrer interface

+ Filter func(int, Constraints) Iter[T]

+ type Hasher interface

+ Hash64 func() int64

+ type IndexState interface

+ SelectIndex func(int)

+ Use func(constraint int)

+ type Indexer interface

+ BestIndex func(IndexState, Constraints) (estimatedCost, estimatedRows int64)

+ type Iter interface

+ Err func() error

+ Next func() bool

+ Value func() T

+ func FromArray[T any](values []T) Iter[T]

+ func FromError[T any](err error) Iter[T]

+ func FromOne[T any](v T) Iter[T]

+ func None[T any]() Iter[T]

+ func TransformArray[T, U any](values []T, trans func(T) U) Iter[U]

+ type MultiString []string

+ type NullString string

+ type Op uint8

+ const ConstraintEQ

+ const ConstraintFUNCTION

+ const ConstraintGE

+ const ConstraintGLOB

+ const ConstraintGT

+ const ConstraintIS

+ const ConstraintISNOT

+ const ConstraintISNOTNULL

+ const ConstraintISNULL

+ const ConstraintLE

+ const ConstraintLIKE

+ const ConstraintLIMIT

+ const ConstraintLT

+ const ConstraintMATCH

+ const ConstraintNE

+ const ConstraintOFFSET

+ const ConstraintREGEXP

+ func (op *Op) Scan(st fmt.ScanState, verb rune) error

+ func (op Op) String() string

+ type PointerValue struct

+ func AsPointer(v any) PointerValue

+ type Rows struct

+ func (r *Rows) Bytecode() string

+ func (r *Rows) Err() error

+ func (r *Rows) ExplainQueryPlan() string

+ func (r *Rows) IsExplain() bool

+ func (r *Rows) ScanOne(dst ...any) error

+ func (rows *Rows) ColumnName(i int) string

+ func (rows *Rows) Next() bool

+ func (rows *Rows) NumColumn() int

+ func (rows *Rows) Scan(dst ...any)

+ type SQLITE3 *C.sqlite3

+ type Updater interface

+ Update func(_ context.Context, index int64, value T) error

+ type VirtualTableOption func(*rVM)

+ func OverloadFunc(name string, fn any) VirtualTableOption