count downloads per repo and day, shown at /admin/downloads with totals and top files (v3.0.161)

@@ -0,0 +1,59 @@1+import type { Hono } from "hono";2+import { html } from "../pages/html.ts";3+import { plural } from "../pages/layout.ts";4+import { downloadsByDay, repoDownloads, topFiles, utcDay } from "../releases/releases.ts";5+import { type AdminContext, adminPage } from "./console.ts";6+import { allRepos } from "./store.ts";7+8+const DAYS_SHOWN = 30;9+const TOP_FILES = 10;10+const DAY_MS = 24 * 60 * 60 * 1000;11+12+/** §24's Downloads section: the last 30 days, each repo's totals and the top files. */13+export function registerDownloads(app: Hono, ctx: AdminContext): void {14+	app.get("/admin/downloads", (c) => {15+		// An unknown repo narrows nothing, as the issues list treats one.16+		const repos = allRepos(ctx.kepr).map((repo) => repo.name);17+		const repo = repos.find((name) => name === c.req.query("repo")) ?? "";18+		const now = Date.now();19+		const days = Array.from({ length: DAYS_SHOWN }, (_, i) =>20+			utcDay(now - (DAYS_SHOWN - 1 - i) * DAY_MS),21+		);22+		const since = days[0] as string;23+		const counts = downloadsByDay(ctx.kepr, since, repo);24+		const peak = Math.max(1, ...counts.values());25+		const option = (name: string) =>26+			html`<option value="${name}"${name === repo ? html` selected` : ""}>${name}</option>`;27+		const body = html`<form class="issues-filter" method="get" action="/admin/downloads">28+<select class="issues-input" name="repo" aria-label="repository">29+<option value="">all repos</option>30+${repos.map(option)}31+</select>32+<button class="issues-submit" type="submit">show</button>33+</form>34+<section class="repo-section"><h2 class="section-label mono">last ${String(DAYS_SHOWN)} days</h2>35+<ol class="admin-days mono">36+${days.map((day) => {37+	const n = counts.get(day) ?? 0;38+	return html`<li><span>${day}</span>39+<meter min="0" max="${String(peak)}" value="${String(n)}" aria-label="${plural(n, "download")} on ${day}"></meter>40+<span>${String(n)}</span></li>`;41+})}42+</ol></section>43+<section class="repo-section"><h2 class="section-label mono">repositories</h2>44+${repoDownloads(ctx.kepr, since).map(45+	(row) => html`<p class="issue-row"><a href="/admin/downloads?repo=${row.repo}">${row.repo}</a>46+<span class="issue-meta mono">${plural(row.total, "download")} · ${String(row.recent)} in ${String(DAYS_SHOWN)} days</span></p>`,47+)}48+</section>49+<section class="repo-section"><h2 class="section-label mono">most downloaded files</h2>50+${topFiles(ctx.kepr, TOP_FILES).map(51+	(52+		row,53+	) => html`<p class="issue-row"><span class="mono">${row.repo} ${row.version} ${row.platform}</span>54+<span class="issue-meta mono">${plural(row.count, "download")}</span></p>`,55+)}56+</section>`;57+		return c.html(adminPage(c, ctx, "downloads", body));58+	});59+}

@@ -0,0 +1,74 @@1+// Covers §24's Downloads section: counts per UTC day, the last 30 days per repo or across all,2+// each repo's totals, the most downloaded files, and dropping days older than 400.3+4+import { afterAll, beforeAll, describe, expect, setSystemTime, test } from "bun:test";5+import { Browser, type Instance, instance } from "./browser.ts";6+import { makeRepos, writeRelease } from "./fixture.ts";7+8+describe("download analytics (§24)", () => {9+	let inst: Instance;10+	let operator: Browser;11+	const at = (iso: string) => setSystemTime(new Date(iso));12+	const download = (repo: string, platform: string) =>13+		inst.app.request(`/${repo}/releases/1.0.0/${platform}`);14+	const page = async (query = "") => (await operator.get(`/admin/downloads${query}`)).text();15+16+	beforeAll(async () => {17+		at("2026-09-30T12:00:00Z");18+		const repos = await makeRepos(["app", "tools"]);19+		for (const repo of ["app", "tools"]) {20+			await writeRelease(repos.bucketDir, repo, {21+				version: "1.0.0",22+				save: repos.saves[repo] as string,23+				files: [24+					{ platform: "linux-x86_64", name: repo, bytes: new Uint8Array([1]) },25+					{ platform: "macos-aarch64", name: repo, bytes: new Uint8Array([2]) },26+				],27+			});28+		}29+		inst = await instance(repos.bucketDir);30+		operator = new Browser(inst.app);31+		await operator.signIn();32+		for (const repo of ["app", "tools"])33+			await operator.post(`/admin/repos/${repo}`, { public: "1" });34+		at("2025-08-01T12:00:00Z");35+		await download("app", "linux-x86_64");36+		at("2026-09-28T23:59:00Z");37+		await download("app", "linux-x86_64");38+		await download("app", "macos-aarch64");39+		at("2026-09-30T00:01:00Z");40+		await download("app", "linux-x86_64");41+		await download("tools", "linux-x86_64");42+	});43+	afterAll(() => setSystemTime());44+45+	test("each download counts toward its repo's UTC day, and days past 400 are dropped", () => {46+		const days = inst.kepr47+			.query("SELECT repo, day, count FROM download_days ORDER BY day, repo")48+			.all();49+		expect(days).toEqual([50+			{ repo: "app", day: "2026-09-28", count: 2 },51+			{ repo: "app", day: "2026-09-30", count: 1 },52+			{ repo: "tools", day: "2026-09-30", count: 1 },53+		]);54+	});55+56+	test("the section shows 30 days, each repo's totals and the top files", async () => {57+		const html = await page();58+		expect(html).toContain('<meter min="0" max="2" value="2"');59+		expect(html).toContain("2026-09-28");60+		expect(html).not.toContain("2026-08-31");61+		expect(html).toContain("2026-09-01");62+		expect(html).toMatch(/app<\/a>\s*<span[^>]*>4 downloads · 3 in 30 days<\/span>/);63+		expect(html.indexOf("app 1.0.0 linux-x86_64")).toBeLessThan(64+			html.indexOf("tools 1.0.0 linux-x86_64"),65+		);66+	});67+68+	test("one repo narrows the days, and an unknown one narrows nothing", async () => {69+		const tools = await page("?repo=tools");70+		expect(tools).toContain('<meter min="0" max="1" value="1"');71+		expect(tools).not.toContain('value="2"');72+		expect(await page("?repo=nowhere")).toContain('<meter min="0" max="2" value="2"');73+	});74+});