sqlite3

package module

Go to main page

Versions in this module

v1

v1.14.22

Feb 2, 2024

v1.14.21

Jan 31, 2024

v1.14.20

Jan 25, 2024

v1.14.19

Dec 15, 2023

v1.14.18

Nov 4, 2023

v1.14.17

May 31, 2023

Changes in this version

type SQLiteConn

+ func (c *SQLiteConn) Deserialize(b []byte, schema string) error

+ func (c *SQLiteConn) Serialize(schema string) ([]byte, error)

v1.14.16

Oct 26, 2022

v1.14.15

Aug 16, 2022

v1.14.14

May 30, 2022

v1.14.13

May 13, 2022

v1.14.12

Feb 28, 2022

v1.14.11

Jan 28, 2022

Changes in this version

+ const SQLITE_FCNTL_BEGIN_ATOMIC_WRITE

+ const SQLITE_FCNTL_BUSYHANDLER

+ const SQLITE_FCNTL_CHUNK_SIZE

+ const SQLITE_FCNTL_CKPT_DONE

+ const SQLITE_FCNTL_CKPT_START

+ const SQLITE_FCNTL_CKSM_FILE

+ const SQLITE_FCNTL_COMMIT_ATOMIC_WRITE

+ const SQLITE_FCNTL_COMMIT_PHASETWO

+ const SQLITE_FCNTL_DATA_VERSION

+ const SQLITE_FCNTL_EXTERNAL_READER

+ const SQLITE_FCNTL_FILE_POINTER

+ const SQLITE_FCNTL_GET_LOCKPROXYFILE

+ const SQLITE_FCNTL_HAS_MOVED

+ const SQLITE_FCNTL_JOURNAL_POINTER

+ const SQLITE_FCNTL_LAST_ERRNO

+ const SQLITE_FCNTL_LOCKSTATE

+ const SQLITE_FCNTL_LOCK_TIMEOUT

+ const SQLITE_FCNTL_MMAP_SIZE

+ const SQLITE_FCNTL_OVERWRITE

+ const SQLITE_FCNTL_PDB

+ const SQLITE_FCNTL_PERSIST_WAL

+ const SQLITE_FCNTL_POWERSAFE_OVERWRITE

+ const SQLITE_FCNTL_PRAGMA

+ const SQLITE_FCNTL_RBU

+ const SQLITE_FCNTL_RESERVE_BYTES

+ const SQLITE_FCNTL_ROLLBACK_ATOMIC_WRITE

+ const SQLITE_FCNTL_SET_LOCKPROXYFILE

+ const SQLITE_FCNTL_SIZE_HINT

+ const SQLITE_FCNTL_SIZE_LIMIT

+ const SQLITE_FCNTL_SYNC

+ const SQLITE_FCNTL_SYNC_OMITTED

+ const SQLITE_FCNTL_TEMPFILENAME

+ const SQLITE_FCNTL_TRACE

+ const SQLITE_FCNTL_VFSNAME

+ const SQLITE_FCNTL_VFS_POINTER

+ const SQLITE_FCNTL_WAL_BLOCK

+ const SQLITE_FCNTL_WIN32_AV_RETRY

+ const SQLITE_FCNTL_WIN32_GET_HANDLE

+ const SQLITE_FCNTL_WIN32_SET_HANDLE

+ const SQLITE_FCNTL_ZIPVFS

type SQLiteConn

+ func (c *SQLiteConn) SetFileControlInt(dbName string, op int, arg int) error

v1.14.10

Dec 29, 2021

Changes in this version

+ const SQLITE_BLOB

+ const SQLITE_BOOL

+ const SQLITE_INTEGER

+ const SQLITE_NULL

+ const SQLITE_NUMERIC

+ const SQLITE_REAL

+ const SQLITE_TEXT

+ const SQLITE_TIME

v1.14.9

Jul 20, 2021

v1.14.8

Jul 15, 2021

v1.14.7

Apr 14, 2021

Changes in this version

type SQLiteStmt

+ func (s *SQLiteStmt) Readonly() bool

v1.14.6

Dec 26, 2020

v1.14.5

Nov 16, 2020

v1.14.4

Oct 2, 2020

v1.14.3

Sep 11, 2020

v1.14.2

Aug 28, 2020

v1.14.1

Aug 19, 2020

v1.14.0

Jun 6, 2020

Changes in this version

type Error

+ SystemErrno syscall.Errno

v1.13.0

Nov 18, 2019

v1.12.0

Oct 8, 2019

Changes in this version

type SQLiteConn

+ func (c *SQLiteConn) RegisterPreUpdateHook(callback func(SQLitePreUpdateData))

+ type SQLitePreUpdateData struct

+ Conn *SQLiteConn

+ DatabaseName string

+ NewRowID int64

+ OldRowID int64

+ Op int

+ TableName string

v1.11.0

Jul 16, 2019

v1.10.0

Oct 24, 2018

Changes in this version

+ 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_DENY

+ 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_IGNORE

+ const SQLITE_OK

+ const SQLITE_PRAGMA

+ const SQLITE_READ

+ const SQLITE_REINDEX

+ const SQLITE_SAVEPOINT

+ const SQLITE_SELECT

+ const SQLITE_TRANSACTION

type SQLiteConn

+ func (c *SQLiteConn) RegisterAuthorizer(callback func(int, string, string, string) int)

v1.9.0

Jun 13, 2018

v1.8.0

Jun 12, 2018

Changes in this version

+ func CryptEncoderSHA1(pass []byte, hash interface{}) []byte

+ func CryptEncoderSHA256(pass []byte, hash interface{}) []byte

+ func CryptEncoderSHA384(pass []byte, hash interface{}) []byte

+ func CryptEncoderSHA512(pass []byte, hash interface{}) []byte

+ func CryptEncoderSSHA1(salt string) func(pass []byte, hash interface{}) []byte

+ func CryptEncoderSSHA256(salt string) func(pass []byte, hash interface{}) []byte

+ func CryptEncoderSSHA384(salt string) func(pass []byte, hash interface{}) []byte

+ func CryptEncoderSSHA512(salt string) func(pass []byte, hash interface{}) []byte

type SQLiteConn

+ func (c *SQLiteConn) AuthEnabled() (exists bool)

+ func (c *SQLiteConn) AuthUserAdd(username, password string, admin bool) error

+ func (c *SQLiteConn) AuthUserChange(username, password string, admin bool) error

+ func (c *SQLiteConn) AuthUserDelete(username string) error

+ func (c *SQLiteConn) Authenticate(username, password string) error

+ func (c *SQLiteConn) GetFilename(schemaName string) string

v1.7.0

May 24, 2018

v1.6.0

Jan 12, 2018

v1.5.0

Nov 22, 2017

v1.4.0

Nov 14, 2017

Changes in this version

+ 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_SQL_LENGTH

+ const SQLITE_LIMIT_TRIGGER_DEPTH

+ const SQLITE_LIMIT_VARIABLE_NUMBER

+ const SQLITE_LIMIT_VDBE_OP

+ const SQLITE_LIMIT_WORKER_THREADS

type SQLiteConn

+ func (c *SQLiteConn) GetLimit(id int) int

+ func (c *SQLiteConn) SetLimit(id int, newVal int) int

v1.3.0

Sep 28, 2017

Changes in this version

+ const SQLITE_DELETE

+ const SQLITE_INSERT

+ const SQLITE_UPDATE

type SQLiteConn

+ func (c *SQLiteConn) BeginTx(ctx context.Context, opts driver.TxOptions) (driver.Tx, error)

+ func (c *SQLiteConn) RegisterCollation(name string, cmp func(string, string) int) error

+ func (c *SQLiteConn) RegisterCommitHook(callback func() int)

+ func (c *SQLiteConn) RegisterRollbackHook(callback func())

+ func (c *SQLiteConn) RegisterUpdateHook(callback func(int, string, string, int64))

+ type SQLiteContext C.sqlite3_context

+ func (c *SQLiteContext) ResultBlob(b []byte)

+ func (c *SQLiteContext) ResultBool(b bool)

+ func (c *SQLiteContext) ResultDouble(d float64)

+ func (c *SQLiteContext) ResultInt(i int)

+ func (c *SQLiteContext) ResultInt64(i int64)

+ func (c *SQLiteContext) ResultNull()

+ func (c *SQLiteContext) ResultText(s string)

+ func (c *SQLiteContext) ResultZeroblob(n int)

v1.2.0

Nov 11, 2016

Changes in this version

+ var ErrConstraintRowID = ErrConstraint.Extend(10)

type SQLiteConn

+ func (c *SQLiteConn) BeginContext(ctx context.Context) (driver.Tx, error)

+ func (c *SQLiteConn) ExecContext(ctx context.Context, query string, args []driver.NamedValue) (driver.Result, error)

+ func (c *SQLiteConn) LoadExtension(lib string, entry string) error

+ func (c *SQLiteConn) Ping(ctx context.Context) error

+ func (c *SQLiteConn) PrepareContext(ctx context.Context, query string) (driver.Stmt, error)

+ func (c *SQLiteConn) QueryContext(ctx context.Context, query string, args []driver.NamedValue) (driver.Rows, error)

+ func (c *SQLiteConn) RegisterAggregator(name string, impl interface{}, pure bool) error

+ func (c *SQLiteConn) RegisterFunc(name string, impl interface{}, pure bool) error

type SQLiteRows

+ func (rc *SQLiteRows) ColumnTypeDatabaseTypeName(i int) string

+ func (rc *SQLiteRows) ColumnTypeNullable(i int) (nullable, ok bool)

+ func (rc *SQLiteRows) ColumnTypeScanType(i int) reflect.Type

+ func (rc *SQLiteRows) DeclTypes() []string

type SQLiteStmt

+ func (s *SQLiteStmt) ExecContext(ctx context.Context, args []driver.NamedValue) (driver.Result, error)

+ func (s *SQLiteStmt) QueryContext(ctx context.Context, args []driver.NamedValue) (driver.Rows, error)

v1.1.0

Sep 5, 2015

v1.0.0

Jun 29, 2015

Changes in this version

+ const ErrNoMask

+ var ErrAbort = ErrNo(4)

+ var ErrAbortRollback = ErrAbort.Extend(2)

+ var ErrAuth = ErrNo(23)

+ var ErrBusy = ErrNo(5)

+ var ErrBusyRecovery = ErrBusy.Extend(1)

+ var ErrBusySnapshot = ErrBusy.Extend(2)

+ var ErrCantOpen = ErrNo(14)

+ var ErrCantOpenConvPath = ErrCantOpen.Extend(4)

+ var ErrCantOpenFullPath = ErrCantOpen.Extend(3)

+ var ErrCantOpenIsDir = ErrCantOpen.Extend(2)

+ var ErrCantOpenNoTempDir = ErrCantOpen.Extend(1)

+ var ErrConstraint = ErrNo(19)

+ var ErrConstraintCheck = ErrConstraint.Extend(1)

+ var ErrConstraintCommitHook = ErrConstraint.Extend(2)

+ var ErrConstraintForeignKey = ErrConstraint.Extend(3)

+ var ErrConstraintFunction = ErrConstraint.Extend(4)

+ var ErrConstraintNotNull = ErrConstraint.Extend(5)

+ var ErrConstraintPrimaryKey = ErrConstraint.Extend(6)

+ var ErrConstraintRowId = ErrConstraint.Extend(10)

+ var ErrConstraintTrigger = ErrConstraint.Extend(7)

+ var ErrConstraintUnique = ErrConstraint.Extend(8)

+ var ErrConstraintVTab = ErrConstraint.Extend(9)

+ var ErrCorrupt = ErrNo(11)

+ var ErrCorruptVTab = ErrCorrupt.Extend(1)

+ var ErrEmpty = ErrNo(16)

+ var ErrError = ErrNo(1)

+ var ErrFormat = ErrNo(24)

+ var ErrFull = ErrNo(13)

+ var ErrInternal = ErrNo(2)

+ var ErrInterrupt = ErrNo(9)

+ var ErrIoErr = ErrNo(10)

+ var ErrIoErrAccess = ErrIoErr.Extend(13)

+ var ErrIoErrBlocked = ErrIoErr.Extend(11)

+ var ErrIoErrCheckReservedLock = ErrIoErr.Extend(14)

+ var ErrIoErrClose = ErrIoErr.Extend(16)

+ var ErrIoErrConvPath = ErrIoErr.Extend(26)

+ var ErrIoErrDelete = ErrIoErr.Extend(10)

+ var ErrIoErrDeleteNoent = ErrIoErr.Extend(23)

+ var ErrIoErrDirClose = ErrIoErr.Extend(17)

+ var ErrIoErrDirFsync = ErrIoErr.Extend(5)

+ var ErrIoErrFstat = ErrIoErr.Extend(7)

+ var ErrIoErrFsync = ErrIoErr.Extend(4)

+ var ErrIoErrGetTempPath = ErrIoErr.Extend(25)

+ var ErrIoErrLock = ErrIoErr.Extend(15)

+ var ErrIoErrMMap = ErrIoErr.Extend(24)

+ var ErrIoErrNoMem = ErrIoErr.Extend(12)

+ var ErrIoErrRDlock = ErrIoErr.Extend(9)

+ var ErrIoErrRead = ErrIoErr.Extend(1)

+ var ErrIoErrSHMLock = ErrIoErr.Extend(20)

+ var ErrIoErrSHMMap = ErrIoErr.Extend(21)

+ var ErrIoErrSHMOpen = ErrIoErr.Extend(18)

+ var ErrIoErrSHMSize = ErrIoErr.Extend(19)

+ var ErrIoErrSeek = ErrIoErr.Extend(22)

+ var ErrIoErrShortRead = ErrIoErr.Extend(2)

+ var ErrIoErrTruncate = ErrIoErr.Extend(6)

+ var ErrIoErrUnlock = ErrIoErr.Extend(8)

+ var ErrIoErrWrite = ErrIoErr.Extend(3)

+ var ErrLocked = ErrNo(6)

+ var ErrLockedSharedCache = ErrLocked.Extend(1)

+ var ErrMismatch = ErrNo(20)

+ var ErrMisuse = ErrNo(21)

+ var ErrNoLFS = ErrNo(22)

+ var ErrNomem = ErrNo(7)

+ var ErrNotADB = ErrNo(26)

+ var ErrNotFound = ErrNo(12)

+ var ErrNotice = ErrNo(27)

+ var ErrNoticeRecoverRollback = ErrNotice.Extend(2)

+ var ErrNoticeRecoverWAL = ErrNotice.Extend(1)

+ var ErrPerm = ErrNo(3)

+ var ErrProtocol = ErrNo(15)

+ var ErrRange = ErrNo(25)

+ var ErrReadonly = ErrNo(8)

+ var ErrReadonlyCantLock = ErrReadonly.Extend(2)

+ var ErrReadonlyDbMoved = ErrReadonly.Extend(4)

+ var ErrReadonlyRecovery = ErrReadonly.Extend(1)

+ var ErrReadonlyRollback = ErrReadonly.Extend(3)

+ var ErrSchema = ErrNo(17)

+ var ErrTooBig = ErrNo(18)

+ var ErrWarning = ErrNo(28)

+ var ErrWarningAutoIndex = ErrWarning.Extend(1)

+ var SQLiteTimestampFormats = []string

+ func Version() (libVersion string, libVersionNumber int, sourceId string)

+ type ErrNo int

+ func (err ErrNo) Error() string

+ func (err ErrNo) Extend(by int) ErrNoExtended

+ type ErrNoExtended int

+ func (err ErrNoExtended) Error() string

+ type Error struct

+ Code ErrNo

+ ExtendedCode ErrNoExtended

+ func (err Error) Error() string

+ type SQLiteBackup struct

+ func (b *SQLiteBackup) Close() error

+ func (b *SQLiteBackup) Finish() error

+ func (b *SQLiteBackup) PageCount() int

+ func (b *SQLiteBackup) Remaining() int

+ func (b *SQLiteBackup) Step(p int) (bool, error)

+ type SQLiteConn struct

+ func (c *SQLiteConn) AutoCommit() bool

+ func (c *SQLiteConn) Backup(dest string, conn *SQLiteConn, src string) (*SQLiteBackup, error)

+ func (c *SQLiteConn) Begin() (driver.Tx, error)

+ func (c *SQLiteConn) Close() error

+ func (c *SQLiteConn) Exec(query string, args []driver.Value) (driver.Result, error)

+ func (c *SQLiteConn) Prepare(query string) (driver.Stmt, error)

+ func (c *SQLiteConn) Query(query string, args []driver.Value) (driver.Rows, error)

+ type SQLiteDriver struct

+ ConnectHook func(*SQLiteConn) error

+ Extensions []string

+ func (d *SQLiteDriver) Open(dsn string) (driver.Conn, error)

+ type SQLiteResult struct

+ func (r *SQLiteResult) LastInsertId() (int64, error)

+ func (r *SQLiteResult) RowsAffected() (int64, error)

+ type SQLiteRows struct

+ func (rc *SQLiteRows) Close() error

+ func (rc *SQLiteRows) Columns() []string

+ func (rc *SQLiteRows) Next(dest []driver.Value) error

+ type SQLiteStmt struct

+ func (s *SQLiteStmt) Close() error

+ func (s *SQLiteStmt) Exec(args []driver.Value) (driver.Result, error)

+ func (s *SQLiteStmt) NumInput() int

+ func (s *SQLiteStmt) Query(args []driver.Value) (driver.Rows, error)

+ type SQLiteTx struct

+ func (tx *SQLiteTx) Commit() error

+ func (tx *SQLiteTx) Rollback() error

Incompatible versions in this module

v2.0.3+incompatible

Jan 28, 2020

retracted

v2.0.2+incompatible

Dec 17, 2019

retracted

v2.0.1+incompatible

Nov 18, 2019

retracted

v2.0.0+incompatible

Aug 2, 2018

retracted

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