\n \n \n",[],[247,249],"4e812eb8-40e9-11f0-8d0a-76b3cceeab13","VoiceRecorder.tsx","4061ce6d-99fe-4594-8cc9-3cb08ba97162","a768bfe6-55ed-4006-91c9-457ba0385ddb",["D",1749003123700],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useRef, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { ShareSettings, VoiceNote } from \"../../shared/types.ts\";\nimport ShareModal from \"./ShareModal.tsx\";\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 } 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 message: \" + data.error);\n }\n })\n .catch(error => {\n console.error(\"Error saving voice message:\", error);\n alert(\"Error saving voice message\");\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 Message Created!\n

\n Your voice message 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 Messages\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 message\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 message\"\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}",[],[247,263,256],"components","4e812558-40e9-11f0-8d0a-76b3cceeab13","VoicePlayer.tsx","2a5ff72f-c05d-4fa0-972d-19b78646ed65",["D",1749003123700],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } 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 message not found\");\n }\n } catch (err) {\n setError(\"Failed to load voice message\");\n console.error(\"Error fetching voice message:\", 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 message 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${\n listensLeft !== 1 ? \"s\" : \"\"\n } 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 Message\"}\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 message 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 Message\n \n

\n );\n}",[],[247,263,265],"4e811cde-40e9-11f0-8d0a-76b3cceeab13","ShareModal.tsx","f075944b-bdc0-4aa0-ae5e-7bcbab7ac643",["D",1749003123700],"/** @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}",[],[247,263,272],"4e8113c4-40e9-11f0-8d0a-76b3cceeab13","Dashboard.tsx","b3138d7a-7b07-46b9-9efb-0c520824637b",["D",1749003123700],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } 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 messages\");\n }\n } catch (err) {\n setError(\"Failed to load voice messages\");\n console.error(\"Error fetching voice messages:\", 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 messages? 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 message: \" + data.error);\n }\n } catch (error) {\n console.error(\"Error deleting voice message:\", error);\n alert(\"Failed to delete voice message\");\n }\n };\n\n if (loading) {\n return (\n

⏳

\n Loading Your Voice Messages...\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 Messages\n

\n \n Refresh\n \n

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

🎙️

\n No Voice Messages Yet\n

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

\n )\n : (\n

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

\n {voiceNote.title || \"Untitled Voice Message\"}\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 && 📊 {voiceNote.maxListens} max}\n {voiceNote.expiresAt && ⏰ Expires {formatDate(voiceNote.expiresAt)}}\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}",[],[247,263,279],"27fa8040-40ea-11f0-8209-76b3cceeab13","App.tsx","b2d77b57-c5db-4cc8-9c7a-7a3bbd235b79",["D",1749003488564],4,"/** @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={`${\n currentView === \"recorder\"\n ? \"btn\"\n : \"btn-secondary\"\n }`}\n >\n 🎙️ Record\n \n setCurrentView(\"dashboard\")}\n className={`${\n currentView === \"dashboard\"\n ? \"btn\"\n : \"btn-secondary\"\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}",[],[247,263,286],"4e813d68-40e9-11f0-8d0a-76b3cceeab13",["D",1749003123700],[208,209,210,211,212],[247,263],"4e81465a-40e9-11f0-8d0a-76b3cceeab13",["D",1749003123700],[207,213,214],[247],"4e810e6a-40e9-11f0-8d0a-76b3cceeab13","index.ts","258ce14e-2ddd-4760-aca1-2e0d5237ee49",["D",1749003123700],"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;",[],[177,302],["D",1749003123700],[],[177,88,86],["D",1749003123700],[],[177,88,75],["D",1749003123700],[203,204],[177,88],"4e80f754-40e9-11f0-8d0a-76b3cceeab13","queries.ts","efbcb531-8e2d-4886-97cb-c964e9614ee5","9c22f435-ebe1-4a93-bf31-234f761ba593",["D",1749003123700],"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}",[],[177,326,319],"database","4e80edd6-40e9-11f0-8d0a-76b3cceeab13","migrations.ts","e4e8b6d1-50a3-4e59-8b4b-170d0fa3f4d9",["D",1749003123700],"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 };",[],[177,326,328],"4e80fd62-40e9-11f0-8d0a-76b3cceeab13",["D",1749003123700],[200,201],[177,326],"4e810fc8-40e9-11f0-8d0a-76b3cceeab13",["D",1749003123700],[199,202,205],[177],["D",1748056195569],{"_11":12,"_141":81},{"_11":12,"_136":137,"_80":81,"_31":79,"_138":139,"_140":30},{"_39":127,"_13":16,"_33":36,"_128":91,"_129":69,"_130":71,"_131":95,"_132":91,"_133":42,"_134":14,"_135":12},"ctx",{"_52":-5,"_161":379,"_380":381,"_382":383,"_384":30,"_385":30,"_386":30,"_387":24,"_388":-5,"_389":-7,"_390":-7,"_391":26,"_392":30,"_393":30,"_394":-5,"_395":30,"_396":30,"_397":30,"_398":-5},"ENV",{"_350":351,"_352":353,"_354":70,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374,"_375":376,"_377":378},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · routes