${line.substring(2)}

`;\n } else if (line.startsWith('## ')) {\n html += `

${line.substring(3)}

`;\n } else if (line.startsWith('### ')) {\n html += `

${line.substring(4)}

`;\n } else if (line.startsWith('* ')) {\n html += `

${line.substring(2)}

`;\n } else if (line.startsWith('=>')) {\n const parts = line.substring(2).trim().split(/\\s+/, 2);\n const url = parts[0];\n const label = parts[1] || url;\n html += `

${label}

`;\n } else if (line.startsWith('> ')) {\n html += `

${line.substring(2)}

`;\n } else if (line.trim() === '') {\n html += '
';\n } else {\n html += `

${line}

`;\n }\n }\n\n return html;\n}\n\n// Render HTML page layout\nfunction renderPageLayout(title: string, styles: string, body: string): string {\n return `\n \n \n \n \n \n ${title}\n \n \n \n \n \n ${body}\n \n \n `;\n}\n\n// Render the notes list page\nfunction renderNotesListPage(notesTableRows: string): string {\n const styles = `\n table { width: 100%; }\n td:first-child { width: auto; }\n td:last-child { width: 1%; text-align: right; white-space: nowrap; }\n textarea { width: 100%; min-height: 100px; }\n form { display: inline-block; margin: 0; }\n button { margin: 0 2px; }\n `;\n\n const body = `\n

Notes

\n Back to Home |\n Search\n

\n\n \n\n

All Notes

\n \n \n \n \n \n \n \n \n ${notesTableRows}\n \n

Note

\n `;\n\n return renderPageLayout('Notes', styles, body);\n}\n\n// Render the search page\nfunction renderSearchPage(notesTableRows: string, searchQuery: string): string {\n const styles = `\n table { width: 100%; }\n td:first-child { width: auto; }\n td:last-child { width: 1%; text-align: right; white-space: nowrap; }\n input[type=\"text\"] { width: 100%; max-width: 500px; }\n `;\n\n const body = `\n

Search Notes

Back to Notes

\n\n \n\n ${searchQuery ? `\n

Search results for \"${searchQuery}\"

\n \n \n \n \n \n \n \n \n ${notesTableRows}\n \n

Note

\n ` : ''}\n `;\n\n return renderPageLayout('Search Notes', styles, body);\n}\n\n// Render the edit note page\nfunction renderEditNotePage(id: string, content: string): string {\n const styles = `\n textarea { width: 100%; min-height: 200px; }\n `;\n\n const body = `\n

Edit Note

\n \n `;\n\n return renderPageLayout('Edit Note', styles, body);\n}\n\n// Render the tag filter page\nfunction renderTagFilterPage(tag: string, notesTableRows: string): string {\n const styles = `\n table { width: 100%; }\n td:first-child { width: auto; }\n td:last-child { width: 1%; text-align: right; white-space: nowrap; }\n `;\n\n const body = `\n

Notes tagged #${tag}

Back to All Notes

\n\n \n \n \n \n \n \n \n \n ${notesTableRows}\n \n

Note

\n `;\n\n return renderPageLayout(`Notes tagged #${tag}`, styles, body);\n}\n\n// Database operations - exported for use in API\n\nexport async function getAllNotes() {\n const notes = await sqlite.execute(\"SELECT * FROM notes ORDER BY created_at DESC\");\n return notes.rows;\n}\n\nexport async function getNoteById(id: string | number) {\n const result = await sqlite.execute(\"SELECT * FROM notes WHERE id = ?\", [id]);\n return result.rows.length > 0 ? result.rows[0] : null;\n}\n\nexport async function createNote(content: string, tags: string[]) {\n const result = await sqlite.execute(\n \"INSERT INTO notes (content) VALUES (?)\",\n [content]\n );\n\n const noteId = result.lastInsertRowid;\n\n if (noteId !== undefined) {\n for (const tag of tags) {\n await sqlite.execute(\n \"INSERT INTO notes_tags (note_id, tag) VALUES (?, ?)\",\n [Number(noteId), tag]\n );\n }\n }\n\n return noteId;\n}\n\nexport async function updateNote(id: string | number, content: string, tags: string[]) {\n await sqlite.execute(\n \"UPDATE notes SET content = ? WHERE id = ?\",\n [content, id]\n );\n\n await sqlite.execute(\"DELETE FROM notes_tags WHERE note_id = ?\", [id]);\n for (const tag of tags) {\n await sqlite.execute(\n \"INSERT INTO notes_tags (note_id, tag) VALUES (?, ?)\",\n [id, tag]\n );\n }\n}\n\nexport async function deleteNote(id: string | number) {\n await sqlite.execute(\"DELETE FROM notes_tags WHERE note_id = ?\", [id]);\n await sqlite.execute(\"DELETE FROM notes WHERE id = ?\", [id]);\n}\n\nexport async function searchNotes(query: string) {\n const result = await sqlite.execute(`\n SELECT * FROM notes\n WHERE content LIKE ?\n ORDER BY created_at DESC\n `, [`%${query}%`]);\n return result.rows;\n}\n\nexport async function getNotesByTag(tag: string) {\n const result = await sqlite.execute(`\n SELECT n.* FROM notes n\n INNER JOIN notes_tags nt ON n.id = nt.note_id\n WHERE nt.tag = ?\n ORDER BY n.created_at DESC\n `, [tag]);\n return result.rows;\n}\n\nexport async function getNoteTags(noteId: string | number) {\n const tagsResult = await sqlite.execute(\n \"SELECT tag FROM notes_tags WHERE note_id = ?\",\n [Number(noteId)]\n );\n return tagsResult.rows.map(row => String(row.tag));\n}\n\n// Helper to build note table rows with tags\nasync function buildNoteTableRows(notes: any[]): Promise {\n let notesTableRows = '';\n\n for (const note of notes) {\n const renderedContent = renderGemtext(String(note.content || ''));\n const tags = await getNoteTags(note.id);\n\n // Render tags as links\n const tagsHtml = tags.length > 0\n ? `

\n ${tags.map(tag => `#${tag}`).join('')}\n

`\n : '';\n\n notesTableRows += `\n \n ${renderedContent}${tagsHtml}\n \n \n \n \n \n `;\n }\n\n return notesTableRows;\n}\n\n// Export extractTags for use in API\nexport { extractTags };\n\n// GET /notes - Display all notes\nexport async function handleGetNotes(c: Context) {\n const notes = await getAllNotes();\n const notesTableRows = await buildNoteTableRows(notes);\n return c.html(renderNotesListPage(notesTableRows));\n}\n\n// POST /notes - Create a new note\nexport async function handleCreateNote(c: Context) {\n const body = await c.req.parseBody();\n const content = body.content as string;\n\n const { cleanContent, tags } = extractTags(content);\n await createNote(cleanContent, tags);\n\n return c.redirect(\"/notes\");\n}\n\n// GET /notes/:id/delete - Delete a note\nexport async function handleDeleteNote(c: Context) {\n const id = c.req.param(\"id\");\n await deleteNote(id);\n return c.redirect(\"/notes\");\n}\n\n// GET /notes/:id/edit - Show edit form\nexport async function handleEditNoteForm(c: Context) {\n const id = c.req.param(\"id\");\n const note = await getNoteById(id);\n\n if (!note) {\n return c.redirect(\"/notes\");\n }\n\n return c.html(renderEditNotePage(id, String(note.content || '')));\n}\n\n// POST /notes/:id/update - Update a note\nexport async function handleUpdateNote(c: Context) {\n const id = c.req.param(\"id\");\n const body = await c.req.parseBody();\n const content = body.content as string;\n\n const { cleanContent, tags } = extractTags(content);\n await updateNote(id, cleanContent, tags);\n\n return c.redirect(\"/notes\");\n}\n\n// GET /notes/search - Search notes\nexport async function handleSearchNotes(c: Context) {\n const query = c.req.query('q') || '';\n\n if (!query.trim()) {\n return c.html(renderSearchPage('', ''));\n }\n\n const notes = await searchNotes(query);\n const notesTableRows = await buildNoteTableRows(notes);\n return c.html(renderSearchPage(notesTableRows, query));\n}\n\n// GET /tags/:tag - Display all notes with a specific tag\nexport async function handleGetNotesByTag(c: Context) {\n const tag = c.req.param(\"tag\");\n const notes = await getNotesByTag(tag);\n const notesTableRows = await buildNoteTableRows(notes);\n return c.html(renderTagFilterPage(tag, notesTableRows));\n}\n","deleted","label",[98],"permalink","https://www.val.town/x/flymaster/lifehub/code/notes.ts","extension","actionData","errors"]