Library to use SQLite in Fuse.
Status: beta
Currently supports iOS, Android and CIL (Fuse Preview)
Issues, feature request and pull request are welcomed.
Using fusepm
$ fusepm install https://github.com/bolav/fuse-sqlite
<SQLite ux:Global="SQLite" />
var sqlite = require('SQLite');
var db = sqlite.open("file.sqlite");
db.execute("create table if not exists ids (id integer primary key)");
db.execute("insert into ids values (?)",2);
var r = db.query("select * from ids");
debug_log(JSON.stringify(r));
It returns an array:
[
{"field1":"value1","field2":"value2"},
{"field1":"value1","field2":"value2"}
]
var sqlite = require('SQLite');
Opens a file that contains a SQLite database
var db = sqlite.open(filename);
Opens a file that contains a SQLite database, possibly from the bundle
var db = sqlite.openFromBundle(filename);
And in the unoproj:
"Includes": [
"*.uno",
"*.uxl",
"*.ux",
"bundle.sqlite:Bundle"
]
Executes a query. Does not return anything.
db.execute(sql_statement);
db.execute(sql_statement, var1, var2, var3);
Executes a query. Returns an array of hashes with the result.
var result = db.query(sql_statement);
var result = db.query(sql_statement, var1, var2, var3);
Prepares a query. Returns a prepared statement.
var statement = db.prepare(sql_statement);
statement.execute(var1,var2,var3);
Closes the database.
db.close();
- Cursor support
- Async support
- Bundled pre-made databases
- Error messages is a bit different between the targets
- Support for JavaScript and CMake Fuse targets is not planned.
- The sqlite3.dll is downloaded from http://www.sqlite.org/download.html
- Mono.Data.Sqlite.dll is included from Mono.
-
Failed to load assembly . . . have caused the assembly to be sandboxed . . .You need to Unblock dll's that you downloaded.