sqlite3

Types

PSqlite3 = ptr Sqlite3
Source Edit
PPSqlite3 = ptr PSqlite3
Source Edit
PSqlite3_Backup = ptr Sqlite3_Backup
Source Edit
PPSqlite3_Backup = ptr PSqlite3_Backup
Source Edit
Pcontext = ptr Context
Source Edit
PStmt = ptr TStmt
Source Edit
PValue = ptr Value
Source Edit
PValueArg = array[0 .. 127, PValue]
Source Edit
Callback = proc (para1: pointer; para2: int32; para3, para4: cstringArray): int32 {...}{.
    cdecl.}
Source Edit
Tbind_destructor_func = proc (para1: pointer) {...}{.cdecl, locks: 0, tags: [],
    gcsafe.}
Source Edit
Create_function_step_func = proc (para1: Pcontext; para2: int32;
                                  para3: PValueArg) {...}{.cdecl.}
Source Edit
Create_function_func_func = proc (para1: Pcontext; para2: int32;
                                  para3: PValueArg) {...}{.cdecl.}
Source Edit
Create_function_final_func = proc (para1: Pcontext) {...}{.cdecl.}
Source Edit
Result_func = proc (para1: pointer) {...}{.cdecl.}
Source Edit
Create_collation_func = proc (para1: pointer; para2: int32; para3: pointer;
                              para4: int32; para5: pointer): int32 {...}{.cdecl.}
Source Edit
Collation_needed_func = proc (para1: pointer; para2: PSqlite3; eTextRep: int32;
                              para4: cstring) {...}{.cdecl.}
Source Edit

Consts

SQLITE_INTEGER = 1
Source Edit
SQLITE_FLOAT = 2
Source Edit
SQLITE_BLOB = 4
Source Edit
SQLITE_NULL = 5
Source Edit
SQLITE_TEXT = 3
Source Edit
SQLITE_UTF8 = 1
Source Edit
SQLITE_UTF16LE = 2
Source Edit
SQLITE_UTF16BE = 3
Source Edit
SQLITE_UTF16 = 4
Source Edit
SQLITE_ANY = 5
Source Edit
SQLITE_OK = 0
Source Edit
SQLITE_ERROR = 1
Source Edit
SQLITE_INTERNAL = 2
Source Edit
SQLITE_PERM = 3
Source Edit
SQLITE_ABORT = 4
Source Edit
SQLITE_BUSY = 5
Source Edit
SQLITE_LOCKED = 6
Source Edit
SQLITE_NOMEM = 7
Source Edit
SQLITE_READONLY = 8
Source Edit
SQLITE_INTERRUPT = 9
Source Edit
SQLITE_IOERR = 10
Source Edit
SQLITE_CORRUPT = 11
Source Edit
SQLITE_NOTFOUND = 12
Source Edit
SQLITE_FULL = 13
Source Edit
SQLITE_CANTOPEN = 14
Source Edit
SQLITE_PROTOCOL = 15
Source Edit
SQLITE_EMPTY = 16
Source Edit
SQLITE_SCHEMA = 17
Source Edit
SQLITE_TOOBIG = 18
Source Edit
SQLITE_CONSTRAINT = 19
Source Edit
SQLITE_MISMATCH = 20
Source Edit
SQLITE_MISUSE = 21
Source Edit
SQLITE_NOLFS = 22
Source Edit
SQLITE_AUTH = 23
Source Edit
SQLITE_FORMAT = 24
Source Edit
SQLITE_RANGE = 25
Source Edit
SQLITE_NOTADB = 26
Source Edit
SQLITE_ROW = 100
Source Edit
SQLITE_DONE = 101
Source Edit
SQLITE_COPY = 0
Source Edit
SQLITE_CREATE_INDEX = 1
Source Edit
SQLITE_CREATE_TABLE = 2
Source Edit
SQLITE_CREATE_TEMP_INDEX = 3
Source Edit
SQLITE_CREATE_TEMP_TABLE = 4
Source Edit
SQLITE_CREATE_TEMP_TRIGGER = 5
Source Edit
SQLITE_CREATE_TEMP_VIEW = 6
Source Edit
SQLITE_CREATE_TRIGGER = 7
Source Edit
SQLITE_CREATE_VIEW = 8
Source Edit
SQLITE_DELETE = 9
Source Edit
SQLITE_DROP_INDEX = 10
Source Edit
SQLITE_DROP_TABLE = 11
Source Edit
SQLITE_DROP_TEMP_INDEX = 12
Source Edit
SQLITE_DROP_TEMP_TABLE = 13
Source Edit
SQLITE_DROP_TEMP_TRIGGER = 14
Source Edit
SQLITE_DROP_TEMP_VIEW = 15
Source Edit
SQLITE_DROP_TRIGGER = 16
Source Edit
SQLITE_DROP_VIEW = 17
Source Edit
SQLITE_INSERT = 18
Source Edit
SQLITE_PRAGMA = 19
Source Edit
SQLITE_READ = 20
Source Edit
SQLITE_SELECT = 21
Source Edit
SQLITE_TRANSACTION = 22
Source Edit
SQLITE_UPDATE = 23
Source Edit
SQLITE_ATTACH = 24
Source Edit
SQLITE_DETACH = 25
Source Edit
SQLITE_ALTER_TABLE = 26
Source Edit
SQLITE_REINDEX = 27
Source Edit
SQLITE_DENY = 1
Source Edit
SQLITE_IGNORE = 2
Source Edit
SQLITE_DETERMINISTIC = 0x00000800
Source Edit
SQLITE_STATIC = nil
Source Edit
SQLITE_TRANSIENT = -1
Source Edit

Procs

proc close(para1: PSqlite3): int32 {...}{.cdecl, dynlib: Lib,
                                     importc: "sqlite3_close".}
Source Edit
proc exec(para1: PSqlite3; sql: cstring; para3: Callback; para4: pointer;
          errmsg: var cstring): int32 {...}{.cdecl, dynlib: Lib,
                                        importc: "sqlite3_exec".}
Source Edit
proc last_insert_rowid(para1: PSqlite3): int64 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_last_insert_rowid".}
Source Edit
proc changes(para1: PSqlite3): int32 {...}{.cdecl, dynlib: Lib,
                                       importc: "sqlite3_changes".}
Source Edit
proc total_changes(para1: PSqlite3): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_total_changes".}
Source Edit
proc interrupt(para1: PSqlite3) {...}{.cdecl, dynlib: Lib,
                                  importc: "sqlite3_interrupt".}
Source Edit
proc complete(sql: cstring): int32 {...}{.cdecl, dynlib: Lib,
                                     importc: "sqlite3_complete".}
Source Edit
proc complete16(sql: pointer): int32 {...}{.cdecl, dynlib: Lib,
                                       importc: "sqlite3_complete16".}
Source Edit
proc busy_handler(para1: PSqlite3;
                  para2: proc (para1: pointer; para2: int32): int32 {...}{.cdecl.};
                  para3: pointer): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_busy_handler".}
Source Edit
proc busy_timeout(para1: PSqlite3; ms: int32): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_busy_timeout".}
Source Edit
proc get_table(para1: PSqlite3; sql: cstring; resultp: var cstringArray;
               nrow, ncolumn: var cint; errmsg: ptr cstring): int32 {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_get_table".}
Source Edit
proc free_table(result: cstringArray) {...}{.cdecl, dynlib: Lib,
                                        importc: "sqlite3_free_table".}
Source Edit
proc mprintf(para1: cstring): cstring {...}{.cdecl, varargs, dynlib: Lib,
                                        importc: "sqlite3_mprintf".}
Source Edit
proc free(z: cstring) {...}{.cdecl, dynlib: Lib, importc: "sqlite3_free".}
Source Edit
proc snprintf(para1: int32; para2: cstring; para3: cstring): cstring {...}{.cdecl,
    dynlib: Lib, varargs, importc: "sqlite3_snprintf".}
Source Edit
proc set_authorizer(para1: PSqlite3; xAuth: proc (para1: pointer; para2: int32;
    para3: cstring; para4: cstring; para5: cstring; para6: cstring): int32 {...}{.
    cdecl.}; pUserData: pointer): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_set_authorizer".}
Source Edit
proc trace(para1: PSqlite3;
           xTrace: proc (para1: pointer; para2: cstring) {...}{.cdecl.};
           para3: pointer): pointer {...}{.cdecl, dynlib: Lib,
                                      importc: "sqlite3_trace".}
Source Edit
proc progress_handler(para1: PSqlite3; para2: int32;
                      para3: proc (para1: pointer): int32 {...}{.cdecl.};
                      para4: pointer) {...}{.cdecl, dynlib: Lib,
                                        importc: "sqlite3_progress_handler".}
Source Edit
proc commit_hook(para1: PSqlite3; para2: proc (para1: pointer): int32 {...}{.cdecl.};
                 para3: pointer): pointer {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_commit_hook".}
Source Edit
proc open(filename: cstring; ppDb: var PSqlite3): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_open".}
Source Edit
proc open16(filename: pointer; ppDb: var PSqlite3): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_open16".}
Source Edit
proc errcode(db: PSqlite3): int32 {...}{.cdecl, dynlib: Lib,
                                    importc: "sqlite3_errcode".}
Source Edit
proc errmsg(para1: PSqlite3): cstring {...}{.cdecl, dynlib: Lib,
                                        importc: "sqlite3_errmsg".}
Source Edit
proc errmsg16(para1: PSqlite3): pointer {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_errmsg16".}
Source Edit
proc prepare(db: PSqlite3; zSql: cstring; nBytes: int32; ppStmt: var PStmt;
             pzTail: ptr cstring): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_prepare".}
Source Edit
proc prepare_v2(db: PSqlite3; zSql: cstring; nByte: cint; ppStmt: var PStmt;
                pzTail: ptr cstring): cint {...}{.importc: "sqlite3_prepare_v2",
    cdecl, dynlib: Lib.}
Source Edit
proc prepare16(db: PSqlite3; zSql: pointer; nBytes: int32; ppStmt: var PStmt;
               pzTail: var pointer): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_prepare16".}
Source Edit
proc bind_blob(para1: PStmt; para2: int32; para3: pointer; n: int32;
               para5: Tbind_destructor_func): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_bind_blob".}
Source Edit
proc bind_double(para1: PStmt; para2: int32; para3: float64): int32 {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_bind_double".}
Source Edit
proc bind_int(para1: PStmt; para2: int32; para3: int32): int32 {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_bind_int".}
Source Edit
proc bind_int64(para1: PStmt; para2: int32; para3: int64): int32 {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_bind_int64".}
Source Edit
proc bind_null(para1: PStmt; para2: int32): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_bind_null".}
Source Edit
proc bind_text(para1: PStmt; para2: int32; para3: cstring; n: int32;
               para5: Tbind_destructor_func): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_bind_text".}
Source Edit
proc bind_text16(para1: PStmt; para2: int32; para3: pointer; para4: int32;
                 para5: Tbind_destructor_func): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_bind_text16".}
Source Edit
proc bind_blob(para1: PStmt; para2: int32; para3: pointer; n: int32;
               para5: int32): int32 {...}{.cdecl, dynlib: Lib,
                                      importc: "sqlite3_bind_blob".}
Source Edit
proc bind_text(para1: PStmt; para2: int32; para3: cstring; n: int32;
               para5: int32): int32 {...}{.cdecl, dynlib: Lib,
                                      importc: "sqlite3_bind_text".}
Source Edit
proc bind_text16(para1: PStmt; para2: int32; para3: pointer; para4: int32;
                 para5: int32): int32 {...}{.cdecl, dynlib: Lib,
                                        importc: "sqlite3_bind_text16".}
Source Edit
proc bind_parameter_count(para1: PStmt): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_bind_parameter_count".}
Source Edit
proc bind_parameter_name(para1: PStmt; para2: int32): cstring {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_bind_parameter_name".}
Source Edit
proc bind_parameter_index(para1: PStmt; zName: cstring): int32 {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_bind_parameter_index".}
Source Edit
proc clear_bindings(para1: PStmt): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_clear_bindings".}
Source Edit
proc column_count(PStmt: PStmt): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_column_count".}
Source Edit
proc column_name(para1: PStmt; para2: int32): cstring {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_column_name".}
Source Edit
proc column_table_name(para1: PStmt; para2: int32): cstring {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_column_table_name".}
Source Edit
proc column_name16(para1: PStmt; para2: int32): pointer {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_column_name16".}
Source Edit
proc column_decltype(para1: PStmt; i: int32): cstring {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_column_decltype".}
Source Edit
proc column_decltype16(para1: PStmt; para2: int32): pointer {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_column_decltype16".}
Source Edit
proc step(para1: PStmt): int32 {...}{.cdecl, dynlib: Lib, importc: "sqlite3_step".}
Source Edit
proc data_count(PStmt: PStmt): int32 {...}{.cdecl, dynlib: Lib,
                                       importc: "sqlite3_data_count".}
Source Edit
proc column_blob(para1: PStmt; iCol: int32): pointer {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_column_blob".}
Source Edit
proc column_bytes(para1: PStmt; iCol: int32): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_column_bytes".}
Source Edit
proc column_bytes16(para1: PStmt; iCol: int32): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_column_bytes16".}
Source Edit
proc column_double(para1: PStmt; iCol: int32): float64 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_column_double".}
Source Edit
proc column_int(para1: PStmt; iCol: int32): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_column_int".}
Source Edit
proc column_int64(para1: PStmt; iCol: int32): int64 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_column_int64".}
Source Edit
proc column_text(para1: PStmt; iCol: int32): cstring {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_column_text".}
Source Edit
proc column_text16(para1: PStmt; iCol: int32): pointer {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_column_text16".}
Source Edit
proc column_type(para1: PStmt; iCol: int32): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_column_type".}
Source Edit
proc finalize(PStmt: PStmt): int32 {...}{.cdecl, dynlib: Lib,
                                     importc: "sqlite3_finalize".}
Source Edit
proc reset(PStmt: PStmt): int32 {...}{.cdecl, dynlib: Lib, importc: "sqlite3_reset".}
Source Edit
proc create_function(para1: PSqlite3; zFunctionName: cstring; nArg: int32;
                     eTextRep: int32; para5: pointer;
                     xFunc: Create_function_func_func;
                     xStep: Create_function_step_func;
                     xFinal: Create_function_final_func): int32 {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_create_function".}
Source Edit
proc create_function16(para1: PSqlite3; zFunctionName: pointer; nArg: int32;
                       eTextRep: int32; para5: pointer;
                       xFunc: Create_function_func_func;
                       xStep: Create_function_step_func;
                       xFinal: Create_function_final_func): int32 {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_create_function16".}
Source Edit
proc aggregate_count(para1: Pcontext): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_aggregate_count".}
Source Edit
proc value_blob(para1: PValue): pointer {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_value_blob".}
Source Edit
proc value_bytes(para1: PValue): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_value_bytes".}
Source Edit
proc value_bytes16(para1: PValue): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_value_bytes16".}
Source Edit
proc value_double(para1: PValue): float64 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_value_double".}
Source Edit
proc value_int(para1: PValue): int32 {...}{.cdecl, dynlib: Lib,
                                       importc: "sqlite3_value_int".}
Source Edit
proc value_int64(para1: PValue): int64 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_value_int64".}
Source Edit
proc value_text(para1: PValue): cstring {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_value_text".}
Source Edit
proc value_text16(para1: PValue): pointer {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_value_text16".}
Source Edit
proc value_text16le(para1: PValue): pointer {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_value_text16le".}
Source Edit
proc value_text16be(para1: PValue): pointer {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_value_text16be".}
Source Edit
proc value_type(para1: PValue): int32 {...}{.cdecl, dynlib: Lib,
                                        importc: "sqlite3_value_type".}
Source Edit
proc aggregate_context(para1: Pcontext; nBytes: int32): pointer {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_aggregate_context".}
Source Edit
proc user_data(para1: Pcontext): pointer {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_user_data".}
Source Edit
proc get_auxdata(para1: Pcontext; para2: int32): pointer {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_get_auxdata".}
Source Edit
proc set_auxdata(para1: Pcontext; para2: int32; para3: pointer;
                 para4: proc (para1: pointer) {...}{.cdecl.}) {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_set_auxdata".}
Source Edit
proc result_blob(para1: Pcontext; para2: pointer; para3: int32;
                 para4: Result_func) {...}{.cdecl, dynlib: Lib,
                                       importc: "sqlite3_result_blob".}
Source Edit
proc result_double(para1: Pcontext; para2: float64) {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_result_double".}
Source Edit
proc result_error(para1: Pcontext; para2: cstring; para3: int32) {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_result_error".}
Source Edit
proc result_error16(para1: Pcontext; para2: pointer; para3: int32) {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_result_error16".}
Source Edit
proc result_int(para1: Pcontext; para2: int32) {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_result_int".}
Source Edit
proc result_int64(para1: Pcontext; para2: int64) {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_result_int64".}
Source Edit
proc result_null(para1: Pcontext) {...}{.cdecl, dynlib: Lib,
                                    importc: "sqlite3_result_null".}
Source Edit
proc result_text(para1: Pcontext; para2: cstring; para3: int32;
                 para4: Result_func) {...}{.cdecl, dynlib: Lib,
                                       importc: "sqlite3_result_text".}
Source Edit
proc result_text16(para1: Pcontext; para2: pointer; para3: int32;
                   para4: Result_func) {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_result_text16".}
Source Edit
proc result_text16le(para1: Pcontext; para2: pointer; para3: int32;
                     para4: Result_func) {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_result_text16le".}
Source Edit
proc result_text16be(para1: Pcontext; para2: pointer; para3: int32;
                     para4: Result_func) {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_result_text16be".}
Source Edit
proc result_value(para1: Pcontext; para2: PValue) {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_result_value".}
Source Edit
proc create_collation(para1: PSqlite3; zName: cstring; eTextRep: int32;
                      para4: pointer; xCompare: Create_collation_func): int32 {...}{.
    cdecl, dynlib: Lib, importc: "sqlite3_create_collation".}
Source Edit
proc create_collation16(para1: PSqlite3; zName: cstring; eTextRep: int32;
                        para4: pointer; xCompare: Create_collation_func): int32 {...}{.
    cdecl, dynlib: Lib, importc: "sqlite3_create_collation16".}
Source Edit
proc collation_needed(para1: PSqlite3; para2: pointer;
                      para3: Collation_needed_func): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_collation_needed".}
Source Edit
proc collation_needed16(para1: PSqlite3; para2: pointer;
                        para3: Collation_needed_func): int32 {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_collation_needed16".}
Source Edit
proc libversion(): cstring {...}{.cdecl, dynlib: Lib, importc: "sqlite3_libversion".}
Source Edit
proc version(): cstring {...}{.cdecl, dynlib: Lib, importc: "sqlite3_libversion".}
Source Edit
proc libversion_number(): int32 {...}{.cdecl, dynlib: Lib,
                                  importc: "sqlite3_libversion_number".}
Source Edit
proc backup_init(pDest: PSqlite3; zDestName: cstring; pSource: PSqlite3;
                 zSourceName: cstring): PSqlite3_Backup {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_backup_init".}
Source Edit
proc backup_step(pBackup: PSqlite3_Backup; nPage: int32): int32 {...}{.cdecl,
    dynlib: Lib, importc: "sqlite3_backup_step".}
Source Edit
proc backup_finish(pBackup: PSqlite3_Backup): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_backup_finish".}
Source Edit
proc backup_pagecount(pBackup: PSqlite3_Backup): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_backup_pagecount".}
Source Edit
proc backup_remaining(pBackup: PSqlite3_Backup): int32 {...}{.cdecl, dynlib: Lib,
    importc: "sqlite3_backup_remaining".}
Source Edit
proc sqlite3_sleep(t: int64): int64 {...}{.cdecl, dynlib: Lib,
                                      importc: "sqlite3_sleep".}
Source Edit

© 2006–2021 Andreas Rumpf
Licensed under the MIT License.
https://nim-lang.org/docs/sqlite3.html