[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_219":220,"_221":222},"routes/_app.x.$handle.$name",{"_105":104,"_37":50,"_114":95,"_32":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_26":-5,"_126":-5,"_127":-5,"_128":30,"_129":130,"_131":64,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_37":50,"_43":51,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":30},"version",6,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","0cfea24b-41e9-458b-b518-a0c84cabba61","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":30},"previous","deleted",false,"deletedHere","path","lib/notify.ts","latestPath","fileId","bd80f7da-9e35-11f1-b93f-1607ee4eb77e","name","notify.ts","fileType","script","content","// lib/notify.ts — Notifiche a più canali via webhook (Slack / Discord / Telegram\n// / webhook HTTP generico). Ogni canale è attivato dalla presenza della sua env var.\n\ninterface NotifyPayload {\n title: string;\n body: string;\n links: Record;\n}\n\nfunction buildText(p: NotifyPayload, prefix = \"\"): string {\n return [\n `${prefix}*${p.title}*`,\n p.body,\n ...Object.entries(p.links).map(([k, v]) => `${k}: ${v}`),\n ].join(\"\\n\");\n}\n\nasync function post(url: string, headers: Record, body: unknown) {\n try {\n await fetch(url, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\", ...headers },\n body: JSON.stringify(body),\n });\n } catch (e) {\n console.error(\"[notify]\", e);\n }\n}\n\nexport async function notify(p: NotifyPayload): Promise {\n const jobs: Promise[] = [];\n\n const slack = Deno.env.get(\"SLACK_WEBHOOK_URL\");\n if (slack) {\n jobs.push(\n post(slack, {}, { text: buildText(p) }),\n );\n }\n\n const discord = Deno.env.get(\"DISCORD_WEBHOOK_URL\");\n if (discord) {\n jobs.push(\n post(discord, {}, { content: buildText(p) }),\n );\n }\n\n const tBot = Deno.env.get(\"TELEGRAM_BOT_TOKEN\");\n const tChat = Deno.env.get(\"TELEGRAM_CHAT_ID\");\n if (tBot && tChat) {\n jobs.push(\n post(\n `https://api.telegram.org/bot${tBot}/sendMessage`,\n {},\n { chat_id: tChat, text: buildText(p), parse_mode: \"Markdown\" },\n ),\n );\n }\n\n const generic = Deno.env.get(\"GENERIC_WEBHOOK_URL\");\n if (generic) {\n jobs.push(post(generic, {}, { title: p.title, body: p.body, links: p.links }));\n }\n\n await Promise.allSettled(jobs);\n}\n","createdAt",["D",1787408907489],"branchVersion","branchId","d0e0f9e5-8ba8-4507-85a6-48258752e110","id","d565aca1-3a7a-4d20-8c25-06afae036bb2","ai-video-editor",["D",1787408834126],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Pipeline serverless di editing video automatizzato con AI","imageUrl","86c0904a-df90-4b28-8be9-0d0cd34688de","pinnedFileId","91ce646a-9e35-11f1-8e1d-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a02515-3428-7129-a58d-ee30dee1111b","tursoName","d565aca13a7a4d208c2506afae036bb2","tursoHostname","d565aca13a7a4d208c2506afae036bb2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789494036282],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_19":60,"_110":111,"_112":30},"branch",{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",10,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","boh","handle","displayName","BCG Collaborazioni","avatar","https://lh3.googleusercontent.com/a/ACg8ocK88V05YV8HsO4yAaG3hTsa_rYvYnQ7JithXHAoBkrpvT9HmN8=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_37":50,"_43":214,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":215,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":216,"_89":217,"_91":218,"_93":30},"tree",[165,171],"files",[165,166,167,168,169,170,171],"counts",{"_155":68,"_156":141,"_157":68,"_158":159,"_160":161},"contents",[136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":148,"_37":149,"_35":150,"_140":-5,"_46":47,"_45":151,"_142":64,"_43":152,"_13":68,"_39":153,"_41":-5,"_29":30,"_146":-5,"_32":154},{"_48":138,"_37":139,"_35":62,"_140":-5,"_46":47,"_45":141,"_142":30,"_43":143,"_13":68,"_39":144,"_41":145,"_29":30,"_146":50,"_32":147},"db4bf8c4-31eb-41bd-a03c-ad8b9cf7557f","main.ts","parentId",1,"latest",["D",1787408834177],"http","export default async function (req: Request): Promise {\n return Response.json({ ok: true, service: \"ai-video-editor\" });\n}\n","label",[139],"bc884ed6-cf89-4e01-b5a7-5c518d0390d5","lib","c5257465-2ce4-4476-b73e-c2fd2f8430cf",2,["D",1787408907290],"directory",[149],"pulls","branches","forks","envVars",{"_162":68,"_164":68},"connections",{"_162":68,"_163":68},"count","unfilledCount","emptyCount",{"_48":148,"_37":149,"_35":150,"_140":-5,"_46":47,"_45":151,"_142":64,"_43":211,"_13":68,"_39":153,"_41":-5,"_29":30,"_146":-5,"_173":212,"_32":213},{"_48":204,"_37":205,"_35":206,"_140":150,"_46":47,"_45":151,"_142":64,"_43":207,"_13":68,"_39":40,"_41":208,"_29":30,"_146":-5,"_173":209,"_32":210},{"_48":196,"_37":197,"_35":198,"_140":150,"_46":47,"_45":199,"_142":64,"_43":200,"_13":68,"_39":40,"_41":201,"_29":30,"_146":-5,"_173":202,"_32":203},{"_48":192,"_37":38,"_35":36,"_140":150,"_46":47,"_45":14,"_142":64,"_43":193,"_13":68,"_39":40,"_41":42,"_29":30,"_146":-5,"_173":194,"_32":195},{"_48":184,"_37":185,"_35":186,"_140":150,"_46":47,"_45":187,"_142":64,"_43":188,"_13":68,"_39":40,"_41":189,"_29":30,"_146":-5,"_173":190,"_32":191},{"_48":176,"_37":177,"_35":178,"_140":150,"_46":47,"_45":179,"_142":64,"_43":180,"_13":68,"_39":40,"_41":181,"_29":30,"_146":-5,"_173":182,"_32":183},{"_48":138,"_37":139,"_35":62,"_140":-5,"_46":47,"_45":141,"_142":30,"_43":172,"_13":68,"_39":144,"_41":145,"_29":30,"_146":50,"_173":174,"_32":175},["D",1787408834177],"children",[],[139],"f4c4ecf4-3e1c-420d-a958-e4cedf9a5a30","transcribe.ts","bd6afdea-9e35-11f1-b93f-1607ee4eb77e",3,["D",1787408907346],"// lib/transcribe.ts — Trascrizione Whisper via URL (Groq come default, fallback OpenAI).\n\nexport interface TranscriptSegment {\n start: number; // secondi\n end: number;\n text: string;\n}\nexport interface Transcript {\n text: string;\n segments: TranscriptSegment[];\n}\n\nconst GROQ = \"https://api.groq.com/openai/v1/audio/transcriptions\";\nconst OPENAI = \"https://api.openai.com/v1/audio/transcriptions\";\n\n/**\n * Trascrive l'audio di una sorgente remota (URL pubblico).\n * Groq `whisper-large-v3-turbo` è veloce e ha un tier gratuito.\n */\nexport async function transcribeFromUrl(\n url: string,\n): Promise {\n const groqKey = Deno.env.get(\"GROQ_API_KEY\");\n const openaiKey = Deno.env.get(\"OPENAI_API_KEY\");\n if (!groqKey && !openaiKey) {\n throw new Error(\n \"Configura GROQ_API_KEY (o OPENAI_API_KEY) per la trascrizione.\",\n );\n }\n const useGroq = !!groqKey;\n const endpoint = useGroq ? GROQ : OPENAI;\n const model = useGroq ? \"whisper-large-v3-turbo\" : \"whisper-1\";\n const key = useGroq ? groqKey! : openaiKey!;\n\n const form = new FormData();\n form.append(\"model\", model);\n form.append(\"response_format\", \"verbose_json\");\n form.append(\"timestamp_granularities[]\", \"segment\");\n form.append(\"timestamp_granularities[]\", \"word\");\n form.append(\"url\", url);\n\n const res = await fetch(endpoint, {\n method: \"POST\",\n headers: { Authorization: `Bearer ${key}` },\n body: form,\n });\n if (!res.ok) {\n throw new Error(`Trascrizione fallita (${res.status}): ${await res.text()}`);\n }\n const data = await res.json();\n\n let segments: TranscriptSegment[] = [];\n if (Array.isArray(data.segments)) {\n segments = data.segments\n .map((s: Record) => ({\n start: Number(s.start ?? 0),\n end: Number(s.end ?? 0),\n text: String(s.text ?? \"\").trim(),\n }))\n .filter((s) => s.text.length > 0);\n }\n return { text: data.text ?? \"\", segments };\n}\n",[],[149,177],"ded362f3-f6c6-4182-a927-37e59774eaaf","renderer.ts","bd797d5c-9e35-11f1-b93f-1607ee4eb77e",5,["D",1787408907441],"// lib/renderer.ts — Client per l'API Shotstack (Edit API). Provider astratto:\n// la timeline JSON è cross-engine, quindi aggiungere Creatomate = nuovo client.\n\nconst STAGE = \"https://api.shotstack.io/edit/stage\"; // sandbox gratuita (watermarked)\nconst PROD = \"https://api.shotstack.io/edit/v1\"; // produzione (credits)\n\nexport interface ShotstackEdit {\n timeline: Record;\n output: Record;\n}\n\nfunction baseUrl(): string {\n return Deno.env.get(\"SHOTSTACK_STAGE\") === \"prod\" ? PROD : STAGE;\n}\n\nexport interface RenderSubmit {\n id: string;\n /** URL temporaneo (se incluso nella risposta subito). */\n url?: string;\n}\n\n/** Invia la timeline JSON a Shotstack e ritorna l'id del render. */\nexport async function submitRender(edit: ShotstackEdit): Promise {\n const key = Deno.env.get(\"SHOTSTACK_API_KEY\");\n if (!key) {\n throw new Error(\"Configura SHOTSTACK_API_KEY per il rendering.\");\n }\n const res = await fetch(`${baseUrl()}/render`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"x-api-key\": key,\n \"Accept\": \"application/json\",\n },\n body: JSON.stringify({ timeline: edit.timeline, output: edit.output }),\n });\n const data = await res.json();\n if (!res.ok || !data?.success) {\n throw new Error(`Shotstack render fallito (${res.status}): ${JSON.stringify(data)}`);\n }\n return { id: String(data.response.id) };\n}\n\nexport interface RenderStatus {\n status: \"queued\" | \"fetching\" | \"rendering\" | \"done\" | \"failed\" | string;\n /** URL temporaneo del video finito (disponibile quando done). */\n url?: string;\n}\n\nexport async function renderStatus(id: string): Promise {\n const key = Deno.env.get(\"SHOTSTACK_API_KEY\");\n if (!key) throw new Error(\"Configura SHOTSTACK_API_KEY.\");\n const res = await fetch(`${baseUrl()}/render/${id}`, {\n headers: { \"x-api-key\": key, \"Accept\": \"application/json\" },\n });\n const data = await res.json();\n if (!res.ok || !data?.success) {\n throw new Error(`Status render fallito (${res.status}): ${JSON.stringify(data)}`);\n }\n return {\n status: String(data.response.status),\n url: data.response.url ?? undefined,\n };\n}\n",[],[149,185],"13ee1032-e75e-4885-a9c8-39abca551c49",["D",1787408907489],[],[149,38],"55701016-d7c9-45c2-b5bc-fcb4f431557c","director.ts","bd727c00-9e35-11f1-b93f-1607ee4eb77e",4,["D",1787408907395],"// lib/director.ts — \"Regista AI\": dal transcript + istruzioni produce una proposta\n// di montaggio (momenti migliori + timeline Shotstack JSON) pronta per approvazione.\n\nimport type { Transcript } from \"./transcribe.ts\";\n\nexport interface Proposal {\n summary: string;\n /** Momenti migliori individuati automaticamente. */\n hooks: { start: number; end: number; why: string }[];\n /** Sottotitoli temporizzati, generati dal transcript. */\n subtitles: { start: number; end: number; text: string }[];\n /** Timeline Shotstack pronta per il rendering. */\n timeline: Record;\n}\n\nexport interface DirectorInput {\n sourceUrl: string;\n transcript: Transcript;\n instructions: string;\n /** True per \"si immerge\" dentro le istruzioni; altrimenti decisione libera. */\n}\n\nfunction buildShotstackEdit(\n sourceUrl: string,\n subtitles: { start: number; end: number; text: string }[],\n hooks: { start: number; end: number; why: string }[],\n): Record {\n const total = Math.max(\n 2,\n ...subtitles.map((s) => s.end),\n ...hooks.map((h) => h.end),\n );\n\n // Traccia di base: l'intero video.\n const baseClips = [\n {\n asset: { type: \"video\", src: sourceUrl },\n start: 0,\n length: total,\n },\n ];\n\n // Traccia sottotitoli: un clip \"title\" per ogni segmento parlato (con un tetto).\n // Il format \"subtitle\" di Shotstack non esiste: usiamo \"title\" base e stile testo.\n const captionClips = subtitles.slice(0, 40).map((s) => ({\n asset: {\n type: \"title\",\n text: s.text,\n style: \"compress\",\n size: \"small\",\n },\n start: s.start,\n length: Math.max(0.4, s.end - s.start),\n }));\n\n return {\n timeline: {\n background: \"#000000\",\n tracks: [ { clips: baseClips }, { clips: captionClips, offset: 0 }],\n },\n output: { format: \"mp4\", resolution: \"sd\" },\n };\n}\n\nasync function callLLM(system: string, user: string): Promise {\n const apiKey =\n Deno.env.get(\"AI_API_KEY\") ??\n Deno.env.get(\"OPENAI_API_KEY\") ??\n Deno.env.get(\"GROQ_API_KEY\");\n if (!apiKey) {\n throw new Error(\n \"Configura AI_API_KEY (o OPENAI_API_KEY / GROQ_API_KEY) per l'orchestrazione AI.\",\n );\n }\n const base = Deno.env.get(\"AI_BASE_URL\") ??\n (Deno.env.get(\"GROQ_API_KEY\") ? \"https://api.groq.com/openai/v1\" : \"https://api.openai.com/v1\");\n const model = Deno.env.get(\"AI_MODEL\") ??\n (base.includes(\"groq\") ? \"llama-3.3-70b-versatile\" : \"gpt-4o-mini\");\n\n const res = await fetch(`${base}/chat/completions`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\", Authorization: `Bearer ${apiKey}` },\n body: JSON.stringify({\n model,\n response_format: { type: \"json_object\" },\n temperature: 0.4,\n messages: [\n { role: \"system\", content: system },\n { role: \"user\", content: user },\n ],\n }),\n });\n if (!res.ok) {\n throw new Error(`LLM fallito (${res.status}): ${await res.text()}`);\n }\n const data = await res.json();\n const content = data?.choices?.[0]?.message?.content;\n if (!content) throw new Error(\"LLM: risposta vuota.\");\n return JSON.parse(content);\n}\n\nconst SYSTEM_PROMPT = `Sei un direttore di montaggio video esperto. Analizzi una trascrizione\ncon timestamp e produci UNA PROPOSTA DI MONTAGGIO. Devi:\n- individuare i momenti più significativi (hook), indicando perché funzionano;\n- proporre una timeline valida per l'API Shotstack (JSON: timeline + output);\n- generare sottotitoli temporizzati.\nRispondi SOLO con un JSON con questo schema:\n{\n \"summary\": \"stringa riassuntiva della proposta\",\n \"hooks\": [ { \"start\": number, \"end\": number, \"why\": \"string\" } ],\n \"subtitles\": [ { \"start\": number, \"end\": number, \"text\": \"string\" } ]\n}\nstart/end sono in secondi. Se non ci sono contenuti idonei, imposta hooks=[] e una\ntimeline minimale. Non inventare fatti non presenti nella trascrizione.`;\n\nexport async function buildProposal(\n input: DirectorInput,\n): Promise {\n const user = `ISTRUZIONI DELL'UTENTE:\\n\"\"\"${input.instructions || \"(nessuna istruzione specifica, decidi tu)\"}\"\"\"\\n\\n` +\n `TRASCRIZIONE (con timestamp):\\n` +\n input.transcript.segments\n .map((s) => `[${s.start.toFixed(1)}-${s.end.toFixed(1)}s] ${s.text}`)\n .join(\"\\n\");\n\n // 1) L'LLM sceglie i momenti migliori + sottotitoli.\n const decided = await callLLM(SYSTEM_PROMPT, user);\n const hooks: { start: number; end: number; why: string }[] = (\n Array.isArray(decided.hooks) ? decided.hooks : []\n ).map((h) => ({\n start: Number(h.start ?? 0),\n end: Number(h.end ?? 0),\n why: String(h.why ?? \"\"),\n }));\n const subtitles = (\n Array.isArray(decided.subtitles) && decided.subtitles.length\n ? decided.subtitles\n : input.transcript.segments\n ).map((s) => ({\n start: Number(s.start ?? 0),\n end: Number(s.end ?? 0),\n text: String(s.text ?? \"\"),\n }));\n\n // 2) Costruiamo materialmente la timeline Shotstack.\n const timeline = buildShotstackEdit(input.sourceUrl, subtitles, hooks);\n\n return {\n summary: String(decided.summary ?? \"\"),\n hooks,\n subtitles,\n timeline,\n };\n}\n\nexport { buildShotstackEdit };\n",[],[149,197],"b08c580c-776b-4428-8d1c-ae8a2105e2f1","db.ts","bd62ea24-9e35-11f1-b93f-1607ee4eb77e",["D",1787408907290],"// lib/db.ts — Modello dati e state machine dei job su SQLite (project-scoped).\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n/** Stati della pipeline. Flusso:\n * created ──assistita──► analyzing ─► proposal (in attesa di approvazione)\n * created ──diretta────► queued ─► rendering ─► rendered ─► done\n * proposal ─approve/decline─► queued / declined\n */\nexport const STATUS = {\n CREATED: \"created\",\n ANALYZING: \"analyzing\",\n PROPOSAL: \"proposal\", // in attesa di approvazione umana\n DECLINED: \"declined\",\n QUEUED: \"queued\",\n RENDERING: \"rendering\",\n RENDERED: \"rendered\",\n DONE: \"done\",\n FAILED: \"failed\",\n CANCELLED: \"cancelled\",\n} as const;\nexport type JobStatus = (typeof STATUS)[keyof typeof STATUS];\n\nexport type JobMode = \"assisted\" | \"direct\";\n\nexport interface Job {\n id: string;\n mode: JobMode;\n instructions: string | null;\n sourceKey: string | null;\n sourceExt: string | null;\n transcript: string | null;\n proposal: string | null; // JSON: { summary, hooks, subtitles, timeline }\n timeline: string | null; // JSON: Shotstack edit\n status: JobStatus;\n renderProvider: string | null;\n renderId: string | null;\n renderUrl: string | null;\n outputKey: string | null;\n notifyUrl: string | null;\n error: string | null;\n createdAt: string;\n updatedAt: string;\n}\n\nlet inited = false;\nasync function ensureInit() {\n if (inited) return;\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS jobs (\n id TEXT PRIMARY KEY,\n mode TEXT NOT NULL,\n instructions TEXT,\n source_key TEXT,\n source_ext TEXT,\n transcript TEXT,\n proposal TEXT,\n timeline TEXT,\n status TEXT NOT NULL,\n render_provider TEXT,\n render_id TEXT,\n render_url TEXT,\n output_key TEXT,\n notify_url TEXT,\n error TEXT,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`);\n inited = true;\n}\n\nfunction rowToJob(row: Record | undefined): Job | null {\n if (!row) return null;\n return {\n id: row.id as string,\n mode: row.mode as JobMode,\n instructions: (row.instructions as string) ?? null,\n sourceKey: (row.source_key as string) ?? null,\n sourceExt: (row.source_ext as string) ?? null,\n transcript: (row.transcript as string) ?? null,\n proposal: (row.proposal as string) ?? null,\n timeline: (row.timeline as string) ?? null,\n status: row.status as JobStatus,\n renderProvider: (row.render_provider as string) ?? null,\n renderId: (row.render_id as string) ?? null,\n renderUrl: (row.render_url as string) ?? null,\n outputKey: (row.output_key as string) ?? null,\n notifyUrl: (row.notify_url as string) ?? null,\n error: (row.error as string) ?? null,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n };\n}\n\nexport async function createJob(j: Job): Promise {\n await ensureInit();\n await sqlite.execute({\n sql: `INSERT INTO jobs (id, mode, instructions, source_key, source_ext,\n transcript, proposal, timeline, status, render_provider, render_id,\n render_url, output_key, notify_url, error, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n j.id, j.mode, j.instructions, j.sourceKey, j.sourceExt,\n j.transcript, j.proposal, j.timeline, j.status, j.renderProvider, j.renderId,\n j.renderUrl, j.outputKey, j.notifyUrl, j.error, j.createdAt, j.updatedAt,\n ],\n });\n}\n\ntype Update = Partial>;\nconst COL: Record = {\n mode: \"mode\", instructions: \"instructions\", sourceKey: \"source_key\",\n sourceExt: \"source_ext\", transcript: \"transcript\", proposal: \"proposal\",\n timeline: \"timeline\", status: \"status\", renderProvider: \"render_provider\",\n renderId: \"render_id\", renderUrl: \"render_url\", outputKey: \"output_key\",\n notifyUrl: \"notify_url\", error: \"error\", updatedAt: \"updated_at\",\n};\n\nexport async function updateJob(id: string, patch: Update): Promise {\n await ensureInit();\n const sets: string[] = [];\n const args: unknown[] = [];\n for (const [k, v] of Object.entries(patch)) {\n const col = COL[k];\n if (!col) continue;\n sets.push(`${col} = ?`);\n args.push(v ?? null);\n }\n if (sets.length === 0) return getJob(id);\n sets.push(\"updated_at = ?\");\n args.push(new Date().toISOString());\n args.push(id);\n await sqlite.execute({ sql: `UPDATE jobs SET ${sets.join(\", \")} WHERE id = ?`, args });\n return getJob(id);\n}\n\nexport async function getJob(id: string): Promise {\n await ensureInit();\n const r = await sqlite.execute({ sql: \"SELECT * FROM jobs WHERE id = ?\", args: [id] });\n return rowToJob(r.rows[0] as Record | undefined);\n}\n\nexport async function listJobsByStatus(status: JobStatus): Promise {\n await ensureInit();\n const r = await sqlite.execute({ sql: \"SELECT * FROM jobs WHERE status = ? ORDER BY created_at ASC\", args: [status] });\n return (r.rows as Record[]).map(rowToJob).filter((x): x is Job => !!x);\n}\n\nexport async function listJobs(limit = 50): Promise {\n await ensureInit();\n const r = await sqlite.execute({ sql: \"SELECT * FROM jobs ORDER BY created_at DESC LIMIT ?\", args: [limit] });\n return (r.rows as Record[]).map(rowToJob).filter((x): x is Job => !!x);\n}\n",[],[149,205],["D",1787408907290],[166,167,168,169,170],[149],["D",1787408834126],["D",1789494036282],{"_105":104,"_113":109},{"_105":104,"_106":107,"_108":109,"_19":60,"_110":111,"_112":30},{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_133":252,"_253":254,"_255":256,"_257":30,"_258":30,"_259":30,"_260":64,"_261":-5,"_262":-7,"_263":-7,"_264":68,"_265":30,"_266":30,"_267":-5,"_268":30,"_269":30,"_270":30,"_271":-5},"ENV",{"_223":224,"_225":226,"_227":95,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v6