index.js

import sqlite3 from "sqlite3";

const db = new sqlite3.Database("data.db");
const adb = (func, query, params) => new Promise((resolve, reject) => {
    db[func](query, params ?? [], (err, res) => {
        if(err) reject(err);
        else resolve(res);
    });
});
adb.get = (query, params) => adb("get", query, params);
adb.all = (query, params) => adb("all", query, params);
adb.run = (query, params) => adb("run", query, params);

export const dateToDateNumber = date => Math.floor(date.getTime() / 1000 / 60 / 60 / 24);

/**
 * @typedef {object} Pobeda
 * @property {number} id Pobeda ID
 * @property {string} handle Pobeda handle
 * @property {string} name Pobeda name
 * @property {number} start_date Pobeda start date
 */
export const init = async () => {
    await adb.run(`CREATE TABLE IF NOT EXISTS pobedas (
        id INTEGER PRIMARY KEY,
        handle TEXT NOT NULL,
        name TEXT NOT NULL,
        start_date INTEGER NOT NULL,
        gif_url TEXT NOT NULL,
        reason1 TEXT NOT NULL,
        reason2 TEXT NOT NULL,
        reason3 TEXT NOT NULL
    )`);
};

export const pushPobeda = async (handle, name, startDate, gifURL, reason1, reason2, reason3) => {
    await adb.run(`INSERT INTO pobedas (handle, name, start_date, gif_url, reason1, reason2, reason3) VALUES (?, ?, ?, ?, ?, ?, ?)`,
        [handle, name, dateToDateNumber(startDate), gifURL, reason1, reason2, reason3]);
}

export const getPobeda = async handle => {
    return await adb.get(`SELECT * FROM pobedas WHERE handle = ?`, [handle]);
}

export const getPobedasCount = async () => {
    return (await adb.get(`SELECT COUNT(*) FROM pobedas`, []))?.["COUNT(*)"];
}