sqlite3-promisify
v1.0.3
Published
Promisify all node-sqlite3 functions
Downloads
20
Maintainers
Readme
sqlite3-promisify
Promisifying node-sqlite3 functions
Install
npm i sqlite3-promisify
Usage
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]' }
})();
API
connect(path)
Takes SQLite
DB path
as input and returns sqlite3 object.- Params
- path (string) - Database absolute path
- Params
serialize()
Serialize consecutive db calls.
get(query, values={Optional})
Executes select queries and returns only first result row.
- Params
- query (string) - SQL query
- values (array) - Values for the query
- Params
all(query, values={Optional})
Executes any query and returns all the result rows
- Params
- query (string) - SQL query
- values (array) - Values for the query
- Params
run(query, values={Optional})
Executes query which does not returns any results
- Params
- query (string) - SQL query
- values (array) - Values for the query
- Params
close()
Closes the db connection
Contributing
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
Contributors
Thank you to all the contributors who have helped us in making this project better :raised_hands: