Mi Vocabulario IA

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_154":155,"_156":157},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_105":86,"_27":53,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":58,"_122":-5,"_123":-5,"_124":125},"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":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",13,"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.ts","latestPath","fileId","bba653ce-82fb-11f1-b873-1607ee4eb77e","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const TOKEN_TELEGRAM = Deno.env.get(\"telegram_token\");\n\n // 1. OBTENER DATOS (Para la Mini App)\n if (req.method === \"GET\" && url.pathname === \"/cargar-datos\") {\n try {\n const seccionesRes = await sqlite.execute(\"SELECT * FROM mis_secciones ORDER BY id DESC\");\n const palabrasRes = await sqlite.execute(\"SELECT * FROM mis_palabras\");\n return new Response(JSON.stringify({ secciones: seccionesRes.rows, palabras: palabrasRes.rows }), { headers: { \"Content-Type\": \"application/json\" } });\n } catch (e) { return new Response(JSON.stringify({ error: e.message }), { status: 500 }); }\n }\n\n // 2. GUARDAR SECCIÓN\n if (req.method === \"POST\" && url.pathname === \"/guardar-seccion\") {\n try {\n const datos = await req.json();\n const resSeccion = await sqlite.execute({\n sql: `INSERT INTO mis_secciones (nombre_seccion) VALUES (?) RETURNING id`,\n args: [datos.nombre]\n });\n const seccionId = resSeccion.rows[0][0];\n const listaPalabras = datos.palabras.map((p: string) => p.trim().toLowerCase()).filter((p: string) => p.length > 0);\n\n for (const palabra of listaPalabras) {\n await sqlite.execute({ sql: `INSERT INTO mis_palabras (seccion_id, palabra) VALUES (?, ?)`, args: [seccionId, palabra] });\n }\n return new Response(JSON.stringify({ OK: true }));\n } catch (e) { return new Response(JSON.stringify({ error: e.message }), { status: 500 }); }\n }\n\n // 3. RENOMBRAR SECCIÓN\n if (req.method === \"POST\" && url.pathname === \"/renombrar-seccion\") {\n try {\n const datos = await req.json();\n await sqlite.execute({ sql: `UPDATE mis_secciones SET nombre_seccion = ? WHERE id = ?`, args: [datos.nuevoNombre, datos.id] });\n return new Response(JSON.stringify({ OK: true }));\n } catch (e) { return new Response(JSON.stringify({ error: e.message }), { status: 500 }); }\n }\n\n // 4. ELIMINAR SECCIÓN\n if (req.method === \"POST\" && url.pathname === \"/eliminar-seccion\") {\n try {\n const datos = await req.json();\n await sqlite.execute({ sql: `DELETE FROM mis_palabras WHERE seccion_id = ?`, args: [datos.id] });\n await sqlite.execute({ sql: `DELETE FROM mis_secciones WHERE id = ?`, args: [datos.id] });\n return new Response(JSON.stringify({ OK: true }));\n } catch (e) { return new Response(JSON.stringify({ error: e.message }), { status: 500 }); }\n }\n\n // 5. ELIMINAR PALABRA INDIVIDUAL\n if (req.method === \"POST\" && url.pathname === \"/eliminar-palabra\") {\n try {\n const datos = await req.json();\n await sqlite.execute({ sql: `DELETE FROM mis_palabras WHERE id = ?`, args: [datos.id] });\n return new Response(JSON.stringify({ OK: true }));\n } catch (e) { return new Response(JSON.stringify({ error: e.message }), { status: 500 }); }\n }\n\n // 6. RESPUESTA DEL BOT (IA NORMAL POR FETCH)\n if (req.method === \"POST\" && url.pathname === \"/webhook-telegram\") {\n try {\n const bulto = await req.json();\n const mensajeUsuario = bulto.message?.text;\n const chatId = bulto.message?.chat?.id;\n\n if (mensajeUsuario && chatId) {\n const resultado = await sqlite.execute(\"SELECT palabra FROM mis_palabras\");\n const misPalabras = resultado.rows.map(row => row[0].trim().toLowerCase());\n \n let respuestaFinal = \"\";\n\n if (misPalabras.length === 0) {\n respuestaFinal = \"¡Hola! Tu lista de palabras está vacía en la app. Agrega palabras en tus secciones primero.\";\n } else {\n const instruccionIA = `Eres un tutor de inglés y amigo virtual común y corriente. Habla de forma natural, fluida y amigable. Sin embargo, tienes una restricción obligatoria: para armar tus respuestas, SOLO puedes usar las palabras en inglés que estén dentro de esta lista: [${misPalabras.join(\", \")}]. Intenta responder al mensaje del usuario de la forma más coherente posible usando únicamente ese vocabulario disponible.`;\n\n // Llamada directa usando la clave interna de Val.town sin librerías externas\n const respuestaIA = await fetch(\"https://api.openai.com/v1/chat/completions\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${Deno.env.get(\"OPENAI_API_KEY\") || Deno.env.get(\"valtown_openai_key\")}`\n },\n body: JSON.stringify({\n model: \"gpt-4o-mini\",\n messages: [\n { role: \"system\", content: instruccionIA },\n { role: \"user\", content: mensajeUsuario }\n ],\n max_tokens: 100\n })\n });\n\n const datosIA = await respuestaIA.json();\n respuestaFinal = datosIA.choices?.[0]?.message?.content || \"No pude generar una respuesta con esas palabras.\";\n }\n\n // Enviar a Telegram\n if (TOKEN_TELEGRAM) {\n await fetch(`https://api.telegram.org/bot${TOKEN_TELEGRAM}/sendMessage`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ chat_id: chatId, text: respuestaFinal })\n });\n }\n }\n return new Response(\"OK\", { status: 200 });\n } catch (e) {\n return new Response(\"OK\", { status: 200 });\n }\n }\n\n // INTERFAZ VISUAL DE LA MINI APP\n const html = `\n \n \n \n \n \n Mi Vocabulario IA\n \n \n \n

📚 Mis Secciones de Inglés

\n \n

\n\n \n\n \n \n \n `;\n\n return new Response(html, { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } });\n}","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const TOKEN_TELEGRAM = Deno.env.get(\"telegram_token\");\n\n // 1. OBTENER DATOS (Para la Mini App)\n if (req.method === \"GET\" && url.pathname === \"/cargar-datos\") {\n try {\n const seccionesRes = await sqlite.execute(\"SELECT * FROM mis_secciones ORDER BY id DESC\");\n const palabrasRes = await sqlite.execute(\"SELECT * FROM mis_palabras\");\n return new Response(JSON.stringify({ secciones: seccionesRes.rows, palabras: palabrasRes.rows }), { headers: { \"Content-Type\": \"application/json\" } });\n } catch (e) { return new Response(JSON.stringify({ error: e.message }), { status: 500 }); }\n }\n\n // 2. GUARDAR SECCIÓN\n if (req.method === \"POST\" && url.pathname === \"/guardar-seccion\") {\n try {\n const datos = await req.json();\n const resSeccion = await sqlite.execute({\n sql: `INSERT INTO mis_secciones (nombre_seccion) VALUES (?) RETURNING id`,\n args: [datos.nombre]\n });\n const seccionId = resSeccion.rows[0][0];\n const listaPalabras = datos.palabras.map((p: string) => p.trim().toLowerCase()).filter((p: string) => p.length > 0);\n\n for (const palabra of listaPalabras) {\n await sqlite.execute({ sql: `INSERT INTO mis_palabras (seccion_id, palabra) VALUES (?, ?)`, args: [seccionId, palabra] });\n }\n return new Response(JSON.stringify({ OK: true }));\n } catch (e) { return new Response(JSON.stringify({ error: e.message }), { status: 500 }); }\n }\n\n // 3. RENOMBRAR SECCIÓN\n if (req.method === \"POST\" && url.pathname === \"/renombrar-seccion\") {\n try {\n const datos = await req.json();\n await sqlite.execute({ sql: `UPDATE mis_secciones SET nombre_seccion = ? WHERE id = ?`, args: [datos.nuevoNombre, datos.id] });\n return new Response(JSON.stringify({ OK: true }));\n } catch (e) { return new Response(JSON.stringify({ error: e.message }), { status: 500 }); }\n }\n\n // 4. ELIMINAR SECCIÓN\n if (req.method === \"POST\" && url.pathname === \"/eliminar-seccion\") {\n try {\n const datos = await req.json();\n await sqlite.execute({ sql: `DELETE FROM mis_palabras WHERE seccion_id = ?`, args: [datos.id] });\n await sqlite.execute({ sql: `DELETE FROM mis_secciones WHERE id = ?`, args: [datos.id] });\n return new Response(JSON.stringify({ OK: true }));\n } catch (e) { return new Response(JSON.stringify({ error: e.message }), { status: 500 }); }\n }\n\n // 5. ELIMINAR PALABRA INDIVIDUAL\n if (req.method === \"POST\" && url.pathname === \"/eliminar-palabra\") {\n try {\n const datos = await req.json();\n await sqlite.execute({ sql: `DELETE FROM mis_palabras WHERE id = ?`, args: [datos.id] });\n return new Response(JSON.stringify({ OK: true }));\n } catch (e) { return new Response(JSON.stringify({ error: e.message }), { status: 500 }); }\n }\n\n // 6. RESPUESTA DEL BOT con rastreador de errores integrado\n if (req.method === \"POST\" && url.pathname === \"/webhook-telegram\") {\n try {\n const bulto = await req.json();\n const mensajeUsuario = bulto.message?.text;\n const chatId = bulto.message?.chat?.id;\n\n if (mensajeUsuario && chatId) {\n const resultado = await sqlite.execute(\"SELECT palabra FROM mis_palabras\");\n const misPalabras = resultado.rows.map(row => row[0].trim().toLowerCase());\n \n let respuestaFinal = \"\";\n\n if (misPalabras.length === 0) {\n respuestaFinal = \"¡Hola! Tu lista de palabras está vacía en la app. Agrega palabras en tus secciones primero.\";\n } else {\n const instruccionIA = `Eres un tutor de inglés y amigo virtual común y corriente. Habla de forma natural, fluida y amigable. Sin embargo, tienes una restricción obligatoria: para armar tus respuestas, SOLO puedes usar las palabras en inglés que estén dentro de esta lista: [${misPalabras.join(\", \")}]. Intenta responder al mensaje del usuario de la forma más coherente posible usando únicamente ese vocabulario disponible.`;\n\n const apiKey = Deno.env.get(\"OPENAI_API_KEY\") || Deno.env.get(\"valtown_openai_key\");\n \n const respuestaIA = await fetch(\"https://api.openai.com/v1/chat/completions\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${apiKey}`\n },\n body: JSON.stringify({\n model: \"gpt-4o-mini\",\n messages: [\n { role: \"system\", content: instruccionIA },\n { role: \"user\", content: mensajeUsuario }\n ],\n max_tokens: 100\n })\n });\n\n const datosIA = await respuestaIA.json();\n \n // RASTREADOR: Si la IA falla, lo sabremos aquí\n if (datosIA.error) {\n console.error(\"⚠️ ERROR DE OPENAI:\", datosIA.error.message);\n respuestaFinal = \"Error interno con el motor de IA.\";\n } else {\n respuestaFinal = datosIA.choices?.[0]?.message?.content || \"No pude generar respuesta.\";\n }\n }\n\n // Enviar a Telegram y rastrear si falla el envío\n if (TOKEN_TELEGRAM) {\n const envioTelegram = await fetch(`https://api.telegram.org/bot${TOKEN_TELEGRAM}/sendMessage`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ chat_id: chatId, text: respuestaFinal })\n });\n \n const resultadoTelegram = await envioTelegram.json();\n // RASTREADOR: Si Telegram rechaza el mensaje, lo sabremos aquí\n if (!resultadoTelegram.ok) {\n console.error(\"⚠️ ERROR DE TELEGRAM:\", resultadoTelegram.description);\n }\n } else {\n console.error(\"⚠️ ERROR: No se encontró la variable 'telegram_token'\");\n }\n }\n return new Response(\"OK\", { status: 200 });\n } catch (e) {\n console.error(\"⚠️ ERROR GENERAL EN WEBHOOK:\", e.message);\n return new Response(\"OK\", { status: 200 });\n }\n }\n\n // INTERFAZ VISUAL DE LA MINI APP\n const html = `...`; // Mantiene la misma interfaz que ya tienes activa\n\n return new Response(html, { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } });\n}","createdAt",["D",1784420005895],"branchVersion","branchId","c0faec25-f8a6-4e0f-b48d-c2cf8244d9a5","id","df9c9d95-b77f-4f3a-b32f-8d975f06d30e","tutorInglesCompleto",["D",1784415312162],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","4c4e18a2-9376-4762-ae5b-3bee5fa0becf","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f6b88-426f-73dc-88c9-36f51736aa69","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_104":100},"org",{"_96":95,"_97":98,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"isOwned",34,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","machadofastfood","handle","displayName","Machado Fast Food","avatar","https://lh3.googleusercontent.com/a/ACg8ocKXjKJcfLEzUjWalAvzWEpqsnsdlTOCCi9Zsd9NAgAxBs9nHZY=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":150,"_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":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":151,"_80":152,"_82":153,"_84":25},"tree",[145],"files",[145],"counts",{"_134":62,"_135":136,"_137":62,"_138":139,"_140":141},"contents",[126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":130,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_27":133},"daddc872-cc9d-4829-926a-b3e55f74a8d3","parentId","latest",["D",1784420005895],12,"label",[28],"pulls","branches",1,"forks","envVars",{"_142":136,"_144":62},"connections",{"_142":62,"_143":62},"count","unfilledCount","emptyCount",{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":146,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_147":148,"_27":149},["D",1784420005895],"children",[],[28],["D",1784415312162],{"_96":95,"_104":100},{"_96":95,"_97":98,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_123":187,"_188":189,"_190":191,"_192":25,"_193":25,"_194":25,"_195":58,"_196":-5,"_197":-7,"_198":-7,"_199":62,"_200":25,"_201":25,"_202":-5,"_203":25,"_204":25,"_205":25,"_206":-5},"ENV",{"_158":159,"_160":161,"_162":86,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186},"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"]

📚 Mis Secciones de Inglés

Nueva Sección

Diff · v13