${\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",[],[157],{"_104":177,"_97":178,"_158":179,"_160":-5,"_161":143,"_162":180,"_163":164,"_106":181,"_101":166,"_167":182,"_169":183,"_171":22,"_172":184,"_173":185,"_100":186},"bd5a0942-1030-11f1-9ed1-42dde27851f2","valtown.ts","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",[],[178],"files",[155,176],"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",[205,208],{"_104":156,"_97":157,"_158":159,"_160":-5,"_161":143,"_162":142,"_163":164,"_106":206,"_101":166,"_167":168,"_169":170,"_171":22,"_172":-5,"_100":207},["D",1771794610962],[157],{"_104":177,"_97":178,"_158":179,"_160":-5,"_161":143,"_162":180,"_163":164,"_106":209,"_101":166,"_167":182,"_169":183,"_171":22,"_172":184,"_100":210},["D",1771793694638],[178],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.environment-variables",{"_95":96,"_97":98,"_102":220,"_195":225,"_241":22},{"_104":105,"_97":98,"_106":221,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":-5,"_119":33,"_16":120,"_121":-5,"_122":-5,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_23":222,"_135":223,"_140":224,"_152":22},["D",1771792894771],{"_95":96,"_133":134},{"_95":96,"_137":134,"_14":114,"_138":139},{"_101":142,"_97":45,"_104":143,"_144":105,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":98,"_151":96},[226,232,235,238],{"_227":228,"_106":229,"_230":-5,"_112":74,"_231":22},"key","WEBHOOK_SECRET",["D",1771794573181],"updatedAt","isEmpty",{"_227":233,"_106":234,"_230":-5,"_112":74,"_231":22},"ADMIN_CHAT_ID",["D",1771794465506],{"_227":236,"_106":237,"_230":-5,"_112":74,"_231":22},"WEBHOOK_BASE_URL",["D",1771794401633],{"_227":239,"_106":240,"_230":-5,"_112":74,"_231":22},"TELEGRAM_TOKEN",["D",1771793771060],"isTeamOrg","actionData","errors"]

Key	Description
WEBHOOK_SECRET
ADMIN_CHAT_ID
WEBHOOK_BASE_URL
TELEGRAM_TOKEN

tionis

uni-passau-bot

Environment variables