[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_331":332,"_333":334},"routes/_app.x.$handle.$name",{"_99":98,"_32":46,"_108":89,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":61,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":61,"_62":61,"_63":-5,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",55,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","frontend/components/App.tsx","latestPath","fileId","01e8f31e-384d-11f0-b246-9e149126039e","name","App.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport VoiceRecorder from \"./VoiceRecorder.tsx\";\nimport VoicePlayer from \"./VoicePlayer.tsx\";\nimport Dashboard from \"./Dashboard.tsx\";\n\ndeclare global {\n interface Window {\n __VOICE_NOTE_ID__?: string;\n }\n}\n\nexport default function App() {\n const [currentView, setCurrentView] = useState<'recorder' | 'player' | 'dashboard'>('recorder');\n const voiceNoteId = window.__VOICE_NOTE_ID__;\n\n useEffect(() => {\n if (voiceNoteId) {\n setCurrentView('player');\n }\n }, [voiceNoteId]);\n\n return (\n

\n 🎙️ Voice Notes\n

\n Record, transcribe, and share voice notes with expiration controls\n

\n\n {/* Navigation */}\n {!voiceNoteId && (\n

\n setCurrentView('recorder')}\n className={`px-6 py-2 rounded-md font-medium transition-colors ${\n currentView === 'recorder'\n ? 'bg-blue-600 text-white'\n : 'bg-white text-gray-700 hover:bg-gray-50'\n }`}\n >\n 🎙️ Record\n \n setCurrentView('dashboard')}\n className={`px-6 py-2 rounded-md font-medium transition-colors ${\n currentView === 'dashboard'\n ? 'bg-blue-600 text-white'\n : 'bg-white text-gray-700 hover:bg-gray-50'\n }`}\n >\n 📋 My Notes\n \n

\n )}\n\n

\n {currentView === 'recorder' && !voiceNoteId && (\n setCurrentView('dashboard')} />\n )}\n \n {currentView === 'dashboard' && !voiceNoteId && (\n \n )}\n \n {currentView === 'player' && voiceNoteId && (\n \n )}\n

\n );\n}","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport Dashboard from \"./Dashboard.tsx\";\nimport VoicePlayer from \"./VoicePlayer.tsx\";\nimport VoiceRecorder from \"./VoiceRecorder.tsx\";\n\ndeclare global {\n interface Window {\n __VOICE_NOTE_ID__?: string;\n }\n}\n\nexport default function App() {\n const [currentView, setCurrentView] = useState<\"recorder\" | \"player\" | \"dashboard\">(\"recorder\");\n const voiceNoteId = window.__VOICE_NOTE_ID__;\n\n useEffect(() => {\n if (voiceNoteId) {\n setCurrentView(\"player\");\n }\n }, [voiceNoteId]);\n\n return (\n

\n 🎙️ Voice Messages\n

\n Record, transcribe, and share voice notes with expiration controls\n

\n\n {/* Navigation */}\n {!voiceNoteId && (\n

\n setCurrentView(\"recorder\")}\n className={`px-6 py-2 rounded-md font-medium transition-colors ${\n currentView === \"recorder\"\n ? \"bg-blue-600 text-white\"\n : \"bg-white text-gray-700 hover:bg-gray-50\"\n }`}\n >\n 🎙️ Record\n \n setCurrentView(\"dashboard\")}\n className={`px-6 py-2 rounded-md font-medium transition-colors ${\n currentView === \"dashboard\"\n ? \"bg-blue-600 text-white\"\n : \"bg-white text-gray-700 hover:bg-gray-50\"\n }`}\n >\n 📋 My Messages\n \n

\n )}\n\n

\n {currentView === \"recorder\" && !voiceNoteId && (\n setCurrentView(\"dashboard\")} />\n )}\n\n {currentView === \"dashboard\" && !voiceNoteId && }\n\n {currentView === \"player\" && voiceNoteId && }\n

\n );\n}","createdAt",["D",1749000199032],"branchVersion","branchId","91599d6a-384c-11f0-8086-9e149126039e","id","91595864-384c-11f0-8086-9e149126039e","voicemessages",["D",1748056195569],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Record, transcribe, and share voice notes","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/18bff8bf-ce15-4f5b-07b9-ea79b4736400/square512?exp=1789534799&sig=fbf5c965a20e2acb54ffcf5496c7396edf408c7c7e67748dd91085e5fc481ad4","35ef5666-3780-42d5-ade0-86fe3fdb6bb1","pinnedFileId","f2ac5c74-384c-11f0-b09d-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",5,"orgId","47e0b4b2-7d41-46e6-8dce-0ae3d76e1a8f","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":57,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"isOwned",58,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","cameronpak","handle","displayName","Cam","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/7fcc9ac1-f8fb-41e2-0168-af29ef7c6400/square512?exp=1789534799&sig=b8783851cb800029806b3df783abeccfd2aeeb94607d545bdfb07a445ccd18e6","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":327,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":61,"_62":61,"_63":-5,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":328,"_83":329,"_85":330,"_87":25},"tree",[176,184,193,195],"files",[176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195],"counts",{"_164":149,"_165":141,"_166":167,"_168":169,"_170":171},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":158,"_32":159,"_30":160,"_137":-5,"_42":43,"_41":161,"_139":61,"_39":162,"_13":149,"_34":150,"_36":-5,"_24":25,"_143":-5,"_27":163},{"_44":152,"_32":153,"_30":154,"_137":-5,"_42":43,"_41":155,"_139":61,"_39":156,"_13":149,"_34":150,"_36":-5,"_24":25,"_143":-5,"_27":157},{"_44":145,"_32":146,"_30":147,"_137":-5,"_42":43,"_41":141,"_139":61,"_39":148,"_13":149,"_34":150,"_36":-5,"_24":25,"_143":-5,"_27":151},{"_44":134,"_32":135,"_30":136,"_137":-5,"_42":43,"_41":138,"_139":61,"_39":140,"_13":141,"_34":20,"_36":142,"_24":25,"_143":-5,"_27":144},"cbedbeb0-384d-11f0-9704-9e149126039e","README.md","ce4351da-384c-11f0-b5cf-9e149126039e","parentId",25,"latest",["D",1748056723340],2,"# Voice Notes App\n\nA web application for recording, transcribing, and sharing voice notes with expiration controls.\n\n## Features\n\n- 🎙️ Record voice notes directly in the browser\n- 🤖 AI-powered transcription using OpenAI Whisper\n- 🔗 Share voice notes via unique URLs\n- ⏰ Set expiration by max listens or date\n- 📋 Dashboard to view and manage all your voice notes\n- 🗑️ Delete voice notes you no longer need\n- 📱 Responsive design with modern UI\n\n## User Stories\n\n- I can record a voice note\n- Given I record a voice note, it is transcribed by AI\n- Given I have recorded a voice note, I can share that voice note with someone via URL\n- I can set an expiration for the voice note by number of max listens (i.e. 1 listen)\n- Or, I can set an expiration for the voice note by choosing an expiration date\n- I can see which voice notes I have sent\n- I can delete voice notes I no longer need\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ ├── routes/\n│ │ ├── voicenotes.ts # Voice note CRUD operations\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ ├── VoiceRecorder.tsx # Recording interface\n│ │ ├── VoicePlayer.tsx # Playback interface\n│ │ ├── ShareModal.tsx # Sharing configuration\n│ │ └── Dashboard.tsx # Voice notes management\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend entry point\n│ └── style.css # Custom styles\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Tech Stack\n\n- **Backend**: Hono (TypeScript API framework)\n- **Database**: SQLite for voice note metadata\n- **Storage**: Val Town Blob storage for audio files\n- **AI**: OpenAI Whisper for transcription\n- **Frontend**: React with TypeScript\n- **Styling**: TailwindCSS","label",[135],"d1bbdf8a-384c-11f0-a838-9e149126039e","shared","9bbd557d-4fef-4efa-8282-7d9b38cff9ef",["D",1748056303584],0,"directory",[146],"f7ecc91c-384c-11f0-a5c1-9e149126039e","frontend","1e39a404-6c56-4f79-a627-ad7b7b74cbf3",8,["D",1748056367659],[153],"d547d262-384c-11f0-a8cb-9e149126039e","backend","fd77e1da-7e08-4cd5-879c-1f60a7a7fcf8",3,["D",1748056309532],[159],"pulls","branches","forks",6,"envVars",{"_172":174,"_175":149},"connections",{"_172":149,"_173":149},"count","unfilledCount",1,"emptyCount",{"_44":158,"_32":159,"_30":160,"_137":-5,"_42":43,"_41":161,"_139":61,"_39":324,"_13":149,"_34":150,"_36":-5,"_24":25,"_143":-5,"_197":325,"_27":326},{"_44":320,"_32":311,"_30":305,"_137":160,"_42":43,"_41":161,"_139":61,"_39":321,"_13":149,"_34":150,"_36":-5,"_24":25,"_143":-5,"_197":322,"_27":323},{"_44":312,"_32":313,"_30":314,"_137":305,"_42":43,"_41":315,"_139":61,"_39":316,"_13":174,"_34":35,"_36":317,"_24":25,"_143":-5,"_197":318,"_27":319},{"_44":302,"_32":303,"_30":304,"_137":305,"_42":43,"_41":306,"_139":61,"_39":307,"_13":213,"_34":35,"_36":308,"_24":25,"_143":-5,"_197":309,"_27":310},{"_44":298,"_32":290,"_30":283,"_137":160,"_42":43,"_41":65,"_139":61,"_39":299,"_13":149,"_34":150,"_36":-5,"_24":25,"_143":-5,"_197":300,"_27":301},{"_44":291,"_32":292,"_30":293,"_137":283,"_42":43,"_41":167,"_139":61,"_39":294,"_13":149,"_34":35,"_36":295,"_24":25,"_143":-5,"_197":296,"_27":297},{"_44":280,"_32":281,"_30":282,"_137":283,"_42":43,"_41":284,"_139":61,"_39":285,"_13":286,"_34":35,"_36":287,"_24":25,"_143":-5,"_197":288,"_27":289},{"_44":272,"_32":273,"_30":59,"_137":160,"_42":43,"_41":274,"_139":61,"_39":275,"_13":161,"_34":276,"_36":277,"_24":25,"_143":-5,"_197":278,"_27":279},{"_44":152,"_32":153,"_30":154,"_137":-5,"_42":43,"_41":155,"_139":61,"_39":269,"_13":149,"_34":150,"_36":-5,"_24":25,"_143":-5,"_197":270,"_27":271},{"_44":264,"_32":235,"_30":229,"_137":154,"_42":43,"_41":265,"_139":61,"_39":266,"_13":149,"_34":150,"_36":-5,"_24":25,"_143":-5,"_197":267,"_27":268},{"_44":260,"_32":33,"_30":31,"_137":229,"_42":43,"_41":14,"_139":61,"_39":261,"_13":141,"_34":35,"_36":38,"_24":25,"_143":-5,"_197":262,"_27":263},{"_44":252,"_32":253,"_30":254,"_137":229,"_42":43,"_41":255,"_139":25,"_39":256,"_13":149,"_34":35,"_36":257,"_24":25,"_143":-5,"_197":258,"_27":259},{"_44":244,"_32":245,"_30":246,"_137":229,"_42":43,"_41":247,"_139":61,"_39":248,"_13":149,"_34":35,"_36":249,"_24":25,"_143":-5,"_197":250,"_27":251},{"_44":236,"_32":237,"_30":238,"_137":229,"_42":43,"_41":239,"_139":25,"_39":240,"_13":149,"_34":35,"_36":241,"_24":25,"_143":-5,"_197":242,"_27":243},{"_44":226,"_32":227,"_30":228,"_137":229,"_42":43,"_41":230,"_139":25,"_39":231,"_13":141,"_34":35,"_36":232,"_24":25,"_143":-5,"_197":233,"_27":234},{"_44":218,"_32":219,"_30":220,"_137":154,"_42":43,"_41":221,"_139":61,"_39":222,"_13":141,"_34":20,"_36":223,"_24":25,"_143":-5,"_197":224,"_27":225},{"_44":210,"_32":211,"_30":212,"_137":154,"_42":43,"_41":213,"_139":61,"_39":214,"_13":149,"_34":35,"_36":215,"_24":25,"_143":-5,"_197":216,"_27":217},{"_44":145,"_32":146,"_30":147,"_137":-5,"_42":43,"_41":141,"_139":61,"_39":207,"_13":149,"_34":150,"_36":-5,"_24":25,"_143":-5,"_197":208,"_27":209},{"_44":200,"_32":201,"_30":202,"_137":147,"_42":43,"_41":141,"_139":61,"_39":203,"_13":149,"_34":35,"_36":204,"_24":25,"_143":-5,"_197":205,"_27":206},{"_44":134,"_32":135,"_30":136,"_137":-5,"_42":43,"_41":138,"_139":61,"_39":196,"_13":141,"_34":20,"_36":142,"_24":25,"_143":-5,"_197":198,"_27":199},["D",1748056723340],"children",[],[135],"d1bba470-384c-11f0-a838-9e149126039e","types.ts","d1bba524-384c-11f0-a838-9e149126039e",["D",1748056303584],"// Shared types for voice notes app\n\nexport interface VoiceNote {\n id: string;\n title?: string;\n audioUrl: string;\n transcription?: string;\n duration: number; // in seconds\n createdAt: string;\n expiresAt?: string; // ISO date string\n maxListens?: number;\n currentListens: number;\n isExpired: boolean;\n}\n\nexport interface CreateVoiceNoteRequest {\n audioBlob: Blob;\n title?: string;\n expiresAt?: string;\n maxListens?: number;\n}\n\nexport interface ShareSettings {\n expiresAt?: string;\n maxListens?: number;\n}\n\nexport interface VoiceNoteResponse {\n success: boolean;\n voiceNote?: VoiceNote;\n shareUrl?: string;\n error?: string;\n}\n\nexport interface TranscriptionResponse {\n success: boolean;\n transcription?: string;\n error?: string;\n}",[],[146,201],["D",1748056303584],[194],[146],"fa30946a-384c-11f0-b0d1-9e149126039e","index.tsx","fa30955a-384c-11f0-b0d1-9e149126039e",9,["D",1748056371459],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();",[],[153,211],"76a23f42-40e2-11f0-9bef-76b3cceeab13","index.html","f7eca9dc-384c-11f0-a5c1-9e149126039e",54,["D",1749000184550],"\n\n \n \n \n Voice Messages\n \n \n \n \n \n

\n \n \n",[],[153,219],"b6a68d16-384d-11f0-b6e9-9e149126039e","VoiceRecorder.tsx","1928f86c-384d-11f0-935b-9e149126039e","416b3093-5329-4e77-86bd-ab402b16fd19",19,["D",1748056687639],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useRef, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport ShareModal from \"./ShareModal.tsx\";\nimport type { VoiceNote, ShareSettings } from \"../../shared/types.ts\";\n\ninterface RecordingState {\n isRecording: boolean;\n isPaused: boolean;\n duration: number;\n audioBlob: Blob | null;\n audioUrl: string | null;\n}\n\ninterface VoiceRecorderProps {\n onVoiceNoteCreated?: () => void;\n}\n\nexport default function VoiceRecorder({ onVoiceNoteCreated }: VoiceRecorderProps) {\n const [recordingState, setRecordingState] = useState({\n isRecording: false,\n isPaused: false,\n duration: 0,\n audioBlob: null,\n audioUrl: null\n });\n \n const [title, setTitle] = useState(\"\");\n const [isUploading, setIsUploading] = useState(false);\n const [showShareModal, setShowShareModal] = useState(false);\n const [createdVoiceNote, setCreatedVoiceNote] = useState(null);\n const [shareUrl, setShareUrl] = useState(\"\");\n \n const mediaRecorderRef = useRef(null);\n const audioChunksRef = useRef([]);\n const timerRef = useRef(null);\n const streamRef = useRef(null);\n\n useEffect(() => {\n return () => {\n if (timerRef.current) {\n clearInterval(timerRef.current);\n }\n if (streamRef.current) {\n streamRef.current.getTracks().forEach(track => track.stop());\n }\n };\n }, []);\n\n const startRecording = async () => {\n try {\n const stream = await navigator.mediaDevices.getUserMedia({ audio: true });\n streamRef.current = stream;\n \n const mediaRecorder = new MediaRecorder(stream);\n mediaRecorderRef.current = mediaRecorder;\n audioChunksRef.current = [];\n\n mediaRecorder.ondataavailable = (event) => {\n if (event.data.size > 0) {\n audioChunksRef.current.push(event.data);\n }\n };\n\n mediaRecorder.onstop = () => {\n const audioBlob = new Blob(audioChunksRef.current, { type: 'audio/webm' });\n const audioUrl = URL.createObjectURL(audioBlob);\n \n setRecordingState(prev => ({\n ...prev,\n audioBlob,\n audioUrl,\n isRecording: false\n }));\n };\n\n mediaRecorder.start();\n \n setRecordingState(prev => ({\n ...prev,\n isRecording: true,\n isPaused: false,\n duration: 0\n }));\n\n // Start timer\n timerRef.current = setInterval(() => {\n setRecordingState(prev => ({\n ...prev,\n duration: prev.duration + 1\n }));\n }, 1000);\n\n } catch (error) {\n console.error('Error starting recording:', error);\n alert('Could not access microphone. Please check permissions.');\n }\n };\n\n const stopRecording = () => {\n if (mediaRecorderRef.current && recordingState.isRecording) {\n mediaRecorderRef.current.stop();\n \n if (timerRef.current) {\n clearInterval(timerRef.current);\n timerRef.current = null;\n }\n \n if (streamRef.current) {\n streamRef.current.getTracks().forEach(track => track.stop());\n }\n }\n };\n\n const resetRecording = () => {\n if (recordingState.audioUrl) {\n URL.revokeObjectURL(recordingState.audioUrl);\n }\n \n setRecordingState({\n isRecording: false,\n isPaused: false,\n duration: 0,\n audioBlob: null,\n audioUrl: null\n });\n \n setTitle(\"\");\n };\n\n const handleSave = (shareSettings: ShareSettings) => {\n if (!recordingState.audioBlob) return;\n \n setIsUploading(true);\n \n const formData = new FormData();\n formData.append('audio', recordingState.audioBlob, 'recording.webm');\n formData.append('title', title);\n formData.append('duration', recordingState.duration.toString());\n \n if (shareSettings.expiresAt) {\n formData.append('expiresAt', shareSettings.expiresAt);\n }\n \n if (shareSettings.maxListens) {\n formData.append('maxListens', shareSettings.maxListens.toString());\n }\n\n fetch('/api/voicenotes', {\n method: 'POST',\n body: formData\n })\n .then(response => response.json())\n .then(data => {\n if (data.success) {\n setCreatedVoiceNote(data.voiceNote);\n setShareUrl(data.shareUrl);\n setShowShareModal(false);\n resetRecording();\n } else {\n alert('Error saving voice note: ' + data.error);\n }\n })\n .catch(error => {\n console.error('Error saving voice note:', error);\n alert('Error saving voice note');\n })\n .finally(() => {\n setIsUploading(false);\n });\n };\n\n const formatDuration = (seconds: number) => {\n const mins = Math.floor(seconds / 60);\n const secs = seconds % 60;\n return `${mins}:${secs.toString().padStart(2, '0')}`;\n };\n\n const copyToClipboard = async (text: string) => {\n try {\n await navigator.clipboard.writeText(text);\n alert('Link copied to clipboard!');\n } catch (error) {\n console.error('Failed to copy:', error);\n }\n };\n\n if (createdVoiceNote) {\n return (\n

✅

\n Voice Note Created!\n

\n Your voice note has been saved and is being transcribed.\n

\n \n

Share this link:

\n \n copyToClipboard(shareUrl)}\n className=\"px-4 py-2 bg-blue-600 text-white rounded-md hover:bg-blue-700 text-sm\"\n >\n Copy\n \n

\n \n {\n setCreatedVoiceNote(null);\n setShareUrl(\"\");\n onVoiceNoteCreated?.();\n }}\n className=\"px-6 py-2 bg-gray-600 text-white rounded-md hover:bg-gray-700\"\n >\n View All Notes\n \n

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

\n {!recordingState.isRecording && !recordingState.audioBlob && (\n <>\n

🎙️

\n Ready to Record\n

\n Click the button below to start recording your voice note\n

\n \n Start Recording\n \n \n )}\n\n {recordingState.isRecording && (\n <>\n

🔴

\n Recording...\n

\n {formatDuration(recordingState.duration)}\n

\n \n Stop Recording\n \n \n )}\n\n {recordingState.audioBlob && (\n <>\n

🎵

\n Recording Complete\n

\n Duration: {formatDuration(recordingState.duration)}\n

\n \n \n \n

\n \n Title (optional)\n \n setTitle(e.target.value)}\n placeholder=\"Enter a title for your voice note\"\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n \n

\n \n Re-record\n \n setShowShareModal(true)}\n disabled={isUploading}\n className=\"px-6 py-2 bg-blue-600 text-white rounded-md hover:bg-blue-700 disabled:opacity-50\"\n >\n {isUploading ? 'Saving...' : 'Save & Share'}\n \n

\n \n )}\n

\n\n {showShareModal && (\n setShowShareModal(false)}\n isUploading={isUploading}\n />\n )}\n

\n );\n}",[],[153,235,227],"components","372226ea-384d-11f0-b669-9e149126039e","VoicePlayer.tsx","372227b2-384d-11f0-b669-9e149126039e",13,["D",1748056473707],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { VoiceNote } from \"../../shared/types.ts\";\n\ninterface VoicePlayerProps {\n voiceNoteId: string;\n}\n\nexport default function VoicePlayer({ voiceNoteId }: VoicePlayerProps) {\n const [voiceNote, setVoiceNote] = useState(null);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n const [audioUrl, setAudioUrl] = useState(null);\n\n useEffect(() => {\n fetchVoiceNote();\n }, [voiceNoteId]);\n\n const fetchVoiceNote = async () => {\n try {\n setLoading(true);\n const response = await fetch(`/api/voicenotes/${voiceNoteId}`);\n const data = await response.json();\n \n if (data.success) {\n setVoiceNote(data.voiceNote);\n // Get audio URL\n setAudioUrl(`/api/voicenotes/${voiceNoteId}/audio`);\n } else {\n setError(data.error || 'Voice note not found');\n }\n } catch (err) {\n setError('Failed to load voice note');\n console.error('Error fetching voice note:', err);\n } finally {\n setLoading(false);\n }\n };\n\n const formatDuration = (seconds: number) => {\n const mins = Math.floor(seconds / 60);\n const secs = seconds % 60;\n return `${mins}:${secs.toString().padStart(2, '0')}`;\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'long',\n day: 'numeric',\n hour: '2-digit',\n minute: '2-digit'\n });\n };\n\n const getExpirationInfo = () => {\n if (!voiceNote) return null;\n \n if (voiceNote.isExpired) {\n return {\n text: \"This voice note has expired\",\n color: \"text-red-600\",\n icon: \"⚠️\"\n };\n }\n \n if (voiceNote.expiresAt) {\n const expiresDate = new Date(voiceNote.expiresAt);\n const now = new Date();\n const timeLeft = expiresDate.getTime() - now.getTime();\n const daysLeft = Math.ceil(timeLeft / (1000 * 60 * 60 * 24));\n \n return {\n text: `Expires on ${formatDate(voiceNote.expiresAt)} (${daysLeft} day${daysLeft !== 1 ? 's' : ''} left)`,\n color: daysLeft <= 1 ? \"text-orange-600\" : \"text-gray-600\",\n icon: \"⏰\"\n };\n }\n \n if (voiceNote.maxListens) {\n const listensLeft = voiceNote.maxListens - voiceNote.currentListens;\n return {\n text: `${listensLeft} listen${listensLeft !== 1 ? 's' : ''} remaining (${voiceNote.currentListens}/${voiceNote.maxListens} used)`,\n color: listensLeft <= 1 ? \"text-orange-600\" : \"text-gray-600\",\n icon: \"👂\"\n };\n }\n \n return null;\n };\n\n const copyToClipboard = async (text: string) => {\n try {\n await navigator.clipboard.writeText(text);\n alert('Transcription copied to clipboard!');\n } catch (error) {\n console.error('Failed to copy:', error);\n }\n };\n\n if (loading) {\n return (\n

⏳

\n Loading Voice Note...\n

\n );\n }\n\n if (error) {\n return (\n

❌

\n Error\n

{error}

\n window.location.href = '/'}\n className=\"px-6 py-2 bg-blue-600 text-white rounded-md hover:bg-blue-700\"\n >\n Go Home\n \n

\n );\n }\n\n if (!voiceNote) {\n return null;\n }\n\n const expirationInfo = getExpirationInfo();\n\n return (\n

🎵

\n {voiceNote.title || 'Voice Note'}\n

\n Created {formatDate(voiceNote.createdAt)}\n

\n Duration: {formatDuration(voiceNote.duration)}\n

\n\n {expirationInfo && (\n

\n {expirationInfo.icon} {expirationInfo.text}\n

\n )}\n\n {!voiceNote.isExpired && audioUrl && (\n

\n \n

\n )}\n\n {voiceNote.isExpired && (\n

\n This voice note has expired and can no longer be played.\n

\n )}\n\n {voiceNote.transcription && (\n

Transcription

\n copyToClipboard(voiceNote.transcription!)}\n className=\"text-sm text-blue-600 hover:text-blue-800 underline\"\n >\n Copy\n \n

\n {voiceNote.transcription}\n

\n )}\n\n {!voiceNote.transcription && !voiceNote.isExpired && (\n

\n 🤖 Transcription in progress... Refresh the page in a moment to see the text.\n

\n )}\n\n

\n window.location.href = '/'}\n className=\"px-6 py-2 bg-blue-600 text-white rounded-md hover:bg-blue-700\"\n >\n Create Your Own Voice Note\n \n

\n );\n}",[],[153,235,237],"24cc64f6-384d-11f0-a787-9e149126039e","ShareModal.tsx","24cc65be-384d-11f0-a787-9e149126039e",12,["D",1748056442945],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { ShareSettings } from \"../../shared/types.ts\";\n\ninterface ShareModalProps {\n onSave: (settings: ShareSettings) => void;\n onCancel: () => void;\n isUploading: boolean;\n}\n\nexport default function ShareModal({ onSave, onCancel, isUploading }: ShareModalProps) {\n const [expirationType, setExpirationType] = useState<'none' | 'date' | 'listens'>('none');\n const [expirationDate, setExpirationDate] = useState('');\n const [maxListens, setMaxListens] = useState(1);\n\n const handleSave = () => {\n const settings: ShareSettings = {};\n \n if (expirationType === 'date' && expirationDate) {\n settings.expiresAt = new Date(expirationDate).toISOString();\n } else if (expirationType === 'listens') {\n settings.maxListens = maxListens;\n }\n \n onSave(settings);\n };\n\n const getTomorrowDate = () => {\n const tomorrow = new Date();\n tomorrow.setDate(tomorrow.getDate() + 1);\n return tomorrow.toISOString().split('T')[0];\n };\n\n return (\n

\n Share Settings\n

\n \n

\n \n Expiration Settings\n \n \n

\n \n setExpirationType(e.target.value as 'none')}\n className=\"mr-2\"\n />\n No expiration\n \n \n \n setExpirationType(e.target.value as 'date')}\n className=\"mr-2\"\n />\n Expire on date\n \n \n {expirationType === 'date' && (\n

\n setExpirationDate(e.target.value)}\n min={getTomorrowDate()}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n )}\n \n \n setExpirationType(e.target.value as 'listens')}\n className=\"mr-2\"\n />\n Expire after listens\n \n \n {expirationType === 'listens' && (\n

\n setMaxListens(parseInt(e.target.value) || 1)}\n min=\"1\"\n max=\"100\"\n className=\"w-20 px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n \n listen{maxListens !== 1 ? 's' : ''}\n \n

\n )}\n

\n \n

\n \n Cancel\n \n \n {isUploading ? 'Saving...' : 'Save & Share'}\n \n

\n );\n}",[],[153,235,245],"a52a05e0-384d-11f0-aa48-9e149126039e","Dashboard.tsx","a52a06b2-384d-11f0-aa48-9e149126039e",16,["D",1748056658307],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { VoiceNote } from \"../../shared/types.ts\";\n\nexport default function Dashboard() {\n const [voiceNotes, setVoiceNotes] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n useEffect(() => {\n fetchVoiceNotes();\n }, []);\n\n const fetchVoiceNotes = async () => {\n try {\n setLoading(true);\n const response = await fetch('/api/voicenotes');\n const data = await response.json();\n \n if (data.success) {\n setVoiceNotes(data.voiceNotes || []);\n } else {\n setError(data.error || 'Failed to fetch voice notes');\n }\n } catch (err) {\n setError('Failed to load voice notes');\n console.error('Error fetching voice notes:', err);\n } finally {\n setLoading(false);\n }\n };\n\n const formatDuration = (seconds: number) => {\n const mins = Math.floor(seconds / 60);\n const secs = seconds % 60;\n return `${mins}:${secs.toString().padStart(2, '0')}`;\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric',\n hour: '2-digit',\n minute: '2-digit'\n });\n };\n\n const getStatusInfo = (voiceNote: VoiceNote) => {\n if (voiceNote.isExpired) {\n return {\n text: \"Expired\",\n color: \"text-red-600 bg-red-50\",\n icon: \"⚠️\"\n };\n }\n \n if (voiceNote.expiresAt) {\n const expiresDate = new Date(voiceNote.expiresAt);\n const now = new Date();\n const timeLeft = expiresDate.getTime() - now.getTime();\n const daysLeft = Math.ceil(timeLeft / (1000 * 60 * 60 * 24));\n \n if (daysLeft <= 1) {\n return {\n text: `Expires soon (${daysLeft} day${daysLeft !== 1 ? 's' : ''})`,\n color: \"text-orange-600 bg-orange-50\",\n icon: \"⏰\"\n };\n }\n \n return {\n text: `Expires in ${daysLeft} days`,\n color: \"text-blue-600 bg-blue-50\",\n icon: \"⏰\"\n };\n }\n \n if (voiceNote.maxListens) {\n const listensLeft = voiceNote.maxListens - voiceNote.currentListens;\n \n if (listensLeft <= 1) {\n return {\n text: `${listensLeft} listen${listensLeft !== 1 ? 's' : ''} left`,\n color: \"text-orange-600 bg-orange-50\",\n icon: \"👂\"\n };\n }\n \n return {\n text: `${listensLeft}/${voiceNote.maxListens} listens left`,\n color: \"text-blue-600 bg-blue-50\",\n icon: \"👂\"\n };\n }\n \n return {\n text: \"Active\",\n color: \"text-green-600 bg-green-50\",\n icon: \"✅\"\n };\n };\n\n const copyShareUrl = async (voiceNoteId: string) => {\n const shareUrl = `${window.location.origin}/note/${voiceNoteId}`;\n try {\n await navigator.clipboard.writeText(shareUrl);\n alert('Share link copied to clipboard!');\n } catch (error) {\n console.error('Failed to copy:', error);\n // Fallback: show the URL in a prompt\n prompt('Copy this link:', shareUrl);\n }\n };\n\n const deleteVoiceNote = async (voiceNoteId: string) => {\n if (!confirm('Are you sure you want to delete this voice note? This action cannot be undone.')) {\n return;\n }\n \n try {\n const response = await fetch(`/api/voicenotes/${voiceNoteId}`, {\n method: 'DELETE'\n });\n \n const data = await response.json();\n \n if (data.success) {\n setVoiceNotes(prev => prev.filter(note => note.id !== voiceNoteId));\n } else {\n alert('Failed to delete voice note: ' + data.error);\n }\n } catch (error) {\n console.error('Error deleting voice note:', error);\n alert('Failed to delete voice note');\n }\n };\n\n if (loading) {\n return (\n

⏳

\n Loading Your Voice Notes...\n

\n );\n }\n\n if (error) {\n return (\n

❌

\n Error\n

{error}

\n \n Try Again\n \n

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

\n 📋 Your Voice Notes\n

\n \n Refresh\n \n

\n\n {voiceNotes.length === 0 ? (\n

🎙️

\n No Voice Notes Yet\n

\n Create your first voice note to see it here!\n

\n ) : (\n

\n {voiceNotes.map((voiceNote) => {\n const statusInfo = getStatusInfo(voiceNote);\n \n return (\n \n

\n {voiceNote.title || 'Untitled Voice Note'}\n

\n Created {formatDate(voiceNote.createdAt)} • {formatDuration(voiceNote.duration)}\n

\n \n \n {statusInfo.icon} {statusInfo.text}\n \n

\n\n {voiceNote.transcription && (\n

\n {voiceNote.transcription}\n

\n )}\n\n

\n 👂 {voiceNote.currentListens} listen{voiceNote.currentListens !== 1 ? 's' : ''}\n {voiceNote.maxListens && (\n 📊 {voiceNote.maxListens} max\n )}\n {voiceNote.expiresAt && (\n ⏰ Expires {formatDate(voiceNote.expiresAt)}\n )}\n

\n \n

\n window.open(`/note/${voiceNote.id}`, '_blank')}\n className=\"px-3 py-1 bg-blue-100 text-blue-700 rounded hover:bg-blue-200\"\n >\n View\n \n copyShareUrl(voiceNote.id)}\n className=\"px-3 py-1 bg-green-100 text-green-700 rounded hover:bg-green-200\"\n >\n Share\n \n deleteVoiceNote(voiceNote.id)}\n className=\"px-3 py-1 bg-red-100 text-red-700 rounded hover:bg-red-200\"\n >\n Delete\n \n

\n );\n })}\n

\n )}\n \n );\n}",[],[153,235,253],"7f44163e-40e2-11f0-b209-76b3cceeab13",["D",1749000199032],[],[153,235,33],"01e8f90e-384d-11f0-b246-9e149126039e",10,["D",1748056384411],[186,187,188,189,190],[153,235],["D",1748056367659],[185,191,192],[153],"63ff7f90-384e-11f0-865c-9e149126039e","index.ts",34,["D",1748056978470],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport voiceNotesRoutes from \"./routes/voicenotes.ts\";\nimport staticRoutes from \"./routes/static.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Run database migrations on startup\ntry {\n await runMigrations();\n console.log(\"Migrations completed successfully\");\n} catch (error) {\n console.error(\"Migration failed:\", error);\n}\n\n// Mount routes\napp.route(\"/api/voicenotes\", voiceNotesRoutes);\napp.route(\"/\", staticRoutes);\n\nexport default app.fetch;",[],[159,273],"9d591b2a-40e1-11f0-8fee-76b3cceeab13","voicenotes.ts","eac31188-384c-11f0-98a6-9e149126039e","90e6d12d-8bf4-440f-abdd-2f873fa0c011",53,["D",1748999820006],20,"import { type Context, Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport Groq from \"npm:groq-sdk\";\nimport type { TranscriptionResponse, VoiceNote, VoiceNoteResponse } from \"../../shared/types.ts\";\nimport { TABLE_NAME } from \"../database/migrations.ts\";\nimport {\n createVoiceNote,\n deleteVoiceNote,\n getAllVoiceNotes,\n getVoiceNote,\n incrementListenCount,\n updateTranscription,\n} from \"../database/queries.ts\";\n\nconst app = new Hono();\nconst openai = new OpenAI();\n\n// Get all voice notes (for admin/dashboard)\napp.get(\"/\", async (c) => {\n try {\n const voiceNotes = await getAllVoiceNotes();\n return c.json({ success: true, voiceNotes });\n } catch (error) {\n console.error(\"Error fetching voice notes:\", error);\n return c.json({ success: true, voiceNotes: [] });\n }\n});\n\n// Create a new voice note\napp.post(\"/\", async (c) => {\n try {\n const formData = await c.req.formData();\n const audioFile = formData.get(\"audio\") as File;\n const title = formData.get(\"title\") as string;\n const duration = formData.get(\"duration\") as string;\n const expiresAt = formData.get(\"expiresAt\") as string;\n const maxListens = formData.get(\"maxListens\") as string;\n\n if (!audioFile) {\n return c.json({ success: false, error: \"No audio file provided\" }, 400);\n }\n\n // Generate unique ID\n const id = crypto.randomUUID();\n const blobKey = `voice_note_${id}`;\n\n // Store audio file in blob storage\n const audioBuffer = await audioFile.arrayBuffer();\n await blob.set(blobKey, new Uint8Array(audioBuffer));\n\n // Create voice note record\n const voiceNote: Omit = {\n id,\n title: title || undefined,\n audioUrl: blobKey,\n duration: duration ? parseInt(duration) : 0,\n createdAt: new Date().toISOString(),\n expiresAt: expiresAt || undefined,\n maxListens: maxListens ? parseInt(maxListens) : undefined,\n currentListens: 0,\n };\n\n await createVoiceNote(voiceNote);\n\n // Start transcription in background\n transcribeAudio(id, audioBuffer).catch(console.error);\n\n const shareUrl = `${new URL(c.req.url).origin}/note/${id}`;\n\n return c.json({\n success: true,\n voiceNote: { ...voiceNote, isExpired: false },\n shareUrl,\n });\n } catch (error) {\n console.error(\"Error creating voice note:\", error);\n return c.json({ success: false, error: \"Failed to create voice note\" }, 500);\n }\n});\n\n// Get a voice note by ID\napp.get(\"/:id\", async (c) => {\n try {\n const id = c.req.param(\"id\");\n const voiceNote = await getVoiceNote(id);\n\n if (!voiceNote) {\n return c.json({ success: false, error: \"Voice note not found\" }, 404);\n }\n\n if (voiceNote.isExpired) {\n return c.json({ success: false, error: \"Voice note has expired\" }, 410);\n }\n\n return c.json({ success: true, voiceNote });\n } catch (error) {\n console.error(\"Error fetching voice note:\", error);\n return c.json({ success: false, error: \"Failed to fetch voice note\" }, 500);\n }\n});\n\n// Get audio file for a voice note\napp.get(\"/:id/audio\", async (c: Context) => {\n try {\n const id = c.req.param(\"id\");\n const voiceNote = await getVoiceNote(id);\n\n if (!voiceNote) {\n return c.json({ success: false, error: \"Voice note not found\" }, 404);\n }\n\n if (voiceNote.isExpired) {\n return c.json({ success: false, error: \"Voice note has expired\" }, 410);\n }\n\n // Increment listen count\n await incrementListenCount(id);\n\n // Check if audio file exists in blob storage\n if (!voiceNote.audioUrl) {\n return c.json({ success: false, error: \"Audio file not found\" }, 404);\n }\n\n // Get audio from blob storage\n const audioStream = await blob.get(voiceNote.audioUrl);\n\n if (!audioStream) {\n return c.json({ success: false, error: \"Audio file not found\" }, 404);\n }\n\n const audioArrayBuffer = await audioStream.arrayBuffer();\n\n // Set headers\n c.header(\"Content-Type\", \"audio/webm\");\n c.header(\"Content-Length\", audioArrayBuffer.byteLength.toString());\n\n // Send the buffer as the response\n return new Response(audioArrayBuffer, {\n headers: c.headers,\n });\n } catch (error) {\n console.error(\"Error serving audio:\", error);\n return c.json({ success: false, error: \"Failed to serve audio\" }, 500);\n }\n});\n\nconst groq = new Groq({\n apiKey: Deno.env.get(\"GROQ_API_KEY\") || \"\",\n});\n// Background transcription function\nasync function transcribeAudio(voiceNoteId: string, audioBuffer: ArrayBuffer) {\n try {\n // Convert ArrayBuffer to File for OpenAI\n const audioFile = new File([audioBuffer], \"audio.webm\", { type: \"audio/webm\" });\n\n const transcription = await groq.audio.transcriptions.create({\n file: audioFile,\n model: \"whisper-large-v3-turbo\",\n response_format: \"verbose_json\",\n });\n\n await updateTranscription(voiceNoteId, transcription.text);\n console.log(`Transcription completed for voice note ${voiceNoteId}`);\n } catch (error) {\n console.error(`Transcription failed for voice note ${voiceNoteId}:`, error);\n }\n}\n\n// Delete a voice note\napp.delete(\"/:id\", async (c) => {\n try {\n const id = c.req.param(\"id\");\n const voiceNote = await getVoiceNote(id);\n\n if (!voiceNote) {\n return c.json({ success: false, error: \"Voice note not found\" }, 404);\n }\n\n // Delete audio from blob storage\n try {\n await blob.delete(voiceNote.audioUrl);\n } catch (error) {\n console.warn(\"Failed to delete audio blob:\", error);\n }\n\n // Delete from database\n await deleteVoiceNote(id);\n\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error deleting voice note:\", error);\n return c.json({ success: false, error: \"Failed to delete voice note\" }, 500);\n }\n});\n\nexport default app;",[],[159,290,281],"routes","ef927280-384c-11f0-b913-9e149126039e","static.ts","ef927352-384c-11f0-b913-9e149126039e",["D",1748056353647],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\nconst app = new Hono();\n\n// Serve frontend files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main app\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// Serve voice note player page\napp.get(\"/note/:id\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject the voice note ID for the player\n const voiceNoteId = c.req.param(\"id\");\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\nexport default app;",[],[159,290,292],"eac337f8-384c-11f0-98a6-9e149126039e",["D",1748056345528],[181,182],[159,290],"be903282-384f-11f0-9749-9e149126039e","queries.ts","de2719a6-384c-11f0-a0be-9e149126039e","ef52caa8-e4eb-4145-a8ba-c4da7877a28a",46,["D",1748057559908],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./migrations.ts\";\nimport type { VoiceNote } from \"../../shared/types.ts\";\n\nexport async function createVoiceNote(voiceNote: Omit): Promise {\n try {\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (\n id, title, audio_blob_key, transcription, duration, \n created_at, expires_at, max_listens, current_listens\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n voiceNote.id,\n voiceNote.title || null,\n voiceNote.audioUrl, // This will be the blob key\n voiceNote.transcription || null,\n voiceNote.duration,\n voiceNote.createdAt,\n voiceNote.expiresAt || null,\n voiceNote.maxListens || null,\n voiceNote.currentListens\n ]\n );\n console.log(\"Voice note successfully inserted into database\");\n } catch (error) {\n console.error(\"Error inserting voice note into database:\", error);\n throw error;\n }\n}\n\nexport async function getVoiceNote(id: string): Promise {\n try {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE id = ?`,\n [id]\n );\n \n // Handle the case where result.rows exists (new format) or result is an array (old format)\n const rows = result.rows || result;\n \n if (!Array.isArray(rows) || rows.length === 0) {\n return null;\n }\n \n const row = rows[0];\n const now = new Date();\n const expiresAt = row.expires_at ? new Date(row.expires_at) : null;\n const isExpiredByDate = expiresAt && now > expiresAt;\n const isExpiredByListens = row.max_listens && row.current_listens >= row.max_listens;\n const isExpired = isExpiredByDate || isExpiredByListens || false;\n \n return {\n id: row.id,\n title: row.title,\n audioUrl: row.audio_blob_key,\n transcription: row.transcription,\n duration: row.duration,\n createdAt: row.created_at,\n expiresAt: row.expires_at,\n maxListens: row.max_listens,\n currentListens: row.current_listens,\n isExpired\n };\n } catch (error) {\n console.error(\"Error getting voice note from database:\", error);\n throw error;\n }\n}\n\nexport async function incrementListenCount(id: string): Promise {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET current_listens = current_listens + 1 WHERE id = ?`,\n [id]\n );\n}\n\nexport async function updateTranscription(id: string, transcription: string): Promise {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET transcription = ? WHERE id = ?`,\n [transcription, id]\n );\n}\n\nexport async function deleteVoiceNote(id: string): Promise {\n await sqlite.execute(\n `DELETE FROM ${TABLE_NAME} WHERE id = ?`,\n [id]\n );\n}\n\nexport async function getAllVoiceNotes(): Promise {\n try {\n const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC`);\n \n // Handle the case where result.rows exists (new format) or result is an array (old format)\n const rows = result.rows || result;\n \n if (!Array.isArray(rows)) {\n return [];\n }\n \n return rows.map(row => {\n const now = new Date();\n const expiresAt = row.expires_at ? new Date(row.expires_at) : null;\n const isExpiredByDate = expiresAt && now > expiresAt;\n const isExpiredByListens = row.max_listens && row.current_listens >= row.max_listens;\n const isExpired = isExpiredByDate || isExpiredByListens || false;\n \n return {\n id: row.id,\n title: row.title,\n audioUrl: row.audio_blob_key,\n transcription: row.transcription,\n duration: row.duration,\n createdAt: row.created_at,\n expiresAt: row.expires_at,\n maxListens: row.max_listens,\n currentListens: row.current_listens,\n isExpired\n };\n });\n } catch (error) {\n console.error('Error in getAllVoiceNotes:', error);\n throw error;\n }\n}",[],[159,311,303],"database","d620c5c6-384d-11f0-ba26-9e149126039e","migrations.ts","d547c4fc-384c-11f0-a8cb-9e149126039e",26,["D",1748056740453],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = 'voice_notes_v1';\n\nexport async function runMigrations() {\n try {\n // Create voice notes table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id TEXT PRIMARY KEY,\n title TEXT,\n audio_blob_key TEXT NOT NULL,\n transcription TEXT,\n duration INTEGER NOT NULL,\n created_at TEXT NOT NULL,\n expires_at TEXT,\n max_listens INTEGER,\n current_listens INTEGER DEFAULT 0,\n is_expired BOOLEAN DEFAULT FALSE\n )`);\n \n console.log('Database migrations completed successfully');\n } catch (error) {\n console.error('Database migration failed:', error);\n throw error;\n }\n}\n\nexport { TABLE_NAME };",[],[159,311,313],"d547d6a4-384c-11f0-a8cb-9e149126039e",["D",1748056309532],[178,179],[159,311],["D",1748056309532],[177,180,183],[159],["D",1748056195569],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":57,"_104":105,"_106":25},{"_13":88,"_32":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"ctx",{"_81":-5,"_127":364,"_365":366,"_367":368,"_369":25,"_370":25,"_371":25,"_372":61,"_373":-5,"_374":-7,"_375":-7,"_376":149,"_377":25,"_378":25,"_379":-5,"_380":25,"_381":25,"_382":25,"_383":-5},"ENV",{"_335":336,"_337":338,"_339":89,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363},"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 · v55