Module esqlite3_nif

Low level erlang API for sqlite3 databases.

Authors: Maas-Maarten Zeeman (mmzeeman@xs4all.nl).

Description

Low level erlang API for sqlite3 databases

bind/4	Bind parameters to a prepared statement.
changes/3	Get the number of affected rows of last statement.
close/3	Close the connection.
column_names/3	Retrieve the column names of the prepared statement.
column_types/3	Retrieve the column types of the prepared statement.
exec/4	Exec the query.
finalize/3	.
insert/4	Insert record.
open/4	Open the specified sqlite3 database.
prepare/4	.
reset/3	.
start/0	Start a low level thread which will can handle sqlite3 calls.
step/3	.

bind(Stmt::statement(), Ref::reference(), Dest::pid(), Args::[]) -> ok | {error, message()}

Bind parameters to a prepared statement.

changes(Db, Ref, Dest) -> any()

Get the number of affected rows of last statement

When the statement is executed Dest will receive message {Ref, answer()} with answer() integer | {error, reason()}

close(Db::connection(), Ref::reference(), Dest::pid()) -> ok | {error, message()}

Close the connection.

column_names(Stmt::statement(), Ref::reference(), Dest::pid()) -> {ok, tuple()} | {error, message()}

Retrieve the column names of the prepared statement

column_types(Stmt::statement(), Ref::reference(), Dest::pid()) -> {ok, tuple()} | {error, message()}

Retrieve the column types of the prepared statement

exec(Db::connection(), Ref::reference(), Dest::pid(), Sql::string()) -> ok | {error, message()}

Exec the query.

Sends an asynchronous exec command over the connection and returns ok immediately.

When the statement is executed Dest will receive message {Ref, answer()} with answer() integer | {error, reason()}

finalize(Stmt, Ref, Dest) -> any()

insert(Db::connection(), Ref::reference(), Dest::pid(), Sql::string()) -> {ok, integer()} | {error, message()}

Insert record

open(Db::connection(), Ref::reference(), Dest::pid(), Filename::string()) -> ok | {error, message()}

Open the specified sqlite3 database.

Sends an asynchronous open command over the connection and returns ok immediately. When the database is opened