bkjs-sqlite

0.3.0 • Public • Published

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

Readme

Keywords

none

Package Sidebar

Install

npm i bkjs-sqlite

Weekly Downloads

26

Version

0.3.0

License

BSD-3-Clause

Unpacked Size

9.16 MB

Total Files

7

Last publish

Collaborators

  • veryakov