Repository Public
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