1234import { Database } from "bun:sqlite";5import { beforeAll, describe, expect, test } from "bun:test";6import { mkdtemp, writeFile } from "node:fs/promises";7import { tmpdir } from "node:os";8import { join } from "node:path";9import { openKeprDb } from "../src/server/db.ts";10import { Browser, type Instance, instance } from "./browser.ts";11import { makeRepos, writeRelease } from "./fixture.ts";1213describe("the selected repo's workspace (§24)", () => {14 let inst: Instance;15 let browser: Browser;16 const workspace = async () => (await browser.get("/admin/repos?repo=app")).text();17 const save = (fields: Record<string, string>) =>18 browser.post("/admin/repos/app", { public: "1", ...fields });1920 beforeAll(async () => {21 const repos = await makeRepos(["app"]);22 const work = join(repos.bucketDir, "..", "work", "app");23 await writeFile(join(work, "main.ts"), "export const a = 1;\nexport const b = 2;\n");24 await writeFile(join(work, "tool.py"), "print(1)\n");25 repos.koh("app", "save", "add sources");26 repos.koh("app", "offer");27 const head = JSON.parse(repos.koh("app", "view", "--json")).head_id as string;28 for (const version of ["1.0.0", "1.1.0"]) {29 await writeRelease(repos.bucketDir, "app", {30 version,31 save: head,32 files: [{ platform: "linux-x86_64", name: "app", bytes: new Uint8Array([1]) }],33 });34 }35 inst = await instance(repos.bucketDir);36 inst.kepr.run(37 `INSERT INTO issues (repo, number, title, body, type, filed_at)38 VALUES ('app', 1, 'Broken', 'It broke', 'bug', 0)`,39 );40 browser = new Browser(inst.app);41 await browser.signIn();42 await save({});43 await inst.app.request("/app/releases/1.1.0/linux-x86_64");44 await inst.app.request("/app/releases/1.1.0/linux-x86_64");45 });4647 test("summarises saves, lines, the newest version, open issues and downloads", async () => {48 const page = await workspace();49 expect(page).toContain('class="admin-vitals"');50 expect(page).toMatch(/<strong>2<\/strong><span class="mono">saves<\/span>/);51 expect(page).toMatch(/<strong>3<\/strong><span class="mono">lines<\/span>/);52 expect(page).toMatch(/<strong>1\.1\.0<\/strong><span class="mono">newest version<\/span>/);53 expect(page).toMatch(/<strong>1<\/strong><span class="mono">open issues<\/span>/);54 expect(page).toMatch(/<strong>2<\/strong><span class="mono">downloads<\/span>/);55 });5657 test("lists the detected languages with their lines", async () => {58 const page = await workspace();59 expect(page).toContain('TypeScript <span class="muted">2 lines</span>');60 expect(page).toContain('Python <span class="muted">1 line</span>');61 });6263 test("edits the description and details; blank hands them back to the README", async () => {64 expect(await workspace()).toMatch(/<textarea[^>]*name="description"[^>]*><\/textarea>/);65 const saved = await save({ description: "Own *words*", details: "## Usage\r\nRun it." });66 expect(saved.status).toBe(303);67 const page = await workspace();68 expect(page).toContain("Own *words*</textarea>");69 expect(page).toContain("## Usage\nRun it.</textarea>");70 const repo = await (await inst.app.request("/app")).text();71 expect(repo).toContain("Own <em>words</em>");72 expect(repo).toContain("Run it.");73 const long = await save({ details: "x".repeat(60_001) });74 expect(long.status).toBe(400);75 expect(await long.text()).toContain("Keep the details under 60,000 characters.");76 await save({ description: "", details: "" });77 expect(inst.kepr.query("SELECT description, details FROM repo_text").get()).toEqual({78 description: "",79 details: "",80 });81 });8283 test("edits its builds in place, with visibility and downloads", async () => {84 inst.kepr.run(85 "INSERT INTO release_settings (repo, version, hidden) VALUES ('app', '1.0.0', 1)",86 );87 const page = await workspace();88 expect(page).toContain('action="/admin/releases/app/1.1.0"');89 expect(page).toContain("<span>shown</span><span>2 downloads</span>");90 expect(page).toContain("<span>hidden</span><span>0 downloads</span>");91 inst.kepr.run("DELETE FROM release_settings");92 });9394 test("shown languages replace the header's detected language; blank brings it back", async () => {95 const header = async () => (await inst.app.request("/app")).text();96 expect(await header()).toContain('<span class="lang-badge">TypeScript</span>');97 expect((await save({ languages: " Zig , TypeScript" })).status).toBe(303);98 const shown = await header();99 expect(shown).toContain('<span class="lang-badge">Zig</span>');100 expect(shown).toContain('<span class="lang-badge">TypeScript</span>');101 expect(await workspace()).toContain('value="Zig, TypeScript"');102 expect((await save({ languages: "" })).status).toBe(303);103 const detected = await header();104 expect(detected).not.toContain('<span class="lang-badge">Zig</span>');105 expect(detected).toContain('<span class="lang-badge">TypeScript</span>');106 });107108 test("refuses more than five languages, a long name or a control character", async () => {109 const refusals: [string, string][] = [110 ["a, b, c, d, e, f", "up to five languages."],111 ["x".repeat(31), "a language name is at most 30 characters."],112 ["Zig\u0007", "a language name is printable text."],113 ];114 for (const [languages, error] of refusals) {115 const response = await save({ languages });116 expect(response.status).toBe(400);117 expect(await response.text()).toContain(error);118 }119 expect(await workspace()).not.toContain('value="Zig');120 });121});122123test("an older kepr.db gains the shown-languages column when opened", async () => {124 const dir = await mkdtemp(join(tmpdir(), "kepr-old-db-"));125 const old = new Database(join(dir, "kepr.db"));126 old.run("CREATE TABLE repos (name TEXT PRIMARY KEY, public INTEGER NOT NULL DEFAULT 0)");127 old.run("INSERT INTO repos (name) VALUES ('app')");128 old.close();129 const db = openKeprDb(dir);130 expect(db.query<{ languages: string }, []>("SELECT languages FROM repos").get()?.languages).toBe(131 "",132 );133});134135test("an older kepr.db loses card order and install lines, keeping each repo", async () => {136 const dir = await mkdtemp(join(tmpdir(), "kepr-old-db-"));137 const old = new Database(join(dir, "kepr.db"));138 old.run(`CREATE TABLE repos (139 name TEXT PRIMARY KEY, public INTEGER NOT NULL DEFAULT 0, sort_order INTEGER NOT NULL DEFAULT 0,140 install1 TEXT NOT NULL DEFAULT '', install2 TEXT NOT NULL DEFAULT '',141 install3 TEXT NOT NULL DEFAULT '')`);142 old.run("INSERT INTO repos (name, public, install1) VALUES ('app', 1, 'nix profile add app')");143 old.close();144 const db = openKeprDb(dir);145 const columns = db.query<{ name: string }, []>("PRAGMA table_info(repos)").all();146 expect(columns.map((column) => column.name)).not.toContain("install1");147 expect(columns.map((column) => column.name)).not.toContain("sort_order");148 expect(db.query("SELECT name, public FROM repos").all()).toEqual([{ name: "app", public: 1 }]);149});