[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_240":241,"_242":243},"routes/_app.x.$handle.$name",{"_104":103,"_37":49,"_113":94,"_32":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":30,"_128":129,"_130":63,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":30},"version",8,"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":33,"_38":39,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","cron.ts","latestPath","fileId","d9c98560-9e35-11f1-83a7-1607ee4eb77e","name","fileType","interval","content","// cron.ts — Reconcile periodico dei render attivi e retry delle analisi bloccate.\n\nimport { reconcile } from \"./lib/pipeline.ts\";\n\nexport default async function (_interval: Interval) {\n await reconcile();\n console.log(\"[cron] reconcile completato\");\n}\n","createdAt",["D",1787408954943],"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",{"_104":103,"_112":108},"org",{"_104":103,"_105":106,"_107":108,"_19":59,"_109":110,"_111":30},"branch",{"_13":93,"_37":94,"_47":46,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"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",{"_47":48,"_37":49,"_42":235,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":236,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":237,"_88":238,"_90":239,"_92":30},"tree",[168,175,176],"files",[168,169,170,171,172,173,174,175,176],"counts",{"_158":67,"_159":141,"_160":67,"_161":162,"_163":164},"contents",[135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":151,"_37":152,"_35":153,"_140":-5,"_45":46,"_44":154,"_142":63,"_42":155,"_13":67,"_38":156,"_40":-5,"_29":30,"_146":-5,"_32":157},{"_47":148,"_37":33,"_35":36,"_140":-5,"_45":46,"_44":14,"_142":63,"_42":149,"_13":67,"_38":39,"_40":41,"_29":30,"_146":-5,"_32":150},{"_47":138,"_37":139,"_35":61,"_140":-5,"_45":46,"_44":141,"_142":30,"_42":143,"_13":67,"_38":144,"_40":145,"_29":30,"_146":49,"_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],"f8d2be3b-c159-4c19-aa20-9c8677abaeb2",["D",1787408954943],[33],"bc884ed6-cf89-4e01-b5a7-5c518d0390d5","lib","c5257465-2ce4-4476-b73e-c2fd2f8430cf",2,["D",1787408907290],"directory",[152],"pulls","branches","forks","envVars",{"_165":67,"_167":67},"connections",{"_165":67,"_166":67},"count","unfilledCount","emptyCount",{"_47":151,"_37":152,"_35":153,"_140":-5,"_45":46,"_44":154,"_142":63,"_42":232,"_13":67,"_38":156,"_40":-5,"_29":30,"_146":-5,"_178":233,"_32":234},{"_47":225,"_37":226,"_35":227,"_140":153,"_45":46,"_44":154,"_142":63,"_42":228,"_13":67,"_38":189,"_40":229,"_29":30,"_146":-5,"_178":230,"_32":231},{"_47":217,"_37":218,"_35":219,"_140":153,"_45":46,"_44":220,"_142":63,"_42":221,"_13":67,"_38":189,"_40":222,"_29":30,"_146":-5,"_178":223,"_32":224},{"_47":209,"_37":210,"_35":211,"_140":153,"_45":46,"_44":212,"_142":63,"_42":213,"_13":67,"_38":189,"_40":214,"_29":30,"_146":-5,"_178":215,"_32":216},{"_47":201,"_37":202,"_35":203,"_140":153,"_45":46,"_44":204,"_142":63,"_42":205,"_13":67,"_38":189,"_40":206,"_29":30,"_146":-5,"_178":207,"_32":208},{"_47":193,"_37":194,"_35":195,"_140":153,"_45":46,"_44":196,"_142":63,"_42":197,"_13":67,"_38":189,"_40":198,"_29":30,"_146":-5,"_178":199,"_32":200},{"_47":184,"_37":185,"_35":186,"_140":153,"_45":46,"_44":187,"_142":63,"_42":188,"_13":67,"_38":189,"_40":190,"_29":30,"_146":-5,"_178":191,"_32":192},{"_47":148,"_37":33,"_35":36,"_140":-5,"_45":46,"_44":14,"_142":63,"_42":181,"_13":67,"_38":39,"_40":41,"_29":30,"_146":-5,"_178":182,"_32":183},{"_47":138,"_37":139,"_35":61,"_140":-5,"_45":46,"_44":141,"_142":30,"_42":177,"_13":67,"_38":144,"_40":145,"_29":30,"_146":49,"_178":179,"_32":180},["D",1787408834177],"children",[],[139],["D",1787408954943],[],[33],"f4c4ecf4-3e1c-420d-a958-e4cedf9a5a30","transcribe.ts","bd6afdea-9e35-11f1-b93f-1607ee4eb77e",3,["D",1787408907346],"script","// 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",[],[152,185],"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",[],[152,194],"25f5627e-4364-4fd5-ac91-b726bb22b910","pipeline.ts","d9c2632a-9e35-11f1-83a7-1607ee4eb77e",7,["D",1787408954894],"// lib/pipeline.ts — Orchestrazione: analisi trascrizione+proposta, avvio render,\n// reconcile degli stati. Usato sia dal server HTTP sia dal cron.\n\nimport { STATUS, getJob, updateJob, listJobsByStatus, type Job } from \"./db.ts\";\nimport { transcribeFromUrl } from \"./transcribe.ts\";\nimport { buildProposal } from \"./director.ts\";\nimport { submitRender, renderStatus } from \"./renderer.ts\";\nimport { notify } from \"./notify.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { httpEndpoint } from \"https://esm.town/v/std/utils/index.ts\";\n\n/** URL pubblico dell'endpoint /media/:id/source (il val fa da media host). */\nexport function sourceUrlFor(id: string): string {\n return httpEndpoint(`/media/${id}/source`);\n}\nexport function outputUrlFor(id: string): string {\n return httpEndpoint(`/media/${id}/output`);\n}\nexport function jobUrl(id: string): string {\n return httpEndpoint(`/jobs/${id}`);\n}\n\n/** Modalità assistita: trascrizione + proposta → stato PROPOSAL. */\nexport async function analyzeJob(id: string): Promise {\n const job = await getJob(id);\n if (!job || job.status !== STATUS.CREATED) return;\n\n await updateJob(id, { status: STATUS.ANALYZING, error: null });\n try {\n const src = sourceUrlFor(id);\n const transcript = await transcribeFromUrl(src);\n const proposal = await buildProposal({\n sourceUrl: src,\n transcript,\n instructions: job.instructions ?? \"\",\n });\n await updateJob(id, {\n status: STATUS.PROPOSAL,\n transcript: transcript.text,\n proposal: JSON.stringify(proposal),\n });\n await notify({\n title: `🧠 Proposta pronta — job ${id}`,\n body: proposal.summary || \"Una proposta di montaggio è pronta per la revisione.\",\n links: {\n \"🎬 Proposta\": `${jobUrl(id)}/proposal`,\n \"✅ Approva\": `${httpEndpoint(`/jobs/${id}/approve`)}`,\n \"❌ Declina\": `${httpEndpoint(`/jobs/${id}/decline`)}`,\n },\n });\n } catch (e) {\n const msg = e instanceof Error ? e.message : String(e);\n console.error(\"[analyze]\", id, msg);\n await updateJob(id, { status: STATUS.FAILED, error: msg });\n await notify({\n title: `⚠️ Analisi fallita — job ${id}`,\n body: msg,\n links: { \"Job\": jobUrl(id) },\n });\n }\n}\n\n/** Avvia il rendering di una timeline esplicita o della proposta approvata. */\nexport async function startRender(id: string): Promise {\n const job = await getJob(id);\n if (!job) return null;\n\n const timelineJson =\n job.timeline ?? (job.proposal ? JSON.parse(job.proposal).timeline : null);\n if (!timelineJson) {\n await updateJob(id, { status: STATUS.FAILED, error: \"Nessuna timeline disponibile.\" });\n return job;\n }\n\n try {\n await updateJob(id, { status: STATUS.QUEUED, renderProvider: \"shotstack\", renderId: null, renderUrl: null, error: null });\n const { id: renderId } = await submitRender(timelineJson);\n await updateJob(id, { status: STATUS.RENDERING, renderId, renderProvider: \"shotstack\" });\n await notify({\n title: `🎬 Rendering avviato — job ${id}`,\n body: \"La timeline è in coda su Shotstack.\",\n links: { \"Job\": jobUrl(id) },\n });\n return job;\n } catch (e) {\n const msg = e instanceof Error ? e.message : String(e);\n console.error(\"[render]\", id, msg);\n await updateJob(id, { status: STATUS.FAILED, error: msg });\n await notify({\n title: `⚠️ Avvio render fallito — job ${id}`,\n body: msg,\n links: { \"Job\": jobUrl(id) },\n });\n return job;\n }\n}\n\n/** Approva la proposta: la timeline proposta passa al render. */\nexport async function approveJob(id: string): Promise {\n const job = await getJob(id);\n if (!job) return null;\n if (job.status !== STATUS.PROPOSAL) {\n throw new Error(`Job ${id} non è in stato di proposta (${job.status}).`);\n }\n return startRender(id);\n}\n\n/** Poll dei render attivi + retry delle analisi impantanate. */\nexport async function reconcile(): Promise {\n const active = [\n ...(await listJobsByStatus(STATUS.QUEUED)),\n ...(await listJobsByStatus(STATUS.RENDERING)),\n ];\n\n for (const job of active) {\n if (!job.renderId) continue;\n try {\n const st = await renderStatus(job.renderId);\n if (st.status === \"done\" && st.url) {\n await completeRender(job, st.url);\n } else if (st.status === \"failed\") {\n await updateJob(job.id, { status: STATUS.FAILED, error: \"Render Shotstack fallito.\" });\n await notify({ title: `💥 Render fallito — ${job.id}`, body: \"Lo stato su Shotstack è 'failed'.\", links: { \"Job\": jobUrl(job.id) } });\n }\n // queued/fetching/rendering → aspetta il prossimo giro.\n } catch (e) {\n console.error(\"[reconcile]\", job.id, e);\n }\n }\n\n // Retry analisi che si sono impantanate (> 10 min in ANALYZING).\n const staleAnalyzing = (await listJobsByStatus(STATUS.ANALYZING)).filter(\n (j) => Date.now() - new Date(j.updatedAt).getTime() > 10 * 60 * 1000,\n );\n for (const j of staleAnalyzing) {\n await updateJob(j.id, { status: STATUS.CREATED });\n void analyzeJob(j.id);\n }\n}\n\n/** Render completato: salva l'output su blob e passa a DONE. */\nasync function completeRender(job: Job, tempUrl: string): Promise {\n try {\n const res = await fetch(tempUrl);\n if (!res.ok) throw new Error(`Download output ${res.status}`);\n const outBlob = await res.blob();\n const key = `jobs/${job.id}/output.mp4`;\n await blob.set(key, outBlob);\n await updateJob(job.id, {\n status: STATUS.DONE,\n renderUrl: tempUrl,\n outputKey: key,\n });\n await notify({\n title: `✅ Video pronto — job ${job.id}`,\n body: \"Il render è completato.\",\n links: {\n \"▶️ Download\": tempUrl,\n \"🍿 Output (val host)\": outputUrlFor(job.id),\n },\n });\n } catch (e) {\n console.error(\"[completeRender]\", job.id, e);\n await updateJob(job.id, {\n status: STATUS.RENDERED,\n renderUrl: tempUrl,\n error: e instanceof Error ? e.message : String(e),\n });\n await notify({\n title: `✅ Render pronto (ma archiviazione fallita) — ${job.id}`,\n body: \"Scarica dal link temporaneo (scade in 24h).\",\n links: { \"▶️ Download\": tempUrl },\n });\n }\n}\n",[],[152,202],"13ee1032-e75e-4885-a9c8-39abca551c49","notify.ts","bd80f7da-9e35-11f1-b93f-1607ee4eb77e",6,["D",1787408907489],"// 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",[],[152,210],"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",[],[152,218],"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",[],[152,226],["D",1787408907290],[169,170,171,172,173,174],[152],["D",1787408834126],["D",1789494036282],{"_104":103,"_112":108},{"_104":103,"_105":106,"_107":108,"_19":59,"_109":110,"_111":30},{"_13":93,"_37":94,"_47":46,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"ctx",{"_86":-5,"_132":273,"_274":275,"_276":277,"_278":30,"_279":30,"_280":30,"_281":63,"_282":-5,"_283":-7,"_284":-7,"_285":67,"_286":30,"_287":30,"_288":-5,"_289":30,"_290":30,"_291":30,"_292":-5},"ENV",{"_244":245,"_246":247,"_248":94,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · v8