[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_322":323,"_324":325},"routes/_app.x.$handle.$name",{"_100":99,"_32":46,"_108":90,"_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":59,"_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":-5,"_18":56,"_57":31,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",17,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":38,"_36":37,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/index.ts","latestPath","fileId","079915b2-3f98-11f0-be1c-76b3cceeab13","name","index.ts","fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { createNotesTable } from \"./database/migrations.ts\";\nimport { getAllNotes } from \"./database/queries.ts\";\nimport notesRoutes from \"./routes/notes.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// Initialize database\nawait createNotesTable();\n\n// API routes\napp.route(\"/api/notes\", notesRoutes);\n\n// Serve static 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 page with initial data\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial notes data to avoid extra round-trip\n const initialNotes = await getAllNotes();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\nexport default app.fetch;","http","createdAt",["D",1748858365762],"branchVersion","branchId","f048b6b6-3f96-11f0-8f2e-76b3cceeab13","id","f048737c-3f96-11f0-8f2e-76b3cceeab13","Jotter",["D",1748857795739],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Workflow app for random notes. Doesnt have to important.","imageUrl","63df53b0-3f96-11f0-ad5b-814c56c8abb0","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"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",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":56,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_44":43,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":46,"_98":99},"isOwned",37,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","zoebee","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d21WSXMweHJKU1VGUzRuclN5YnBBVzgyaCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":317,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":31,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":318,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":319,"_84":320,"_86":321,"_88":25},"tree",[183,190,198,200,201],"files",[183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201],"counts",{"_172":63,"_173":174,"_175":63,"_176":177,"_178":179},"contents",[130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":166,"_32":167,"_30":168,"_138":-5,"_42":43,"_41":169,"_140":59,"_39":170,"_13":63,"_34":158,"_36":-5,"_24":25,"_144":-5,"_27":171},{"_44":160,"_32":161,"_30":162,"_138":-5,"_42":43,"_41":163,"_140":59,"_39":164,"_13":63,"_34":158,"_36":-5,"_24":25,"_144":-5,"_27":165},{"_44":153,"_32":154,"_30":155,"_138":-5,"_42":43,"_41":156,"_140":59,"_39":157,"_13":63,"_34":158,"_36":-5,"_24":25,"_144":-5,"_27":159},{"_44":146,"_32":147,"_30":148,"_138":-5,"_42":43,"_41":149,"_140":25,"_39":150,"_13":63,"_34":20,"_36":151,"_24":25,"_144":-5,"_27":152},{"_44":135,"_32":136,"_30":137,"_138":-5,"_42":43,"_41":139,"_140":59,"_39":141,"_13":142,"_34":35,"_36":143,"_24":25,"_144":-5,"_27":145},"4219e608-3f98-11f0-a83c-76b3cceeab13","main.tsx","f04a67fe-3f96-11f0-8f2e-76b3cceeab13","parentId",16,"latest",["D",1748858362493],3,"// This file has been replaced by the new Jotter app structure\n// The main entry point is now /backend/index.ts\n// Please use the backend/index.ts file as the HTTP trigger\n\nexport default async function (req: Request) {\n return new Response(\"Please use /backend/index.ts as the main entry point\", {\n status: 302,\n headers: { Location: \"/backend/\" }\n });\n}","label",[136],"efe409e0-3f97-11f0-ab6c-76b3cceeab13","README.md","efe40a9e-3f97-11f0-ab6c-76b3cceeab13",4,["D",1748858224574],"# Jotter\n\nA simple and user-friendly notes app for remote workspaces.\n\n## Features\n\n- Clean, minimal interface\n- Real-time note editing\n- Organized note management\n- Search functionality\n- Responsive design\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main API server\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ └── routes/\n│ └── notes.ts # Notes API endpoints\n├── frontend/\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend entry point\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ ├── NotesList.tsx # Notes sidebar\n│ │ ├── NoteEditor.tsx # Note editing area\n│ │ └── SearchBar.tsx # Search functionality\n│ └── style.css # Custom styles\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Development\n\nThe app uses:\n- **Backend**: Hono.js for API routes\n- **Frontend**: React with TypeScript\n- **Database**: SQLite for note storage\n- **Styling**: TailwindCSS",[147],"f28a125c-3f97-11f0-933b-76b3cceeab13","shared","a0d5ad60-e89e-45d5-b597-509694c34435",5,["D",1748858229011],"directory",[154],"0e4a2e6e-3f98-11f0-81cf-76b3cceeab13","frontend","4bdccf82-d5f9-4df2-b8ec-6913997e0f81",10,["D",1748858275572],[161],"f523b400-3f97-11f0-a83c-76b3cceeab13","backend","d481350a-bfa3-496b-b072-adc37d136c96",6,["D",1748858233376],[167],"pulls","branches",1,"forks","envVars",{"_180":63,"_182":63},"connections",{"_180":63,"_181":63},"count","unfilledCount","emptyCount",{"_44":166,"_32":167,"_30":168,"_138":-5,"_42":43,"_41":169,"_140":59,"_39":314,"_13":63,"_34":158,"_36":-5,"_24":25,"_144":-5,"_203":315,"_27":316},{"_44":310,"_32":302,"_30":296,"_138":168,"_42":43,"_41":169,"_140":59,"_39":311,"_13":63,"_34":158,"_36":-5,"_24":25,"_144":-5,"_203":312,"_27":313},{"_44":303,"_32":304,"_30":305,"_138":296,"_42":43,"_41":169,"_140":25,"_39":306,"_13":63,"_34":35,"_36":307,"_24":25,"_144":-5,"_203":308,"_27":309},{"_44":293,"_32":294,"_30":295,"_138":296,"_42":43,"_41":297,"_140":25,"_39":298,"_13":63,"_34":35,"_36":299,"_24":25,"_144":-5,"_203":300,"_27":301},{"_44":289,"_32":288,"_30":282,"_138":168,"_42":43,"_41":283,"_140":59,"_39":290,"_13":63,"_34":158,"_36":-5,"_24":25,"_144":-5,"_203":291,"_27":292},{"_44":279,"_32":280,"_30":281,"_138":282,"_42":43,"_41":283,"_140":25,"_39":284,"_13":63,"_34":35,"_36":285,"_24":25,"_144":-5,"_203":286,"_27":287},{"_44":275,"_32":33,"_30":31,"_138":168,"_42":43,"_41":14,"_140":59,"_39":276,"_13":174,"_34":38,"_36":37,"_24":25,"_144":-5,"_203":277,"_27":278},{"_44":160,"_32":161,"_30":162,"_138":-5,"_42":43,"_41":163,"_140":59,"_39":272,"_13":63,"_34":158,"_36":-5,"_24":25,"_144":-5,"_203":273,"_27":274},{"_44":268,"_32":243,"_30":237,"_138":162,"_42":43,"_41":238,"_140":59,"_39":269,"_13":63,"_34":158,"_36":-5,"_24":25,"_144":-5,"_203":270,"_27":271},{"_44":260,"_32":261,"_30":262,"_138":237,"_42":43,"_41":263,"_140":25,"_39":264,"_13":63,"_34":35,"_36":265,"_24":25,"_144":-5,"_203":266,"_27":267},{"_44":252,"_32":253,"_30":254,"_138":237,"_42":43,"_41":255,"_140":25,"_39":256,"_13":63,"_34":35,"_36":257,"_24":25,"_144":-5,"_203":258,"_27":259},{"_44":244,"_32":245,"_30":246,"_138":237,"_42":43,"_41":247,"_140":25,"_39":248,"_13":63,"_34":35,"_36":249,"_24":25,"_144":-5,"_203":250,"_27":251},{"_44":234,"_32":235,"_30":236,"_138":237,"_42":43,"_41":238,"_140":59,"_39":239,"_13":63,"_34":35,"_36":240,"_24":25,"_144":-5,"_203":241,"_27":242},{"_44":227,"_32":228,"_30":229,"_138":162,"_42":43,"_41":163,"_140":59,"_39":230,"_13":63,"_34":20,"_36":231,"_24":25,"_144":-5,"_203":232,"_27":233},{"_44":219,"_32":220,"_30":221,"_138":162,"_42":43,"_41":222,"_140":59,"_39":223,"_13":63,"_34":35,"_36":224,"_24":25,"_144":-5,"_203":225,"_27":226},{"_44":153,"_32":154,"_30":155,"_138":-5,"_42":43,"_41":156,"_140":59,"_39":216,"_13":63,"_34":158,"_36":-5,"_24":25,"_144":-5,"_203":217,"_27":218},{"_44":209,"_32":210,"_30":211,"_138":155,"_42":43,"_41":156,"_140":25,"_39":212,"_13":63,"_34":35,"_36":213,"_24":25,"_144":-5,"_203":214,"_27":215},{"_44":146,"_32":147,"_30":148,"_138":-5,"_42":43,"_41":149,"_140":25,"_39":206,"_13":63,"_34":20,"_36":151,"_24":25,"_144":-5,"_203":207,"_27":208},{"_44":135,"_32":136,"_30":137,"_138":-5,"_42":43,"_41":139,"_140":59,"_39":202,"_13":142,"_34":35,"_36":143,"_24":25,"_144":-5,"_203":204,"_27":205},["D",1748858362493],"children",[],[136],["D",1748858224574],[],[147],"f289e05c-3f97-11f0-933b-76b3cceeab13","types.ts","f289e192-3f97-11f0-933b-76b3cceeab13",["D",1748858229011],"export interface Note {\n id: number;\n title: string;\n content: string;\n created_at: string;\n updated_at: string;\n}\n\nexport interface CreateNoteRequest {\n title: string;\n content: string;\n}\n\nexport interface UpdateNoteRequest {\n title?: string;\n content?: string;\n}",[],[154,210],["D",1748858229011],[199],[154],"3b049048-3f98-11f0-a0de-76b3cceeab13","index.tsx","3b0490f2-3f98-11f0-a0de-76b3cceeab13",15,["D",1748858350614],"/** @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?deps=react@18.2.0\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();",[],[161,220],"0e4a2342-3f98-11f0-81cf-76b3cceeab13","index.html","0e4a23f6-3f98-11f0-81cf-76b3cceeab13",["D",1748858275572],"\n\n\n \n \n Jotter - Notes for Remote Workspaces\n \n \n \n \n \n \n\n\n

\n \n\n",[],[161,228],"13c1706e-3f98-11f0-b85e-76b3cceeab13","SearchBar.tsx","13c1715e-3f98-11f0-b85e-76b3cceeab13","bca7a288-ebf0-438a-96bf-cf363ceca606",11,["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}",[],[161,243,235],"components","20b42992-3f98-11f0-a759-76b3cceeab13","NotesList.tsx","20b42aaa-3f98-11f0-a759-76b3cceeab13",12,["D",1748858306469],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { Note } from \"../../shared/types.ts\";\nimport SearchBar from \"./SearchBar.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 \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 {/* Notes List */}\n

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

📄

No notes yet

Create your first note to get started

\n ) : (\n

\n {notes.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 {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}",[],[161,243,245],"2df6ddca-3f98-11f0-a95b-76b3cceeab13","NoteEditor.tsx","2df6deba-3f98-11f0-a95b-76b3cceeab13",13,["D",1748858328715],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { Note } from \"../../shared/types.ts\";\n\ninterface NoteEditorProps {\n note: Note | null;\n onSave: (id: number, title: string, content: string) => void;\n}\n\nexport default function NoteEditor({ note, onSave }: NoteEditorProps) {\n const [title, setTitle] = useState(\"\");\n const [content, setContent] = useState(\"\");\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 } else {\n setTitle(\"\");\n setContent(\"\");\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 || content !== note.content) {\n setIsSaving(true);\n try {\n await onSave(note.id, title, content);\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, 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 text-gray-900 bg-transparent border-none outline-none placeholder-gray-400\"\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 {/* 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}",[],[161,243,253],"3860ffc0-3f98-11f0-a790-76b3cceeab13","App.tsx","38610074-3f98-11f0-a790-76b3cceeab13",14,["D",1748858346187],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { Note } 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 })\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 (id: number, title: string, content: string) => {\n try {\n const response = await fetch(`/api/notes/${id}`, {\n method: 'PUT',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ title, content })\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}",[],[161,243,261],"13c1773a-3f98-11f0-b85e-76b3cceeab13",["D",1748858284741],[192,193,194,195],[161,243],["D",1748858275572],[191,196,197],[161],"440c4938-3f98-11f0-a83c-76b3cceeab13",["D",1748858365762],[],[167,33],"025e8730-3f98-11f0-b775-76b3cceeab13","notes.ts","025e87f8-3f98-11f0-b775-76b3cceeab13","375d9928-e523-4387-80e0-575ebe733b85",8,["D",1748858255574],"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 };\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;",[],[167,288,280],"routes","025e9360-3f98-11f0-b775-76b3cceeab13",["D",1748858255574],[188],[167,288],"fb9d7eba-3f97-11f0-8845-76b3cceeab13","queries.ts","fb9d7f5a-3f97-11f0-8845-76b3cceeab13","a09f57fb-2680-409a-bf5e-a7840ebee99b",7,["D",1748858244242],"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 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)\n VALUES (?, ?)\n `, [data.title, data.content]);\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 (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}",[],[167,302,294],"database","f523a8ca-3f97-11f0-a83c-76b3cceeab13","migrations.ts","f523a974-3f97-11f0-a83c-76b3cceeab13",["D",1748858233376],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = 'jotter_notes_v1';\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 created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\nexport { TABLE_NAME };",[],[167,302,304],"f523b55e-3f97-11f0-a83c-76b3cceeab13",["D",1748858233376],[185,186],[167,302],["D",1748858233376],[184,187,189],[167],["D",1748857795739],["D",1789649456549],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":56,"_104":105,"_106":25},{"_13":89,"_32":90,"_44":43,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":46,"_98":99},"ctx",{"_82":-5,"_127":355,"_356":357,"_358":359,"_360":25,"_361":25,"_362":25,"_363":59,"_364":-5,"_365":-7,"_366":-7,"_367":63,"_368":25,"_369":25,"_370":-5,"_371":25,"_372":25,"_373":25,"_374":-5},"ENV",{"_326":327,"_328":329,"_330":90,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v17