Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

sqlite3

package

Go to main page

Versions in this module

v0

v0.4.2

Oct 30, 2018

v0.4.1

Oct 11, 2018

v0.4.0

Sep 29, 2018

Changes in this version

+ const CHANGESET_ABORT

+ const CHANGESET_CONFLICT

+ const CHANGESET_CONSTRAINT

+ const CHANGESET_DATA

+ const CHANGESET_FOREIGN_KEY

+ const CHANGESET_NOTFOUND

+ const CHANGESET_OMIT

+ const CHANGESET_REPLACE

+ func ChangesetConcat(w io.Writer, r1, r2 io.Reader) error

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

+ type BusyFunc func(count int) (retry bool)

+ type Changegroup struct

+ func NewChangegroup() (*Changegroup, error)

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

+ func (cg Changegroup) Delete()

+ func (cg Changegroup) Output(w io.Writer) (err error)

+ type ChangesetIter struct

+ func ChangesetIterStart(r io.Reader) (ChangesetIter, error)

+ func (iter ChangesetIter) Close() error

+ func (iter ChangesetIter) Conflict(col int) (v Value, err error)

+ func (iter ChangesetIter) FKConflicts() (int, error)

+ func (iter ChangesetIter) New(col int) (v Value, err error)

+ func (iter ChangesetIter) Next() (rowReturned bool, err error)

+ func (iter ChangesetIter) Old(col int) (v Value, err error)

+ func (iter ChangesetIter) Op() (table string, numCols int, opType OpType, indirect bool, err error)

+ func (iter ChangesetIter) PK() ([]bool, error)

+ type CommitFunc func() (abort bool)

+ type ConflictAction int

+ type ConflictType int

type Conn

+ func (c *Conn) BusyFunc(f BusyFunc)

+ func (c *Conn) CommitFunc(f CommitFunc) (prev CommitFunc)

+ func (c *Conn) RollbackFunc(f RollbackFunc) (prev RollbackFunc)

+ func (c *Conn) UpdateFunc(f UpdateFunc) (prev UpdateFunc)

+ func (conn *Conn) ChangesetApply(r io.Reader, filterFn func(tableName string) bool, ...) error

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

+ type OpType int

+ type RollbackFunc func()

+ type Session struct

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

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

+ func (s *Session) Close()

+ func (s *Session) Diff(fromDB, tbl string) error

+ func (s *Session) Disable()

+ func (s *Session) Enable()

+ func (s *Session) IsEmpty() bool

+ func (s *Session) IsEnabled() bool

+ func (s *Session) IsIndirect() bool

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

+ func (s *Session) SetIndirect(indirect bool)

+ type UpdateFunc func(op int, db, tbl RawString, row int64)

+ type Value struct

v0.3.1

Sep 17, 2018

v0.3.0

Sep 16, 2018

v0.2.0

Sep 14, 2018

v0.1.2

Sep 1, 2018

Changes in this version

type Conn

+ func (c *Conn) WithTx(f func() error) error

+ func (c *Conn) WithTxExclusive(f func() error) error

+ func (c *Conn) WithTxImmediate(f func() error) error

type Stmt

+ func (s *Stmt) ColumnBlob(i int) []byte

+ func (s *Stmt) ColumnBytes(i int) int

+ func (s *Stmt) ColumnDouble(i int) float64

+ func (s *Stmt) ColumnInt(i int) int

+ func (s *Stmt) ColumnInt64(i int) int64

+ func (s *Stmt) ColumnRawBytes(i int) RawBytes

+ func (s *Stmt) ColumnRawString(i int) RawString

+ func (s *Stmt) ColumnText(i int) string

v0.1.1

Aug 25, 2018

v0.1.0

Aug 21, 2018

Changes in this version

+ const ABORT

+ const ABORT_ROLLBACK

+ const ALTER_TABLE

+ const ANALYZE

+ const ATTACH

+ const AUTH

+ const BLOB

+ const BUSY

+ const BUSY_RECOVERY

+ const BUSY_SNAPSHOT

+ const CANTOPEN

+ const CANTOPEN_CONVPATH

+ const CANTOPEN_FULLPATH

+ const CANTOPEN_ISDIR

+ const CANTOPEN_NOTEMPDIR

+ const CONSTRAINT

+ const CONSTRAINT_CHECK

+ const CONSTRAINT_COMMITHOOK

+ const CONSTRAINT_FOREIGNKEY

+ const CONSTRAINT_FUNCTION

+ const CONSTRAINT_NOTNULL

+ const CONSTRAINT_PRIMARYKEY

+ const CONSTRAINT_ROWID

+ const CONSTRAINT_TRIGGER

+ const CONSTRAINT_UNIQUE

+ const CONSTRAINT_VTAB

+ const CORRUPT

+ const CORRUPT_VTAB

+ const CREATE_INDEX

+ const CREATE_TABLE

+ const CREATE_TEMP_INDEX

+ const CREATE_TEMP_TABLE

+ const CREATE_TEMP_TRIGGER

+ const CREATE_TEMP_VIEW

+ const CREATE_TRIGGER

+ const CREATE_VIEW

+ const CREATE_VTABLE

+ const DBSTATUS_CACHE_HIT

+ const DBSTATUS_CACHE_MISS

+ const DBSTATUS_CACHE_USED

+ const DBSTATUS_CACHE_WRITE

+ const DBSTATUS_DEFERRED_FKS

+ const DBSTATUS_LOOKASIDE_HIT

+ const DBSTATUS_LOOKASIDE_MISS_FULL

+ const DBSTATUS_LOOKASIDE_MISS_SIZE

+ const DBSTATUS_LOOKASIDE_USED

+ const DBSTATUS_SCHEMA_USED

+ const DBSTATUS_STMT_USED

+ const DELETE

+ const DETACH

+ const DONE

+ const DROP_INDEX

+ const DROP_TABLE

+ const DROP_TEMP_INDEX

+ const DROP_TEMP_TABLE

+ const DROP_TEMP_TRIGGER

+ const DROP_TEMP_VIEW

+ const DROP_TRIGGER

+ const DROP_VIEW

+ const DROP_VTABLE

+ const EMPTY

+ const ERROR

+ const FLOAT

+ const FORMAT

+ const FULL

+ const FUNCTION

+ const INSERT

+ const INTEGER

+ const INTERNAL

+ const INTERRUPT

+ const IOERR

+ const IOERR_ACCESS

+ const IOERR_BLOCKED

+ const IOERR_CHECKRESERVEDLOCK

+ const IOERR_CLOSE

+ const IOERR_CONVPATH

+ const IOERR_DELETE

+ const IOERR_DELETE_NOENT

+ const IOERR_DIR_CLOSE

+ const IOERR_DIR_FSYNC

+ const IOERR_FSTAT

+ const IOERR_FSYNC

+ const IOERR_GETTEMPPATH

+ const IOERR_LOCK

+ const IOERR_MMAP

+ const IOERR_NOMEM

+ const IOERR_RDLOCK

+ const IOERR_READ

+ const IOERR_SEEK

+ const IOERR_SHMLOCK

+ const IOERR_SHMMAP

+ const IOERR_SHMOPEN

+ const IOERR_SHMSIZE

+ const IOERR_SHORT_READ

+ const IOERR_TRUNCATE

+ const IOERR_UNLOCK

+ const IOERR_WRITE

+ const LIMIT_ATTACHED

+ const LIMIT_COLUMN

+ const LIMIT_COMPOUND_SELECT

+ const LIMIT_EXPR_DEPTH

+ const LIMIT_FUNCTION_ARG

+ const LIMIT_LENGTH

+ const LIMIT_LIKE_PATTERN_LENGTH

+ const LIMIT_SQL_LENGTH

+ const LIMIT_TRIGGER_DEPTH

+ const LIMIT_VARIABLE_NUMBER

+ const LIMIT_VDBE_OP

+ const LOCKED

+ const LOCKED_SHAREDCACHE

+ const MISMATCH

+ const MISUSE

+ const NOLFS

+ const NOMEM

+ const NOTADB

+ const NOTFOUND

+ const NOTICE

+ const NOTICE_RECOVER_ROLLBACK

+ const NOTICE_RECOVER_WAL

+ const NULL

+ const OK

+ const OPEN_AUTOPROXY

+ const OPEN_CREATE

+ const OPEN_DELETEONCLOSE

+ const OPEN_EXCLUSIVE

+ const OPEN_FULLMUTEX

+ const OPEN_MAIN_DB

+ const OPEN_MAIN_JOURNAL

+ const OPEN_MASTER_JOURNAL

+ const OPEN_MEMORY

+ const OPEN_NOMUTEX

+ const OPEN_PRIVATECACHE

+ const OPEN_READONLY

+ const OPEN_READWRITE

+ const OPEN_SHAREDCACHE

+ const OPEN_SUBJOURNAL

+ const OPEN_TEMP_DB

+ const OPEN_TEMP_JOURNAL

+ const OPEN_TRANSIENT_DB

+ const OPEN_URI

+ const OPEN_WAL

+ const PERM

+ const PRAGMA

+ const PROTOCOL

+ const RANGE

+ const READ

+ const READONLY

+ const READONLY_CANTLOCK

+ const READONLY_DBMOVED

+ const READONLY_RECOVERY

+ const READONLY_ROLLBACK

+ const RECURSIVE

+ const REINDEX

+ const ROW

+ const SAVEPOINT

+ const SCHEMA

+ const SELECT

+ const STATUS_MALLOC_COUNT

+ const STATUS_MALLOC_SIZE

+ const STATUS_MEMORY_USED

+ const STATUS_PAGECACHE_OVERFLOW

+ const STATUS_PAGECACHE_SIZE

+ const STATUS_PAGECACHE_USED

+ const STATUS_PARSER_STACK

+ const STATUS_SCRATCH_OVERFLOW

+ const STATUS_SCRATCH_SIZE

+ const STATUS_SCRATCH_USED

+ const STMTSTATUS_AUTOINDEX

+ const STMTSTATUS_FULLSCAN_STEP

+ const STMTSTATUS_SORT

+ const STMTSTATUS_VM_STEP

+ const TEXT

+ const TOOBIG

+ const TRANSACTION

+ const UPDATE

+ const WARNING

+ const WARNING_AUTOINDEX

+ var ErrBadBackup = &Error

+ var ErrBadConn = &Error

+ var ErrBadIO = &Error

+ var ErrBlobFull = &Error

+ func Complete(sql string) bool

+ func ReleaseMemory(n int) int

+ func SoftHeapLimit(n int64) int64

+ func SourceID() string

+ func Status(op int, reset bool) (cur, peak int, err error)

+ func Version() string

+ func VersionNum() int

+ type Backup struct

+ func (b *Backup) Close() error

+ func (b *Backup) Conn() (src, dst *Conn)

+ func (b *Backup) Progress() (remaining, total int)

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

+ type BlobIO struct

+ func (b *BlobIO) Close() error

+ func (b *BlobIO) Conn() *Conn

+ func (b *BlobIO) Len() int

+ func (b *BlobIO) Read(p []byte) (n int, err error)

+ func (b *BlobIO) Reopen(row int64) error

+ func (b *BlobIO) Row() int64

+ func (b *BlobIO) Seek(offset int64, whence int) (ret int64, err error)

+ func (b *BlobIO) Write(p []byte) (n int, err error)

+ type Conn struct

+ func Open(name string, flagArgs ...int) (*Conn, error)

+ func (c *Conn) AutoCommit() bool

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

+ func (c *Conn) Begin() error

+ func (c *Conn) BeginExclusive() error

+ func (c *Conn) BeginImmediate() error

+ func (c *Conn) BlobIO(db, tbl, col string, row int64, rw bool) (*BlobIO, error)

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

+ func (c *Conn) Changes() int

+ func (c *Conn) Close() error

+ func (c *Conn) Commit() error

+ func (c *Conn) Exec(sql string, args ...interface{}) error

+ func (c *Conn) FileName(db string) string

+ func (c *Conn) Interrupt()

+ func (c *Conn) LastInsertRowID() int64

+ func (c *Conn) Limit(id, value int) (prev int)

+ func (c *Conn) Prepare(sql string, args ...interface{}) (s *Stmt, err error)

+ func (c *Conn) Rollback() error

+ func (c *Conn) Status(op int, reset bool) (cur, peak int, err error)

+ func (c *Conn) TotalChanges() int

+ type Error struct

+ func NewError(rc int, msg string) *Error

+ func (err *Error) Code() int

+ func (err *Error) Error() string

+ type NamedArgs map[string]interface

+ type RawBytes []byte

+ func (b RawBytes) Copy() []byte

+ type RawString string

+ func (s RawString) Copy() string

+ type Stmt struct

+ Tail string

+ func (s *Stmt) Bind(args ...interface{}) error

+ func (s *Stmt) BindParameterCount() int

+ func (s *Stmt) Busy() bool

+ func (s *Stmt) ClearBindings() error

+ func (s *Stmt) Close() error

+ func (s *Stmt) ColumnCount() int

+ func (s *Stmt) ColumnName(i int) string

+ func (s *Stmt) ColumnNames() []string

+ func (s *Stmt) ColumnType(i int) byte

+ func (s *Stmt) ColumnTypes() []byte

+ func (s *Stmt) DeclType(i int) string

+ func (s *Stmt) DeclTypes() []string

+ func (s *Stmt) Exec(args ...interface{}) error

+ func (s *Stmt) ReadOnly() bool

+ func (s *Stmt) Reset() error

+ func (s *Stmt) Scan(dst ...interface{}) error

+ func (s *Stmt) Status(op int, reset bool) int

+ func (s *Stmt) Step() (bool, error)

+ func (s *Stmt) StepToCompletion() error

+ type ZeroBlob int