[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_175":176,"_177":178},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_133":-5,"_20":134,"_22":135,"_136":137,"_138":139,"_25":140,"_24":-5,"_141":-5,"_142":-5,"_143":54,"_144":145,"_146":45,"_147":-5,"_148":-5,"_149":150},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","alibalialibayov","name","Demo_1","branchName","main","version","path","","project",{"_34":75,"_13":14,"_46":76,"_77":-5,"_78":54,"_79":80,"_81":80,"_82":-5,"_83":-5,"_84":85,"_86":-5,"_87":54,"_88":-5,"_89":-5,"_90":91,"_92":93,"_94":95,"_96":97,"_98":99,"_100":-5,"_101":102,"_103":102,"_104":105,"_106":105,"_107":105,"_108":102,"_109":102,"_110":111,"_112":113,"_114":115,"_116":54},"tree",[66,67],"file","contents",[32,33],"upstream","pull","ahead","behind","envVars",{"_34":58,"_13":59,"_37":60,"_39":-5,"_40":41,"_42":61,"_44":45,"_46":62,"_17":63,"_49":24,"_51":64,"_53":54,"_55":-5,"_18":65},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":56,"_18":57},"id","8b32edae-535f-11f1-a275-ee650bb23af1","main.ts","fileId","73edb1c4-52b5-11f1-8e61-ee650bb23af1","parentId","branchId","73ebb4d2-52b5-11f1-8e61-ee650bb23af1","branchVersion",9,"latest",true,"createdAt",["D",1779180524744],6,"fileType","http","content","\"Change the color scheme to dark blue and white.\"import { Hono } from \"npm:hono@4\";\nimport { serveFile, parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { blob } from \"https://esm.town/v/std/blob\";\n\n// ── Persistence Layer ──────────────────────────────────────────────\n// Primary: SQLite (structured queries, ordering, filtering)\n// Backup: Blob storage (JSON snapshot for resilience & portability)\n\nconst BLOB_KEY = \"assistance_requests\";\nconst MAX_TEXT_LENGTH = 1000;\nconst MIN_TEXT_LENGTH = 3;\n\n// Ensure SQLite table exists\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n`);\n\n/** Sync current SQLite rows → Blob storage as a JSON snapshot */\nasync function syncToBlob() {\n const result = await sqlite.execute(\"SELECT * FROM requests ORDER BY id DESC\");\n await blob.setJSON(BLOB_KEY, {\n syncedAt: new Date().toISOString(),\n count: result.rows.length,\n requests: result.rows,\n });\n}\n\n/** Validate request text. Returns null if valid, or an error string. */\nfunction validateText(raw: unknown): { text: string } | { error: string } {\n if (raw === undefined || raw === null) {\n return { error: \"Request text is required.\" };\n }\n if (typeof raw !== \"string\") {\n return { error: \"Request text must be a string.\" };\n }\n const text = raw.trim();\n if (text.length === 0) {\n return { error: \"Request text cannot be empty or whitespace-only.\" };\n }\n if (text.length < MIN_TEXT_LENGTH) {\n return { error: `Request must be at least ${MIN_TEXT_LENGTH} characters.` };\n }\n if (text.length > MAX_TEXT_LENGTH) {\n return { error: `Request must be at most ${MAX_TEXT_LENGTH} characters (you sent ${text.length}).` };\n }\n return { text };\n}\n\n// ── App ────────────────────────────────────────────────────────────\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// Serve the HTML page\napp.get(\"/\", () => serveFile(\"./index.html\", import.meta.url));\n\n// GET /requests — list all saved requests\napp.get(\"/requests\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM requests ORDER BY id DESC\");\n return c.json(result.rows);\n});\n\n// POST /requests — create a new request (with validation)\napp.post(\"/requests\", async (c) => {\n let body: Record;\n try {\n body = await c.req.json();\n } catch {\n return c.json({ error: \"Invalid JSON body.\" }, 400);\n }\n\n const check = validateText(body.text);\n if (\"error\" in check) {\n return c.json({ error: check.error }, 400);\n }\n\n // Check for exact duplicates submitted in the last 60 seconds\n const dupeCheck = await sqlite.execute({\n sql: `SELECT id FROM requests\n WHERE text = ? AND created_at > datetime('now', '-60 seconds')\n LIMIT 1`,\n args: [check.text],\n });\n if (dupeCheck.rows.length > 0) {\n return c.json({ error: \"Duplicate request — you just submitted this.\" }, 409);\n }\n\n // Insert into SQLite\n const result = await sqlite.execute({\n sql: \"INSERT INTO requests (text) VALUES (?) RETURNING *\",\n args: [check.text],\n });\n const newRow = result.rows[0];\n\n // Sync snapshot to Blob storage (fire-and-forget, don't block response)\n syncToBlob().catch((err) => console.error(\"Blob sync failed:\", err));\n\n return c.json(newRow, 201);\n});\n\n// DELETE /requests/:id — remove a request\napp.delete(\"/requests/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n if (!Number.isInteger(id) || id < 1) {\n return c.json({ error: \"Invalid request ID.\" }, 400);\n }\n const result = await sqlite.execute({\n sql: \"DELETE FROM requests WHERE id = ? RETURNING id\",\n args: [id],\n });\n if (result.rows.length === 0) {\n return c.json({ error: \"Request not found.\" }, 404);\n }\n\n syncToBlob().catch((err) => console.error(\"Blob sync failed:\", err));\n return c.json({ deleted: id });\n});\n\n// GET /requests/blob — read the blob snapshot directly (debug/export)\napp.get(\"/requests/blob\", async (c) => {\n const data = await blob.getJSON(BLOB_KEY);\n if (!data) return c.json({ error: \"No blob snapshot yet.\" }, 404);\n return c.json(data);\n});\n\n// GET /requests/validation-rules — expose rules so frontend stays in sync\napp.get(\"/requests/validation-rules\", (c) => {\n return c.json({ minLength: MIN_TEXT_LENGTH, maxLength: MAX_TEXT_LENGTH });\n});\n\n// View source\napp.get(\"/source\", (c) => c.redirect(parseVal(import.meta.url).links.self.val));\n\nexport default app.fetch;","deleted",false,"label","holberton",[36],"a50a6d8c-52b6-11f1-9f70-ee650bb23af1","index.html","f688132c-52b5-11f1-ae3a-ee650bb23af1",8,["D",1779107983134],1,"\n\n\n \n \n Assistance Requests\n \n \n\n\n

\n\n \n

🛎️ Assistance Requests

\n Requests are persisted in SQLite + synced to Blob storage.\n

\n Data survives restarts. View blob snapshot ↗\n

\n\n \n

\n\n \n\n\n",[59],{"_34":58,"_13":59,"_37":60,"_39":-5,"_40":41,"_42":61,"_44":45,"_46":72,"_17":63,"_49":24,"_51":64,"_53":54,"_55":-5,"_69":73,"_18":74},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":68,"_17":48,"_49":50,"_51":52,"_53":54,"_55":56,"_69":70,"_18":71},["D",1779180524744],"children",[],[36],["D",1779107983134],[],[59],"73e84b8a-52b5-11f1-8e61-ee650bb23af1",["D",1779107471235],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","30002205-f633-459e-aa9c-f2ab06555894","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e3b11-0a4d-7623-9799-c05b81016766","tursoName","73e84b8a52b511f18e61ee650bb23af1","tursoHostname","73e84b8a52b511f18e61ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789489912439],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_132":128},"org",{"_11":12,"_125":126,"_127":128,"_84":85,"_129":130,"_131":54},"branch",{"_17":43,"_13":16,"_34":41,"_117":75,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":14,"_124":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Alibali Alibayov","avatar","https://lh3.googleusercontent.com/a/ACg8ocID-7V_B05PTDQVHncLW0G8yWS7tzd-s5hg1M7PtpymGkmdg3M=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":75,"_13":14,"_46":170,"_77":-5,"_78":54,"_79":80,"_81":80,"_82":-5,"_83":-5,"_84":85,"_86":-5,"_87":54,"_88":-5,"_89":-5,"_90":91,"_92":93,"_94":95,"_96":97,"_98":171,"_100":-5,"_101":102,"_103":102,"_104":105,"_106":105,"_107":105,"_108":102,"_109":102,"_110":172,"_112":173,"_114":174,"_116":54},[164,165],"files",[164,165],"counts",{"_155":91,"_156":63,"_157":91,"_31":158,"_159":160},[151,152],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_34":58,"_13":59,"_37":60,"_39":-5,"_40":41,"_42":61,"_44":45,"_46":62,"_17":63,"_49":24,"_51":64,"_53":54,"_55":-5,"_18":154},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":56,"_18":153},[36],[59],"pulls","branches","forks",{"_161":91,"_163":91},"connections",{"_161":91,"_162":91},"count","unfilledCount","emptyCount",{"_34":58,"_13":59,"_37":60,"_39":-5,"_40":41,"_42":61,"_44":45,"_46":72,"_17":63,"_49":24,"_51":64,"_53":54,"_55":-5,"_69":168,"_18":169},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":68,"_17":48,"_49":50,"_51":52,"_53":54,"_55":56,"_69":166,"_18":167},[],[36],[],[59],["D",1779107471235],["D",1789489912439],{"_11":12,"_132":128},{"_11":12,"_125":126,"_127":128,"_84":85,"_129":130,"_131":54},{"_17":43,"_13":16,"_34":41,"_117":75,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":14,"_124":12},"ctx",{"_110":-5,"_148":208,"_209":210,"_211":212,"_213":54,"_214":54,"_215":54,"_216":45,"_217":-5,"_218":-7,"_219":-7,"_220":91,"_221":54,"_222":54,"_223":-5,"_224":54,"_225":54,"_226":54,"_227":-5},"ENV",{"_179":180,"_181":182,"_183":16,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","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","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

🛎️ Assistance Requests

📋 Submitted Requests

Code