[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_172":173,"_174":175},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_131":-5,"_20":132,"_22":133,"_134":135,"_136":137,"_26":138,"_24":139,"_140":-5,"_141":-5,"_142":52,"_143":144,"_145":43,"_146":-5,"_147":-5,"_148":149},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","diegoravecca","name","faq-chatbot","branchName","main","version","path","main.ts","project",{"_33":72,"_13":14,"_44":73,"_74":-5,"_75":52,"_76":77,"_78":77,"_79":80,"_81":-5,"_82":83,"_84":36,"_85":43,"_86":-5,"_87":-5,"_88":89,"_90":91,"_92":93,"_94":95,"_96":97,"_98":-5,"_99":100,"_101":100,"_102":103,"_104":103,"_105":103,"_106":100,"_107":100,"_108":109,"_110":111,"_112":113,"_114":52},"tree",[56,57],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":54,"_18":55},"contents",[],"upstream","pull","ahead","behind","envVars","id","20316d5a-17fe-4811-9ede-32184d9a1687","fileId","3dc18bf4-ae16-11f1-b07b-1607ee4eb77e","parentId","branchId","73555ffa-82f1-460d-966b-d6fe95aff5be","branchVersion",46,"latest",true,"createdAt",["D",1789230173942],21,"fileType","http","content","// FAQ Chatbot — session-based: new visitors pick a personality, then chat.\nimport {\n loadFaq,\n llmAnswer,\n addMessage,\n getMessages,\n clearMessages,\n getSession,\n setSession,\n generateGreeting,\n PERSONALITIES,\n DEFAULT_PERSONALITY,\n} from \"./lib.ts\";\n\n/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { renderToStaticMarkup } from \"https://esm.sh/react-dom@18.2.0/server\";\n\nconst SESSION_COOKIE = \"faq_session\";\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n const faq = await loadFaq();\n\n const sessionId = getCookie(req.headers.get(\"cookie\") ?? \"\", SESSION_COOKIE);\n const session = sessionId ? await getSession(sessionId) : null;\n\n // POST /api/chat → receive { text }, answer with the session's personality\n if (url.pathname === \"/api/chat\" && req.method === \"POST\") {\n if (!session) {\n return json({ error: \"no_session\" }, 401);\n }\n const body = await req.json().catch(() => ({}));\n const text = (body.text ?? \"\").toString().trim();\n const { text: reply } = await llmAnswer(text, faq, session.personality);\n await addMessage(session.convo, \"user\", text);\n await addMessage(session.convo, \"bot\", reply);\n const history = await getMessages(session.convo);\n return json({ reply, history });\n }\n\n // POST /api/clear → wipe the conversation\n if (url.pathname === \"/api/clear\" && req.method === \"POST\") {\n if (session) await clearMessages(session.convo);\n return json({});\n }\n\n // GET /choose?personality=X → bind session + redirect to the chat\n if (url.pathname === \"/choose\") {\n const personality = url.searchParams.get(\"personality\") ?? DEFAULT_PERSONALITY;\n const id = sessionId ?? crypto.randomUUID();\n await setSession(id, personality, id); // convo = session id\n // Start a fresh conversation with a greeting generated from the current FAQ.\n await clearMessages(id);\n await addMessage(id, \"bot\", await generateGreeting(personality, faq));\n return redirectWithCookie(\"/\", id);\n }\n\n // GET \"/\" → show personality picker (new user) or the chat (existing session)\n if (!session) {\n return new Response(buildChoosePage(), {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n }\n\n const history = await getMessages(session.convo);\n return new Response(buildChatPage(history, session.personality), {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n\n// ---------- Personality chooser (new users) ----------\nfunction buildChoosePage(): string {\n const buttons = Object.entries(PERSONALITIES).map(\n ([key, p]) =>\n `\n ${emojiOf(p.name)}\n ${escapeHtml(p.name)}\n `,\n ).join(\"\");\n\n return `\n\n\n \n \n FAQ Chatbot\n \n\n\n

🤖 Elegí con quién hablar

Un compañero distinto, una respuesta distinta.

${buttons}

\n ⚠️ Aviso: las respuestas se basan en material informativo proporcionado y pueden\n contener errores u omisiones; consultá siempre las fuentes oficiales.\n Los personajes son ficticios; cualquier parecido con la realidad es mera coincidencia.\n Esta página usa cookies para recordar tu personalidad elegida y tu conversación.\n

\n\n`;\n}\n\nfunction emojiOf(name: string): string {\n // Grab the trailing emoji cluster from names like \"Delegada 😠\" or \"Profe 👩🏫\".\n const m = name.match(/[\\p{Extended_Pictographic}](?:\\u{200D}[\\p{Extended_Pictographic}])*[\\u{FE0F}]?$/u);\n return m ? m[0] : \"🙂\";\n}\n\n// ---------- Chat (returning users) ----------\nfunction buildChatPage(\n history: { role: string; text: string; created_at: number }[],\n personality: string,\n): string {\n const personas = Object.entries(PERSONALITIES).map(([key, p]) =>\n ``,\n ).join(\"\");\n\n const bubbles = history\n .map((m) => {\n const side = m.role === \"user\" ? \"user\" : \"bot\";\n const when = new Date(Number(m.created_at)).toLocaleTimeString(\"es-AR\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n });\n return `

${escapeHtml(m.text)}${when}

`;\n })\n .join(\"\");\n\n const page = renderToStaticMarkup(\n React.createElement(\n \"html\",\n null,\n React.createElement(\"head\", null,\n React.createElement(\"meta\", { charSet: \"utf-8\" }),\n React.createElement(\"title\", null, \"FAQ Chatbot\"),\n React.createElement(\"meta\", { name: \"viewport\", content: \"width=device-width, initial-scale=1\" }),\n React.createElement(\"style\", null, CHAT_CSS),\n ),\n React.createElement(\"body\", null,\n React.createElement(\"div\", { id: \"app\" },\n React.createElement(\"header\", null,\n React.createElement(\"h1\", null, \"🤖 FAQ Chatbot\"),\n React.createElement(\"select\", { id: \"personality\", dangerouslySetInnerHTML: { __html: personas } }),\n React.createElement(\"button\", { id: \"clear\", className: \"clear\" }, \"🧹\"),\n ),\n React.createElement(\"div\", { id: \"messages\", dangerouslySetInnerHTML: { __html: bubbles } }),\n React.createElement(\"div\", { id: \"inputbar\" },\n React.createElement(\"input\", { id: \"input\", placeholder: \"Escribí tu pregunta…\", autocomplete: \"off\" }),\n React.createElement(\"button\", { id: \"send\" }, \"➤\"),\n ),\n ),\n React.createElement(\"script\", {\n dangerouslySetInnerHTML: {\n __html: \"window.__config = { history: \" + JSON.stringify(history) + \" };\",\n },\n }),\n React.createElement(\"script\", { dangerouslySetInnerHTML: { __html: CLIENT_JS } }),\n ),\n ),\n );\n\n return \"\\n\" + page;\n}\n\n// ---------- helpers ----------\nfunction getCookie(header: string, name: string): string | null {\n for (const part of header.split(\";\")) {\n const eq = part.indexOf(\"=\");\n if (eq === -1) continue;\n const k = part.slice(0, eq).trim();\n if (k === name) return decodeURIComponent(part.slice(eq + 1).trim());\n }\n return null;\n}\n\nfunction redirectWithCookie(path: string, sessionId: string): Response {\n const res = new Response(null, { status: 302, headers: { location: path } });\n res.headers.set(\n \"Set-Cookie\",\n `${SESSION_COOKIE}=${encodeURIComponent(sessionId)}; Path=/; HttpOnly; SameSite=Lax; Max-Age=2592000`,\n );\n return res;\n}\n\nfunction json(data: unknown, status = 200): Response {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\n\nfunction escapeHtml(s: string): string {\n return s\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\");\n}\n\nconst CHAT_CSS = `\n * { box-sizing: border-box; }\n body { margin: 0; font-family: -apple-system, system-ui, sans-serif; background: #e5ddd5; }\n #app { display: flex; flex-direction: column; height: 100vh; height: 100dvh; max-width: 720px; margin: 0 auto; background: #efe7dd; border-left: 1px solid #d5cdc5; border-right: 1px solid #d5cdc5; }\n header { display: flex; align-items: center; gap: 10px; padding: 10px 14px; background: #075e54; color: #fff; position: sticky; top: 0; z-index: 10; flex-shrink: 0; }\n header h1 { font-size: 17px; flex: 1; margin: 0; }\n header select { padding: 6px 8px; border-radius: 6px; border: none; font-size: 14px; }\n header .clear { background: rgba(255,255,255,.2); color: #fff; border: none; border-radius: 6px; padding: 6px 10px; cursor: pointer; font-size: 15px; }\n #messages { flex: 1; overflow-y: auto; padding: 14px; display: flex; flex-direction: column; gap: 4px; }\n .row { display: flex; width: 100%; }\n .row.user { justify-content: flex-end; }\n .row.bot { justify-content: flex-start; }\n .bubble { max-width: 78%; padding: 8px 12px; border-radius: 10px; font-size: 15px; line-height: 1.4; position: relative; box-shadow: 0 1px 1px rgba(0,0,0,.08); white-space: pre-wrap; }\n .bubble.user { background: #dcf8c6; border-bottom-right-radius: 2px; }\n .bubble.bot { background: #fff; border-bottom-left-radius: 2px; }\n .bubble .time { float: right; margin-left: 8px; margin-top: 6px; font-size: 11px; color: #999; }\n .bubble.typing { padding: 14px 18px; }\n .bubble.typing span { display: inline-block; width: 8px; height: 8px; margin: 0 2px; border-radius: 50%; background: #999; animation: typing 1.2s infinite ease-in-out; }\n .bubble.typing span:nth-child(2) { animation-delay: .2s; }\n .bubble.typing span:nth-child(3) { animation-delay: .4s; }\n @keyframes typing { 0%, 60%, 100% { transform: translateY(0); opacity: .4; } 30% { transform: translateY(-4px); opacity: 1; } }\n #inputbar { display: flex; gap: 8px; padding: 10px 14px; background: #f0f0f0; border-top: 1px solid #ddd; }\n #inputbar input { flex: 1; padding: 12px 14px; font-size: 16px; border: none; border-radius: 24px; outline: none; background: #fff; }\n #inputbar button { width: 46px; height: 46px; border-radius: 50%; border: none; background: #075e54; color: #fff; font-size: 18px; cursor: pointer; }\n`;\n\nconst CLIENT_JS = `\n const history = window.__config.history || [];\n const messages = document.getElementById(\"messages\");\n const input = document.getElementById(\"input\");\n const send = document.getElementById(\"send\");\n const clearBtn = document.getElementById(\"clear\");\n const persona = document.getElementById(\"personality\");\n\n function scrollBottom() { messages.scrollTop = messages.scrollHeight; }\n\n function bubbleHTML(m) {\n const side = m.role === \"user\" ? \"user\" : \"bot\";\n const when = new Date(Number(m.created_at)).toLocaleTimeString(\"es-AR\", { hour: \"2-digit\", minute: \"2-digit\" });\n return '

' + esc(m.text) + '' + when + '

';\n }\n\n function render(hist) {\n messages.innerHTML = (hist || []).map(bubbleHTML).join(\"\");\n scrollBottom();\n }\n\n function showTyping() {\n messages.insertAdjacentHTML(\"beforeend\",\n '

');\n scrollBottom();\n }\n\n function esc(s) {\n return (s || \"\").replace(/&/g, \"&\").replace(//g, \">\");\n }\n\n async function sendMessage() {\n const text = input.value.trim();\n if (!text) return;\n input.value = \"\";\n render((window.__hist || []).concat([{ role: \"user\", text: text, created_at: Date.now() }]));\n showTyping();\n const res = await fetch(\"/api/chat\", { method: \"POST\", headers: { \"content-type\": \"application/json\" }, body: JSON.stringify({ text }) });\n const data = await res.json();\n window.__hist = data.history;\n render(data.history);\n }\n\n send.addEventListener(\"click\", sendMessage);\n input.addEventListener(\"keydown\", (e) => { if (e.key === \"Enter\") sendMessage(); });\n // Changing personality updates the session cookie, then clears the visible chat.\n persona.addEventListener(\"change\", () => {\n window.location.href = \"/choose?personality=\" + persona.value;\n });\n clearBtn.addEventListener(\"click\", async () => {\n await fetch(\"/api/clear\", { method: \"POST\" });\n window.__hist = [];\n render([]);\n });\n\n window.__hist = history;\n render(history);\n`;\n","deleted",false,"label","primeroprimera",[19],{"_33":62,"_13":63,"_35":64,"_37":-5,"_38":39,"_40":65,"_42":43,"_44":66,"_17":67,"_47":68,"_49":69,"_51":52,"_53":-5,"_59":70,"_18":71},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":58,"_17":46,"_47":48,"_49":50,"_51":52,"_53":54,"_59":60,"_18":61},["D",1789230173942],"children",[],[19],"33036cbc-cd62-4d5a-8631-7bbd5364cc74","lib.ts","f9788d16-ae16-11f1-ad57-1607ee4eb77e",49,["D",1789420944337],26,"script","// Shared FAQ + personalities logic for the FAQ chatbot.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport const SHEET_URL =\n \"https://docs.google.com/spreadsheets/d/e/2PACX-1vSerSBZETsDKevnovm-yTNi79xVoemUOdATL-rgxz99VoeNhG6q1L131fnjEsJr4gPMg-88jDSD7yM9/pub?output=csv\";\n\n// Cache the sheet so we don't refetch on every request.\nlet cached: { q: string; answers: string[] }[] | null = null;\nlet cachedAt = 0;\nconst CACHE_MS = 60_000;\n\nexport async function loadFaq(): Promise<{ q: string; answers: string[] }[]> {\n if (cached && Date.now() - cachedAt < CACHE_MS) return cached;\n const res = await fetch(SHEET_URL);\n const csv = await res.text();\n const rows = csv.trim().split(\"\\n\").map(splitCsv);\n\n const questions: { num: string; text: string }[] = [];\n const answersByQuestion: Record = {};\n let currentGroup: string | null = null;\n\n for (const [a, b] of rows) {\n const aTrim = (a ?? \"\").trim();\n const bTrim = (b ?? \"\").trim();\n\n const qMatch = aTrim.match(/^Pregunta\\s*(\\d+)/i);\n if (qMatch) {\n questions.push({ num: qMatch[1], text: bTrim });\n continue;\n }\n\n const rMatch = aTrim.match(/^Respuestas?\\s+a\\s+Pregunta\\s*(\\d+)/i);\n if (rMatch) {\n currentGroup = rMatch[1];\n answersByQuestion[currentGroup] = [bTrim];\n continue;\n }\n\n if (!aTrim && bTrim && currentGroup) {\n answersByQuestion[currentGroup].push(bTrim);\n }\n }\n\n cached = questions\n .map((q) => ({ q: q.text, answers: answersByQuestion[q.num] ?? [] }))\n .filter((f) => f.q && f.answers.length > 0);\n\n cachedAt = Date.now();\n return cached;\n}\n\nfunction splitCsv(line: string): string[] {\n const out: string[] = [];\n let cur = \"\";\n let inQuotes = false;\n for (const ch of line) {\n if (ch === '\"') inQuotes = !inQuotes;\n else if (ch === \",\" && !inQuotes) {\n out.push(cur);\n cur = \"\";\n } else cur += ch;\n }\n out.push(cur);\n return out;\n}\n\n// Fallback (no API key): pick the best matching question by keyword overlap,\n// return a random one of its answers.\nexport function keywordAnswer(\n question: string,\n faq: { q: string; answers: string[] }[],\n): string {\n const words = question.toLowerCase().split(/\\W+/).filter(Boolean);\n let best: { item: { q: string; answers: string[] }; score: number } | null =\n null;\n for (const item of faq) {\n const qWords = item.q.toLowerCase().split(/\\W+/).filter(Boolean);\n let score = 0;\n for (const w of words) if (qWords.includes(w)) score++;\n if (!best || score > best.score) best = { item, score };\n }\n if (!best || best.score === 0) {\n return \"Uy, no tengo eso en el bolsillo todavía. Reformulámela que capaz te doy una mano.\";\n }\n const answers = best.item.answers;\n return answers[Math.floor(Math.random() * answers.length)];\n}\n\n// ------- Personalities -------\n// Each personality shapes how the bot talks while still grounded in the FAQ.\n// `identity` gives the bot a backstory so it can answer questions about itself\n// (e.g. \"¿Sos delegada?\" → yes, because its identity says so).\nexport const PERSONALITIES: Record<\n string,\n { name: string; identity: string; system: string }\n> = {\n delegada: {\n name: \"Delegada 😠\",\n identity:\n \"Sos la delegada del curso. Si te preguntan si sos la delegada o si sos delegada, \" +\n \"respondé que sí, con seguridad y orgullo, y que como delegada sabés todo del curso.\",\n system:\n \"Sos una delegada escolar, mandona y hablas como abogada en español rioplatense (voseo). \" +\n \"Siempre respondé en oraciones largas, con un toque sarcastico o canchero \" +\n \"Dá la info del FAQ y agregale SIEMPRE una pequeña frase de acompañamiento. \" +\n \"Si no sabés, decilo con altura y como sintiendote superior.\",\n },\n docente: {\n name: \"Profe 👩‍🏫\",\n identity:\n \"Sos la profesora. Si te preguntan si sos la profe o docente, \" +\n \"respondé que sí, que sos la profe del curso y que por eso sabés todo de la materia.\",\n system:\n \"Sos un profesor claro, didáctico y entusiasta que habla en español. \" +\n \"Respondé SIEMPRE en 2-3 oraciones: primer respuesta sera una pista del FAQ, después una breve explicación \" +\n \"de por qué, y cerra con 1 consejo corto para estudiar (ej: repasar tal tema, hacer un resumen). \" +\n \"Usá un tono de profe piola, no solemne. Basate en la info del FAQ.\",\n },\n chistoso: {\n name: \"El gracioso del curso 😜\",\n identity:\n \"Sos un compañero del curso, el más gracioso y carismático de la clase. \" +\n \"Si te preguntan quién sos o si sos el chistoso, respondé que sí, que sos el compa chistoso del curso.\",\n system:\n \"Sos un compa sarcástico pero buena onda que habla en español rioplatense (voseo). \" +\n \"Respondé SIEMPRE en 1-2 oraciones: primero la respuesta del FAQ, después agregale un chiste corto, \" +\n \"un comentario irónico o un remate gracioso relacionado. \" +\n \"El humor SIEMPRE después de la data, que la info se entienda clara. No te pases de largo ni seas grosero.\",\n },\n breve: {\n name: \"El niño sabelotodo 🤓\",\n identity:\n \"Sos un compañero del curso sabelotodo, reservado y de pocas palabras. \" +\n \"Si te preguntan quién sos, respondé en pocas palabras quién sos.\",\n system:\n \"Sos ultralacónico y directo y mas que nada sabelotodo. Respondé en español con UNA frase cortísima o incluso una palabra \" +\n \"si alcanza. Nada de rodeos, nada de explicaciones, nada de saludos. \" +\n 'Basate SIEMPRE en la info del FAQ. Si no sabés, decilo en máximo 3 palabras (ej: \"no sé\").',\n },\n};\n\nexport const DEFAULT_PERSONALITY = \"delegada\";\n\n// ------- LLM layer -------\n// Uses OpenAI-compatible API (`/chat/completions`). It works with:\n// - DeepSeek (cheapest): set LLM_API_KEY to a DeepSeek key, base URL stays\n// https://api.deepseek.com (default), model defaults to deepseek-v4-flash.\n// - OpenAI: set OPENAI_API_KEY and LLM_BASE_URL=https://api.openai.com/v1,\n// LLM_MODEL=gpt-4o-mini.\n// Without any key, falls back to keywordAnswer().\nconst LLM_BASE_URL = Deno.env.get(\"LLM_BASE_URL\") ?? \"https://api.deepseek.com\";\n// default to DeepSeek's cheap flash model if the LLM key is a DeepSeek one\nconst LLM_MODEL = Deno.env.get(\"LLM_MODEL\") ?? \"deepseek-v4-flash\";\n// DeepSeek key is the primary; OpenAI key is secondary.\n// Accepts DEEPSEEK, DEEPSEEK_API_KEY, or LLM_API_KEY for the DeepSeek key.\nconst DEEPSEEK_API_KEY = Deno.env.get(\"DEEPSEEK\") ??\n Deno.env.get(\"DEEPSEEK_API_KEY\") ??\n Deno.env.get(\"LLM_API_KEY\");\nconst LLM_API_KEY = DEEPSEEK_API_KEY ?? Deno.env.get(\"OPENAI_API_KEY\");\n\n// A cheap fingerprint of the FAQ so the cache invalidates when the sheet changes.\nfunction faqSignature(faq: { q: string; answers: string[] }[]): string {\n let s = \"\";\n for (const f of faq) s += f.q + \"|\" + f.answers.join(\"^\") + \"\\n\";\n return s.slice(0, 2000);\n}\n\nasync function ensureCacheDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS answer_cache (\n key TEXT PRIMARY KEY, -- normalized question + personality\n faq_sig TEXT NOT NULL,\n answer TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )`);\n}\n\n// Cost-saver: only hit the LLM the FIRST time a question is asked. Reuse the\n// stored answer for repeated questions until the FAQ changes.\nasync function getCachedAnswer(\n question: string,\n faq: { q: string; answers: string[] }[],\n personality: string,\n): Promise {\n await ensureCacheDb();\n const sig = faqSignature(faq);\n const key = personality + \"::\" + question.toLowerCase().trim();\n const r = await sqlite.execute({\n sql: \"SELECT answer, faq_sig FROM answer_cache WHERE key = ?\",\n args: [key],\n });\n const row = (r.rows ?? [])[0] as\n | { answer: string; faq_sig: string }\n | undefined;\n if (!row) return null;\n if (row.faq_sig !== sig) return null; // sheet changed → re-ask\n return row.answer;\n}\n\nasync function storeCached(\n question: string,\n faq: { q: string; answers: string[] }[],\n personality: string,\n answer: string,\n) {\n await ensureCacheDb();\n await sqlite.execute({\n sql:\n \"INSERT OR REPLACE INTO answer_cache (key, faq_sig, answer, created_at) VALUES (?, ?, ?, ?)\",\n args: [\n personality + \"::\" + question.toLowerCase().trim(),\n faqSignature(faq),\n answer,\n Date.now(),\n ],\n });\n}\n\nexport async function llmAnswer(\n question: string,\n faq: { q: string; answers: string[] }[],\n personality: string,\n): Promise<{ text: string; usedAI: boolean }> {\n const persona = PERSONALITIES[personality] ??\n PERSONALITIES[DEFAULT_PERSONALITY];\n\n // No API key configured → fall back to keyword matching (free).\n if (!LLM_API_KEY) {\n return { text: keywordAnswer(question, faq), usedAI: false };\n }\n\n // Reuse a prior answer for this question+personality when the FAQ unchanged.\n const hit = await getCachedAnswer(question, faq, personality);\n if (hit) {\n return { text: hit, usedAI: true };\n }\n\n const faqBlock = faq\n .map((f) => `P: ${f.q}\\nR: ${f.answers.join(\" | \")}`)\n .join(\"\\n\\n\");\n\n const res = await fetch(`${LLM_BASE_URL}/chat/completions`, {\n method: \"POST\",\n headers: {\n \"content-type\": \"application/json\",\n authorization: `Bearer ${LLM_API_KEY}`,\n },\n body: JSON.stringify({\n model: LLM_MODEL,\n temperature: 0.9,\n max_tokens: 1000,\n messages: [\n { role: \"system\", content: persona.identity },\n { role: \"system\", content: persona.system },\n {\n role: \"system\",\n content: \"Este es el FAQ de referencia. Respondé basandote en el. \" +\n \"SIEMPRE hablá en español rioplatense con voseo (vos, tenés, querés, mirá), como un argentino. \" +\n \"Sumá 1 o 2 emojis a cada respuesta para darle onda y ser más gracioso (ej: 😎 🙄 😂 🤓). \" +\n \"Si el usuario pregunta algo que NO esta en el FAQ pero es sobre vos, tu identidad o personalidad, \" +\n \"respondé usando tu identidad y tono. \" +\n \"Si la pregunta NO esta en el FAQ y tampoco es sobre tu identidad, inventá una respuesta \" +\n \"plausible y graciosa en tu personaje. \" +\n \"NUNCA asumas el género del usuario (ni varón ni mujer). Si lo amerita y no sabés su nombre, \" +\n 'preguntáselo de forma neutra (ej: \"¿Cómo te llamás?\") y usalo después para personalizar. ' +\n \"\\n\\n\" + faqBlock,\n },\n { role: \"user\", content: question },\n ],\n }),\n });\n\n if (!res.ok) {\n const err = await res.text();\n console.error(\"LLM error\", res.status, err);\n return { text: keywordAnswer(question, faq), usedAI: false };\n }\n\n const data = await res.json();\n const text = data?.choices?.[0]?.message?.content?.trim();\n if (!text) {\n console.error(\n \"LLM returned empty content\",\n JSON.stringify(data).slice(0, 500),\n );\n return { text: keywordAnswer(question, faq), usedAI: false };\n }\n await storeCached(question, faq, personality, text); // save for next time\n return { text, usedAI: true };\n}\n\n// ------- Conversation history (WhatsApp-style) -------\n// Persist messages per conversation id so a refresh keeps the thread.\nexport async function ensureDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n convo TEXT NOT NULL,\n role TEXT NOT NULL, -- 'user' | 'bot'\n text TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )`);\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_convo ON messages (convo, id)`,\n );\n}\n\nexport async function addMessage(convo: string, role: string, text: string) {\n await ensureDb();\n await sqlite.execute({\n sql:\n \"INSERT INTO messages (convo, role, text, created_at) VALUES (?, ?, ?, ?)\",\n args: [convo, role, text, Date.now()],\n });\n}\n\nexport async function getMessages(convo: string) {\n await ensureDb();\n const r = await sqlite.execute({\n sql:\n \"SELECT role, text, created_at FROM messages WHERE convo = ? ORDER BY id ASC LIMIT 200\",\n args: [convo],\n });\n return (r.rows ?? []) as { role: string; text: string; created_at: number }[];\n}\n\nexport async function clearMessages(convo: string) {\n await ensureDb();\n await sqlite.execute({\n sql: \"DELETE FROM messages WHERE convo = ?\",\n args: [convo],\n });\n} // ------- Sessions -------\n// A session binds a browser (via a cookie) to a chosen personality + convo.\n// A new visitor has no session → they pick a personality first.\nexport async function ensureSessionDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS sessions (\n id TEXT PRIMARY KEY,\n personality TEXT NOT NULL,\n convo TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )`);\n}\n\nexport async function getSession(\n id: string,\n): Promise<{ personality: string; convo: string } | null> {\n await ensureSessionDb();\n const r = await sqlite.execute({\n sql: \"SELECT personality, convo FROM sessions WHERE id = ?\",\n args: [id],\n });\n const row = (r.rows ?? [])[0] as\n | { personality: string; convo: string }\n | undefined;\n return row\n ? { personality: String(row.personality), convo: String(row.convo) }\n : null;\n}\n\nexport async function setSession(\n id: string,\n personality: string,\n convo: string,\n) {\n await ensureSessionDb();\n await sqlite.execute({\n sql:\n \"INSERT OR REPLACE INTO sessions (id, personality, convo, created_at) VALUES (?, ?, ?, ?)\",\n args: [id, personality, convo, Date.now()],\n });\n}\n// ------- Opening greeting -------\n// The greeting a character sends when picked. Instead of hardcoding \"exam on\n// Monday\", it's generated from the CURRENT FAQ content, so when the sheet\n// changes topic the greeting adapts automatically. Cached by FAQ signature so\n// it's only regenerated when the sheet changes (cost-friendly).\nconst STATIC_GREETINGS: Record = {\n delegada:\n \"¡Che, bienvenid@! 👋 Soy la Delegada, la que sabe todo de este curso. Contame, ¿qué querés saber?\",\n docente:\n \"¡Hola! 👩‍🏫 Soy la profe. Contame, ¿en qué te doy una mano?\",\n chistoso:\n \"¡¿Qué hacés?! 😜 Soy el gracioso del curso. Preguntame lo que quieras y después te cuento un chiste.\",\n breve: \"Soy el sabelotodo. 🤓 Preguntá.\",\n};\n\nexport async function generateGreeting(\n personality: string,\n faq: { q: string; answers: string[] }[],\n): Promise {\n const persona = PERSONALITIES[personality] ??\n PERSONALITIES[DEFAULT_PERSONALITY];\n\n // Reuse the answer cache (invalidates automatically when the FAQ changes).\n const cached = await getCachedAnswer(\"__greeting__\", faq, personality);\n if (cached) return cached;\n\n // No API key → static fallback.\n if (!LLM_API_KEY) {\n return STATIC_GREETINGS[personality] ?? STATIC_GREETINGS.delegada;\n }\n\n const faqBlock = faq\n .map((f) => `P: ${f.q}\\nR: ${f.answers.join(\" | \")}`)\n .join(\"\\n\\n\");\n\n try {\n const res = await fetch(`${LLM_BASE_URL}/chat/completions`, {\n method: \"POST\",\n headers: {\n \"content-type\": \"application/json\",\n authorization: `Bearer ${LLM_API_KEY}`,\n },\n body: JSON.stringify({\n model: LLM_MODEL,\n temperature: 0.9,\n max_tokens: 1000, // deepseek-flash reasons first; needs room before the answer\n messages: [\n { role: \"system\", content: persona.identity },\n {\n role: \"system\",\n content:\n \"Sos este personaje escolar y hablás en español rioplatense con voseo. \" +\n \"Este es el material del curso: \\n\\n\" + faqBlock +\n \"\\n\\nEscribí UN mensaje de bienvenida corto (1 o 2 oraciones) que te presente \" +\n \"y pregunta que quiere saber. No uses comillas ni texto entre paréntesis. Sumá 1 emoji.\",\n },\n ],\n }),\n });\n\n if (res.ok) {\n const data = await res.json();\n const text = data?.choices?.[0]?.message?.content?.trim();\n if (text) {\n await storeCached(\"__greeting__\", faq, personality, text); // save → only rewrite when sheet changes\n return text;\n }\n console.error(\n \"greeting empty content\",\n JSON.stringify(data).slice(0, 300),\n );\n }\n } catch (e) {\n console.error(\"greeting error\", e);\n }\n\n return STATIC_GREETINGS[personality] ?? STATIC_GREETINGS.delegada;\n}",[],[63],"fa71ddb1-4d13-45e3-a4b2-9fb14ebe52e9",["D",1789154591216],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","FAQ chatbot reading from a Google Sheet CSV","imageUrl","userId","19ccde2f-c4b0-46a6-82af-561e6df89055","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a091ea-ed57-7183-b991-f2c54fa7bd7e","tursoName","fa71ddb14d1345e3a4b29fb14ebe52e9","tursoHostname","fa71ddb14d1345e3a4b29fb14ebe52e9-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789503703835],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_130":126},"org",{"_11":12,"_123":124,"_125":126,"_82":83,"_127":128,"_129":52},"branch",{"_17":65,"_13":16,"_33":39,"_115":72,"_116":-5,"_117":-5,"_118":-5,"_119":-5,"_120":-5,"_121":14,"_122":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Diego Ravecca","avatar","https://lh3.googleusercontent.com/a/ACg8ocJdEvC5DSZOpC-To6ZUw6Oc_ZfdazqGtQfI9BhzAz_txuHSM_Sw=s96-c","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":72,"_13":14,"_44":167,"_74":-5,"_75":52,"_76":77,"_78":77,"_79":80,"_81":-5,"_82":83,"_84":36,"_85":43,"_86":-5,"_87":-5,"_88":89,"_90":91,"_92":93,"_94":95,"_96":168,"_98":-5,"_99":100,"_101":100,"_102":103,"_104":103,"_105":103,"_106":100,"_107":100,"_108":169,"_110":170,"_112":171,"_114":52},[161,162],"files",[161,162],"counts",{"_151":89,"_152":153,"_154":89,"_32":155,"_156":157},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":54,"_18":150},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches",1,"forks",{"_158":153,"_160":89},"connections",{"_158":89,"_159":89},"count","unfilledCount","emptyCount",{"_33":62,"_13":63,"_35":64,"_37":-5,"_38":39,"_40":65,"_42":43,"_44":66,"_17":67,"_47":68,"_49":69,"_51":52,"_53":-5,"_59":165,"_18":166},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":58,"_17":46,"_47":48,"_49":50,"_51":52,"_53":54,"_59":163,"_18":164},[],[19],[],[63],["D",1789154591216],["D",1789503703835],{"_11":12,"_130":126},{"_11":12,"_123":124,"_125":126,"_82":83,"_127":128,"_129":52},{"_17":65,"_13":16,"_33":39,"_115":72,"_116":-5,"_117":-5,"_118":-5,"_119":-5,"_120":-5,"_121":14,"_122":12},"ctx",{"_108":-5,"_147":205,"_206":207,"_208":209,"_210":52,"_211":52,"_212":52,"_213":43,"_214":-5,"_215":-7,"_216":-7,"_217":89,"_218":52,"_219":52,"_220":-5,"_221":52,"_222":52,"_223":52,"_224":-5},"ENV",{"_176":177,"_178":179,"_180":16,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204},"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"]