PronounsPage/server/db.ts

import * as sqlite from 'sqlite';
import sqlite3 from 'sqlite3';

const __dirname = new URL('.', import.meta.url).pathname;

export type SQLQuery = sqlite.ISqlite.SqlType;
export interface Database {
    get<T = unknown>(sql: SQLQuery, ...args: unknown[]): Promise<T | undefined>;
    each<T = unknown>(sql: SQLQuery, callback: (err: unknown, row: T) => void): Promise<number>;
    all<T = unknown>(sql: SQLQuery, ...args: unknown[]): Promise<T[]>;
    close(): Promise<void>;
}

export default (): Promise<sqlite.Database> => sqlite.open({
    filename: `${__dirname}/../db.sqlite`,
    driver: sqlite3.Database,
});