Press n or j to go to the next uncovered block, b, p or k for the previous block.
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 | 2x 10x 10x 10x 10x 3x 3x 3x 3x 2x | // Database query helper functions using callbacks (for compatibility with sqlite3)
const { db } = require("../database");
// Run a query and get a single result
function getOne(sql, params = []) {
return new Promise((resolve, reject) => {
db.get(sql, params, (err, row) => {
Iif (err) reject(err);
else resolve(row);
});
});
}
// Run a query and get all results
function getAll(sql, params = []) {
return new Promise((resolve, reject) => {
db.all(sql, params, (err, rows) => {
Iif (err) reject(err);
else resolve(rows || []);
});
});
}
// Run an insert/update/delete query
function run(sql, params = []) {
return new Promise((resolve, reject) => {
db.run(sql, params, function (err) {
if (err) reject(err);
else resolve({ lastID: this.lastID, changes: this.changes });
});
});
}
module.exports = {
getOne,
getAll,
run,
};
|