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 = 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}","createdAt",["D",1738174681208],"version",157,"currentUserHasLiked","likeCount","forkCount",1,"referenceCount","dependencyCount",3,"commentCount","prCount","mergedPr",{"_131":132,"_133":134},"handle","flymaster","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJsemw5UHAzaE8xeGRPbnpDRnZqNFhVR1NvNCJ9","forkedVal","interval","slug","flymaster/BugTracker","description","versions",[142,145,149,153,157,161,165,169,173,177,181,185,189,193,197,201,205,209,213,217,221,225,229,233,237,241,245,249,253,257,261,265,269,273,277,281,285,289,293,297,301,305,309,313,317,321,325,329,333,337,341,345,349,353,357,361,365,369,373,377,381,385,389,393,397,401,405,409,413,417,421,425,429,433,437,441,445,449,453,457,461,465,469,473,477,481,485,489,493,497,501,505,509,513,517,521,525,529,533,537,541,545,549,553,557,561,565,569,573,577,581,585,589,593,597,601,605,609,613,617,621,625,629,633,637,641,645,649,653,657,661,665,669,673,677,681,685,689,693,697,701,705,709,713,717,721,725,729,733,737,741,745,749,753,757,760,763,766],{"_118":119,"_143":-5,"_116":144,"_113":111},"prId",["D",1738174681208],{"_118":146,"_143":-5,"_116":147,"_113":148},156,["D",1738174650176],"4d575eb0-de6d-11ef-9f0c-e6cdfca9ef9f",{"_118":150,"_143":-5,"_116":151,"_113":152},155,["D",1738174590987],"2a12ae46-de6d-11ef-942c-e6cdfca9ef9f",{"_118":154,"_143":-5,"_116":155,"_113":156},154,["D",1738174521784],"00ccd368-de6d-11ef-8f07-e6cdfca9ef9f",{"_118":158,"_143":-5,"_116":159,"_113":160},153,["D",1738174464742],"decf4f70-de6c-11ef-977b-e6cdfca9ef9f",{"_118":162,"_143":-5,"_116":163,"_113":164},152,["D",1738174421736],"c52a6ab4-de6c-11ef-8f07-e6cdfca9ef9f",{"_118":166,"_143":-5,"_116":167,"_113":168},151,["D",1738174373291],"a84b9eea-de6c-11ef-9b3b-e6cdfca9ef9f",{"_118":170,"_143":-5,"_116":171,"_113":172},150,["D",1738174345521],"97bd87a0-de6c-11ef-91e5-e6cdfca9ef9f",{"_118":174,"_143":-5,"_116":175,"_113":176},149,["D",1738174315669],"85f2a87a-de6c-11ef-9d53-e6cdfca9ef9f",{"_118":178,"_143":-5,"_116":179,"_113":180},148,["D",1736537907839],"76de7cb0-cf8a-11ef-a486-e6cdfca9ef9f",{"_118":182,"_143":-5,"_116":183,"_113":184},147,["D",1736536676979],"993937c6-cf87-11ef-ba03-e6cdfca9ef9f",{"_118":186,"_143":-5,"_116":187,"_113":188},146,["D",1736536306356],"bc4faf66-cf86-11ef-943b-e6cdfca9ef9f",{"_118":190,"_143":-5,"_116":191,"_113":192},145,["D",1736194744872],"79cf1528-cc6b-11ef-aa2d-e6cdfca9ef9f",{"_118":194,"_143":-5,"_116":195,"_113":196},144,["D",1736194499150],"e75851a0-cc6a-11ef-9668-e6cdfca9ef9f",{"_118":198,"_143":-5,"_116":199,"_113":200},143,["D",1736194482948],"ddafe21c-cc6a-11ef-8358-e6cdfca9ef9f",{"_118":202,"_143":-5,"_116":203,"_113":204},142,["D",1736191068232],"ea5a67ec-cc62-11ef-aa44-e6cdfca9ef9f",{"_118":206,"_143":-5,"_116":207,"_113":208},141,["D",1736191025881],"d11d82fa-cc62-11ef-bea2-e6cdfca9ef9f",{"_118":210,"_143":-5,"_116":211,"_113":212},140,["D",1736190960227],"a9fb740c-cc62-11ef-9c8c-e6cdfca9ef9f",{"_118":214,"_143":-5,"_116":215,"_113":216},139,["D",1736190897280],"847550e0-cc62-11ef-a6c8-e6cdfca9ef9f",{"_118":218,"_143":-5,"_116":219,"_113":220},138,["D",1736190892739],"81c156fa-cc62-11ef-936a-e6cdfca9ef9f",{"_118":222,"_143":-5,"_116":223,"_113":224},137,["D",1736190872586],"75bd6308-cc62-11ef-b905-e6cdfca9ef9f",{"_118":226,"_143":-5,"_116":227,"_113":228},136,["D",1736190859258],"6dcee28e-cc62-11ef-bf4f-e6cdfca9ef9f",{"_118":230,"_143":-5,"_116":231,"_113":232},135,["D",1736190732647],"22552728-cc62-11ef-aa5f-e6cdfca9ef9f",{"_118":234,"_143":-5,"_116":235,"_113":236},134,["D",1736190688027],"07bcf4cc-cc62-11ef-b974-e6cdfca9ef9f",{"_118":238,"_143":-5,"_116":239,"_113":240},133,["D",1735934165449],"c45d6d62-ca0c-11ef-a78f-e6cdfca9ef9f",{"_118":242,"_143":-5,"_116":243,"_113":244},132,["D",1735862119300],"0582fcc4-c965-11ef-bd0f-e6cdfca9ef9f",{"_118":246,"_143":-5,"_116":247,"_113":248},131,["D",1735862048940],"db9425aa-c964-11ef-b6b6-e6cdfca9ef9f",{"_118":250,"_143":-5,"_116":251,"_113":252},130,["D",1734545707677],"030a3638-bd6c-11ef-91b8-e6cdfca9ef9f",{"_118":254,"_143":-5,"_116":255,"_113":256},129,["D",1734545694226],"fb05f850-bd6b-11ef-8c6b-e6cdfca9ef9f",{"_118":258,"_143":-5,"_116":259,"_113":260},128,["D",1734544762943],"cfeebc4e-bd69-11ef-afd9-e6cdfca9ef9f",{"_118":262,"_143":-5,"_116":263,"_113":264},127,["D",1734544652834],"8e4db0ce-bd69-11ef-978e-e6cdfca9ef9f",{"_118":266,"_143":-5,"_116":267,"_113":268},126,["D",1734544617317],"792296c4-bd69-11ef-b533-e6cdfca9ef9f",{"_118":270,"_143":-5,"_116":271,"_113":272},125,["D",1734544598054],"6da7b130-bd69-11ef-8103-e6cdfca9ef9f",{"_118":274,"_143":-5,"_116":275,"_113":276},124,["D",1734544583353],"64e43a50-bd69-11ef-9aec-e6cdfca9ef9f",{"_118":278,"_143":-5,"_116":279,"_113":280},123,["D",1734544559437],"56a2ff4e-bd69-11ef-94e4-e6cdfca9ef9f",{"_118":282,"_143":-5,"_116":283,"_113":284},122,["D",1734544512214],"3a7ca2b6-bd69-11ef-8c92-e6cdfca9ef9f",{"_118":286,"_143":-5,"_116":287,"_113":288},121,["D",1734544483139],"29291094-bd69-11ef-8ebb-e6cdfca9ef9f",{"_118":290,"_143":-5,"_116":291,"_113":292},120,["D",1734544465069],"1e65e8d0-bd69-11ef-bdf5-e6cdfca9ef9f",{"_118":294,"_143":-5,"_116":295,"_113":296},119,["D",1734543970151],"f7665b62-bd67-11ef-b70d-e6cdfca9ef9f",{"_118":298,"_143":-5,"_116":299,"_113":300},118,["D",1734543926560],"dd6908a4-bd67-11ef-9172-e6cdfca9ef9f",{"_118":302,"_143":-5,"_116":303,"_113":304},117,["D",1734543876793],"bfbefcb4-bd67-11ef-b296-e6cdfca9ef9f",{"_118":306,"_143":-5,"_116":307,"_113":308},116,["D",1734543850114],"afdcd6fe-bd67-11ef-b296-e6cdfca9ef9f",{"_118":310,"_143":-5,"_116":311,"_113":312},115,["D",1734543830372],"a414c3e0-bd67-11ef-a0bd-e6cdfca9ef9f",{"_118":314,"_143":-5,"_116":315,"_113":316},114,["D",1734543820550],"9e39c7e0-bd67-11ef-9b63-e6cdfca9ef9f",{"_118":318,"_143":-5,"_116":319,"_113":320},113,["D",1734543674676],"4748760c-bd67-11ef-90c7-e6cdfca9ef9f",{"_118":322,"_143":-5,"_116":323,"_113":324},112,["D",1734543596933],"18f03b28-bd67-11ef-9a56-e6cdfca9ef9f",{"_118":326,"_143":-5,"_116":327,"_113":328},111,["D",1734543488098],"d810eeea-bd66-11ef-a964-e6cdfca9ef9f",{"_118":330,"_143":-5,"_116":331,"_113":332},110,["D",1734543446051],"bf01918e-bd66-11ef-81f9-e6cdfca9ef9f",{"_118":334,"_143":-5,"_116":335,"_113":336},109,["D",1734539650814],"e8ddcada-bd5d-11ef-b132-e6cdfca9ef9f",{"_118":338,"_143":-5,"_116":339,"_113":340},108,["D",1734539615375],"d3beb43e-bd5d-11ef-932f-e6cdfca9ef9f",{"_118":342,"_143":-5,"_116":343,"_113":344},107,["D",1734539554890],"afb2f492-bd5d-11ef-b86d-e6cdfca9ef9f",{"_118":346,"_143":-5,"_116":347,"_113":348},106,["D",1734539524605],"9da43a9a-bd5d-11ef-89de-e6cdfca9ef9f",{"_118":350,"_143":-5,"_116":351,"_113":352},105,["D",1734539471089],"7dbfa552-bd5d-11ef-ba3b-e6cdfca9ef9f",{"_118":354,"_143":-5,"_116":355,"_113":356},104,["D",1734539348979],"34f659e2-bd5d-11ef-89ed-e6cdfca9ef9f",{"_118":358,"_143":-5,"_116":359,"_113":360},103,["D",1734539335199],"2cbeec26-bd5d-11ef-80a6-e6cdfca9ef9f",{"_118":362,"_143":-5,"_116":363,"_113":364},102,["D",1734539292568],"13579c74-bd5d-11ef-80a6-e6cdfca9ef9f",{"_118":366,"_143":-5,"_116":367,"_113":368},101,["D",1734539166753],"c8587108-bd5c-11ef-bfe7-e6cdfca9ef9f",{"_118":370,"_143":-5,"_116":371,"_113":372},100,["D",1734539146698],"bc64a2e0-bd5c-11ef-b123-e6cdfca9ef9f",{"_118":374,"_143":-5,"_116":375,"_113":376},99,["D",1734468383278],"fa1bca78-bcb7-11ef-8e8b-e6cdfca9ef9f",{"_118":378,"_143":-5,"_116":379,"_113":380},98,["D",1734468329276],"d9eaf6de-bcb7-11ef-8c72-e6cdfca9ef9f",{"_118":382,"_143":-5,"_116":383,"_113":384},97,["D",1734465555569],"64a88d2e-bcb1-11ef-bae2-e6cdfca9ef9f",{"_118":386,"_143":-5,"_116":387,"_113":388},96,["D",1734465495247],"40b4ef02-bcb1-11ef-b7e9-e6cdfca9ef9f",{"_118":390,"_143":-5,"_116":391,"_113":392},95,["D",1734465430276],"19fae3e4-bcb1-11ef-a1d8-e6cdfca9ef9f",{"_118":394,"_143":-5,"_116":395,"_113":396},94,["D",1734465415090],"10ed45da-bcb1-11ef-a5d8-e6cdfca9ef9f",{"_118":398,"_143":-5,"_116":399,"_113":400},93,["D",1734465326651],"dc3726da-bcb0-11ef-a5d8-e6cdfca9ef9f",{"_118":402,"_143":-5,"_116":403,"_113":404},92,["D",1734463874282],"7a88ed2c-bcad-11ef-bd46-e6cdfca9ef9f",{"_118":406,"_143":-5,"_116":407,"_113":408},91,["D",1734463861421],"72dec060-bcad-11ef-b9c1-e6cdfca9ef9f",{"_118":410,"_143":-5,"_116":411,"_113":412},90,["D",1734463833092],"61fc08c0-bcad-11ef-9e97-e6cdfca9ef9f",{"_118":414,"_143":-5,"_116":415,"_113":416},89,["D",1734463698116],"1187f4c6-bcad-11ef-9f5a-e6cdfca9ef9f",{"_118":418,"_143":-5,"_116":419,"_113":420},88,["D",1734463621329],"e3c31c00-bcac-11ef-81d7-e6cdfca9ef9f",{"_118":422,"_143":-5,"_116":423,"_113":424},87,["D",1734461312738],"83bc778e-bca7-11ef-a988-e6cdfca9ef9f",{"_118":426,"_143":-5,"_116":427,"_113":428},86,["D",1734461190465],"3adb103e-bca7-11ef-abd0-e6cdfca9ef9f",{"_118":430,"_143":-5,"_116":431,"_113":432},85,["D",1734460805009],"551b0018-bca6-11ef-95bc-e6cdfca9ef9f",{"_118":434,"_143":-5,"_116":435,"_113":436},84,["D",1734460763882],"3c97b3d8-bca6-11ef-95bc-e6cdfca9ef9f",{"_118":438,"_143":-5,"_116":439,"_113":440},83,["D",1734460622888],"e88d9942-bca5-11ef-bbe9-e6cdfca9ef9f",{"_118":442,"_143":-5,"_116":443,"_113":444},82,["D",1734460588297],"d3ef0e62-bca5-11ef-9aad-e6cdfca9ef9f",{"_118":446,"_143":-5,"_116":447,"_113":448},81,["D",1734460525408],"ae738e74-bca5-11ef-8829-e6cdfca9ef9f",{"_118":450,"_143":-5,"_116":451,"_113":452},80,["D",1734460477327],"91ca768e-bca5-11ef-9d29-e6cdfca9ef9f",{"_118":454,"_143":-5,"_116":455,"_113":456},79,["D",1734460414920],"6c989062-bca5-11ef-9be3-e6cdfca9ef9f",{"_118":458,"_143":-5,"_116":459,"_113":460},78,["D",1734460300642],"287a990c-bca5-11ef-a711-e6cdfca9ef9f",{"_118":462,"_143":-5,"_116":463,"_113":464},77,["D",1734460231833],"ff77a4a0-bca4-11ef-a711-e6cdfca9ef9f",{"_118":466,"_143":-5,"_116":467,"_113":468},76,["D",1734460015209],"7e592222-bca4-11ef-83db-e6cdfca9ef9f",{"_118":470,"_143":-5,"_116":471,"_113":472},75,["D",1734460000465],"758f5dfa-bca4-11ef-829c-e6cdfca9ef9f",{"_118":474,"_143":-5,"_116":475,"_113":476},74,["D",1734459973899],"65b9b0d8-bca4-11ef-8a4d-e6cdfca9ef9f",{"_118":478,"_143":-5,"_116":479,"_113":480},73,["D",1734459861545],"22c2d174-bca4-11ef-b1cf-e6cdfca9ef9f",{"_118":482,"_143":-5,"_116":483,"_113":484},72,["D",1734459487130],"43967cd0-bca3-11ef-97b1-e6cdfca9ef9f",{"_118":486,"_143":-5,"_116":487,"_113":488},71,["D",1734459302723],"d5acf28a-bca2-11ef-a1f5-e6cdfca9ef9f",{"_118":490,"_143":-5,"_116":491,"_113":492},70,["D",1734459254038],"b8a7afc2-bca2-11ef-8028-e6cdfca9ef9f",{"_118":494,"_143":-5,"_116":495,"_113":496},69,["D",1734459208167],"9d500530-bca2-11ef-b8b6-e6cdfca9ef9f",{"_118":498,"_143":-5,"_116":499,"_113":500},68,["D",1734459171368],"87611be2-bca2-11ef-878c-e6cdfca9ef9f",{"_118":502,"_143":-5,"_116":503,"_113":504},67,["D",1734459085556],"543b125e-bca2-11ef-9ce0-e6cdfca9ef9f",{"_118":506,"_143":-5,"_116":507,"_113":508},66,["D",1734459080550],"513fc518-bca2-11ef-a43d-e6cdfca9ef9f",{"_118":510,"_143":-5,"_116":511,"_113":512},65,["D",1734459009991],"2731265e-bca2-11ef-b10e-e6cdfca9ef9f",{"_118":514,"_143":-5,"_116":515,"_113":516},64,["D",1734458994968],"1e3c8372-bca2-11ef-9ce0-e6cdfca9ef9f",{"_118":518,"_143":-5,"_116":519,"_113":520},63,["D",1734458896749],"e3b22018-bca1-11ef-a7a6-e6cdfca9ef9f",{"_118":522,"_143":-5,"_116":523,"_113":524},62,["D",1734454318707],"3af782ba-bc97-11ef-b637-e6cdfca9ef9f",{"_118":526,"_143":-5,"_116":527,"_113":528},61,["D",1734454215752],"fd9a155e-bc96-11ef-baf5-e6cdfca9ef9f",{"_118":530,"_143":-5,"_116":531,"_113":532},60,["D",1734454139378],"d01424bc-bc96-11ef-b50d-e6cdfca9ef9f",{"_118":534,"_143":-5,"_116":535,"_113":536},59,["D",1734454136256],"ce37e138-bc96-11ef-8da5-e6cdfca9ef9f",{"_118":538,"_143":-5,"_116":539,"_113":540},58,["D",1734454066634],"a4b974d4-bc96-11ef-a11a-e6cdfca9ef9f",{"_118":542,"_143":-5,"_116":543,"_113":544},57,["D",1734453977006],"6f4c27b0-bc96-11ef-b886-e6cdfca9ef9f",{"_118":546,"_143":-5,"_116":547,"_113":548},56,["D",1734453918427],"4c61e37a-bc96-11ef-9d1f-e6cdfca9ef9f",{"_118":550,"_143":-5,"_116":551,"_113":552},55,["D",1734453801266],"068cc806-bc96-11ef-9542-e6cdfca9ef9f",{"_118":554,"_143":-5,"_116":555,"_113":556},54,["D",1734453767064],"f22a2cd2-bc95-11ef-b0f5-e6cdfca9ef9f",{"_118":558,"_143":-5,"_116":559,"_113":560},53,["D",1734453717784],"d4ca1a58-bc95-11ef-bc34-e6cdfca9ef9f",{"_118":562,"_143":-5,"_116":563,"_113":564},52,["D",1734453623635],"9cac6806-bc95-11ef-9b00-e6cdfca9ef9f",{"_118":566,"_143":-5,"_116":567,"_113":568},51,["D",1734453584582],"85656076-bc95-11ef-be72-e6cdfca9ef9f",{"_118":570,"_143":-5,"_116":571,"_113":572},50,["D",1734453569788],"7c93c6d6-bc95-11ef-99e9-e6cdfca9ef9f",{"_118":574,"_143":-5,"_116":575,"_113":576},49,["D",1734453517290],"5d4974f6-bc95-11ef-99e9-e6cdfca9ef9f",{"_118":578,"_143":-5,"_116":579,"_113":580},48,["D",1734453475792],"448cf71c-bc95-11ef-9d43-e6cdfca9ef9f",{"_118":582,"_143":-5,"_116":583,"_113":584},47,["D",1734453458072],"39fd710a-bc95-11ef-b30b-e6cdfca9ef9f",{"_118":586,"_143":-5,"_116":587,"_113":588},46,["D",1734453426626],"273ea52a-bc95-11ef-bcf1-e6cdfca9ef9f",{"_118":590,"_143":-5,"_116":591,"_113":592},45,["D",1734453180464],"9485baca-bc94-11ef-9f47-e6cdfca9ef9f",{"_118":594,"_143":-5,"_116":595,"_113":596},44,["D",1734453161975],"8982a5d4-bc94-11ef-96cb-e6cdfca9ef9f",{"_118":598,"_143":-5,"_116":599,"_113":600},43,["D",1734453142849],"7e1aaa48-bc94-11ef-8a67-e6cdfca9ef9f",{"_118":602,"_143":-5,"_116":603,"_113":604},42,["D",1734453082372],"5a0df218-bc94-11ef-9b4e-e6cdfca9ef9f",{"_118":606,"_143":-5,"_116":607,"_113":608},41,["D",1734449111578],"1b46b9b0-bc8b-11ef-843c-e6cdfca9ef9f",{"_118":610,"_143":-5,"_116":611,"_113":612},40,["D",1734449096047],"120f4ccc-bc8b-11ef-99ce-e6cdfca9ef9f",{"_118":614,"_143":-5,"_116":615,"_113":616},39,["D",1734449078841],"07c47d32-bc8b-11ef-9976-e6cdfca9ef9f",{"_118":618,"_143":-5,"_116":619,"_113":620},38,["D",1734449007895],"dd79d964-bc8a-11ef-8547-e6cdfca9ef9f",{"_118":622,"_143":-5,"_116":623,"_113":624},37,["D",1734448847467],"7ddaa542-bc8a-11ef-b874-e6cdfca9ef9f",{"_118":626,"_143":-5,"_116":627,"_113":628},36,["D",1734448810306],"67b4b6b8-bc8a-11ef-a58b-e6cdfca9ef9f",{"_118":630,"_143":-5,"_116":631,"_113":632},35,["D",1734448781621],"569b5170-bc8a-11ef-9d95-e6cdfca9ef9f",{"_118":634,"_143":-5,"_116":635,"_113":636},34,["D",1734448750956],"4454386a-bc8a-11ef-9d95-e6cdfca9ef9f",{"_118":638,"_143":-5,"_116":639,"_113":640},33,["D",1734448740153],"3de44d8a-bc8a-11ef-9658-e6cdfca9ef9f",{"_118":642,"_143":-5,"_116":643,"_113":644},32,["D",1734448577390],"dce0c1f8-bc89-11ef-bf4a-e6cdfca9ef9f",{"_118":646,"_143":-5,"_116":647,"_113":648},31,["D",1734448561023],"d31ec1f6-bc89-11ef-b5de-e6cdfca9ef9f",{"_118":650,"_143":-5,"_116":651,"_113":652},30,["D",1734448554660],"cf53b8ec-bc89-11ef-b420-e6cdfca9ef9f",{"_118":654,"_143":-5,"_116":655,"_113":656},29,["D",1734448524855],"bd909b84-bc89-11ef-a284-e6cdfca9ef9f",{"_118":658,"_143":-5,"_116":659,"_113":660},28,["D",1734377056641],"5730ec3c-bbe3-11ef-9d3f-e6cdfca9ef9f",{"_118":662,"_143":-5,"_116":663,"_113":664},27,["D",1734376634684],"5baee27e-bbe2-11ef-9672-e6cdfca9ef9f",{"_118":666,"_143":-5,"_116":667,"_113":668},26,["D",1734376559517],"2ee1c536-bbe2-11ef-bde9-e6cdfca9ef9f",{"_118":670,"_143":-5,"_116":671,"_113":672},25,["D",1734376550177],"29505010-bbe2-11ef-989b-e6cdfca9ef9f",{"_118":674,"_143":-5,"_116":675,"_113":676},24,["D",1734376534124],"1fbe78ec-bbe2-11ef-90e4-e6cdfca9ef9f",{"_118":678,"_143":-5,"_116":679,"_113":680},23,["D",1734376390187],"c9f38952-bbe1-11ef-bb95-e6cdfca9ef9f",{"_118":682,"_143":-5,"_116":683,"_113":684},22,["D",1734376355838],"b57aa208-bbe1-11ef-b8af-e6cdfca9ef9f",{"_118":686,"_143":-5,"_116":687,"_113":688},21,["D",1734376327893],"a4d2f1ee-bbe1-11ef-b83f-e6cdfca9ef9f",{"_118":690,"_143":-5,"_116":691,"_113":692},20,["D",1734376149771],"3aa6d56a-bbe1-11ef-b4dd-e6cdfca9ef9f",{"_118":694,"_143":-5,"_116":695,"_113":696},19,["D",1734376051147],"ffddf51c-bbe0-11ef-a030-e6cdfca9ef9f",{"_118":698,"_143":-5,"_116":699,"_113":700},18,["D",1734376023109],"ef2761a4-bbe0-11ef-8ef4-e6cdfca9ef9f",{"_118":702,"_143":-5,"_116":703,"_113":704},17,["D",1734375940852],"be20c776-bbe0-11ef-9a0a-e6cdfca9ef9f",{"_118":706,"_143":-5,"_116":707,"_113":708},16,["D",1734375698338],"2d935f3e-bbe0-11ef-ab52-e6cdfca9ef9f",{"_118":710,"_143":-5,"_116":711,"_113":712},15,["D",1734375663263],"18ab5d1a-bbe0-11ef-9323-e6cdfca9ef9f",{"_118":714,"_143":-5,"_116":715,"_113":716},14,["D",1734375650829],"1145e66c-bbe0-11ef-aba4-e6cdfca9ef9f",{"_118":718,"_143":-5,"_116":719,"_113":720},13,["D",1734375350315],"5e241702-bbdf-11ef-9a17-e6cdfca9ef9f",{"_118":722,"_143":-5,"_116":723,"_113":724},12,["D",1734375312596],"47a82eaa-bbdf-11ef-a52d-e6cdfca9ef9f",{"_118":726,"_143":-5,"_116":727,"_113":728},11,["D",1734375250507],"22a710f8-bbdf-11ef-9b3c-e6cdfca9ef9f",{"_118":730,"_143":-5,"_116":731,"_113":732},10,["D",1734375196229],"024c1790-bbdf-11ef-8f29-e6cdfca9ef9f",{"_118":734,"_143":-5,"_116":735,"_113":736},9,["D",1734374979024],"80d52508-bbde-11ef-9185-e6cdfca9ef9f",{"_118":738,"_143":-5,"_116":739,"_113":740},8,["D",1734374944666],"6c5a167e-bbde-11ef-8643-e6cdfca9ef9f",{"_118":742,"_143":-5,"_116":743,"_113":744},7,["D",1734374826428],"25e09cf4-bbde-11ef-b758-e6cdfca9ef9f",{"_118":746,"_143":-5,"_116":747,"_113":748},6,["D",1734374819236],"21976150-bbde-11ef-8f30-e6cdfca9ef9f",{"_118":750,"_143":-5,"_116":751,"_113":752},5,["D",1734374690904],"d51a103e-bbdd-11ef-b482-e6cdfca9ef9f",{"_118":754,"_143":-5,"_116":755,"_113":756},4,["D",1734374639505],"b677dc1a-bbdd-11ef-a787-e6cdfca9ef9f",{"_118":126,"_143":-5,"_116":758,"_113":759},["D",1734374626363],"aea26af0-bbdd-11ef-9b60-e6cdfca9ef9f",{"_118":90,"_143":-5,"_116":761,"_113":762},["D",1734374586789],"970cb224-bbdd-11ef-b491-e6cdfca9ef9f",{"_118":123,"_143":-5,"_116":764,"_113":765},["D",1734371504904],"6a18d646-bbd6-11ef-a451-e6cdfca9ef9f",{"_118":31,"_143":-5,"_116":767,"_113":768},["D",1734371429946],"3d6efc74-bbd6-11ef-a146-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[773,784,789],{"_113":774,"_775":776,"_116":777,"_778":-5,"_779":26,"_780":26,"_20":781},"70ce0380-f06a-11ef-b21c-e6cdfca9ef9f","body","Very cool! I'd love to feature this in our newsletter\n\nI tried to fork it but ran into some issues, `@flymaster/css` is private, and I don't have the right sqlite tables set up. A readme with instructions on setup and maybe even a screenshot would be awesome",["D",1740152542151],"updatedAt","canDelete","canEdit",{"_131":782,"_133":783},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_113":785,"_775":786,"_116":787,"_778":-5,"_779":26,"_780":26,"_20":788},"19a4e418-f086-11ef-ae55-e6cdfca9ef9f","Awesome! I’m currently sitting on a beach in the Caribbean, but give me a few days and I’ll tidy things up.",["D",1740164421828],{"_131":132,"_133":134},{"_113":790,"_775":791,"_116":792,"_778":-5,"_779":26,"_780":26,"_20":793},"6813f7fa-f087-11ef-a72a-e6cdfca9ef9f","ha! nice! enjoy!",["D",1740164982915],{"_131":782,"_133":783},"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_93":797,"_798":799,"_94":800},"single","redirect","/v/flymaster/BugTracker/versions",{"_113":148,"_114":801,"_118":146,"_116":802,"_803":99,"_100":101,"_108":109,"_131":132,"_11":96,"_804":-5,"_805":-5,"_806":-5,"_794":26,"_137":138},"import { getBugCSS } from \"https://esm.town/v/flymaster/css\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { markdownToHtml } from \"https://esm.town/v/xkonti/markdownToHtml\";\nimport { Hono, HonoRequest } from \"npm:hono\";\nimport { basicAuth } from \"npm:hono/basic-auth\";\n\nexport default async function(req: Request): Promise {\n const app = new Hono();\n app.use(\n \"*\",\n basicAuth({\n username: Deno.env.get(\"USERNAME\"),\n password: Deno.env.get(\"PASSWORD\"),\n }),\n );\n app.get(\"/\", (c) => c.html(bugListTable(\"open\")));\n app.get(\"/all\", (c) => c.html(bugListTable(\"all\")));\n app.get(\"/new\", (c) => c.html(createBugForm(c.req)));\n app.post(\"/new\", (c) => c.html(createBug(c.req)));\n app.get(\"/bug/:id\", (c) => c.html(showBug(c.req)));\n app.get(\"/close/:id\", (c) => c.html(closeBug(c.req)));\n app.get(\"/wontfix/:id\", (c) => c.html(wontfixBug(c.req)));\n app.get(\"/projects\", (c) => c.html(getProjects()));\n app.get(\"/projects/:name\", (c) => c.html(getProject(c.req)));\n return app.fetch(req);\n}\n\nasync function getTable(rows: any) {\n let html = \"\";\n for (const row of rows.rows) {\n html += ``;\n }\n html += \"

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

Home

Project
${row[0]}

\";\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

BugTracker

Version 156