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