poof/app/db.js

1import sqlite from "better-sqlite3"; 2import path from "path"; 3 4const db = new sqlite(path.resolve("poof.db"), { fileMustExist: true }); 5 6const query = (sql, params) => { 7 return db.prepare(sql).all(params); 8}; 9 10const get = (sql, params) => { 11 return db.prepare(sql).get(params); 12}; 13 14const run = (sql, params) => { 15 return db.prepare(sql).run(params); 16}; 17 18export default { 19 query, 20 get, 21 run, 22};