[{"_1":2,"_177":-5,"_178":-5},"loaderData",{"_3":4,"_91":92,"_159":160,"_176":-5},"root",{"_5":6,"_32":33,"_58":59,"_89":90},"ctx",{"_7":8,"_18":19,"_20":-5,"_21":22,"_23":24,"_25":26,"_27":26,"_28":29,"_30":31},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"sessionClaims","sessionId","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","fa80b67e1f763bfb4b247c3f5ca4f0b0730f3f5c","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","WORKER_FINGERPRINT","799d99f2805306c2714a7cfefbeae178","clerkState",{"_60":61},"__internal_clerk_state",{"_62":63,"_64":43,"_65":66,"_67":66,"_68":26,"_69":66,"_70":66,"_71":66,"_72":66,"_73":66,"_74":66,"_75":66,"_76":66,"_77":78,"_87":26,"_88":26},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_79":26,"_80":66,"_81":82,"_83":66,"_84":43,"_85":26,"_86":66},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","remixVersion",2,"routes/_app.v.$handle.$name",{"_93":94,"_95":96,"_94":97,"_154":-5,"_155":-5,"_156":157,"_128":129,"_141":107,"_100":101,"_98":99,"_118":-7,"_50":51,"_158":26},"type","val","author","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18",{"_98":99,"_95":96,"_100":101,"_102":-5,"_103":-5,"_104":105,"_106":107,"_108":109,"_110":111,"_112":26,"_113":111,"_114":115,"_116":117,"_118":90,"_119":26,"_120":31,"_121":31,"_122":31,"_123":90,"_124":31,"_125":31,"_126":-5,"_20":127,"_132":133,"_138":-7,"_139":140,"_141":107,"_142":143},"name","BugTracker","valNameId","2e668080-f06a-11ef-8d38-e6cdfca9ef9f","parentFolderId","isOwned","privacy","public","readme","A simple bug tracker.","valType","http","currentVersion","450fd2aa-f06a-11ef-bcea-e6cdfca9ef9f","legacyPrivate","id","code","import { 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.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]}	\| \|

\";\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}","createdAt",["D",1740152468736],"version","currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_128":129,"_130":131},"handle","stevekrouse","profileImageUrl","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","forkedVal",{"_113":134,"_128":135,"_98":99,"_118":136,"_137":-5},"5fd38ec4-de6d-11ef-97bf-e6cdfca9ef9f","flymaster",157,"prDisabledHint","interval","slug","stevekrouse/BugTracker","description","versions",[144,147,151],{"_118":90,"_145":-5,"_116":146,"_113":111},"prId",["D",1740152468736],{"_118":148,"_145":-5,"_116":149,"_113":150},1,["D",1740152454551],"3c9a416e-f06a-11ef-8032-e6cdfca9ef9f",{"_118":31,"_145":-5,"_116":152,"_113":153},["D",1740152430729],"2ea619b6-f06a-11ef-8d38-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.pulls._index",{"_95":96,"_94":161,"_128":129,"_141":107,"_98":99,"_172":31,"_173":31,"_50":51,"_174":175},{"_98":99,"_95":96,"_100":101,"_102":-5,"_103":-5,"_104":105,"_106":107,"_108":109,"_110":111,"_112":26,"_113":111,"_114":115,"_116":162,"_118":90,"_119":26,"_120":31,"_121":31,"_122":31,"_123":90,"_124":31,"_125":31,"_126":-5,"_20":163,"_132":164,"_138":-7,"_139":140,"_141":107,"_142":165},["D",1740152468736],{"_128":129,"_130":131},{"_113":134,"_128":135,"_98":99,"_118":136,"_137":-5},[166,168,170],{"_118":90,"_145":-5,"_116":167,"_113":111},["D",1740152468736],{"_118":148,"_145":-5,"_116":169,"_113":150},["D",1740152454551],{"_118":31,"_145":-5,"_116":171,"_113":153},["D",1740152430729],"page","count","prs",[],"routes/_app","actionData","errors"]