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 let bucketDir: string;17 const workspace = async () => (await browser.get("/admin/repos?repo=app")).text();18 const save = (fields: Record<string, string>) =>19 browser.post("/admin/repos/app", { public: "1", ...fields });2021 beforeAll(async () => {22 const repos = await makeRepos(["app"]);23 const work = join(repos.bucketDir, "..", "work", "app");24 await writeFile(join(work, "main.ts"), "export const a = 1;\nexport const b = 2;\n");25 await writeFile(join(work, "tool.py"), "print(1)\n");26 repos.koh("app", "save", "add sources");27 repos.koh("app", "offer");28 const head = JSON.parse(repos.koh("app", "view", "--json")).head_id as string;29 for (const version of ["1.0.0", "1.1.0"]) {30 await writeRelease(repos.bucketDir, "app", {31 version,32 save: head,33 files: [{ platform: "linux-x86_64", name: "app", bytes: new Uint8Array([1]) }],34 });35 }36 bucketDir = repos.bucketDir;37 inst = await instance(repos.bucketDir);38 inst.kepr.run(39 `INSERT INTO issues (repo, number, title, body, type, filed_at)40 VALUES ('app', 1, 'Broken', 'It broke', 'bug', 0)`,41 );42 browser = new Browser(inst.app);43 await browser.signIn();44 await save({});45 await inst.app.request("/app/releases/1.1.0/linux-x86_64");46 await inst.app.request("/app/releases/1.1.0/linux-x86_64");47 });4849 test("summarises saves, lines, the newest version, open issues and downloads", async () => {50 const page = await workspace();51 expect(page).toContain('class="admin-vitals"');52 expect(page).toMatch(/<strong>2<\/strong><span class="mono">saves<\/span>/);53 expect(page).toMatch(/<strong>3<\/strong><span class="mono">lines<\/span>/);54 expect(page).toMatch(/<strong>1\.1\.0<\/strong><span class="mono">newest version<\/span>/);55 expect(page).toMatch(/<strong>1<\/strong><span class="mono">open issues<\/span>/);56 expect(page).toMatch(/<strong>2<\/strong><span class="mono">downloads<\/span>/);57 });5859 test("lists the detected languages with their lines", async () => {60 const page = await workspace();61 expect(page).toContain('TypeScript <span class="muted">2 lines</span>');62 expect(page).toContain('Python <span class="muted">1 line</span>');63 });6465 test("edits the description and details; blank hands them back to the README", async () => {66 expect(await workspace()).toMatch(/<textarea[^>]*name="description"[^>]*><\/textarea>/);67 const saved = await save({ description: "Own *words*", details: "## Usage\r\nRun it." });68 expect(saved.status).toBe(303);69 const page = await workspace();70 expect(page).toContain("Own *words*</textarea>");71 expect(page).toContain("## Usage\nRun it.</textarea>");72 const repo = await (await inst.app.request("/app")).text();73 expect(repo).toContain("Own <em>words</em>");74 expect(repo).toContain("Run it.");75 const long = await save({ details: "x".repeat(60_001) });76 expect(long.status).toBe(400);77 expect(await long.text()).toContain("Keep the details under 60,000 characters.");78 await save({ description: "", details: "" });79 expect(inst.kepr.query("SELECT description, details FROM repo_text").get()).toEqual({80 description: "",81 details: "",82 });83 });8485 test("edits its builds in place, with visibility and downloads", async () => {86 inst.kepr.run(87 "INSERT INTO release_settings (repo, version, hidden) VALUES ('app', '1.0.0', 1)",88 );89 const page = await workspace();90 expect(page).toContain('action="/admin/releases/app/1.1.0"');91 expect(page).toContain("<span>shown</span><span>2 downloads</span>");92 expect(page).toContain("<span>hidden</span><span>0 downloads</span>");93 inst.kepr.run("DELETE FROM release_settings");94 });9596 test("shown languages replace the header's detected language; blank brings it back", async () => {97 const header = async () => (await inst.app.request("/app")).text();98 expect(await header()).toContain('<span class="lang-badge">TypeScript</span>');99 expect((await save({ languages: " Zig , TypeScript" })).status).toBe(303);100 const shown = await header();101 expect(shown).toContain('<span class="lang-badge">Zig</span>');102 expect(shown).toContain('<span class="lang-badge">TypeScript</span>');103 expect(await workspace()).toContain('value="Zig, TypeScript"');104 expect((await save({ languages: "" })).status).toBe(303);105 const detected = await header();106 expect(detected).not.toContain('<span class="lang-badge">Zig</span>');107 expect(detected).toContain('<span class="lang-badge">TypeScript</span>');108 });109110 test("refuses more than five languages, a long name or a control character", async () => {111 const refusals: [string, string][] = [112 ["a, b, c, d, e, f", "up to five languages."],113 ["x".repeat(31), "a language name is at most 30 characters."],114 ["Zig\u0007", "a language name is printable text."],115 ];116 for (const [languages, error] of refusals) {117 const response = await save({ languages });118 expect(response.status).toBe(400);119 expect(await response.text()).toContain(error);120 }121 expect(await workspace()).not.toContain('value="Zig');122 });123124 test("deletes the repo's kept tarballs from the bucket", async () => {125 await save({});126 const head = (await inst.app.request("/app/archive/HEAD.tar.gz")).headers.get("location");127 expect((await inst.app.request(head ?? "")).status).toBe(200);128 const kept = new Bun.Glob("**/*.tar.gz");129 const keptIn = () => Array.fromAsync(kept.scan(join(bucketDir, ".kepr", "tarballs", "app")));130 expect(await keptIn()).toHaveLength(1);131 expect(await workspace()).toContain('action="/admin/repos/app/tarballs/delete"');132 const deleted = await browser.post("/admin/repos/app/tarballs/delete", {});133 expect(deleted.headers.get("location")).toBe("/admin/repos?repo=app&saved=1#repo-editor");134 expect(await keptIn()).toEqual([]);135 expect((await inst.app.request(head ?? "")).status).toBe(200);136 });137});138139test("an older kepr.db gains the shown-languages column when opened", async () => {140 const dir = await mkdtemp(join(tmpdir(), "kepr-old-db-"));141 const old = new Database(join(dir, "kepr.db"));142 old.run("CREATE TABLE repos (name TEXT PRIMARY KEY, public INTEGER NOT NULL DEFAULT 0)");143 old.run("INSERT INTO repos (name) VALUES ('app')");144 old.close();145 const db = openKeprDb(dir);146 expect(db.query<{ languages: string }, []>("SELECT languages FROM repos").get()?.languages).toBe(147 "",148 );149});150151test("an older kepr.db loses card order and install lines, keeping each repo", async () => {152 const dir = await mkdtemp(join(tmpdir(), "kepr-old-db-"));153 const old = new Database(join(dir, "kepr.db"));154 old.run(`CREATE TABLE repos (155 name TEXT PRIMARY KEY, public INTEGER NOT NULL DEFAULT 0, sort_order INTEGER NOT NULL DEFAULT 0,156 install1 TEXT NOT NULL DEFAULT '', install2 TEXT NOT NULL DEFAULT '',157 install3 TEXT NOT NULL DEFAULT '')`);158 old.run("INSERT INTO repos (name, public, install1) VALUES ('app', 1, 'nix profile add app')");159 old.close();160 const db = openKeprDb(dir);161 const columns = db.query<{ name: string }, []>("PRAGMA table_info(repos)").all();162 expect(columns.map((column) => column.name)).not.toContain("install1");163 expect(columns.map((column) => column.name)).not.toContain("sort_order");164 expect(db.query("SELECT name, public FROM repos").all()).toEqual([{ name: "app", public: 1 }]);165});