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 order by project asc\");\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 = getBugCSS();\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}",[],[172],"files",[151,170],"counts",{"_183":32,"_184":119,"_185":119,"_186":187},"pulls","branches","forks","envVars",{"_188":32,"_189":32},"count","emptyCount","contents",[192,195],{"_102":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":119,"_159":108,"_104":193,"_99":32,"_161":162,"_163":164,"_165":22,"_166":-5,"_98":194},["D",1734371429946],[153],{"_102":171,"_95":172,"_154":115,"_156":-5,"_157":139,"_158":138,"_159":108,"_104":196,"_99":174,"_161":175,"_163":176,"_165":22,"_166":-5,"_98":197},["D",1743550160031],[172],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name._index",{"_93":94,"_95":96,"_97":-7,"_99":-7,"_100":206,"_190":211,"_216":217,"_220":-5,"_221":-5,"_179":222,"_229":230},{"_102":103,"_95":96,"_104":207,"_106":-5,"_107":108,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":115,"_116":108,"_117":-5,"_118":119,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":208,"_133":209,"_136":210,"_148":22},["D",1746140232154],{"_93":94,"_131":132},{"_93":94,"_135":132},{"_99":138,"_95":43,"_102":139,"_140":103,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},[212,214],{"_102":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":119,"_159":108,"_104":193,"_99":32,"_161":162,"_163":164,"_165":22,"_166":-5,"_98":213},[153],{"_102":171,"_95":172,"_154":115,"_156":-5,"_157":139,"_158":138,"_159":108,"_104":196,"_99":174,"_161":175,"_163":176,"_165":22,"_166":-5,"_98":215},[172],"readme",{"_102":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":119,"_159":108,"_104":218,"_99":32,"_161":162,"_163":164,"_165":22,"_166":-5,"_98":219},["D",1734371429946],[153],"upstream","pull",[223,226],{"_102":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":119,"_159":108,"_104":160,"_99":32,"_161":162,"_163":164,"_165":22,"_166":-5,"_167":224,"_98":225},[],[153],{"_102":171,"_95":172,"_154":115,"_156":-5,"_157":139,"_158":138,"_159":108,"_104":173,"_99":174,"_161":175,"_163":176,"_165":22,"_166":-5,"_167":227,"_98":228},[],[172],"previews",[226],"actionData","errors"]

flymaster

BugTracker