ID	Title	Project	Type	Status	Actions
${row[0]}	${row[1]}	${\n row[4]\n }	${row[3]}	${row[5]}	\| \|

\";\n return html;\n}\n\nasync function getProject(req: HonoRequest) {\n const name = req.param(\"name\");\n const rows = await sqlite.execute({ sql: \"SELECT * FROM bugs WHERE project = ?\", args: [name] });\n let html = await getTable(rows);\n html += \"

\";\n return await htmlWrapper(html);\n}\n\nasync function distinctProjects(): any {\n return await sqlite.execute(\"SELECT DISTINCT project FROM bugs\");\n}\n\nasync function getProjects() {\n const rows = await distinctProjects();\n let html = \"\";\n for (const row of rows.rows) {\n html += ``;\n }\n html += \"

Project
${row[0]}

\";\n html += \"

Home

\";\n return await htmlWrapper(html);\n}\n\nasync function showBug(req: HonoRequest) {\n const id = req.param(\"id\");\n const rows = await sqlite.execute({ sql: \"SELECT * FROM bugs WHERE id = ?\", args: [id] });\n let html = await getTable(rows);\n html += `${await markdownToHtml(rows.rows[0][2])}`;\n html += \"

Home

\";\n return await htmlWrapper(html);\n}\n\nasync function bugListTable(q: string) {\n let rows = await sqlite.execute(\"SELECT * FROM bugs where status='open'\");\n if (q == \"all\") {\n rows = await sqlite.execute(\"SELECT * FROM bugs\");\n }\n let html = await getTable(rows);\n html +=\n \"Show All | Show Open | New | Show Projects\";\n return await htmlWrapper(html);\n}\n\nasync function createBugForm(req: HonoRequest) {\n let parent = req.query(\"parent\");\n let parentHTML = `Parent:\n `;\n let datalist = ``;\n const rows = await distinctProjects();\n for (const row of rows.rows) {\n datalist += `\";\n let projectHTML = `Project:\n ${datalist}`;\n if (parent != null) {\n parentHTML = ``;\n const rows = await sqlite.execute({ sql: \"select project from bugs where id=?\", args: [parent] });\n projectHTML = ``;\n }\n\n let body = `\n \n Home\n\n `;\n return await htmlWrapper(body);\n}\n\nasync function htmlWrapper(html: string) {\n const style = \"\";\n return `\n \n \n Bug Tracker\n \n \n \n \n

Bug Tracker

\n ${html}\n \n \n `;\n}\n\nasync function createBug(req: HonoRequest) {\n const formData = await req.formData();\n const title = formData.get(\"title\") as string;\n const description = formData.get(\"description\") as string;\n const type = formData.get(\"type\") as string;\n const project = formData.get(\"project\") as string;\n const status = formData.get(\"status\") as string;\n const parent = formData.get(\"parent\") as string;\n await sqlite.execute({\n sql: `INSERT INTO bugs (title, description, type, project, status, parent) VALUES (?, ?, ?, ?, ?, ?)`,\n args: [title, description, type, project, status, parent],\n });\n return createBugForm(req);\n}\n\nasync function closeBug(req: HonoRequest) {\n const id = req.param(\"id\");\n await sqlite.execute({\n sql: `UPDATE bugs SET status = 'closed', closedtime = CURRENT_TIMESTAMP WHERE id = ?`,\n args: [id],\n });\n return bugListTable(req);\n}\n\nasync function wontfixBug(req: HonoRequest) {\n const id = req.param(\"id\");\n await sqlite.execute({\n sql: `UPDATE bugs SET status = 'wontfix', closedtime = CURRENT_TIMESTAMP WHERE id = ?`,\n args: [id],\n });\n return bugListTable(req);\n}","deleted","label",[98],"permalink","https://www.val.town/x/stevekrouse/BugTracker/code/main.tsx","extension","actionData","errors"]