Sqlite module for node and backendjs
Usage
var sqlite = require("bkjs-sqlite");
var db = new sqlite.Database("test.db", sqlite.SQLITE_OPEN_CREATE, function(err) {
if (err) console.log(err);
this.runSync("PRAGMA cache_size=5000");
this.runSync("CREATE TABLE test(a int, b text)")
this.query("SELECT name FROM sqlite_master WHERE type=?", ["table"], function(err, tables) {
console.log(err, tables);
});
});
Database class
-
new Database(filename, options, callback)
- create new database object, the callback will be called with an Error if occured. - Properties:
-
open
- return 1 if the db is open -
affected_rows
- returns number of rows affected by the last operation -
inserted_oid
- last auto generated ID
-
- Methods:
-
exec(sql[, callback])
- execute the SQL statememt in a worker thread -
run(sql, [values], [callback])
- execute a DDL statement in a worker thread, supports parameters in the statement -
runSync(sql, [values])
- execute a DDL statement synchronously -
query(sql, [values], [callback])
- execute any SQL statement in a worker thread, if a callback is given it will be passed an array with result if exists, otherwise empty array -
querySync(sql, [values])
- execute a SQL statement synchronously, returns array with result -
close([callback])
- close the database in a worker thread -
closeSync()
- close the database in the main thread -
copy(db2)
- copy currently open database into another, db2 can be an open db object or a file name
-
Statement class
-
new Statement(db, sql, callback)
- create new SQL statement object for a database and SQL statement, a callback will be called with an error if occured, otherwise prepared statement is ready for execution - Methods:
-
prepare(sql, [callback])
- prepare another SQL statement in the existing statement object -
run([callback])
- execute prepared DDL statement in a worker thread -
runSync()
- execute prepared DDL statememnt in the main thread -
query([values], [callback])
- execute prepared statement with values for the parameters, if callback is given it will be passed the results -
querySync([values])
- execute prepared statement with values for the parameters in the main thread -
finalize()
- close and free the statement, it cannot be used anymore and will be deleted eventually
-
Author
Vlad Seryakov