Constructor
# new SQLite(fname)
SQLite database.
Note: SQLite module must be loaded by calling LoadLibrary("sqlite") before using!
Parameters:
Name | Type | Description |
---|---|---|
fname |
string | name of the database file. It will be created if it dows not exist. |
Methods
# Exec() → {Array.<Object>}
Execute a SQL query on the database. See SQLite documentation for query language details.
returns a list of objects for SQL queries. Each object has the column names as keys and the column contents as values.
Array.<Object>
Example
var sql = new SQLite("test.db");
//////
// create test table
exec(sql, "CREATE TABLE test (id INTEGER PRIMARY KEY, name TEXT);");
// insert two lines
exec(sql, "INSERT INTO test (id, name) VALUES (42, 'zweiundvierzig');");
exec(sql, "INSERT INTO test (id, name) VALUES (23, 'dreiundzwanzig');");
// try duplicate check
exec(sql, "INSERT INTO test (id, name) VALUES (23, 'dreiundzwanzig');");
// Error: SQL error: UNIQUE constraint failed: test.id
// at SQLite.prototype.Exec (native)
// select some data
var res1 = exec(sql, "SELECT * from test;"); // [{"id":"23","name":"dreiundzwanzig"},{"id":"42","name":"zweiundvierzig"}]
var res2 = exec(sql, "SELECT * from test WHERE id=23;"); // [{"id":"23","name":"dreiundzwanzig"}]