Class SQLite3

SQLite3 Database handle.

Example:

const SQLite3 = require('sqlite3').SQLite3;
var db = new SQLite3('./my_db.sqlite');
var c = db.cursor('SELECT * FROM table_1 WHERE id IN (?,?)');
c.bind([4,6]);

for (let row in c) {
 print(row.toSource());
}

SQLite3 version as human readable string

SQLite3 version as an integer. For example, SQLite v3.6.12 would have a version of 3006012

Close the database handle. Force the database handle to be closed now, instead of when the object gets garbage collected.

Returns the row id of the last inserted column

Executes a given SQL statement and optionally, bind parameters can be passed to fill the placeholders in the SQL statement

Note:

If the execution throws an exception and the execution is aborted it will not automatically rollback the applied changes. If this is wanted the user of this function has to explicitly take care about it by using SQLite3#begin,SQLite3#commit and SQLite3#rollback

Example usage:

 
db.exec('CREATE TABLE foobar (a,b,c)');

db.exec('INSERT INTO foobar VALUES(?,?,?)',[1,2,3]);

db.exec('INSERT INTO foobar VALUES(:first, :second, :third)',
        { first: 4, second: 5, third: 6 });

Executes given SQL statement(s). Bind parameters can be passed to fill placeholders used in the corresponding SQL statement.

The parameter is expected to be an array of objects with sql and optional bind properties. The bind property should contain a value, an array or an object. The object can be used for named placeholders

Note:

If the execution throws an exception and the execution is aborted it will not automatically rollback the applied changes. If this is wanted the user of this function has to explicitly take care about it by using SQLite3#begin,SQLite3#commit and SQLite3#rollback

Example:

 
db.exec([{ 
       sql: 'CREATE TABLE foobar (a,b,c)'
   }, {
       sql: 'INSERT INTO foobar VALUES(?,?,?)',
       bind: [1,2,3]
   }, {
       sql: 'INSERT INTO foobar VALUES(:first, :second, :third)',
       bind: { first: 4, second: 5, third: 6 }
   }])

Begin a transaction

Commit a transaction

Rollback a transaction

Get a cursor to execute the given SQL statement. Bind parameters can be passed in as parameters the SQL, or by using SQLite3.Cursor#bind.