${\n dateObj.toLocaleDateString(\"de-DE\", {\n weekday: \"long\",\n })\n }, der ${dateObj.toLocaleDateString(\"de-DE\")}

\\n

${escapeHtml(entry.category)}: ${\n escapeHtml(entry.name)\n } (${entry.price.stud.toFixed(2).replace(\".\", \",\")}€)

\\n\";\n return out;\n })\n .join(\"\");\n\n return textResponse(\n `\n\n\t\n\t\t\n\t\t\n\t\t\n\t\tmensa\n\t\t\n\t\n\t\n\t\t

Speiseplan fuer KW ${week}

\n\t\t${body}\n\t\n`,\n 200,\n \"text/html; charset=utf-8\",\n );\n }\n default:\n return textResponse(\"Invalid format\", 400);\n }\n}\n\nasync function registerWebhook(\n env: BotEnv,\n request: Request,\n): Promise {\n if (request.headers.get(\"Authorization\") !== env.TELEGRAM_TOKEN) {\n return jsonResponse({ error: \"Unauthorized\" }, 401);\n }\n\n const url = new URL(request.url);\n const webhookUrl = `https://${url.host}${WEBHOOK_PATH}`;\n const result = (await (\n await tgGet(env, \"setWebhook\", {\n url: webhookUrl,\n secret_token: env.WEBHOOK_SECRET,\n })\n ).json()) as { ok?: boolean };\n\n if (result.ok) {\n return jsonResponse({ status: \"ok\", webhookUrl });\n }\n\n return jsonResponse(\n {\n error: \"Failed to register webhook\",\n response: result,\n webhookUrl,\n },\n 500,\n );\n}\n\nasync function unregisterWebhook(\n env: BotEnv,\n request: Request,\n): Promise {\n if (request.headers.get(\"Authorization\") !== env.TELEGRAM_TOKEN) {\n return jsonResponse({ error: \"Unauthorized\" }, 401);\n }\n\n const result =\n (await (await tgGet(env, \"setWebhook\", { url: \"\" })).json()) as {\n ok?: boolean;\n };\n\n if (result.ok) {\n return jsonResponse({ status: \"ok\" });\n }\n\n return jsonResponse({\n error: \"Failed to unregister webhook\",\n response: result,\n }, 500);\n}\n\nasync function handleWebhookUpdate(\n env: BotEnv,\n request: Request,\n): Promise {\n if (\n request.headers.get(\"X-Telegram-Bot-Api-Secret-Token\") !==\n env.WEBHOOK_SECRET\n ) {\n return textResponse(\"Unauthorized\", 403);\n }\n\n let update: unknown;\n try {\n update = await request.json();\n } catch {\n return textResponse(\"Invalid JSON\", 400);\n }\n\n const message = getTextMessage(update);\n if (message) {\n await handleTelegramMessage(env, message);\n }\n\n return textResponse(\"ok\");\n}\n\nasync function handleRequest(request: Request, env: BotEnv): Promise {\n const url = new URL(request.url);\n const path = normalizePath(url.pathname);\n\n if (request.method === \"GET\" && path === \"/\") {\n return textResponse(\"Hi!\");\n }\n\n if (request.method === \"GET\" && path === \"/mensa\") {\n return handleWeekRoute(env, request, getISOWeek(new Date()));\n }\n\n const weekMatch = path.match(/^\\/mensa\\/(\\d{1,2})$/);\n if (request.method === \"GET\" && weekMatch) {\n const week = Number.parseInt(weekMatch[1], 10);\n if (!isValidWeek(week)) {\n return textResponse(\"Invalid week\", 400);\n }\n return handleWeekRoute(env, request, week);\n }\n\n if (request.method === \"POST\" && path === WEBHOOK_PATH) {\n return handleWebhookUpdate(env, request);\n }\n\n if (request.method === \"GET\" && path === \"/webhook/register\") {\n return registerWebhook(env, request);\n }\n\n if (request.method === \"GET\" && path === \"/webhook/unregister\") {\n return unregisterWebhook(env, request);\n }\n\n return textResponse(\"Not Found\", 404);\n}\n\nfunction createMemoryCache(): CacheStore {\n const store = new Map();\n return {\n async get(key: string) {\n const hit = store.get(key);\n if (!hit) {\n return null;\n }\n if (Date.now() >= hit.expiresAt) {\n store.delete(key);\n return null;\n }\n return hit.value;\n },\n async put(key: string, value: string, options?: CachePutOptions) {\n const ttl = options?.expirationTtl ?? CACHE_TTL_SECONDS;\n store.set(key, {\n value,\n expiresAt: Date.now() + ttl * 1000,\n });\n },\n };\n}\n\nexport { createMemoryCache, handleRequest, WEBHOOK_PATH };\nexport type { BotEnv, CachePutOptions, CacheStore, MensaEntry, MensaPrice };","deleted","label","children",[],[158],{"_105":178,"_97":101,"_159":179,"_161":-5,"_162":144,"_163":180,"_164":165,"_107":181,"_102":167,"_168":182,"_170":183,"_172":22,"_173":184,"_174":185,"_100":186},"bd5a0942-1030-11f1-9ed1-42dde27851f2","e099da7e-102e-11f1-bf19-42dde27851f2",17,["D",1771793694638],"http","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { handleRequest } from \"./bot.ts\";\nimport type { BotEnv, CacheStore } from \"./bot.ts\";\n\nawait sqlite.execute(`\n\tCREATE TABLE IF NOT EXISTS cache_entries (\n\t\tcache_key TEXT PRIMARY KEY,\n\t\tcache_value TEXT NOT NULL,\n\t\texpires_at INTEGER NOT NULL\n\t)\n`);\n\nawait sqlite.execute(`\n\tCREATE INDEX IF NOT EXISTS cache_entries_expires_at_idx\n\tON cache_entries (expires_at)\n`);\n\nconst cacheStore: CacheStore = {\n async get(key: string): Promise {\n const result = await sqlite.execute({\n sql:\n \"SELECT cache_value, expires_at FROM cache_entries WHERE cache_key = ? LIMIT 1\",\n args: [key],\n });\n if (result.rows.length === 0) {\n return null;\n }\n\n const row = result.rows[0] as [string, number];\n const cacheValue = String(row[0]);\n const expiresAt = Number(row[1]);\n\n if (expiresAt <= Date.now()) {\n await sqlite.execute({\n sql: \"DELETE FROM cache_entries WHERE cache_key = ?\",\n args: [key],\n });\n return null;\n }\n\n return cacheValue;\n },\n async put(key: string, value: string, options): Promise {\n const ttl = options?.expirationTtl ?? 60 * 60;\n const expiresAt = Date.now() + ttl * 1000;\n await sqlite.execute({\n sql: `INSERT INTO cache_entries (cache_key, cache_value, expires_at)\n\t\t\t VALUES (?, ?, ?)\n\t\t\t ON CONFLICT(cache_key) DO UPDATE SET\n\t\t\t cache_value = excluded.cache_value,\n\t\t\t expires_at = excluded.expires_at`,\n args: [key, value, expiresAt],\n });\n },\n};\n\ntype DenoEnvLike = {\n env: {\n get(name: string): string | undefined;\n };\n};\n\nfunction requireSecret(secretName: string): string {\n const deno = (globalThis as unknown as { Deno?: DenoEnvLike }).Deno;\n const value = deno?.env.get(secretName);\n if (!value) {\n throw new Error(`Missing required Val Town secret: ${secretName}`);\n }\n return value;\n}\n\nconst env: BotEnv = {\n UNI_PASSAU_BOT_CACHE: cacheStore,\n TELEGRAM_TOKEN: requireSecret(\"TELEGRAM_TOKEN\"),\n WEBHOOK_SECRET: requireSecret(\"WEBHOOK_SECRET\"),\n ADMIN_CHAT_ID: requireSecret(\"ADMIN_CHAT_ID\"),\n};\n\nexport default async function (request: Request): Promise {\n return await handleRequest(request, env);\n}","mensa-uni-passau",[],[101],"files",[156,177],"counts",{"_191":33,"_192":193,"_194":33,"_195":196,"_200":201},"pulls","branches",1,"forks","envVars",{"_197":198,"_199":33},"count",4,"emptyCount","connections",{"_197":33,"_202":33},"unfilledCount","contents",[],"file",{"_105":178,"_162":144,"_159":179,"_97":101,"_170":183,"_168":182,"_102":167,"_161":-5,"_107":207,"_163":180,"_173":184,"_100":208},["D",1771793694638],[101],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.code.$",{"_95":96,"_97":98,"_99":45,"_102":-7,"_100":101,"_103":217,"_154":222,"_187":229,"_205":230,"_203":233,"_234":-5,"_235":-5,"_236":-5,"_237":-5,"_238":239,"_195":-5},{"_105":106,"_97":98,"_107":218,"_109":-5,"_110":22,"_111":112,"_113":-5,"_114":-5,"_14":115,"_116":-5,"_117":22,"_118":-5,"_119":-5,"_120":33,"_16":121,"_122":-5,"_123":-5,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":219,"_136":220,"_141":221,"_153":22},["D",1771792894771],{"_95":96,"_134":135},{"_95":96,"_138":135,"_14":115,"_139":140},{"_102":143,"_97":45,"_105":144,"_145":106,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":98,"_152":96},[223,226],{"_105":157,"_97":158,"_159":160,"_161":-5,"_162":144,"_163":143,"_164":165,"_107":166,"_102":167,"_168":169,"_170":171,"_172":22,"_173":-5,"_174":224,"_100":225},[],[158],{"_105":178,"_97":101,"_159":179,"_161":-5,"_162":144,"_163":180,"_164":165,"_107":181,"_102":167,"_168":182,"_170":183,"_172":22,"_173":184,"_174":227,"_100":228},[],[101],[223,226],{"_105":178,"_162":144,"_159":179,"_97":101,"_170":183,"_168":182,"_102":167,"_161":-5,"_107":231,"_163":180,"_173":184,"_100":232},["D",1771793694638],[101],[],"upstream","pull","ahead","behind","templates",[],"actionData","errors"]

tionis

uni-passau-bot