[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_109":110,"_111":112},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","boh","name","ai-video-editor","path","lib/db.ts","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":56,"_57":-5,"_58":59,"_60":61,"_62":34,"_63":-5,"_64":-5,"_65":38,"_66":67,"_68":69,"_70":71,"_72":73,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/boh/ai-video-editor/code/lib/db.ts","extension","id","b08c580c-776b-4428-8d1c-ae8a2105e2f1","db.ts","fileId","bd62ea24-9e35-11f1-b93f-1607ee4eb77e","parentId","c5257465-2ce4-4476-b73e-c2fd2f8430cf","branchId","d0e0f9e5-8ba8-4507-85a6-48258752e110","branchVersion",2,"latest",true,"createdAt",["D",1787408907290],"version",0,"fileType","script","content","// 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","deleted",false,"label",[47,24],"lib","d565aca1-3a7a-4d20-8c25-06afae036bb2",["D",1787408834126],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Pipeline serverless di editing video automatizzato con AI","imageUrl","userId","86c0904a-df90-4b28-8be9-0d0cd34688de","pinnedFileId","91ce646a-9e35-11f1-8e1d-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount","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",{"_9":10,"_108":104},"org",{"_9":10,"_101":102,"_103":104,"_58":59,"_105":106,"_107":44},"branch",{"_37":91,"_11":92,"_22":30,"_93":48,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":12,"_100":10},"isOwned",10,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","BCG Collaborazioni","avatar","https://lh3.googleusercontent.com/a/ACg8ocK88V05YV8HsO4yAaG3hTsa_rYvYnQ7JithXHAoBkrpvT9HmN8=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_84":-5,"_142":143,"_144":145,"_146":147,"_148":44,"_149":44,"_150":44,"_151":34,"_152":-5,"_153":-7,"_154":-7,"_155":38,"_156":44,"_157":44,"_158":-5,"_159":44,"_160":44,"_161":44,"_162":-5},"ENV",{"_113":114,"_115":116,"_117":92,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139,"_140":141},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]