sqlite API Reference

Functions

fn SQLITE_OK() -> int

**Returns:** int

fn SQLITE_ROW() -> int

**Returns:** int

fn SQLITE_DONE() -> int

**Returns:** int

fn SQLITE_INTEGER() -> int

**Returns:** int

fn SQLITE_FLOAT() -> int

**Returns:** int

fn SQLITE_TEXT() -> int

**Returns:** int

fn SQLITE_BLOB() -> int

**Returns:** int

fn SQLITE_NULL() -> int

**Returns:** int

extern fn nl_sqlite3_version() -> string

**Returns:** string

extern fn nl_sqlite3_version_number() -> int

**Returns:** int

fn version() -> string

**Returns:** string

fn version_number() -> int

**Returns:** int

extern fn nl_sqlite3_open(_filename: string) -> int

**Parameters:**

Name	Type
_filename	string

**Returns:** int

extern fn nl_sqlite3_close(_db: int) -> int

**Parameters:**

Name	Type
_db	int

**Returns:** int

extern fn nl_sqlite3_errmsg(_db: int) -> string

**Parameters:**

Name	Type
_db	int

**Returns:** string

fn open(filename: string) -> int

**Parameters:**

Name	Type
filename	string

**Returns:** int

fn close(db: int) -> int

**Parameters:**

Name	Type
db	int

**Returns:** int

fn errmsg(db: int) -> string

**Parameters:**

Name	Type
db	int

**Returns:** string

extern fn nl_sqlite3_exec(_db: int, _sql: string) -> int

**Parameters:**

Name	Type
_db	int
_sql	string

**Returns:** int

fn exec(db: int, sql: string) -> int

**Parameters:**

Name	Type
db	int
sql	string

**Returns:** int

extern fn nl_sqlite3_prepare(_db: int, _sql: string) -> int

**Parameters:**

Name	Type
_db	int
_sql	string

**Returns:** int

extern fn nl_sqlite3_finalize(_stmt: int) -> int

**Parameters:**

Name	Type
_stmt	int

**Returns:** int

extern fn nl_sqlite3_step(_stmt: int) -> int

**Parameters:**

Name	Type
_stmt	int

**Returns:** int

extern fn nl_sqlite3_reset(_stmt: int) -> int

**Parameters:**

Name	Type
_stmt	int

**Returns:** int

fn prepare(db: int, sql: string) -> int

**Parameters:**

Name	Type
db	int
sql	string

**Returns:** int

fn finalize(stmt: int) -> int

**Parameters:**

Name	Type
stmt	int

**Returns:** int

fn step(stmt: int) -> int

**Parameters:**

Name	Type
stmt	int

**Returns:** int

fn reset(stmt: int) -> int

**Parameters:**

Name	Type
stmt	int

**Returns:** int

extern fn nl_sqlite3_bind_int(_stmt: int, _index: int, _value: int) -> int

**Parameters:**

Name	Type
_stmt	int
_index	int
_value	int

**Returns:** int

extern fn nl_sqlite3_bind_double(_stmt: int, _index: int, _value: float) -> int

**Parameters:**

Name	Type
_stmt	int
_index	int
_value	float

**Returns:** int

extern fn nl_sqlite3_bind_text(_stmt: int, _index: int, _value: string) -> int

**Parameters:**

Name	Type
_stmt	int
_index	int
_value	string

**Returns:** int

extern fn nl_sqlite3_bind_null(_stmt: int, _index: int) -> int

**Parameters:**

Name	Type
_stmt	int
_index	int

**Returns:** int

fn bind_int(stmt: int, index: int, value: int) -> int

**Parameters:**

Name	Type
stmt	int
index	int
value	int

**Returns:** int

fn bind_double(stmt: int, index: int, value: float) -> int

**Parameters:**

Name	Type
stmt	int
index	int
value	float

**Returns:** int

fn bind_text(stmt: int, index: int, value: string) -> int

**Parameters:**

Name	Type
stmt	int
index	int
value	string

**Returns:** int

fn bind_null(stmt: int, index: int) -> int

**Parameters:**

Name	Type
stmt	int
index	int

**Returns:** int

extern fn nl_sqlite3_column_count(_stmt: int) -> int

**Parameters:**

Name	Type
_stmt	int

**Returns:** int

extern fn nl_sqlite3_column_name(_stmt: int, _index: int) -> string

**Parameters:**

Name	Type
_stmt	int
_index	int

**Returns:** string

extern fn nl_sqlite3_column_int(_stmt: int, _index: int) -> int

**Parameters:**

Name	Type
_stmt	int
_index	int

**Returns:** int

extern fn nl_sqlite3_column_double(_stmt: int, _index: int) -> float

**Parameters:**

Name	Type
_stmt	int
_index	int

**Returns:** float

extern fn nl_sqlite3_column_text(_stmt: int, _index: int) -> string

**Parameters:**

Name	Type
_stmt	int
_index	int

**Returns:** string

extern fn nl_sqlite3_column_type(_stmt: int, _index: int) -> int

**Parameters:**

Name	Type
_stmt	int
_index	int

**Returns:** int

fn column_count(stmt: int) -> int

**Parameters:**

Name	Type
stmt	int

**Returns:** int

fn column_name(stmt: int, index: int) -> string

**Parameters:**

Name	Type
stmt	int
index	int

**Returns:** string

fn column_int(stmt: int, index: int) -> int

**Parameters:**

Name	Type
stmt	int
index	int

**Returns:** int

fn column_double(stmt: int, index: int) -> float

**Parameters:**

Name	Type
stmt	int
index	int

**Returns:** float

fn column_text(stmt: int, index: int) -> string

**Parameters:**

Name	Type
stmt	int
index	int

**Returns:** string

fn column_type(stmt: int, index: int) -> int

**Parameters:**

Name	Type
stmt	int
index	int

**Returns:** int

extern fn nl_sqlite3_last_insert_rowid(_db: int) -> int

**Parameters:**

Name	Type
_db	int

**Returns:** int

extern fn nl_sqlite3_changes(_db: int) -> int

**Parameters:**

Name	Type
_db	int

**Returns:** int

fn last_insert_rowid(db: int) -> int

**Parameters:**

Name	Type
db	int

**Returns:** int

fn changes(db: int) -> int

**Parameters:**

Name	Type
db	int

**Returns:** int

extern fn nl_sqlite3_begin_transaction(_db: int) -> int

**Parameters:**

Name	Type
_db	int

**Returns:** int

extern fn nl_sqlite3_commit(_db: int) -> int

**Parameters:**

Name	Type
_db	int

**Returns:** int

extern fn nl_sqlite3_rollback(_db: int) -> int

**Parameters:**

Name	Type
_db	int

**Returns:** int

fn begin_transaction(db: int) -> int

**Parameters:**

Name	Type
db	int

**Returns:** int

fn commit(db: int) -> int

**Parameters:**

Name	Type
db	int

**Returns:** int

fn rollback(db: int) -> int

**Parameters:**

Name	Type
db	int

**Returns:** int

fn exec_ok(db: int, sql: string) -> bool

**Parameters:**

Name	Type
db	int
sql	string

**Returns:** bool

fn has_row(step_result: int) -> bool

**Parameters:**

Name	Type
step_result	int

**Returns:** bool

fn is_done(step_result: int) -> bool

**Parameters:**

Name	Type
step_result	int

**Returns:** bool

Structs

*No public structs*

Enums

*No public enums*

Unions

*No public unions*

Opaque Types

*No opaque types*

Constants

*No constants*