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: '[e-mail]' },
  //   { id: 2, name: 'Sqlite3', email: '[e-mail]' }
  // ]


  const row = await Db.get(`SELECT * FROM ${DB_NAME} WHERE id = ?;`, [1]);
  console.log(row);

  ////////// OUTPUT ////////////
  // { id: 1, name: 'Arshad', email: '[e-mail]' }
  
})();

API

• connect(path)

  Takes SQLite DB path as input and returns sqlite3 object.

  • Params
    • path (string) - Database absolute path

• 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

• all(query, values={Optional})

  Executes any query and returns all the result rows

  • Params
    • query (string) - SQL query
    • values (array) - Values for the query

• run(query, values={Optional})

  Executes query which does not returns any results

  • Params
    • query (string) - SQL query
    • values (array) - Values for the query

• 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 🙌