\n \n\n\n",[18,68],"1d3c0780-3aa6-11f1-a795-42b51c65c3df",["D",1776462055454],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport ClipForm from \"./components/ClipForm.tsx\";\nimport JobList from \"./components/JobList.tsx\";\nimport Header from \"./components/Header.tsx\";\n\nexport default function App() {\n const [jobs, setJobs] = useState([]);\n const [loading, setLoading] = useState(true);\n const [activeJob, setActiveJob] = useState(null);\n\n const fetchJobs = async () => {\n try {\n const res = await fetch(\"/api/jobs\");\n const data = await res.json();\n setJobs(data);\n } catch (e) {\n console.error(e);\n } finally {\n setLoading(false);\n }\n };\n\n const fetchJobDetail = async (id: string) => {\n const res = await fetch(`/api/jobs/${id}`);\n const data = await res.json();\n setActiveJob(data);\n };\n\n useEffect(() => {\n fetchJobs();\n }, []);\n\n return (\n

\n {\n setJobs((prev) => [job.job, ...prev]);\n setActiveJob(job);\n }}\n />\n\n {activeJob && (\n

\n \n {activeJob.job.title || \"Untitled Video\"}\n

\n setActiveJob(null)}\n class=\"text-gray-400 hover:text-white transition\"\n >\n \n \n

\n\n

\n {activeJob.job.platform}\n

\n {formatDuration(activeJob.job.duration)}\n

\n {activeJob.clips.length} clips\n

\n {new Date(activeJob.job.created_at).toLocaleDateString()}\n

\n\n {activeJob.job.thumbnail && (\n \n )}\n\n

\n {activeJob.clips.map((clip: any) => (\n \n

\n {clip.part_number}\n

{clip.title}

\n {formatDuration(clip.start_time)} → {formatDuration(clip.end_time)}\n \n ({formatDuration(clip.end_time - clip.start_time)})\n \n

\n {activeJob.job.platform === \"youtube\" && activeJob.job.video_id && (\n \n Watch\n \n )}\n copyTimestamp(clip)}\n class=\"bg-purple-600 hover:bg-purple-500 text-white px-3 py-2 rounded-lg text-sm font-medium transition flex items-center gap-1\"\n >\n Copy\n \n

\n ))}\n

\n\n

\n How to download clips:\n

Use the timestamps above with a tool like clipr.xyz or ytcutter.com
Or use yt-dlp locally: yt-dlp --download-sections \"*start-end\" URL
Copy timestamps with the Copy button and paste into your preferred tool

\n )}\n\n fetchJobDetail(id)}\n onDelete={async (id: string) => {\n await fetch(`/api/jobs/${id}`, { method: \"DELETE\" });\n setJobs((prev) => prev.filter((j) => j.id !== id));\n if (activeJob?.job?.id === id) setActiveJob(null);\n }}\n />\n\n \n \n );\n}\n\nfunction formatDuration(seconds: number): string {\n const h = Math.floor(seconds / 3600);\n const m = Math.floor((seconds % 3600) / 60);\n const s = Math.floor(seconds % 60);\n if (h > 0) return `${h}:${m.toString().padStart(2, \"0\")}:${s.toString().padStart(2, \"0\")}`;\n return `${m}:${s.toString().padStart(2, \"0\")}`;\n}\n\nfunction copyTimestamp(clip: any) {\n const text = `Part ${clip.part_number}: ${formatDuration(clip.start_time)} - ${formatDuration(clip.end_time)}`;\n navigator.clipboard.writeText(text);\n}\n",[18,92],"21900034-3aa6-11f1-b353-42b51c65c3df",["D",1776462062708],[18,101],"pulls","branches",1,"forks","envVars",{"_212":26,"_214":26},"connections",{"_212":26,"_213":26},"count","unfilledCount","emptyCount",{"_36":341,"_13":340,"_66":334,"_46":-5,"_38":39,"_179":335,"_180":24,"_40":342,"_42":26,"_69":102,"_182":-5,"_70":30,"_183":-5,"_239":343,"_17":344},{"_36":331,"_13":332,"_66":333,"_46":334,"_38":39,"_179":335,"_180":24,"_40":336,"_42":26,"_69":83,"_182":337,"_70":30,"_183":-5,"_239":338,"_17":339},{"_36":327,"_13":318,"_66":312,"_46":-5,"_38":39,"_179":322,"_180":24,"_40":328,"_42":26,"_69":102,"_182":-5,"_70":30,"_183":-5,"_239":329,"_17":330},{"_36":319,"_13":320,"_66":321,"_46":312,"_38":39,"_179":322,"_180":24,"_40":323,"_42":26,"_69":83,"_182":324,"_70":30,"_183":-5,"_239":325,"_17":326},{"_36":309,"_13":310,"_66":311,"_46":312,"_38":39,"_179":313,"_180":24,"_40":314,"_42":26,"_69":83,"_182":315,"_70":30,"_183":-5,"_239":316,"_17":317},{"_36":178,"_13":18,"_66":103,"_46":-5,"_38":39,"_179":43,"_180":24,"_40":306,"_42":26,"_69":102,"_182":-5,"_70":30,"_183":-5,"_239":307,"_17":308},{"_36":201,"_13":101,"_66":100,"_46":103,"_38":39,"_179":95,"_180":24,"_40":303,"_42":26,"_69":102,"_182":-5,"_70":30,"_183":-5,"_239":304,"_17":305},{"_36":295,"_13":296,"_66":297,"_46":100,"_38":39,"_179":298,"_180":24,"_40":299,"_42":26,"_69":83,"_182":300,"_70":30,"_183":-5,"_239":301,"_17":302},{"_36":288,"_13":289,"_66":290,"_46":100,"_38":39,"_179":95,"_180":24,"_40":291,"_42":26,"_69":83,"_182":292,"_70":30,"_183":-5,"_239":293,"_17":294},{"_36":280,"_13":281,"_66":282,"_46":100,"_38":39,"_179":283,"_180":24,"_40":284,"_42":26,"_69":83,"_182":285,"_70":30,"_183":-5,"_239":286,"_17":287},{"_36":197,"_13":92,"_66":91,"_46":103,"_38":39,"_179":86,"_180":24,"_40":277,"_42":26,"_69":83,"_182":199,"_70":30,"_183":-5,"_239":278,"_17":279},{"_36":193,"_13":68,"_66":67,"_46":103,"_38":39,"_179":43,"_180":24,"_40":274,"_42":26,"_69":21,"_182":195,"_70":30,"_183":-5,"_239":275,"_17":276},{"_36":189,"_13":82,"_66":81,"_46":103,"_38":39,"_179":76,"_180":24,"_40":271,"_42":26,"_69":83,"_182":191,"_70":30,"_183":-5,"_239":272,"_17":273},{"_36":267,"_13":259,"_66":253,"_46":-5,"_38":39,"_179":206,"_180":24,"_40":268,"_42":26,"_69":102,"_182":-5,"_70":30,"_183":-5,"_239":269,"_17":270},{"_36":260,"_13":261,"_66":262,"_46":253,"_38":39,"_179":206,"_180":24,"_40":263,"_42":26,"_69":83,"_182":264,"_70":30,"_183":-5,"_239":265,"_17":266},{"_36":250,"_13":251,"_66":252,"_46":253,"_38":39,"_179":254,"_180":24,"_40":255,"_42":206,"_69":83,"_182":256,"_70":30,"_183":-5,"_239":257,"_17":258},{"_36":242,"_13":243,"_66":244,"_46":-5,"_38":39,"_179":245,"_180":24,"_40":246,"_42":26,"_69":21,"_182":247,"_70":30,"_183":-5,"_239":248,"_17":249},{"_36":233,"_13":234,"_66":116,"_46":-5,"_38":39,"_179":143,"_180":24,"_40":235,"_42":236,"_69":237,"_182":238,"_70":30,"_183":-5,"_239":240,"_17":241},"5178f46c-3ae3-11f1-b941-42b51c65c3df","main.ts",["D",1776488342384],2,"http","import { Hono } from \"npm:hono@4\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { createJob, createClip, getJobs, getJobWithClips, deleteJob } from \"./database/queries.ts\";\nimport { detectPlatform, extractYouTubeId, extractTwitchId, generateSmartClips, generateId } from \"./shared/utils.ts\";\nimport { getYouTubeInfo } from \"./backend/youtube.ts\";\n\nconst app = new Hono();\n\n// Error handler for stack traces\napp.onError((err) => Promise.reject(err));\n\n// Run migrations on cold start\nlet migrated = false;\napp.use(\"*\", async (c, next) => {\n if (!migrated) {\n await runMigrations();\n migrated = true;\n }\n return next();\n});\n\n// Serve frontend\napp.get(\"/\", (c) => serveFile(\"/frontend/index.html\", import.meta.url));\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// View source\napp.get(\"/source\", (c) => c.redirect(parseVal(import.meta.url).links.self.val));\n\n// API: Create clip job\napp.post(\"/api/clip\", async (c) => {\n const body = await c.req.json();\n const { url, numClips = 4, manualDuration } = body;\n\n if (!url) return c.json({ error: \"URL is required\" }, 400);\n\n const platform = detectPlatform(url);\n let title = \"\";\n let duration = 0;\n let thumbnail = \"\";\n let videoId = \"\";\n\n if (platform === \"youtube\") {\n videoId = extractYouTubeId(url) || \"\";\n if (videoId) {\n const info = await getYouTubeInfo(videoId);\n title = info.title;\n duration = info.duration;\n thumbnail = info.thumbnail;\n }\n } else if (platform === \"twitch\") {\n videoId = extractTwitchId(url) || \"\";\n title = `Twitch VOD ${videoId}`;\n thumbnail = \"\";\n }\n\n // Use manual duration if provided or auto-detect failed\n if (manualDuration && manualDuration > 0) {\n duration = manualDuration;\n }\n\n if (!duration || duration < 10) {\n return c.json({\n error: \"Could not detect video duration. Please use Manual Duration mode and enter the length (e.g. 1:30:00).\",\n }, 400);\n }\n\n if (numClips > duration / 5) {\n return c.json({ error: \"Too many clips for this video length\" }, 400);\n }\n\n const jobId = generateId();\n const timestamps = generateSmartClips(duration, numClips);\n\n await createJob(jobId, url, platform, title, duration, numClips, thumbnail, videoId);\n\n const clips = [];\n for (let i = 0; i < timestamps.length; i++) {\n const clipId = generateId();\n const clipTitle = `${title ? title + \" - \" : \"\"}Part ${i + 1}`;\n await createClip(clipId, jobId, i + 1, timestamps[i].start, timestamps[i].end, clipTitle);\n clips.push({\n id: clipId,\n job_id: jobId,\n part_number: i + 1,\n start_time: timestamps[i].start,\n end_time: timestamps[i].end,\n title: clipTitle,\n });\n }\n\n const job = {\n id: jobId,\n url,\n platform,\n title,\n duration,\n num_clips: numClips,\n status: \"done\",\n thumbnail,\n video_id: videoId,\n created_at: new Date().toISOString(),\n };\n\n return c.json({ job, clips });\n});\n\n// API: List jobs\napp.get(\"/api/jobs\", async (c) => {\n const jobs = await getJobs();\n return c.json(jobs);\n});\n\n// API: Get job detail\napp.get(\"/api/jobs/:id\", async (c) => {\n const data = await getJobWithClips(c.req.param(\"id\"));\n if (!data) return c.json({ error: \"Not found\" }, 404);\n return c.json(data);\n});\n\n// API: Delete job\napp.delete(\"/api/jobs/:id\", async (c) => {\n await deleteJob(c.req.param(\"id\"));\n return c.json({ ok: true });\n});\n\nexport default app.fetch;\n","children",[],[234],"4e71095e-3aa6-11f1-bdea-42b51c65c3df","README.md","4e710a3a-3aa6-11f1-bdea-42b51c65c3df",13,["D",1776462137999],"# 🎬 Clip Factory\n\nAuto-split YouTube & Twitch videos into multiple clips for faceless social media content.\n\n## How It Works\n\n1. **Paste a video URL** — YouTube or Twitch VOD link\n2. **Choose number of clips** — Split into 2-10 parts\n3. **Get timestamps** — Instant clip boundaries with timestamps\n4. **Download clips** — Use timestamps with tools like [ytcutter.com](https://ytcutter.com) or `yt-dlp`\n\n## Features\n\n- 🎥 **YouTube support** — Auto-detects title, duration, and thumbnail\n- 🟣 **Twitch support** — Paste VOD links with manual duration\n- ✂️ **Smart splitting** — Evenly divides videos into your chosen number of parts\n- 📋 **Copy timestamps** — One-click copy for each clip's time range\n- 🔗 **Direct YouTube links** — Jump to exact timestamps on YouTube\n- 📜 **History** — All your clip jobs saved and browsable\n\n## Architecture\n\n```mermaid\ngraph TD\n A[User pastes URL] --> B[Backend detects platform]\n B --> C{YouTube?}\n C -->|Yes| D[Fetch video info & duration]\n C -->|No| E[Manual duration input]\n D --> F[Split into N equal clips]\n E --> F\n F --> G[Save to SQLite]\n G --> H[Display clip timestamps]\n H --> I[Copy/Watch/Download]\n```\n\n## Downloading Clips\n\nSince Val Town runs serverless (no FFmpeg), use these tools with the timestamps:\n\n- **[ytcutter.com](https://ytcutter.com)** — Browser-based YouTube clip cutter\n- **[clipr.xyz](https://clipr.xyz)** — Online video trimmer \n- **yt-dlp** (local): `yt-dlp --download-sections \"*00:00-05:30\" URL`\n",[],[243],"38721e6c-3aa7-11f1-8b8c-42b51c65c3df","utils.ts","01e24db4-3aa6-11f1-9ec3-42b51c65c3df","6b2fcdda-a3f4-4721-8b08-d80a0442fb3a",14,["D",1776462530592],"export function detectPlatform(url: string): \"youtube\" | \"twitch\" | \"unknown\" {\n if (/youtube\\.com|youtu\\.be/i.test(url)) return \"youtube\";\n if (/twitch\\.tv/i.test(url)) return \"twitch\";\n return \"unknown\";\n}\n\nexport function extractYouTubeId(url: string): string | null {\n const patterns = [\n /(?:youtube\\.com\\/watch\\?v=|youtu\\.be\\/|youtube\\.com\\/embed\\/|youtube\\.com\\/v\\/)([a-zA-Z0-9_-]{11})/,\n /youtube\\.com\\/shorts\\/([a-zA-Z0-9_-]{11})/,\n ];\n for (const p of patterns) {\n const m = url.match(p);\n if (m) return m[1];\n }\n return null;\n}\n\nexport function extractTwitchId(url: string): string | null {\n const m = url.match(/twitch\\.tv\\/videos\\/(\\d+)/);\n return m ? m[1] : null;\n}\n\nexport function formatTime(seconds: number): string {\n const h = Math.floor(seconds / 3600);\n const m = Math.floor((seconds % 3600) / 60);\n const s = Math.floor(seconds % 60);\n if (h > 0) return `${h}:${m.toString().padStart(2, \"0\")}:${s.toString().padStart(2, \"0\")}`;\n return `${m}:${s.toString().padStart(2, \"0\")}`;\n}\n\n/**\n * Generate clips in the 45s-2min range.\n * Splits the video into as many clips as possible within the target range.\n * If user requests a specific number, it adjusts clip length accordingly.\n */\nexport function generateSmartClips(\n duration: number,\n requestedClips?: number,\n): { start: number; end: number }[] {\n const MIN_CLIP = 45;\n const MAX_CLIP = 120;\n const TARGET_CLIP = 90; // prefer ~90 seconds\n\n let numClips: number;\n\n if (requestedClips && requestedClips > 0) {\n numClips = requestedClips;\n } else {\n // Auto-calculate: how many clips at target length?\n numClips = Math.max(1, Math.floor(duration / TARGET_CLIP));\n }\n\n // Calculate clip length\n let clipLen = Math.floor(duration / numClips);\n\n // Enforce the 45s-2min bounds on clip length\n if (clipLen < MIN_CLIP) clipLen = MIN_CLIP;\n if (clipLen > MAX_CLIP) clipLen = MAX_CLIP;\n\n // Recalculate how many clips we can actually fit\n numClips = Math.max(1, Math.floor(duration / clipLen));\n\n const clips: { start: number; end: number }[] = [];\n for (let i = 0; i < numClips; i++) {\n const start = i * clipLen;\n let end = start + clipLen;\n // Last clip extends to end of video if close enough\n if (i === numClips - 1 && duration - end < MIN_CLIP) {\n end = duration;\n }\n // Don't exceed video\n if (end > duration) end = duration;\n // Only add if clip is at least 30 seconds\n if (end - start >= 30) {\n clips.push({ start, end });\n }\n }\n\n return clips;\n}\n\nexport function generateId(): string {\n return crypto.randomUUID().slice(0, 8);\n}\n",[],[259,251],"shared","fd362b46-3aa5-11f1-a795-42b51c65c3df","types.ts","fd362c0e-3aa5-11f1-a795-42b51c65c3df",["D",1776462001721],"export interface ClipJob {\n id: string;\n url: string;\n platform: \"youtube\" | \"twitch\" | \"unknown\";\n title: string;\n duration: number; // seconds\n numClips: number;\n status: \"pending\" | \"processing\" | \"done\" | \"error\";\n clips: Clip[];\n createdAt: string;\n error?: string;\n}\n\nexport interface Clip {\n id: string;\n jobId: string;\n partNumber: number;\n startTime: number;\n endTime: number;\n title: string;\n downloadUrl?: string;\n}\n\nexport interface VideoInfo {\n title: string;\n duration: number;\n thumbnail: string;\n platform: \"youtube\" | \"twitch\" | \"unknown\";\n videoId: string;\n}\n",[],[259,261],"fd3649aa-3aa5-11f1-a795-42b51c65c3df",["D",1776462001721],[229,230],[259],["D",1776462031149],[],[18,82],["D",1776462027162],[],[18,68],["D",1776462055454],[],[18,92],"3470a708-3aa6-11f1-9005-42b51c65c3df","JobList.tsx","3470a7b2-3aa6-11f1-9005-42b51c65c3df",10,["D",1776462094386],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\ninterface Props {\n jobs: any[];\n loading: boolean;\n onSelect: (id: string) => void;\n onDelete: (id: string) => void;\n}\n\nexport default function JobList({ jobs, loading, onSelect, onDelete }: Props) {\n if (loading) {\n return (\n

\n \n

Loading history...

\n );\n }\n\n if (jobs.length === 0) {\n return (\n

🎬

No clips yet

Paste a video URL above to get started!

\n );\n }\n\n return (\n

\n Recent Clips\n

\n {jobs.map((job: any) => (\n onSelect(job.id)}\n >\n

\n {job.thumbnail ? (\n \n ) : (\n

\n \n

\n )}\n

\n {job.title || \"Untitled\"}\n

\n {job.num_clips} clips • {formatDuration(job.duration)} •{\" \"}\n {new Date(job.created_at).toLocaleDateString()}\n

\n \n {job.status}\n \n {\n e.stopPropagation();\n onDelete(job.id);\n }}\n class=\"text-gray-600 hover:text-red-400 transition p-1\"\n >\n \n \n

\n ))}\n

\n \n );\n}\n\nfunction formatDuration(seconds: number): string {\n const h = Math.floor(seconds / 3600);\n const m = Math.floor((seconds % 3600) / 60);\n const s = Math.floor(seconds % 60);\n if (h > 0) return `${h}:${m.toString().padStart(2, \"0\")}:${s.toString().padStart(2, \"0\")}`;\n return `${m}:${s.toString().padStart(2, \"0\")}`;\n}\n",[],[18,101,281],"218fc3b2-3aa6-11f1-b353-42b51c65c3df","Header.tsx","218fc470-3aa6-11f1-b353-42b51c65c3df",["D",1776462062708],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\nexport default function Header() {\n return (\n

🎬

\n Clip Factory\n

\n Paste a YouTube or Twitch video link, choose how many clips you want,\n and get instant timestamps to split and download for your faceless content.\n

\n \n YouTube\n \n \n Twitch\n \n \n Auto-Split\n \n

\n );\n}\n",[],[18,101,289],"2c6a386c-3aa6-11f1-b353-42b51c65c3df","ClipForm.tsx","2c6a3948-3aa6-11f1-b353-42b51c65c3df",9,["D",1776462080921],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface Props {\n onCreated: (job: any) => void;\n}\n\nexport default function ClipForm({ onCreated }: Props) {\n const [url, setUrl] = useState(\"\");\n const [numClips, setNumClips] = useState(4);\n const [duration, setDuration] = useState(\"\");\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(\"\");\n const [mode, setMode] = useState<\"auto\" | \"manual\">(\"auto\");\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!url.trim()) return;\n setLoading(true);\n setError(\"\");\n\n try {\n const body: any = { url: url.trim(), numClips };\n if (mode === \"manual\" && duration) {\n body.manualDuration = parseDuration(duration);\n }\n const res = await fetch(\"/api/clip\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(body),\n });\n const data = await res.json();\n if (!res.ok) throw new Error(data.error || \"Failed to create clips\");\n onCreated(data);\n setUrl(\"\");\n setDuration(\"\");\n } catch (e: any) {\n setError(e.message);\n } finally {\n setLoading(false);\n }\n };\n\n return (\n

\n setMode(\"auto\")}\n class={`px-4 py-2 rounded-lg text-sm font-medium transition ${\n mode === \"auto\"\n ? \"bg-purple-600 text-white\"\n : \"bg-gray-800 text-gray-400 hover:text-white\"\n }`}\n >\n Auto Detect\n \n setMode(\"manual\")}\n class={`px-4 py-2 rounded-lg text-sm font-medium transition ${\n mode === \"manual\"\n ? \"bg-purple-600 text-white\"\n : \"bg-gray-800 text-gray-400 hover:text-white\"\n }`}\n >\n Manual Duration\n \n

\n\n

\n setUrl((e.target as HTMLInputElement).value)}\n placeholder=\"Paste YouTube or Twitch video URL...\"\n class=\"flex-1 bg-gray-800 border border-gray-700 rounded-xl px-4 py-3 text-white placeholder-gray-500 focus:outline-none focus:border-purple-500 transition\"\n required\n />\n {mode === \"manual\" && (\n setDuration((e.target as HTMLInputElement).value)}\n placeholder=\"Duration (e.g. 1:30:00)\"\n class=\"w-40 bg-gray-800 border border-gray-700 rounded-xl px-4 py-3 text-white placeholder-gray-500 focus:outline-none focus:border-purple-500 transition\"\n />\n )}\n

\n Clips:\n setNumClips(Number((e.target as HTMLSelectElement).value))}\n class=\"bg-transparent text-white font-bold text-lg focus:outline-none\"\n >\n {[2, 3, 4, 5, 6, 8, 10].map((n) => (\n \n ))}\n \n

\n \n {loading ? (\n <>\n Processing...\n \n ) : (\n <>\n Split Video\n \n )}\n \n

\n\n {error && (\n

\n {error}\n

\n )}\n\n

\n \n Auto Detect fetches video duration from YouTube. For Twitch or if auto-detect fails, use Manual Duration.\n

\n );\n}\n\nfunction parseDuration(str: string): number {\n const parts = str.split(\":\").map(Number);\n if (parts.length === 3) return parts[0] * 3600 + parts[1] * 60 + parts[2];\n if (parts.length === 2) return parts[0] * 60 + parts[1];\n return Number(str) || 0;\n}\n",[],[18,101,296],["D",1776462062708],[222,223,224],[18,101],["D",1776462027162],[221,225,226,227],[18],"093715cc-3aa6-11f1-9ec3-42b51c65c3df","queries.ts","0937169e-3aa6-11f1-9ec3-42b51c65c3df","0a5b92f7-f372-4058-b3c0-5f5ce20dcd42",4,["D",1776462021866],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function createJob(\n id: string,\n url: string,\n platform: string,\n title: string,\n duration: number,\n numClips: number,\n thumbnail: string,\n videoId: string,\n) {\n await sqlite.execute({\n sql: `INSERT INTO clip_jobs (id, url, platform, title, duration, num_clips, status, thumbnail, video_id)\n VALUES (?, ?, ?, ?, ?, ?, 'done', ?, ?)`,\n args: [id, url, platform, title, duration, numClips, thumbnail, videoId],\n });\n}\n\nexport async function createClip(\n id: string,\n jobId: string,\n partNumber: number,\n startTime: number,\n endTime: number,\n title: string,\n) {\n await sqlite.execute({\n sql: `INSERT INTO clips (id, job_id, part_number, start_time, end_time, title)\n VALUES (?, ?, ?, ?, ?, ?)`,\n args: [id, jobId, partNumber, startTime, endTime, title],\n });\n}\n\nexport async function getJobs(limit = 20) {\n const result = await sqlite.execute({\n sql: `SELECT * FROM clip_jobs ORDER BY created_at DESC LIMIT ?`,\n args: [limit],\n });\n return result.rows;\n}\n\nexport async function getJobWithClips(jobId: string) {\n const jobResult = await sqlite.execute({\n sql: `SELECT * FROM clip_jobs WHERE id = ?`,\n args: [jobId],\n });\n if (jobResult.rows.length === 0) return null;\n\n const clipsResult = await sqlite.execute({\n sql: `SELECT * FROM clips WHERE job_id = ? ORDER BY part_number ASC`,\n args: [jobId],\n });\n\n return { job: jobResult.rows[0], clips: clipsResult.rows };\n}\n\nexport async function deleteJob(jobId: string) {\n await sqlite.batch([\n { sql: `DELETE FROM clips WHERE job_id = ?`, args: [jobId] },\n { sql: `DELETE FROM clip_jobs WHERE id = ?`, args: [jobId] },\n ]);\n}\n",[],[318,310],"database","04c67442-3aa6-11f1-8c4b-42b51c65c3df","migrations.ts","04c67514-3aa6-11f1-8c4b-42b51c65c3df",3,["D",1776462014416],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function runMigrations() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS clip_jobs (\n id TEXT PRIMARY KEY,\n url TEXT NOT NULL,\n platform TEXT NOT NULL,\n title TEXT NOT NULL DEFAULT '',\n duration INTEGER NOT NULL DEFAULT 0,\n num_clips INTEGER NOT NULL DEFAULT 4,\n status TEXT NOT NULL DEFAULT 'pending',\n error TEXT,\n thumbnail TEXT DEFAULT '',\n video_id TEXT DEFAULT '',\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS clips (\n id TEXT PRIMARY KEY,\n job_id TEXT NOT NULL,\n part_number INTEGER NOT NULL,\n start_time INTEGER NOT NULL,\n end_time INTEGER NOT NULL,\n title TEXT NOT NULL DEFAULT '',\n FOREIGN KEY (job_id) REFERENCES clip_jobs(id)\n )`,\n },\n ]);\n}\n",[],[318,320],"04c69896-3aa6-11f1-8c4b-42b51c65c3df",["D",1776462014416],[218,219],[318],"39eef4a0-3aa6-11f1-bdea-42b51c65c3df","youtube.ts","39eef658-3aa6-11f1-bdea-42b51c65c3df","e473acb4-41d3-44d2-a8c4-6bd12d3dab8f",11,["D",1776462103600],"// Fetch YouTube video info using the oembed API and page scraping\nexport async function getYouTubeInfo(videoId: string): Promise<{\n title: string;\n duration: number;\n thumbnail: string;\n}> {\n // Get title from oembed\n const oembedUrl = `https://www.youtube.com/oembed?url=https://www.youtube.com/watch?v=${videoId}&format=json`;\n let title = \"YouTube Video\";\n try {\n const res = await fetch(oembedUrl);\n if (res.ok) {\n const data = await res.json();\n title = data.title || title;\n }\n } catch (_) {}\n\n const thumbnail = `https://img.youtube.com/vi/${videoId}/hqdefault.jpg`;\n\n // Try to get duration by fetching the page and looking for duration in meta\n let duration = 0;\n try {\n const pageRes = await fetch(`https://www.youtube.com/watch?v=${videoId}`, {\n headers: {\n \"User-Agent\":\n \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\",\n },\n });\n const html = await pageRes.text();\n\n // Look for \"lengthSeconds\":\"123\" pattern\n const match = html.match(/\"lengthSeconds\"\\s*:\\s*\"(\\d+)\"/);\n if (match) {\n duration = parseInt(match[1], 10);\n }\n\n // Also try approxDurationMs\n if (!duration) {\n const msMatch = html.match(/\"approxDurationMs\"\\s*:\\s*\"(\\d+)\"/);\n if (msMatch) {\n duration = Math.floor(parseInt(msMatch[1], 10) / 1000);\n }\n }\n } catch (_) {}\n\n return { title, duration, thumbnail };\n}\n",[],[340,332],"backend","39ef21c8-3aa6-11f1-bdea-42b51c65c3df",["D",1776462103600],[216],[340],["D",1776461992838],["D",1789513858534],{"_11":12,"_156":73},{"_11":12,"_152":-5,"_72":73,"_31":71,"_153":154,"_155":30},{"_42":143,"_13":16,"_36":39,"_144":105,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":14,"_151":12},"ctx",{"_56":-5,"_175":383,"_384":385,"_386":387,"_388":30,"_389":30,"_390":30,"_391":24,"_392":-5,"_393":-7,"_394":-7,"_395":26,"_396":30,"_397":30,"_398":-5,"_399":30,"_400":30,"_401":30,"_402":-5},"ENV",{"_354":355,"_356":357,"_358":16,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374,"_375":376,"_377":378,"_379":380,"_381":382},"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"]

History · frontend