Notes on Node SQLite

//....
import db from './config/db'

//....

//....
/**
 * Read all records and all their columns from some given table.
 */
const read = async ({ table }) => {
	const stmt = `SELECT * FROM ${table}`
	let res = {}
	// all 
  db.all(stmt, (error, data) => {
    logger.info('---all');
    console.log(`${JSON.stringify(data)} `);
  });
  return res;
};

const read = async ({ table }) => {
	const stmt = `SELECT * FROM ${table}`
	// all 
	let res = {}
  db.each(stmt, (error, row) => {
	  logger.info('--each');
	// This will be printed everytime a row is returned
		console.log(`${JSON.stringify(row)} `);
	});
  return res;
};

//....
import db from './config/db'
import { promisify } from "util";
//....

// Use the promise pattern for SQLite so we don't end up in callback hell.
const query = promisify(db.all).bind(db);

//....
/**
 * Read all records and all their columns from some given table.
 */
const read = async ({ table }) => {
	const stmt = `SELECT * FROM ${table}`
  const res = await query(stmt);
  return res;
};

//....