Promisifying node-sqlite3 functions
npm i sqlite3-promisify
const SQLiteCrud = require('sqlite3-promisify');
const DB_PATH = __dirname + '/sqlite3.db';
const DB_NAME = 'sqlite3_test';
(async () => {
const Db = new SQLiteCrud(DB_PATH);
const rows = await Db.all(`SELECT * FROM ${DB_NAME};`);
console.log(rows);
////////// OUTPUT ////////////
// [
// { id: 1, name: 'Arshad', email: '[email protected]' },
// { id: 2, name: 'Sqlite3', email: '[email protected]' }
// ]
const row = await Db.get(`SELECT * FROM ${DB_NAME} WHERE id = ?;`, [1]);
console.log(row);
////////// OUTPUT ////////////
// { id: 1, name: 'Arshad', email: '[email protected]' }
})();
connect(path)
Takes SQLite DB path
as input and returns sqlite3 object.
serialize()
Serialize consecutive db calls.
get(query, values={Optional})
Executes select queries and returns only first result row.
all(query, values={Optional})
Executes any query and returns all the result rows
run(query, values={Optional})
Executes query which does not returns any results
close()
Closes the db connection
Interested in contributing to this project? You can log any issues or suggestion related to this library here
Read our contributing guide on getting started with contributing to the codebase