Index

Modules: sqlite, sqlite/autoconv, sqlite/common, sqlite/comparators, sqlite/private/libsqlite3.

API symbols

`==`:

• comparators: proc `==`(a: DbValue; b: type(nil)): bool
• comparators: proc `==`(a, b: DbValue): bool
• comparators: proc `==`(a: DbValue; b: seq[byte]): bool
• comparators: proc `==`(a: DbValue; b: SomeFloat): bool
• comparators: proc `==`(a: DbValue; b: SomeInteger): bool
• comparators: proc `==`(a: DbValue; b: string): bool

all:

• sqlite: proc all(db: DbConn; query: string; params: varargs[DbValue, toDbValue]): seq[DbRow]

bind_blob:

• libsqlite3: proc bind_blob(arg1: Stmt; arg2: int32; arg3: pointer; n: int32; arg5: BindDestructor): int32

BindDestructor:

• libsqlite3: type BindDestructor

bind_double:

• libsqlite3: proc bind_double(arg1: Stmt; arg2: int32; arg3: float64): int32

bind_int64:

• libsqlite3: proc bind_int64(arg1: Stmt; arg2: int32; arg3: int64): int32

bind_null:

• libsqlite3: proc bind_null(arg1: Stmt; arg2: int32): int32

bind_parameter_count:

• libsqlite3: proc bind_parameter_count(arg1: Stmt): int32

bind_text:

• libsqlite3: proc bind_text(arg1: Stmt; arg2: int32; arg3: cstring; n: int32; arg5: BindDestructor): int32

borrow:

• sqlite: proc borrow(pool: var DbPool): DbConn

closeSqlite:

• sqlite: proc closeSqlite(db: DbConn)

closeSqlitePool:

• sqlite: proc closeSqlitePool(pool: var DbPool)

close_v2:

• libsqlite3: proc close_v2(arg: Sqlite3): int32

column_blob:

• libsqlite3: proc column_blob(stmt: Stmt; c: cint): pointer

column_bytes:

• libsqlite3: proc column_bytes(stmt: Stmt; c: cint): cint

column_count:

• libsqlite3: proc column_count(stmt: Stmt): cint

column_double:

• libsqlite3: proc column_double(stmt: Stmt; c: cint): float64

column_int64:

• libsqlite3: proc column_int64(stmt: Stmt; c: cint): int64

column_text:

• libsqlite3: proc column_text(stmt: Stmt; c: cint): cstring

column_type:

• libsqlite3: proc column_type(stmt: Stmt; c: cint): cint

DbConn:

• common: type DbConn

DbConnProfile:

• common: enum DbConnProfile

DbError:

• common: object DbError

DbPool:

• common: object DbPool

DbRow:

• common: type DbRow

DbValue:

• common: object DbValue

DbValueKind:

• common: enum DbValueKind

errmsg:

• libsqlite3: proc errmsg(arg1: Sqlite3): cstring

exec:

• sqlite: proc exec(db: DbConn; query: string; params: varargs[DbValue, toDbValue])

execScript:

• sqlite: proc execScript(db: DbConn; query: string)

extended_result_codes:

• libsqlite3: proc extended_result_codes(arg1: Sqlite3; onoff: cint): cint

finalize:

• libsqlite3: proc finalize(arg: Stmt): cint

get_autocommit:

• libsqlite3: proc get_autocommit(arg1: Sqlite3): cint

getLastRowId:

• sqlite: proc getLastRowId(db: DbConn): int64

isNull:

• sqlite: proc isNull(val: DbValue): bool

items:

• sqlite: iterator items(pool: var DbPool): DbConn

iterate:

• sqlite: iterator iterate(db: DbConn; query: string; params: varargs[DbValue, toDbValue]): DbRow

last_insert_rowid:

• libsqlite3: proc last_insert_rowid(arg1: Sqlite3): int64

one:

• sqlite: proc one(db: DbConn; query: string; params: varargs[DbValue, toDbValue]): DbRow

open:

• libsqlite3: proc open(filename: cstring; ppDb: var Sqlite3): int32

openSqlite:

• sqlite: proc openSqlite(fn: string; profile = DbConnProfile.Minimal): DbConn

openSqlitePool:

• sqlite: proc openSqlitePool(filename: string; size: int; profile = DbConnProfile.Minimal): DbPool

optimize:

• sqlite: proc optimize(db: DbConn; analysisLimit = 400; mask = "")

prepare_v2:

• libsqlite3: proc prepare_v2(db: Sqlite3; zSql: cstring; nByte: cint; ppStmt: var Stmt; pzTail: ptr cstring): cint

recycle:

• sqlite: proc recycle(pool: var DbPool; conn: DbConn)

reset:

• libsqlite3: proc reset(arg: Stmt): cint

Sqlite3:

• libsqlite3: type Sqlite3

SQLITE_BLOB:

• libsqlite3: const SQLITE_BLOB

SQLITE_DONE:

• libsqlite3: const SQLITE_DONE

SQLITE_FLOAT:

• libsqlite3: const SQLITE_FLOAT

SQLITE_INTEGER:

• libsqlite3: const SQLITE_INTEGER

SQLITE_MISUSE:

• libsqlite3: const SQLITE_MISUSE

SQLITE_NULL:

• libsqlite3: const SQLITE_NULL

SQLITE_OK:

• libsqlite3: const SQLITE_OK

SQLITE_ROW:

• libsqlite3: const SQLITE_ROW

SQLITE_STATIC:

• libsqlite3: const SQLITE_STATIC

SQLITE_TEXT:

• libsqlite3: const SQLITE_TEXT

SQLITE_TRANSIENT:

• libsqlite3: const SQLITE_TRANSIENT

step:

• libsqlite3: proc step(arg1: Stmt): cint

Stmt:

• libsqlite3: type Stmt

toDbValue:

• autoconv: proc toDbValue[T: SomeInteger](v: T): DbValue
• autoconv: proc toDbValue[T: SomeFloat](v: T): DbValue
• autoconv: proc toDbValue[T: string](v: T): DbValue
• autoconv: proc toDbValue[T: seq[byte]](v: T): DbValue
• autoconv: proc toDbValue[T: type(nil)](v: T): DbValue
• autoconv: proc toDbValue[T: bool](v: T): DbValue

transaction:

• sqlite: template transaction(db: DbConn; body)

withDb:

• sqlite: template withDb(pool: var DbPool; conn, body)