[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_201":202,"_203":204},"routes/_app.x.$handle.$name",{"_103":102,"_32":45,"_112":89,"_27":113,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_20":-5,"_124":125,"_126":127,"_128":25,"_129":130,"_131":58,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",21,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","019e5736-7fdf-732d-97a0-21e443f4924b","name","fileType","http","content","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}","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// 1. Cədvəlləri yaradırıq (Həm sorğular, həm də çat üçün)\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\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS chat_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n message 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 // --- API: Yeni Sorğu Göndərmək (Requests) ---\n if (req.method === \"POST\" && url.pathname === \"/api/requests\") {\n try {\n const body = await req.json();\n const text = (body.text || \"\").trim();\n if (!text) return Response.json({ error: \"Empty request.\" }, { status: 400 });\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 return Response.json({ id: Number(result.lastInsertRowid), text, timestamp }, { status: 201 });\n } catch {\n return Response.json({ error: \"Invalid data.\" }, { status: 400 });\n }\n }\n\n // --- API: Yeni Çat Mesajı Göndərmək (Chat) ---\n if (req.method === \"POST\" && url.pathname === \"/api/chat\") {\n try {\n const body = await req.json();\n const username = (body.username || \"Guest\").trim();\n const message = (body.message || \"\").trim();\n \n if (!message) return Response.json({ error: \"Empty message.\" }, { status: 400 });\n\n const timestamp = new Date().toISOString();\n await sqlite.execute({\n sql: \"INSERT INTO chat_messages (username, message, timestamp) VALUES (?, ?, ?)\",\n args: [username, message, timestamp],\n });\n return Response.json({ success: true }, { status: 201 });\n } catch {\n return Response.json({ error: \"Invalid data.\" }, { status: 400 });\n }\n }\n\n // --- API: Çat Mesajlarını Oxumaq ---\n if (req.method === \"GET\" && url.pathname === \"/api/chat\") {\n // Ən son 50 mesajı alırıq\n const result = await sqlite.execute(\n \"SELECT id, username, message, timestamp FROM chat_messages ORDER BY id DESC LIMIT 50\"\n );\n // Frontend-də köhnədən yeniyə doğru göstərmək üçün sıranı tərsinə çeviririk\n return Response.json(result.rows.reverse());\n }\n\n // --- GET / — Əsas Səhifə (HTML, CSS, JS) ---\n if (req.method === \"GET\" && (url.pathname === \"/\" || url.pathname === \"\")) {\n const requestsResult = await sqlite.execute(\n \"SELECT id, text, timestamp FROM assistance_requests ORDER BY id DESC\"\n );\n\n const requestsHtml = requestsResult.rows.length === 0\n ? `

No requests yet. Submit one above!

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

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

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

`).join(\"\");\n\n const html = `\n\n \n App & Chat\n \n \n \n \n \n

\n \n

📋 Assistance Requests

\n \n \n

\n ${requestsHtml}\n

\n\n

💬 Real-Time Chat

\n \n

Enter a username to join the chat.

\n \n \n

\n\n

\n \n

\n\n

\n \n \n \n`;\n\n return new Response(html, { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } });\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}","createdAt",["D",1779581185557],"branchVersion","branchId","d4613cde-5700-11f1-bb8e-ee650bb23af1","id","d45d09b6-5700-11f1-bb8e-ee650bb23af1","assistance-requests",["D",1779579649958],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Simple page for submitting and viewing assistance requests","imageUrl","4eec23d2-7413-4ff2-95ba-aca08105871a","pinnedFileId","pinPreview",true,"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",{"_103":102,"_111":107},"org",{"_103":102,"_104":105,"_106":107,"_18":55,"_108":109,"_110":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":92,"_93":94,"_95":50,"_96":97,"_98":99,"_100":45,"_101":102},"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",{"_43":44,"_32":45,"_38":196,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":197,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":198,"_83":199,"_85":200,"_87":25},"tree",[183,184,185],"files",[183,184,185],"counts",{"_173":62,"_174":161,"_175":62,"_176":177,"_178":179},"contents",[148,149,150],"upstreamProject",{"_43":97,"_32":143,"_52":144,"_54":145,"_49":50,"_81":146},"upstreamBranch",{"_43":92,"_38":136,"_137":138,"_32":89,"_90":97,"_13":139,"_91":-5,"_93":-5,"_140":141,"_47":-5,"_87":25,"_49":50,"_101":142,"_63":99,"_100":143},"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=1789592399&sig=b404cb1e8c001706d6cdf6fda9bec1d4b698921c910bef823903e227e4b26d4c",{"_103":142,"_111":147},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789592399&sig=e3667930a878fd5db49e47cce78fe270a8ba33317e34775a1ada2dd4a7c49d8d",{"_43":165,"_32":166,"_30":167,"_152":-5,"_41":42,"_40":168,"_153":58,"_38":169,"_13":170,"_33":20,"_35":171,"_24":25,"_156":-5,"_27":172},{"_43":158,"_32":159,"_30":160,"_152":-5,"_41":42,"_40":161,"_153":58,"_38":162,"_13":62,"_33":20,"_35":163,"_24":25,"_156":-5,"_27":164},{"_43":151,"_32":28,"_30":31,"_152":-5,"_41":42,"_40":14,"_153":25,"_38":154,"_13":155,"_33":34,"_35":37,"_24":25,"_156":-5,"_27":157},"67a84e08-5704-11f1-899b-ee650bb23af1","parentId","latest",["D",1779581185557],10,"label",[28],"d467ca7c-5700-11f1-bb8e-ee650bb23af1","favicon.svg","019e5736-7fdf-732d-97a0-19845f63e82a",1,["D",1779579649958],"",[159],"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",[166],"pulls","branches","forks","envVars",{"_180":62,"_182":62},"connections",{"_180":62,"_181":62},"count","unfilledCount","emptyCount",{"_43":165,"_32":166,"_30":167,"_152":-5,"_41":42,"_40":168,"_153":58,"_38":193,"_13":170,"_33":20,"_35":171,"_24":25,"_156":-5,"_187":194,"_27":195},{"_43":158,"_32":159,"_30":160,"_152":-5,"_41":42,"_40":161,"_153":58,"_38":190,"_13":62,"_33":20,"_35":163,"_24":25,"_156":-5,"_187":191,"_27":192},{"_43":151,"_32":28,"_30":31,"_152":-5,"_41":42,"_40":14,"_153":25,"_38":186,"_13":155,"_33":34,"_35":37,"_24":25,"_156":-5,"_187":188,"_27":189},["D",1779581185557],"children",[],[28],["D",1779579649958],[],[159],["D",1779580310792],[],[166],["D",1779579649958],["D",1789510872811],{"_103":102,"_111":107},{"_103":102,"_104":105,"_106":107,"_18":55,"_108":109,"_110":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":92,"_93":94,"_95":50,"_96":97,"_98":99,"_100":45,"_101":102},"ctx",{"_81":-5,"_133":234,"_235":236,"_237":238,"_239":25,"_240":25,"_241":25,"_242":58,"_243":-5,"_244":-7,"_245":-7,"_246":62,"_247":25,"_248":25,"_249":-5,"_250":25,"_251":25,"_252":25,"_253":-5},"ENV",{"_205":206,"_207":208,"_209":89,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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 · v21