benjivers/val Public Public: anyone can read this; the crew can change it.

/**

 * What survives a restart: finished matches. The live match lives in memory

 * — it is gone the moment the process is — but its result is written here,

 * under FORGE_APP_DATA, so the page can say what happened before you arrived.

 */

import { Database } from "bun:sqlite";

import { mkdirSync } from "node:fs";

import { join } from "node:path";

const dataDir = process.env.FORGE_APP_DATA ?? "./data";

mkdirSync(dataDir, { recursive: true });

export const db = new Database(join(dataDir, "app.db"));

db.exec("PRAGMA journal_mode = WAL");

db.exec(

  `CREATE TABLE IF NOT EXISTS result (

     id INTEGER PRIMARY KEY,

     summary TEXT NOT NULL,

     red INTEGER NOT NULL,

     blue INTEGER NOT NULL,

     rounds INTEGER NOT NULL,

     ended_at TEXT NOT NULL DEFAULT (datetime('now'))

   )`,

);

export type Result = { summary: string; red: number; blue: number; rounds: number; ended_at: string };

export const recordResult = (summary: string, red: number, blue: number, rounds: number): void => {

  db.query("INSERT INTO result (summary, red, blue, rounds) VALUES (?1, ?2, ?3, ?4)").run(

    summary.slice(0, 120),

    red,

    blue,

    rounds,

  );

};

export const recentResults = (limit = 5): Result[] =>

  db

    .query<Result, [number]>(

      "SELECT summary, red, blue, rounds, ended_at FROM result ORDER BY id DESC LIMIT ?1",

    )

    .all(Math.max(1, Math.min(50, limit)));