SPB Git

Repository Public

rebuild-derived.ts 2.2 KB 40 lines typescript

1import "./_env";2import { rm, copyFile, mkdir } from "node:fs/promises";3import path from "node:path";4import { randomUUID } from "node:crypto";5import { sql } from "../src/lib/db";6import { env } from "../src/lib/env";7import { keys, storage, THUMB_SIZES } from "../src/server/storage";8import { makeThumb } from "../src/server/media";910/**11 * After a restore: checks every stored file the database refers to.12 *  - missing thumbnails are rebuilt from the cover original;13 *  - missing renditions are queued again for the worker;14 *  - missing ORIGINALS are reported (exit code 1): they can only come back from a backup.15 */16async function main() {17  const st = storage();18  let missingOriginals = 0, thumbs = 0, renditions = 0;19  for (const a of await sql<{ storage_key: string; track_id: string; kind: string }[]>`SELECT storage_key, track_id, kind FROM media_assets WHERE kind IN ('original', 'rendition')`) {20    if ((await st.size(a.storage_key)) !== null) continue;21    if (a.kind === "original") { missingOriginals++; console.error(`MISSING ORIGINAL ${a.storage_key} (track ${a.track_id})`); }22    else { await sql`DELETE FROM media_assets WHERE storage_key = ${a.storage_key}`; await sql`UPDATE tracks SET compat_state = 'queued' WHERE id = ${a.track_id}`; renditions++; }23  }24  const work = path.join(env.tmpDir, "work"); await mkdir(work, { recursive: true });25  for (const w of await sql<{ sha256: string; mime: string }[]>`SELECT sha256, mime FROM artworks`) {26    const orig = keys.artOriginal(w.sha256, w.mime === "image/jpeg" ? "jpg" : w.mime.slice(6));27    if ((await st.size(orig)) === null) { console.error(`MISSING COVER ${orig}`); continue; }28    for (const s of THUMB_SIZES) {29      if ((await st.size(keys.artThumb(w.sha256, s))) !== null) continue;30      const src = path.join(work, randomUUID()), tmp = `${src}.jpg`;31      await copyFile(await st.localPath(orig), src);32      await makeThumb(src, tmp, s); await st.putFile(keys.artThumb(w.sha256, s), tmp); await rm(src, { force: true }); thumbs++;33    }34  }35  console.log(`thumbnails rebuilt: ${thumbs}, renditions queued: ${renditions}, missing originals: ${missingOriginals}`);36  await sql.end();37  if (missingOriginals) process.exit(1);38}39main().catch((e) => { console.error(e.message); process.exit(1); });40
Files main
Menu

Theme