\n \n\n",[],[118,136],"13c1773a-3f98-11f0-b85e-76b3cceeab13","components","bca7a288-ebf0-438a-96bf-cf363ceca606",11,["D",1748858284741],[149,150,151,152,153,154],[118,143],{"_36":195,"_13":196,"_39":197,"_41":144,"_43":44,"_45":198,"_47":48,"_49":199,"_17":200,"_52":88,"_54":201,"_56":57,"_58":-5,"_90":202,"_18":203},{"_36":187,"_13":188,"_39":189,"_41":144,"_43":44,"_45":190,"_47":48,"_49":191,"_17":65,"_52":88,"_54":192,"_56":57,"_58":-5,"_90":193,"_18":194},{"_36":179,"_13":180,"_39":181,"_41":144,"_43":44,"_45":182,"_47":48,"_49":183,"_17":65,"_52":88,"_54":184,"_56":57,"_58":-5,"_90":185,"_18":186},{"_36":170,"_13":171,"_39":172,"_41":144,"_43":44,"_45":173,"_47":48,"_49":174,"_17":175,"_52":88,"_54":176,"_56":57,"_58":-5,"_90":177,"_18":178},{"_36":162,"_13":163,"_39":164,"_41":144,"_43":44,"_45":165,"_47":48,"_49":166,"_17":104,"_52":88,"_54":167,"_56":57,"_58":-5,"_90":168,"_18":169},{"_36":155,"_13":156,"_39":157,"_41":144,"_43":44,"_45":145,"_47":48,"_49":158,"_17":65,"_52":88,"_54":159,"_56":57,"_58":-5,"_90":160,"_18":161},"13c1706e-3f98-11f0-b85e-76b3cceeab13","SearchBar.tsx","13c1715e-3f98-11f0-b85e-76b3cceeab13",["D",1748858284741],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface SearchBarProps {\n onSearch: (query: string) => void;\n placeholder?: string;\n}\n\nexport default function SearchBar({ onSearch, placeholder = \"Search notes...\" }: SearchBarProps) {\n const [query, setQuery] = useState(\"\");\n\n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n onSearch(query);\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const value = e.target.value;\n setQuery(value);\n \n // Search as user types (debounced effect would be better in production)\n onSearch(value);\n };\n\n return (\n \n );\n}",[],[118,143,156],"9c92e462-3f99-11f0-b451-76b3cceeab13","NotesList.tsx","20b42aaa-3f98-11f0-a759-76b3cceeab13",36,["D",1748858943775],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Note, ImportanceLevel, TimeFrame } from \"../../shared/types.ts\";\nimport { IMPORTANCE_LABELS, TIME_FRAME_LABELS } from \"../../shared/types.ts\";\nimport SearchBar from \"./SearchBar.tsx\";\nimport FilterBar from \"./FilterBar.tsx\";\n\ninterface NotesListProps {\n notes: Note[];\n selectedNoteId: number | null;\n onSelectNote: (note: Note) => void;\n onCreateNote: () => void;\n onDeleteNote: (id: number) => void;\n onSearch: (query: string) => void;\n}\n\nexport default function NotesList({ \n notes, \n selectedNoteId, \n onSelectNote, \n onCreateNote, \n onDeleteNote,\n onSearch \n}: NotesListProps) {\n const [selectedImportance, setSelectedImportance] = useState('all');\n const [selectedTimeFrame, setSelectedTimeFrame] = useState('all');\n const [showCompleted, setShowCompleted] = useState(false);\n\n // Filter notes based on selected filters\n const filteredNotes = notes.filter(note => {\n // Completion filter\n if (note.is_completed !== showCompleted) return false;\n \n // Importance filter\n if (selectedImportance !== 'all' && note.importance !== selectedImportance) return false;\n \n // Time frame filter\n if (selectedTimeFrame !== 'all' && note.time_frame !== selectedTimeFrame) return false;\n \n return true;\n });\n \n const formatDate = (dateString: string) => {\n const date = new Date(dateString);\n const now = new Date();\n const diffInHours = (now.getTime() - date.getTime()) / (1000 * 60 * 60);\n \n if (diffInHours < 24) {\n return date.toLocaleTimeString([], { hour: '2-digit', minute: '2-digit' });\n } else if (diffInHours < 24 * 7) {\n return date.toLocaleDateString([], { weekday: 'short' });\n } else {\n return date.toLocaleDateString([], { month: 'short', day: 'numeric' });\n }\n };\n\n const truncateContent = (content: string, maxLength: number = 100) => {\n if (content.length <= maxLength) return content;\n return content.substring(0, maxLength) + \"...\";\n };\n\n return (\n

\n {/* Header */}\n

📝 Jotter

\n \n \n New\n \n

\n \n \n

\n\n {/* Filters */}\n \n\n {/* Notes List */}\n

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

📄

\n {notes.length === 0 ? (\n <>\n

No notes yet

Create your first note to get started

\n \n ) : (\n <>\n

No notes match your filters

Try adjusting your filter settings

\n \n )}\n

\n ) : (\n

\n {filteredNotes.map((note) => (\n onSelectNote(note)}\n className={`note-item p-4 cursor-pointer transition-colors ${\n selectedNoteId === note.id ? 'active' : ''\n }`}\n >\n

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

\n {note.is_completed && ✅}\n

\n \n {/* Labels */}\n

\n \n {IMPORTANCE_LABELS[note.importance].emoji}\n {IMPORTANCE_LABELS[note.importance].label}\n \n \n {TIME_FRAME_LABELS[note.time_frame].emoji}\n {TIME_FRAME_LABELS[note.time_frame].label}\n \n

\n \n

\n {truncateContent(note.content) || \"No content\"}\n

\n {formatDate(note.updated_at)}\n

\n \n {\n e.stopPropagation();\n onDeleteNote(note.id);\n }}\n className=\"ml-2 p-1 text-gray-400 hover:text-red-500 transition-colors\"\n title=\"Delete note\"\n >\n \n \n

\n ))}\n

\n )}\n

\n \n );\n}",[],[118,143,163],"75bae132-3f99-11f0-a390-76b3cceeab13","NoteEditor.tsx","2df6deba-3f98-11f0-a95b-76b3cceeab13",30,["D",1748858878611],4,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { Note, ImportanceLevel, TimeFrame } from \"../../shared/types.ts\";\nimport LabelSelector from \"./LabelSelector.tsx\";\n\ninterface NoteEditorProps {\n note: Note | null;\n onSave: (id: number, title: string, content: string, importance: ImportanceLevel, timeFrame: TimeFrame, isCompleted: boolean) => void;\n}\n\nexport default function NoteEditor({ note, onSave }: NoteEditorProps) {\n const [title, setTitle] = useState(\"\");\n const [content, setContent] = useState(\"\");\n const [importance, setImportance] = useState('medium');\n const [timeFrame, setTimeFrame] = useState('no_deadline');\n const [isCompleted, setIsCompleted] = useState(false);\n const [isSaving, setIsSaving] = useState(false);\n const [lastSaved, setLastSaved] = useState(null);\n\n // Update local state when note changes\n useEffect(() => {\n if (note) {\n setTitle(note.title);\n setContent(note.content);\n setImportance(note.importance);\n setTimeFrame(note.time_frame);\n setIsCompleted(note.is_completed);\n } else {\n setTitle(\"\");\n setContent(\"\");\n setImportance('medium');\n setTimeFrame('no_deadline');\n setIsCompleted(false);\n }\n }, [note]);\n\n // Auto-save functionality\n useEffect(() => {\n if (!note) return;\n \n const timeoutId = setTimeout(async () => {\n if (title !== note.title || \n content !== note.content || \n importance !== note.importance || \n timeFrame !== note.time_frame || \n isCompleted !== note.is_completed) {\n setIsSaving(true);\n try {\n await onSave(note.id, title, content, importance, timeFrame, isCompleted);\n setLastSaved(new Date());\n } catch (error) {\n console.error(\"Failed to save note:\", error);\n } finally {\n setIsSaving(false);\n }\n }\n }, 1000); // Auto-save after 1 second of inactivity\n\n return () => clearTimeout(timeoutId);\n }, [note, title, content, importance, timeFrame, isCompleted, onSave]);\n\n const formatLastSaved = (date: Date) => {\n const now = new Date();\n const diffInSeconds = Math.floor((now.getTime() - date.getTime()) / 1000);\n \n if (diffInSeconds < 60) {\n return \"Saved just now\";\n } else if (diffInSeconds < 3600) {\n const minutes = Math.floor(diffInSeconds / 60);\n return `Saved ${minutes} minute${minutes > 1 ? 's' : ''} ago`;\n } else {\n return `Saved at ${date.toLocaleTimeString([], { hour: '2-digit', minute: '2-digit' })}`;\n }\n };\n\n if (!note) {\n return (\n

✍️

Welcome to Jotter

Select a note to start editing, or create a new one

\n Perfect for remote workspaces and quick note-taking\n

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

\n {/* Editor Header */}\n

\n setTitle(e.target.value)}\n placeholder=\"Note title...\"\n className={`w-full text-xl font-semibold bg-transparent border-none outline-none placeholder-gray-400 ${\n isCompleted ? 'text-gray-500 line-through' : 'text-gray-900'\n }`}\n />\n

\n \n

\n {isSaving && (\n

\n Saving...\n

\n )}\n \n {lastSaved && !isSaving && (\n {formatLastSaved(lastSaved)}\n )}\n \n

\n {content.length} characters\n

\n\n {/* Labels */}\n \n

\n\n {/* Editor Content */}\n

\n setContent(e.target.value)}\n placeholder=\"Start writing your note...\"\n className=\"note-editor w-full h-full resize-none border-none outline-none text-gray-700 placeholder-gray-400 leading-relaxed\"\n style={{ fontSize: '15px', lineHeight: '1.6' }}\n />\n

\n );\n}",[],[118,143,171],"54ee9fb6-3f99-11f0-9c10-76b3cceeab13","LabelSelector.tsx","54eea0a6-3f99-11f0-9c10-76b3cceeab13",24,["D",1748858823588],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { ImportanceLevel, TimeFrame } from \"../../shared/types.ts\";\nimport { IMPORTANCE_LABELS, TIME_FRAME_LABELS } from \"../../shared/types.ts\";\n\ninterface LabelSelectorProps {\n importance: ImportanceLevel;\n timeFrame: TimeFrame;\n isCompleted: boolean;\n onImportanceChange: (importance: ImportanceLevel) => void;\n onTimeFrameChange: (timeFrame: TimeFrame) => void;\n onCompletedChange: (completed: boolean) => void;\n}\n\nexport default function LabelSelector({\n importance,\n timeFrame,\n isCompleted,\n onImportanceChange,\n onTimeFrameChange,\n onCompletedChange\n}: LabelSelectorProps) {\n const [showImportanceDropdown, setShowImportanceDropdown] = useState(false);\n const [showTimeFrameDropdown, setShowTimeFrameDropdown] = useState(false);\n\n return (\n

\n {/* Completion Toggle */}\n onCompletedChange(!isCompleted)}\n className={`flex items-center gap-1 px-2 py-1 rounded-md text-xs font-medium transition-colors ${\n isCompleted \n ? 'bg-green-100 text-green-700 hover:bg-green-200' \n : 'bg-gray-100 text-gray-600 hover:bg-gray-200'\n }`}\n title={isCompleted ? \"Mark as incomplete\" : \"Mark as complete\"}\n >\n {isCompleted ? '✅' : '⭕'} \n {isCompleted ? 'Done' : 'Todo'}\n \n\n {/* Importance Selector */}\n

\n setShowImportanceDropdown(!showImportanceDropdown)}\n className={`flex items-center gap-1 px-2 py-1 rounded-md text-xs font-medium transition-colors hover:opacity-80 ${IMPORTANCE_LABELS[importance].color}`}\n >\n {IMPORTANCE_LABELS[importance].emoji} {IMPORTANCE_LABELS[importance].label}\n \n \n\n {showImportanceDropdown && (\n

\n {Object.entries(IMPORTANCE_LABELS).map(([key, config]) => (\n {\n onImportanceChange(key as ImportanceLevel);\n setShowImportanceDropdown(false);\n }}\n className={`w-full flex items-center gap-2 px-3 py-2 text-xs font-medium hover:bg-gray-50 first:rounded-t-lg last:rounded-b-lg ${\n key === importance ? 'bg-gray-50' : ''\n }`}\n >\n \n {config.emoji} {config.label}\n \n \n ))}\n

\n )}\n

\n\n {/* Time Frame Selector */}\n

\n setShowTimeFrameDropdown(!showTimeFrameDropdown)}\n className={`flex items-center gap-1 px-2 py-1 rounded-md text-xs font-medium transition-colors hover:opacity-80 ${TIME_FRAME_LABELS[timeFrame].color}`}\n >\n {TIME_FRAME_LABELS[timeFrame].emoji} {TIME_FRAME_LABELS[timeFrame].label}\n \n \n\n {showTimeFrameDropdown && (\n

\n {Object.entries(TIME_FRAME_LABELS).map(([key, config]) => (\n {\n onTimeFrameChange(key as TimeFrame);\n setShowTimeFrameDropdown(false);\n }}\n className={`w-full flex items-center gap-2 px-3 py-2 text-xs font-medium hover:bg-gray-50 first:rounded-t-lg last:rounded-b-lg ${\n key === timeFrame ? 'bg-gray-50' : ''\n }`}\n >\n \n {config.emoji} {config.label}\n \n \n ))}\n

\n )}\n

\n );\n}",[],[118,143,180],"8c065c3c-3f99-11f0-8107-76b3cceeab13","FilterBar.tsx","8c065d0e-3f99-11f0-8107-76b3cceeab13",33,["D",1748858916018],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { ImportanceLevel, TimeFrame } from \"../../shared/types.ts\";\nimport { IMPORTANCE_LABELS, TIME_FRAME_LABELS } from \"../../shared/types.ts\";\n\ninterface FilterBarProps {\n selectedImportance: ImportanceLevel | 'all';\n selectedTimeFrame: TimeFrame | 'all';\n showCompleted: boolean;\n onImportanceFilter: (importance: ImportanceLevel | 'all') => void;\n onTimeFrameFilter: (timeFrame: TimeFrame | 'all') => void;\n onCompletedFilter: (showCompleted: boolean) => void;\n}\n\nexport default function FilterBar({\n selectedImportance,\n selectedTimeFrame,\n showCompleted,\n onImportanceFilter,\n onTimeFrameFilter,\n onCompletedFilter\n}: FilterBarProps) {\n return (\n

\n {/* Completion Filter */}\n

\n Show:\n

\n onCompletedFilter(false)}\n className={`px-2 py-1 text-xs rounded ${\n !showCompleted \n ? 'bg-blue-100 text-blue-700' \n : 'bg-white text-gray-600 hover:bg-gray-100'\n }`}\n >\n Active\n \n onCompletedFilter(true)}\n className={`px-2 py-1 text-xs rounded ${\n showCompleted \n ? 'bg-green-100 text-green-700' \n : 'bg-white text-gray-600 hover:bg-gray-100'\n }`}\n >\n Completed\n \n

\n\n {/* Importance Filter */}\n

\n Priority:\n

\n onImportanceFilter('all')}\n className={`px-2 py-1 text-xs rounded ${\n selectedImportance === 'all' \n ? 'bg-gray-200 text-gray-800' \n : 'bg-white text-gray-600 hover:bg-gray-100'\n }`}\n >\n All\n \n {Object.entries(IMPORTANCE_LABELS).map(([key, config]) => (\n onImportanceFilter(key as ImportanceLevel)}\n className={`px-2 py-1 text-xs rounded flex items-center gap-1 ${\n selectedImportance === key \n ? config.color \n : 'bg-white text-gray-600 hover:bg-gray-100'\n }`}\n >\n {config.emoji}\n {config.label}\n \n ))}\n

\n\n {/* Time Frame Filter */}\n

\n Due:\n

\n onTimeFrameFilter('all')}\n className={`px-2 py-1 text-xs rounded ${\n selectedTimeFrame === 'all' \n ? 'bg-gray-200 text-gray-800' \n : 'bg-white text-gray-600 hover:bg-gray-100'\n }`}\n >\n All\n \n {Object.entries(TIME_FRAME_LABELS).map(([key, config]) => (\n onTimeFrameFilter(key as TimeFrame)}\n className={`px-2 py-1 text-xs rounded flex items-center gap-1 ${\n selectedTimeFrame === key \n ? config.color \n : 'bg-white text-gray-600 hover:bg-gray-100'\n }`}\n >\n {config.emoji}\n {config.label}\n \n ))}\n

\n );\n}",[],[118,143,188],"81295792-3f99-11f0-8c95-76b3cceeab13","App.tsx","38610074-3f98-11f0-a790-76b3cceeab13",32,["D",1748858897788],2,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { Note, ImportanceLevel, TimeFrame } from \"../../shared/types.ts\";\nimport NotesList from \"./NotesList.tsx\";\nimport NoteEditor from \"./NoteEditor.tsx\";\n\n// Get initial data from server-side injection\nconst initialData = (window as any).__INITIAL_DATA__ || { notes: [] };\n\nexport default function App() {\n const [notes, setNotes] = useState(initialData.notes);\n const [selectedNote, setSelectedNote] = useState(null);\n const [searchQuery, setSearchQuery] = useState(\"\");\n\n // Load notes from API\n const loadNotes = async (query?: string) => {\n try {\n const url = query ? `/api/notes?q=${encodeURIComponent(query)}` : '/api/notes';\n const response = await fetch(url);\n if (response.ok) {\n const notesData = await response.json();\n setNotes(notesData);\n }\n } catch (error) {\n console.error(\"Failed to load notes:\", error);\n }\n };\n\n // Create new note\n const createNote = async () => {\n try {\n const response = await fetch('/api/notes', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ \n title: 'New Note',\n content: '',\n importance: 'medium',\n time_frame: 'no_deadline'\n })\n });\n \n if (response.ok) {\n const newNote = await response.json();\n setNotes(prev => [newNote, ...prev]);\n setSelectedNote(newNote);\n }\n } catch (error) {\n console.error(\"Failed to create note:\", error);\n }\n };\n\n // Save note\n const saveNote = async (\n id: number, \n title: string, \n content: string, \n importance: ImportanceLevel, \n timeFrame: TimeFrame, \n isCompleted: boolean\n ) => {\n try {\n const response = await fetch(`/api/notes/${id}`, {\n method: 'PUT',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ \n title, \n content, \n importance, \n time_frame: timeFrame, \n is_completed: isCompleted \n })\n });\n \n if (response.ok) {\n const updatedNote = await response.json();\n setNotes(prev => prev.map(note => \n note.id === id ? updatedNote : note\n ));\n setSelectedNote(updatedNote);\n }\n } catch (error) {\n console.error(\"Failed to save note:\", error);\n throw error;\n }\n };\n\n // Delete note\n const deleteNote = async (id: number) => {\n if (!confirm(\"Are you sure you want to delete this note?\")) {\n return;\n }\n \n try {\n const response = await fetch(`/api/notes/${id}`, {\n method: 'DELETE'\n });\n \n if (response.ok) {\n setNotes(prev => prev.filter(note => note.id !== id));\n if (selectedNote?.id === id) {\n setSelectedNote(null);\n }\n }\n } catch (error) {\n console.error(\"Failed to delete note:\", error);\n }\n };\n\n // Handle search\n const handleSearch = async (query: string) => {\n setSearchQuery(query);\n await loadNotes(query);\n };\n\n // Select note\n const selectNote = (note: Note) => {\n setSelectedNote(note);\n };\n\n return (\n

\n \n \n \n

\n );\n}",[],[118,143,196],["D",1748858233376],[207,208,209],[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":225,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_90":226,"_18":227},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":213,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_90":214,"_18":215},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":210,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_90":211,"_18":212},["D",1748858365762],[],[19,38],["D",1748858255574],[216],[19,61],{"_36":217,"_13":218,"_39":219,"_41":62,"_43":44,"_45":220,"_47":48,"_49":221,"_17":51,"_52":88,"_54":222,"_56":57,"_58":-5,"_90":223,"_18":224},"4841ccac-3f99-11f0-b6f4-76b3cceeab13","notes.ts","025e87f8-3f98-11f0-b775-76b3cceeab13",23,["D",1748858802321],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n getAllNotes, \n getNoteById, \n createNote, \n updateNote, \n deleteNote, \n searchNotes \n} from \"../database/queries.ts\";\n\nconst notes = new Hono();\n\n// Get all notes or search\nnotes.get(\"/\", async (c) => {\n const query = c.req.query(\"q\");\n \n if (query) {\n const results = await searchNotes(query);\n return c.json(results);\n }\n \n const allNotes = await getAllNotes();\n return c.json(allNotes);\n});\n\n// Get specific note\nnotes.get(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid note ID\" }, 400);\n }\n \n const note = await getNoteById(id);\n if (!note) {\n return c.json({ error: \"Note not found\" }, 404);\n }\n \n return c.json(note);\n});\n\n// Create new note\nnotes.post(\"/\", async (c) => {\n const body = await c.req.json();\n \n if (!body.title || typeof body.title !== \"string\") {\n return c.json({ error: \"Title is required\" }, 400);\n }\n \n const noteData = {\n title: body.title,\n content: body.content || \"\",\n importance: body.importance || 'medium',\n time_frame: body.time_frame || 'no_deadline'\n };\n \n const note = await createNote(noteData);\n return c.json(note, 201);\n});\n\n// Update note\nnotes.put(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid note ID\" }, 400);\n }\n \n const body = await c.req.json();\n const note = await updateNote(id, body);\n \n if (!note) {\n return c.json({ error: \"Note not found\" }, 404);\n }\n \n return c.json(note);\n});\n\n// Delete note\nnotes.delete(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid note ID\" }, 400);\n }\n \n const deleted = await deleteNote(id);\n if (!deleted) {\n return c.json({ error: \"Note not found\" }, 404);\n }\n \n return c.json({ success: true });\n});\n\nexport default notes;",[],[19,61,218],["D",1748858233376],[228,229],[19,69],{"_36":238,"_13":239,"_39":240,"_41":70,"_43":44,"_45":241,"_47":48,"_49":242,"_17":51,"_52":88,"_54":243,"_56":57,"_58":-5,"_90":244,"_18":245},{"_36":230,"_13":231,"_39":232,"_41":70,"_43":44,"_45":233,"_47":48,"_49":234,"_17":87,"_52":88,"_54":235,"_56":57,"_58":-5,"_90":236,"_18":237},"44693566-3f99-11f0-b566-76b3cceeab13","queries.ts","fb9d7f5a-3f97-11f0-8845-76b3cceeab13",22,["D",1748858795861],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./migrations.ts\";\nimport type { Note, CreateNoteRequest, UpdateNoteRequest } from \"../../shared/types.ts\";\n\nexport async function getAllNotes(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLE_NAME} \n ORDER BY \n CASE importance \n WHEN 'urgent' THEN 1 \n WHEN 'high' THEN 2 \n WHEN 'medium' THEN 3 \n WHEN 'low' THEN 4 \n END,\n CASE time_frame \n WHEN 'today' THEN 1 \n WHEN 'this_week' THEN 2 \n WHEN 'this_month' THEN 3 \n WHEN 'later' THEN 4 \n WHEN 'no_deadline' THEN 5 \n END,\n is_completed ASC,\n updated_at DESC\n `);\n return result.rows as Note[];\n}\n\nexport async function getNoteById(id: number): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLE_NAME} \n WHERE id = ?\n `, [id]);\n \n return result.rows[0] as Note || null;\n}\n\nexport async function createNote(data: CreateNoteRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${TABLE_NAME} (title, content, importance, time_frame)\n VALUES (?, ?, ?, ?)\n `, [\n data.title, \n data.content, \n data.importance || 'medium',\n data.time_frame || 'no_deadline'\n ]);\n \n const noteId = result.lastInsertRowId;\n const note = await getNoteById(noteId);\n if (!note) throw new Error(\"Failed to create note\");\n return note;\n}\n\nexport async function updateNote(id: number, data: UpdateNoteRequest): Promise {\n const updates: string[] = [];\n const values: any[] = [];\n \n if (data.title !== undefined) {\n updates.push(\"title = ?\");\n values.push(data.title);\n }\n \n if (data.content !== undefined) {\n updates.push(\"content = ?\");\n values.push(data.content);\n }\n \n if (data.importance !== undefined) {\n updates.push(\"importance = ?\");\n values.push(data.importance);\n }\n \n if (data.time_frame !== undefined) {\n updates.push(\"time_frame = ?\");\n values.push(data.time_frame);\n }\n \n if (data.is_completed !== undefined) {\n updates.push(\"is_completed = ?\");\n values.push(data.is_completed ? 1 : 0);\n }\n \n if (updates.length === 0) {\n return await getNoteById(id);\n }\n \n updates.push(\"updated_at = CURRENT_TIMESTAMP\");\n values.push(id);\n \n await sqlite.execute(`\n UPDATE ${TABLE_NAME} \n SET ${updates.join(\", \")}\n WHERE id = ?\n `, values);\n \n return await getNoteById(id);\n}\n\nexport async function deleteNote(id: number): Promise {\n const result = await sqlite.execute(`\n DELETE FROM ${TABLE_NAME} \n WHERE id = ?\n `, [id]);\n \n return result.changes > 0;\n}\n\nexport async function searchNotes(query: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLE_NAME} \n WHERE title LIKE ? OR content LIKE ?\n ORDER BY updated_at DESC\n `, [`%${query}%`, `%${query}%`]);\n \n return result.rows as Note[];\n}",[],[19,69,231],"36dec88e-3f99-11f0-980b-76b3cceeab13","migrations.ts","f523a974-3f97-11f0-a83c-76b3cceeab13",19,["D",1748858773150],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = 'jotter_notes_v2';\n\nexport async function createNotesTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n content TEXT NOT NULL DEFAULT '',\n importance TEXT NOT NULL DEFAULT 'medium' CHECK (importance IN ('low', 'medium', 'high', 'urgent')),\n time_frame TEXT NOT NULL DEFAULT 'no_deadline' CHECK (time_frame IN ('today', 'this_week', 'this_month', 'later', 'no_deadline')),\n is_completed BOOLEAN NOT NULL DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\nexport { TABLE_NAME };",[],[19,69,239],"f048737c-3f96-11f0-8f2e-76b3cceeab13",["D",1748857795739],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Workflow app for random notes. Doesnt have to important.","imageUrl","userId","63df53b0-3f96-11f0-ad5b-814c56c8abb0","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","8ef27479-02af-4c82-89ec-299d9c968033","tursoName","f048737c3f9611f08f2e76b3cceeab13","tursoHostname","f048737c3f9611f08f2e76b3cceeab13-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789649456549],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_302":298},"org",{"_11":12,"_296":-5,"_297":298,"_256":257,"_299":300,"_301":57},"branch",{"_17":96,"_13":16,"_36":44,"_288":246,"_289":-5,"_290":-5,"_291":-5,"_292":-5,"_293":-5,"_294":14,"_295":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d21WSXMweHJKU1VGUzRuclN5YnBBVzgyaCJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":246,"_13":14,"_49":401,"_248":-5,"_249":57,"_250":251,"_252":251,"_253":254,"_255":-5,"_256":257,"_258":40,"_259":48,"_260":48,"_261":-5,"_262":65,"_263":264,"_265":266,"_267":268,"_269":402,"_271":-5,"_272":273,"_274":273,"_275":276,"_277":276,"_278":276,"_279":273,"_280":273,"_281":403,"_283":404,"_285":405,"_287":57},[338,345,355,357,358],"files",[338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358],"counts",{"_329":65,"_330":51,"_331":65,"_32":332,"_333":334},[323,324,325],{"_36":74,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":71,"_47":48,"_49":75,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_18":322},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":72,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_18":328},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":64,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_18":327},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":326},[19,38],[19,61],[19,69],"pulls","branches","forks",{"_335":65,"_337":65},"connections",{"_335":65,"_336":65},"count","unfilledCount","emptyCount",{"_36":74,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":71,"_47":48,"_49":204,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_90":399,"_18":400},{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":225,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_90":397,"_18":398},{"_36":238,"_13":239,"_39":240,"_41":70,"_43":44,"_45":241,"_47":48,"_49":242,"_17":51,"_52":88,"_54":243,"_56":57,"_58":-5,"_90":395,"_18":396},{"_36":230,"_13":231,"_39":232,"_41":70,"_43":44,"_45":233,"_47":48,"_49":234,"_17":87,"_52":88,"_54":235,"_56":57,"_58":-5,"_90":393,"_18":394},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":213,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_90":391,"_18":392},{"_36":217,"_13":218,"_39":219,"_41":62,"_43":44,"_45":220,"_47":48,"_49":221,"_17":51,"_52":88,"_54":222,"_56":57,"_58":-5,"_90":389,"_18":390},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":210,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_90":387,"_18":388},{"_36":117,"_13":118,"_39":119,"_41":-5,"_43":44,"_45":120,"_47":48,"_49":121,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_90":385,"_18":386},{"_36":142,"_13":143,"_39":144,"_41":119,"_43":44,"_45":145,"_47":48,"_49":146,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_90":383,"_18":384},{"_36":195,"_13":196,"_39":197,"_41":144,"_43":44,"_45":198,"_47":48,"_49":199,"_17":200,"_52":88,"_54":201,"_56":57,"_58":-5,"_90":381,"_18":382},{"_36":187,"_13":188,"_39":189,"_41":144,"_43":44,"_45":190,"_47":48,"_49":191,"_17":65,"_52":88,"_54":192,"_56":57,"_58":-5,"_90":379,"_18":380},{"_36":179,"_13":180,"_39":181,"_41":144,"_43":44,"_45":182,"_47":48,"_49":183,"_17":65,"_52":88,"_54":184,"_56":57,"_58":-5,"_90":377,"_18":378},{"_36":170,"_13":171,"_39":172,"_41":144,"_43":44,"_45":173,"_47":48,"_49":174,"_17":175,"_52":88,"_54":176,"_56":57,"_58":-5,"_90":375,"_18":376},{"_36":162,"_13":163,"_39":164,"_41":144,"_43":44,"_45":165,"_47":48,"_49":166,"_17":104,"_52":88,"_54":167,"_56":57,"_58":-5,"_90":373,"_18":374},{"_36":155,"_13":156,"_39":157,"_41":144,"_43":44,"_45":145,"_47":48,"_49":158,"_17":65,"_52":88,"_54":159,"_56":57,"_58":-5,"_90":371,"_18":372},{"_36":135,"_13":136,"_39":137,"_41":119,"_43":44,"_45":120,"_47":48,"_49":138,"_17":65,"_52":24,"_54":139,"_56":57,"_58":-5,"_90":369,"_18":370},{"_36":127,"_13":128,"_39":129,"_41":119,"_43":44,"_45":130,"_47":48,"_49":131,"_17":65,"_52":88,"_54":132,"_56":57,"_58":-5,"_90":367,"_18":368},{"_36":101,"_13":102,"_39":103,"_41":-5,"_43":44,"_45":104,"_47":48,"_49":105,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_90":365,"_18":366},{"_36":109,"_13":110,"_39":111,"_41":103,"_43":44,"_45":112,"_47":48,"_49":113,"_17":51,"_52":88,"_54":114,"_56":57,"_58":-5,"_90":363,"_18":364},{"_36":93,"_13":94,"_39":95,"_41":-5,"_43":44,"_45":96,"_47":48,"_49":97,"_17":51,"_52":24,"_54":98,"_56":57,"_58":-5,"_90":361,"_18":362},{"_36":82,"_13":83,"_39":84,"_41":-5,"_43":44,"_45":85,"_47":48,"_49":86,"_17":87,"_52":88,"_54":89,"_56":57,"_58":-5,"_90":359,"_18":360},[],[83],[],[94],[],[102,110],[356],[102],[],[118,128],[],[118,136],[],[118,143,156],[],[118,143,163],[],[118,143,171],[],[118,143,180],[],[118,143,188],[],[118,143,196],[347,348,349,350,351,352],[118,143],[346,353,354],[118],[],[19,38],[],[19,61,218],[343],[19,61],[],[19,69,231],[],[19,69,239],[340,341],[19,69],[339,342,344],[19],["D",1748857795739],["D",1789649456549],{"_11":12,"_302":298},{"_11":12,"_296":-5,"_297":298,"_256":257,"_299":300,"_301":57},{"_17":96,"_13":16,"_36":44,"_288":246,"_289":-5,"_290":-5,"_291":-5,"_292":-5,"_293":-5,"_294":14,"_295":12},"ctx",{"_281":-5,"_319":439,"_440":441,"_442":443,"_444":57,"_445":57,"_446":57,"_447":48,"_448":-5,"_449":-7,"_450":-7,"_451":65,"_452":57,"_453":57,"_454":-5,"_455":57,"_456":57,"_457":57,"_458":-5},"ENV",{"_410":411,"_412":413,"_414":16,"_415":416,"_417":418,"_419":420,"_421":422,"_423":424,"_425":426,"_427":428,"_429":430,"_431":432,"_433":434,"_435":436,"_437":438},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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"]