[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_162":163,"_164":165},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_61":132,"_16":-7,"_133":-5,"_17":134,"_135":136,"_28":137,"_21":138,"_23":139,"_140":-5,"_141":-5,"_142":-5,"_143":35,"_144":145,"_146":38,"_147":-5,"_148":-5,"_149":150},"routes/_app.x.$handle.$name._index",{"_11":12,"_13":14,"_15":-7,"_16":-7,"_17":18,"_19":20,"_21":22,"_23":24,"_25":-7,"_26":-5,"_27":-5,"_28":29,"_30":31,"_32":-5,"_33":-5,"_34":35,"_36":35,"_37":38},"handle","bus","name","untitled-5156","branchName","version","project",{"_39":78,"_13":14,"_50":79,"_80":-5,"_81":35,"_82":83,"_84":83,"_85":-5,"_86":-5,"_87":88,"_89":43,"_90":38,"_91":-5,"_92":-5,"_93":67,"_94":95,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":101,"_102":101,"_103":104,"_105":104,"_106":104,"_107":101,"_108":101,"_109":110,"_111":112,"_113":114,"_115":35},"tags",[],"counts",{"_66":67,"_68":69,"_70":67,"_71":72,"_73":74},"contents",[63],"readme","upstream","pull","files",[31],"preview",{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":51,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_59":60,"_61":62},"ahead","behind","showHomeCustomizationHint",false,"showHTTPPreviewSettingsHint","hasHTTPFiles",true,"id","25acdb86-1a05-11f1-ad05-42dde27851f2","main.ts","fileId","899d36f8-1a01-11f1-b3cf-42dde27851f2","parentId","branchId","899a4c86-1a01-11f1-b3cf-42dde27851f2","branchVersion",13,"latest","createdAt",["D",1772874483428],12,"fileType","http","content","import { sqlite } from \"https://esm.town\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // Tábla létrehozása, ha nincs\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS shared_notes_v1 (\n id INTEGER PRIMARY KEY CHECK (id = 1), \n content TEXT\n )\n `);\n\n // POST: mentés\n if (req.method === \"POST\") {\n const { text } = await req.json();\n await sqlite.execute({\n sql:\n `INSERT OR REPLACE INTO shared_notes_v1 (id, content) VALUES (1, :text)`,\n args: { text },\n });\n return Response.json({ ok: true });\n }\n\n // SSE: csak változáskor küld, 15 mp-ként néz\n if (url.searchParams.has(\"stream\")) {\n const stream = new ReadableStream({\n async start(controller) {\n const encoder = new TextEncoder();\n let last = \"\";\n while (!req.signal.aborted) {\n const res = await sqlite.execute(\n \"SELECT content FROM shared_notes_v1 WHERE id = 1\",\n );\n const current = res.rows[0]?.[0] || \"\";\n if (current !== last) {\n last = current;\n controller.enqueue(\n encoder.encode(`data: ${JSON.stringify({ text: current })}\\n\\n`),\n );\n }\n await new Promise((r) => setTimeout(r, 15000)); // 15 mp\n }\n controller.close();\n },\n });\n return new Response(stream, {\n headers: { \"Content-Type\": \"text/event-stream\" },\n });\n }\n\n // GET: HTML oldal kezdeti tartalommal\n const res = await sqlite.execute(\n \"SELECT content FROM shared_notes_v1 WHERE id = 1\",\n );\n const initialText = res.rows[0]?.[0] || \"Hello World\";\n\n return new Response(\n `\n \n \n \n \n \n \n

SQL-alapú Élő Jegyzet

\n \n \n \n `,\n { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n}","deleted","label","children",[],"path",[41],{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":64,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_61":65},["D",1772874483428],[41],"pulls",0,"branches",1,"forks","envVars",{"_75":67,"_77":67},"connections",{"_75":67,"_76":67},"count","unfilledCount","emptyCount","8999d5e4-1a01-11f1-b3cf-42dde27851f2",["D",1772872933099],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","019b5204-de36-735b-acba-f85553decb28","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019b5204-de36-735b-acba-fe052daf18f4","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_131":127},"org",{"_11":12,"_125":-5,"_126":127,"_87":88,"_128":129,"_130":35},"branch",{"_16":48,"_13":116,"_39":46,"_117":78,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":14,"_124":12},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM3SjN4ZXE3alFlSk1OOGs1VEJPaUlEeHNHZSJ9","tier","free","canRestrictVals","profileImageUrl","","adoptOrgId",{"_39":78,"_13":14,"_50":158,"_80":-5,"_81":35,"_82":83,"_84":83,"_85":-5,"_86":-5,"_87":88,"_89":43,"_90":38,"_91":-5,"_92":-5,"_93":67,"_94":95,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":101,"_102":101,"_103":104,"_105":104,"_106":104,"_107":101,"_108":101,"_109":159,"_111":160,"_113":161,"_115":35},"tree",[155],[155],{"_66":67,"_68":69,"_70":67,"_71":153,"_73":154},[151],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":64,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_61":152},[41],{"_75":67,"_77":67},{"_75":67,"_76":67},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":51,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_59":156,"_61":157},[],[41],["D",1772872933099],{"_11":12,"_131":127},{"_11":12,"_125":-5,"_126":127,"_87":88,"_128":129,"_130":35},{"_16":48,"_13":116,"_39":46,"_117":78,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":14,"_124":12},"ctx",{"_109":-5,"_148":195,"_196":197,"_198":199,"_200":35,"_201":35,"_202":35,"_203":38,"_204":-5,"_205":-7,"_206":-7,"_207":67,"_208":35,"_209":35,"_210":-5,"_211":35,"_212":35,"_213":35,"_214":-5},"ENV",{"_166":167,"_168":169,"_170":116,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194},"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"]