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