[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_204":205,"_206":207},"routes/_app.x.$handle.$name",{"_102":101,"_32":43,"_111":88,"_27":112,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_20":-5,"_123":124,"_125":126,"_127":47,"_128":129,"_130":25,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_32":43,"_36":44,"_45":-5,"_46":47,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":47},"version",20,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_24":25},"previous",{"_30":31,"_32":28,"_33":20,"_34":35},"deleted",true,"deletedHere","path","style.css","latestPath","fileId","019e5736-7fdf-732d-97a0-288321ab092c","name","fileType","content","* {\n box-sizing: border-box;\n margin: 0;\n padding: 0;\n}\n\nbody {\n font-family: system-ui, -apple-system, sans-serif;\n background: #f5f5f5;\n color: #333;\n min-height: 100vh;\n display: flex;\n flex-direction: column;\n align-items: center;\n padding: 2rem 1rem;\n}\n\n.container {\n width: 100%;\n max-width: 600px;\n}\n\nh1 {\n margin-bottom: 1.5rem;\n font-size: 1.5rem;\n}\n\n#request-form {\n display: flex;\n gap: 0.5rem;\n margin-bottom: 1.5rem;\n}\n\n#request-input {\n flex: 1;\n padding: 0.6rem 0.8rem;\n border: 1px solid #ccc;\n border-radius: 6px;\n font-size: 0.95rem;\n}\n\n#request-input:focus {\n outline: none;\n border-color: #555;\n}\n\nbutton[type=\"submit\"] {\n padding: 0.6rem 1.2rem;\n background: #333;\n color: #fff;\n border: none;\n border-radius: 6px;\n font-size: 0.95rem;\n cursor: pointer;\n}\n\nbutton[type=\"submit\"]:hover {\n background: #555;\n}\n\n#requests-list {\n display: flex;\n flex-direction: column;\n gap: 0.5rem;\n}\n\n.empty-msg {\n color: #999;\n font-size: 0.9rem;\n}\n\n.error-msg {\n color: #d32f2f;\n font-size: 0.85rem;\n margin-bottom: 1rem;\n}\n\n.request-item {\n background: #fff;\n border: 1px solid #e0e0e0;\n border-radius: 6px;\n padding: 0.75rem 1rem;\n}\n\n.request-item .text {\n font-size: 0.95rem;\n}\n\n.request-item .time {\n font-size: 0.75rem;\n color: #999;\n margin-top: 0.25rem;\n}\n\nfooter {\n margin-top: 2rem;\n font-size: 0.8rem;\n}\n\nfooter a {\n color: #999;\n}\n","createdAt",["D",1779581175596],"branchVersion","branchId","d4613cde-5700-11f1-bb8e-ee650bb23af1","id","d45d09b6-5700-11f1-bb8e-ee650bb23af1","assistance-requests",["D",1779579649958],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","Simple page for submitting and viewing assistance requests","imageUrl","4eec23d2-7413-4ff2-95ba-aca08105871a","pinnedFileId","019e5736-7fdf-732d-97a0-21e443f4924b","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e572a-9807-726e-b565-1ff9d9da77ec","tursoName","d45d09b6570011f1bb8eee650bb23af1","tursoHostname","d45d09b6570011f1bb8eee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789510872811],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_110":106},"org",{"_102":101,"_103":104,"_105":106,"_18":54,"_107":108,"_109":47},"branch",{"_13":87,"_32":88,"_41":40,"_89":42,"_90":91,"_92":93,"_94":49,"_95":96,"_97":98,"_99":43,"_100":101},"isOwned",22,"main","projectId","forkedBranchId","7a3b261a-4186-11f0-ae9b-76b3cceeab13","forkedBranchVersion",75,"forkedProjectPrivacy","forkedProjectId","7a3abcf2-4186-11f0-ae9b-76b3cceeab13","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","samedzadehh","handle","displayName","Huseyn Samedzade","avatar","https://avatars.githubusercontent.com/u/129556088?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_32":43,"_36":199,"_45":-5,"_46":47,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":200,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":201,"_82":202,"_84":203,"_86":47},"tree",[186,187,188],"files",[186,187,188],"counts",{"_176":61,"_177":164,"_178":61,"_179":180,"_181":182},"contents",[147,148,149],"upstreamProject",{"_41":96,"_32":142,"_51":143,"_53":144,"_48":49,"_80":145},"upstreamBranch",{"_41":91,"_36":135,"_136":137,"_32":88,"_89":96,"_13":138,"_90":-5,"_92":-5,"_139":140,"_45":-5,"_86":47,"_48":49,"_100":141,"_62":98,"_99":142},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1749070628054],"updatedAt",["D",1779896149804],76,"lockfileKey","1779896350378-esm.town_v_templates_basic-html-starter@76-main","templates","basic-html-starter","Basic HTML starter template based on Glitch's starter","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/1e130d76-f5f9-42d2-df67-91517700ff00/square512?exp=1789588799&sig=7a4e4547de36f0a23e153eea630217f36709d955bbdc4e6d4f5150f68a5e2e03",{"_102":141,"_110":146},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789588799&sig=6ce4a653b65ad390b6349a1b0a383cb839cc380a1beaf91551581c108538875d",{"_41":168,"_32":169,"_30":170,"_152":-5,"_39":40,"_38":171,"_154":25,"_36":172,"_13":173,"_33":20,"_34":174,"_24":47,"_159":-5,"_27":175},{"_41":161,"_32":162,"_30":163,"_152":-5,"_39":40,"_38":164,"_154":25,"_36":165,"_13":61,"_33":20,"_34":166,"_24":47,"_159":-5,"_27":167},{"_41":150,"_32":151,"_30":56,"_152":-5,"_39":40,"_38":153,"_154":47,"_36":155,"_13":156,"_33":157,"_34":158,"_24":47,"_159":-5,"_27":160},"6f2f2aa8-5703-11f1-80f7-ee650bb23af1","main.tsx","parentId",18,"latest",["D",1779580768698],9,"http","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Create table on module load\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS assistance_requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n timestamp TEXT NOT NULL DEFAULT (datetime('now'))\n )\n`);\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // --- POST /api/requests — yeni sorğunu yaddaşa yazır ---\n if (req.method === \"POST\" && url.pathname === \"/api/requests\") {\n try {\n const body = await req.json(); // Məlumatı JSON olaraq oxuyur\n const text = (body.text || \"\").trim();\n\n if (!text) {\n return Response.json({ error: \"Request text cannot be empty.\" }, {\n status: 400,\n });\n }\n\n const timestamp = new Date().toISOString();\n const result = await sqlite.execute({\n sql: \"INSERT INTO assistance_requests (text, timestamp) VALUES (?, ?)\",\n args: [text, timestamp],\n });\n\n return Response.json({\n id: Number(result.lastInsertRowid),\n text,\n timestamp,\n }, { status: 201 });\n } catch {\n return Response.json({ error: \"Invalid request body.\" }, { status: 400 });\n }\n }\n\n // --- GET / — Səhifəni və bazadakı qeydləri göstərir ---\n if (req.method === \"GET\" && (url.pathname === \"/\" || url.pathname === \"\")) {\n const result = await sqlite.execute(\n \"SELECT id, text, timestamp FROM assistance_requests ORDER BY id DESC\",\n );\n\n const requestsHtml = result.rows.length === 0\n ? `

No requests yet. Submit one above!

`\n : result.rows.map((r: any) => `\n

${escapeHtml(String(r.text))}

${new Date(String(r.timestamp)).toLocaleString()}

`).join(\"\");\n\n const html = `\n\n \n Assistance Requests\n \n \n \n \n \n

📋 Assistance Requests

\n \n \n \n`;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n\n return new Response(\"Not Found\", { status: 404 });\n}\n\nfunction escapeHtml(str: string): string {\n return str\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}","label",[151],"d467ca7c-5700-11f1-bb8e-ee650bb23af1","favicon.svg","019e5736-7fdf-732d-97a0-19845f63e82a",1,["D",1779579649958],"",[162],"5e400c90-5702-11f1-be4d-ee650bb23af1","README.md","019e5736-7fdf-732d-97a0-16a579e50b0b",17,["D",1779580310792],2,"# 📋 Assistance Requests\n\nA simple full-stack app for submitting and viewing assistance requests, backed by SQLite.\n\n## How it works\n\n```mermaid\nsequenceDiagram\n participant Browser\n participant Server (main.tsx)\n participant SQLite\n\n Browser->>Server (main.tsx): GET /\n Server (main.tsx)->>SQLite: SELECT all requests\n SQLite-->>Server (main.tsx): rows\n Server (main.tsx)-->>Browser: HTML with pre-loaded requests\n\n Browser->>Server (main.tsx): POST /api/requests {text}\n Server (main.tsx)->>Server (main.tsx): Validate (reject empty)\n Server (main.tsx)->>SQLite: INSERT request\n SQLite-->>Server (main.tsx): lastInsertRowid\n Server (main.tsx)-->>Browser: JSON {id, text, timestamp}\n Browser->>Browser: Prepend card to DOM\n```\n\n## Features\n\n- **Persistent storage** — requests saved to SQLite (`assistance_requests` table)\n- **Server-side rendering** — GET `/` returns HTML with all saved requests pre-loaded\n- **REST API** — POST `/api/requests` to create a new request\n- **Validation** — both frontend and backend reject empty submissions\n- **No page refresh** — `fetch` API + DOM manipulation for seamless UX\n\n## Files\n\n| File | Purpose |\n|------|---------|\n| `main.tsx` | HTTP handler: routing, DB queries, HTML generation |\n| `script.js` | Client-side form handling via fetch API |\n| `style.css` | Minimal styling |\n\nBuilt with [Val Town](https://val.town).\n",[169],"pulls","branches","forks","envVars",{"_183":61,"_185":61},"connections",{"_183":61,"_184":61},"count","unfilledCount","emptyCount",{"_41":168,"_32":169,"_30":170,"_152":-5,"_39":40,"_38":171,"_154":25,"_36":196,"_13":173,"_33":20,"_34":174,"_24":47,"_159":-5,"_190":197,"_27":198},{"_41":161,"_32":162,"_30":163,"_152":-5,"_39":40,"_38":164,"_154":25,"_36":193,"_13":61,"_33":20,"_34":166,"_24":47,"_159":-5,"_190":194,"_27":195},{"_41":150,"_32":151,"_30":56,"_152":-5,"_39":40,"_38":153,"_154":47,"_36":189,"_13":156,"_33":157,"_34":158,"_24":47,"_159":-5,"_190":191,"_27":192},["D",1779580768698],"children",[],[151],["D",1779579649958],[],[162],["D",1779580310792],[],[169],["D",1779579649958],["D",1789510872811],{"_102":101,"_110":106},{"_102":101,"_103":104,"_105":106,"_18":54,"_107":108,"_109":47},{"_13":87,"_32":88,"_41":40,"_89":42,"_90":91,"_92":93,"_94":49,"_95":96,"_97":98,"_99":43,"_100":101},"ctx",{"_80":-5,"_132":237,"_238":239,"_240":241,"_242":47,"_243":47,"_244":47,"_245":25,"_246":-5,"_247":-7,"_248":-7,"_249":61,"_250":47,"_251":47,"_252":-5,"_253":47,"_254":47,"_255":47,"_256":-5},"ENV",{"_208":209,"_210":211,"_212":88,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

Diff · v20