class SQLite

Provides access to the SQLite database system.

A companion object, SQLResult, is required for most database operations.

SQLite is not yet supported in the v8 engine.

Constructors

new SQLite();

Constructs a new instance of the SQLite class

All future calls to the database will be through this instance of the object.

Methods

begintransaction

Start an SQL transaction on the database

This allows you to batch database updates and to roll back sets of changes if they do not all complete. When you are done with batch updates, a call to SQLite.endtransaction() should be executed.

begintransaction(): void;

close

Close a previously opened SQLite database

close(): void;

endtransaction

Complete a transaction and flush all database writes to the file

endtransaction(): void;

exec

Perform an SQL command on the database

This command must be in standard SQL language syntax, limited to the operations that SQLite supports.

exec(command: string, result: SQLResult): number;

Example

var res = new SQLResult;
var rtn = sqlite.exec(“CREATE TABLE Persons (PersonID INTEGER, LastName TEXT, FirstName TEXT);”, res);

open

Open an SQLite-format file for database operations

open(filename: string, on_disk?: number, must_exist?: number): number;