A local-first personal finance app
import Database from 'better-sqlite3';
export class WrappedDatabase {
constructor(db) {
this.db = db;
}
/**
* @param {string} sql
* @param {(string | number)[]} params
*/
all(sql, params = []) {
const stmt = this.db.prepare(sql);
return stmt.all(...params);
}
/**
* @param {string} sql
* @param {string[]} params
*/
first(sql, params = []) {
const rows = this.all(sql, params);
return rows.length === 0 ? null : rows[0];
}
/**
* @param {string} sql
*/
exec(sql) {
return this.db.exec(sql);
}
/**
* @param {string} sql
* @param {(string | number | null | undefined)[]} params
*/
mutate(sql, params = []) {
const stmt = this.db.prepare(sql);
const info = stmt.run(...params);
return { changes: info.changes, insertId: info.lastInsertRowid };
}
/**
* @param {() => void} fn
*/
transaction(fn) {
return this.db.transaction(fn)();
}
close() {
this.db.close();
}
}
/** @param {string} filename */
export function openDatabase(filename) {
return new WrappedDatabase(new Database(filename));
}